MahrooUntitled Query
Updated 2022-10-19Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with DAU as
(select distinct tx_from as user,
count(*) as trades
from osmosis.core.fact_transactions
where block_timestamp like '2022%'
group by 1
having count(*) >= 146
)
select count(distinct trader),
count(*),
count(distinct pool_ids)
from osmosis.core.fact_swaps s
left outer join osmosis.core.dim_labels d ON
d.address = s.to_currency
where block_timestamp like '2022%'
and trader in (select user from DAU)
Run a query to Download Data