Skip to content
Dune Analytics

@rchen8 / All Authereum contracts sorted by number of transactions

SQL query

1WITH wallets AS
2  (SELECT block_time AS creation_time,
3          block_number AS creation_block_number,
4          address
5   FROM ethereum.traces
6   WHERE "from" IN ('\x69c0047531fd1cc24daa9eccd221cb66b53c63f8',
7                    '\x5ffe9ab0a508d8640a46bb892499803bc7bec3ea',
8                    '\x0d54d0f1c1f5fe7a525713b85f36de8fb6014046')
9     AND TYPE = 'create' ),
10     peraddress AS
11  (SELECT et."from" AS address,
12          count(DISTINCT et.tx_hash) AS transactions
13   FROM ethereum.traces et
14   JOIN wallets ON wallets.address = et."from"
15   WHERE et."to" IN ('\x237EDCDd43349227ef511581Cc834962ECf23076',
16                     '\x20af9e54a3670ef6a601bca1f1ec22b1f93cbe23',
17                     '\x2e1723d1dfa2947f0d08d5c5d214b71def4f951f',
18                     '\x79fee076b1bcd4054dff0b4364c26899492198dc',
19                     '\x211deb5c0a28a213fcf5976ac22c70ff96b9004c',
20                     '\x185c46c8d3ef5155f3678e69c827db7a2116a6cd',
21                     '\xd8cab604bdd8cbb7c3eb0c26f7dc3abffb005a92',
22                     '\xae1710e83211decb356f031a9346a24ef55055e0')
23     AND call_type = 'delegatecall'
24     AND tx_success = TRUE
25     AND error IS NULL...

SQL query results

Loading