kiichiUntitled Query
Updated 2022-08-02
9
1
2
3
4
5
6
7
8
9
›
⌄
with new_poly as (
select from_address as address , min(block_timestamp)::date as min_date
from flipside_prod_db.polygon.transactions
group by address
)
select count(address) as new_address, min_date,
sum(new_address) over (order by min_date asc rows between unbounded preceding and current row) as cumulative_address
from new_poly group by min_date
Run a query to Download Data