headitmanagercumulative chart
Updated 2022-07-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with totalcontract as (select count(distinct value)
from osmosis.core.fact_swaps , table(flatten(input => pool_ids )))
, top10contract as (select count(*),value
from osmosis.core.fact_swaps , table(flatten(input => pool_ids ))
where
block_timestamp::date > '2022-05-01'
group by value
order by count(*) desc
limit 10)
, contracts_min_date as (select value, min(block_timestamp::date) as min_date
from osmosis.core.fact_swaps , table(flatten(input => pool_ids ))
group by value)
, cumulative as (select count(*) as count_c , sum(count_c) over (order by min_date) as cumulative_contract ,min_date from contracts_min_date
where min_date >'2022-05-01'
group by min_date)
select * from cumulative
Run a query to Download Data