HosseinUntitled Query
Updated 2023-01-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with
t1 as (
select
trader,
min(block_timestamp::date) as min_date
from osmosis.core.fact_swaps
group by trader
),
t2 as (
select
min_date,
count(*) as new_swappers_count
from t1
group by min_date
)
select
sum(new_swappers_count) as new_swappers_count
from t2
where min_date > current_date - 90
Run a query to Download Data