mz0111Untitled Query
Updated 2022-11-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with first_tx as (
select
origin_from_address as user_address,
min(block_timestamp)::date as min_date
from ethereum.core.fact_event_logs
where lower(contract_address) = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')
group by user_address
HAVING min_date >= CURRENT_DATE - 36
)
select
count(user_address) as new_address,
min_date,
sum(new_address) over (order by min_date asc) as cumulative_address
from first_tx
group by min_date
Run a query to Download Data