Skip to content
Dune Analytics

@rchen8 / Authereum weekly active users

Authereum weekly active users

Loading
 

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.

SQL query

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

SQL query results

Loading