binhachonNew Addresses
Updated 2022-05-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with transactions as (
select
block_timestamp,
from_address
from flipside_prod_db.polygon.transactions
where nonce = 0
)
select
date_trunc('{{timefram}}', block_timestamp) as time,
count(*) as number_of_new_users,
sum(number_of_new_users) over (order by time) as total_users
from transactions
group by 1
Run a query to Download Data