messariUntitled Query
Updated 2023-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with swap_tx as ( select min(BLOCK_TIMESTAMP::date) as date, trader
from osmosis.core.fact_swaps
group by 2)
,
acitve_user as ( select trader, count(DISTINCT(tx_id)) as total_tx
from osmosis.core.fact_swaps
where BLOCK_TIMESTAMP >= CURRENT_DATE - 400
group by 1
having total_tx > 15)
select 'Active Users' as type, date(BLOCK_TIMESTAMP) as date, count(DISTINCT(trader)) as total_user
from osmosis.core.fact_swaps
where BLOCK_TIMESTAMP >= CURRENT_DATE - 400
and trader in ( select trader from acitve_user)
group by 1,2
Run a query to Download Data