adriaparcerisasOmosis contracts
Updated 2022-07-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH
contracts as (
select
distinct value as contracts, min(block_timestamp) as debut
--count(distinct tx_id) as counts
from osmosis.core.fact_swaps , table(flatten(input => pool_ids )) where block_timestamp between '2022-05-01' and CURRENT_DATE-1
group by 1 order by 2 asc
--limit 10
)
SELECT
trunc(debut,'day') as date,
count(distinct contracts) as contract_name,
sum(contract_name) over (order by date) as cum_contracts
from contracts
group by 1
order by 1 asc
Run a query to Download Data