About queries and results
Dune Analytics lets you explore, create, and share Ethereum analytics. You can find an endless amount of great queries and dashboards on Dune.
We have decoded Ethereum smart contract data so you can do powerful analysis with simple SQL queries and visualise the query results into beautiful graphs.
Dune Analytics is free for everyone forever. If you want extra features like private queries, export your results and more check out our Pro plan.
1SELECT 2 ssq.time, 3 new_users as new, 4 (unique_users - new_users) as old 5FROM ( 6 SELECT 7 sq.time, 8 count(*) as new_users 9 FROM ( 10 SELECT 11 tx_from as user, 12 MIN(date_trunc('day', oi.block_time)) as time 13 FROM ( 14 SELECT to_token, from_token, to_amount, from_amount, tx_hash, block_time, tx_from FROM oneinch.view_swaps UNION ALL 15 SELECT to_token, from_token, to_amount, from_amount, tx_hash, block_time, tx_from FROM onesplit.view_swaps 16 WHERE tx_hash NOT IN (SELECT tx_hash FROM oneinch.view_swaps) 17 ) oi 18 GROUP BY 1 19 ORDER BY 1 20 ) sq 21 GROUP BY 1 22) ssq 23LEFT JOIN ( 24 SELECT 25 date_trunc('day', oi.block_time) AS time,...