bachihot contracts 4
Updated 2022-07-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with allpools as (
select block_timestamp, value as pool1
from osmosis.core.fact_swaps , table(flatten(input => pool_ids))
),
new_pools_since_may as (
select *, value as pool
from osmosis.core.fact_swaps , table(flatten(input => pool_ids))
where block_timestamp >= '2022-05-01'
and (select min(block_timestamp) from allpools where pool1=value) >= '2022-05-01'
)
select count(distinct pool) as no_of_pools from new_pools_since_may
Run a query to Download Data