Skip to content
Dune Analytics

@amcassetti / RenVM Total Users

Total Unique UsersRenVM Total 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 results

Loading
 

SQL query

1SELECT table3.day, sum(table3.users) OVER (ORDER BY day ASC ROWS BETWEEN unbounded preceding AND CURRENT ROW) AS total_users
2FROM
3    (SELECT table2.day, count(table2.user) as users FROM
4        (SELECT min(table1.day) as day, table1.user
5              FROM
6                (SELECT date_trunc('day', evt_block_time) as day, erc20."ERC20_evt_Transfer".to as user
7                    FROM erc20."ERC20_evt_Transfer"
8                    WHERE contract_address = '\xeb4c2781e4eba804ce9a9803c67d0893436bb27d' -- renBTC token contract address
9                UNION
10                SELECT  date_trunc('day', evt_block_time) as day,  erc20."ERC20_evt_Transfer".from as user
11                    FROM erc20."ERC20_evt_Transfer"
12                    WHERE contract_address = '\xeb4c2781e4eba804ce9a9803c67d0893436bb27d' -- renBTC token contract address
13                UNION
14                SELECT date_trunc('day', evt_block_time) as day, erc20."ERC20_evt_Transfer".to as user
15                    FROM erc20."ERC20_evt_Transfer"
16                    WHERE contract_address = '\x1c5db575e2ff833e46a2e9864c22f4b22e0b37c2' -- renZEC token contract address
17                UNION
18                SELECT  date_trunc('day', evt_block_time) as day,  erc20."ERC20_evt_Transfer".from as user
19                    FROM erc20."ERC20_evt_Transfer"
20                    WHERE contract_address = '\x1c5db575e2ff833e46a2e9864c22f4b22e0b37c2' -- renZEC token contract address
21                UNION
22                SELECT date_trunc('day', evt_block_time) as day, erc20."ERC20_evt_Transfer".to as user
23                    FROM erc20."ERC20_evt_Transfer"
24                    WHERE contract_address = '\x459086f2376525bdceba5bdda135e4e9d3fef5bf' -- renBCH token contract address
25                UNION...