peteer2Terradash
Updated 2022-12-17
9
1
2
3
4
5
6
›
⌄
with contracts_date as (select pool_id , min(block_timestamp::date) as created_date from terra.core.ez_swaps
group by 1)
select count(*) as total_contracts ,date_trunc('week', created_date) as cdate, sum(total_contracts) over (order by cdate asc) as cum from contracts_date
group by cdate
Run a query to Download Data