bachihot contracts
Updated 2022-07-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
⌄
/*Select *, split[pool_ids, ','] as poolIds
from osmosis.core.fact_swaps where block_timestamp >='2022-05-01'*/
--select date(block_tiemstamp) as day, length(pool_ids) as pools_count from osmosis.core.fact_swaps where block_timestamp >='2022-05-01'
with data as (
select * from osmosis.core.fact_swaps where block_timestamp >='2022-05-01'
),
with pools as (
select
block_timestamp,
value as poolids
from
osmosis.core.fact_swaps,
table(
flatten(
pool_ids
)
) where block_timestamp >='2022-05-01'
)
select day, count(distinct pool_ids) as pools_count from (
select date(a.block_timestamp) as day, b.pool_ids from data a join pools b on a.block_timestamp = b.block_timestamp
) group by day
Run a query to Download Data