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.
1WITH wallets AS ( 2 SELECT 3 block_time as creation_time, 4 block_number as creation_block_number, 5 address 6 from ethereum.traces 7 where "from" in ('\x95BEBe7bfc6aCc186C13D055D0Aacc2DE5f81502','\xb24d47364163f909e64cf2cf7788d22c51cea851', '\x85bb8a852c29d8f100cb97ecdf4589086d1be2dd', '\xE0731c1a30E6eD0c6E9162EB87Fc85e831caF382') -- Monolith deployers 8 and type = 'create' 9), 10 11transfersERC20 AS ( 12 SELECT 13 evt_block_time AS block_time, 14 tr."from" AS address, 15 -tr.value / 10^decimals AS amount, 16 erc.symbol AS symbol 17 FROM erc20."ERC20_evt_Transfer" tr 18 join erc20.tokens erc 19 on tr.contract_address = erc.contract_address 20 where "from" in (select address from wallets) 21 UNION ALL 22 SELECT 23 evt_block_time AS block_time, 24 tr."to" AS address, 25 tr.value / 10^decimals AS amount ,...