Eman-RazNew Traders per Day
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with tab1 as (select SWAPPER, min(block_timestamp::date) as first_trade
from solana.core.fact_swaps
where (swap_from_mint='So11111111111111111111111111111111111111112' or
swap_to_mint='So11111111111111111111111111111111111111112') --and block_timestamp::date>'2023-05-20'
group by 1
order by 1)
select first_trade::date as "Date", count(distinct swapper) as "New Trader", case
when first_trade::date>'2023-06-05' then 'After'
when first_trade::date<'2023-06-05' then 'Before'
else 'SEC’s lawsuits announcement'
end as "Period"
from tab1
where first_trade::date>='2023-05-20'
group by 1
order by 1
Run a query to Download Data