Eman-RazNew Traders
Updated 2023-09-02
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with tab1 as (select ORIGIN_FROM_ADDRESS AS "Trader", min(block_timestamp::date) as first_trade
from avalanche.core.ez_dex_swaps
where platform='hashflow'
group by 1)
select date_trunc('{{Time_Frame}}',first_trade) as "Date", count(distinct "Trader") as "# of New Trader",
sum("# of New Trader") over (order by "Date" asc) as "Total # of New Trader"
from tab1
where first_trade::date>='{{Start_Date}}' and first_trade::date<='{{End_Date}}'
group by 1
order by 1
Run a query to Download Data