MufasaNew Ethereum Dex users on daily basis
Updated 2022-12-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with min_eth_users as (
SELECT sender, min(to_date(block_timestamp)) as date_minimum
FROM ethereum.core.ez_dex_swaps
WHERE amount_in_usd < 1000000000
GROUP BY sender
), data_one as (
select date_minimum, count(*) as users_new,
CASE WHEN date_minimum > '2022-11-08' THEN 'After FTX Event' ELSE 'Before FTX Event' END as event
from min_eth_users
group by date_minimum, 3
), cum_users as (
select *, sum(users_new) over (order by date_minimum) as cummulative_new_users
from data_one
HAVING date_minimum > CURRENT_DATE - 120
)
select * from cum_users;
Run a query to Download Data