boomer77Paraswap new active users
Updated 2021-12-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with raw as (select date_trunc('day',block_timestamp) as dt,
tx_from_address,
COUNT(DISTINCT tx_id) as txtransaction
from ethereum.events_emitted
where dt >= CURRENT_DATE - 60 and contract_address='0xcafe001067cdef266afb7eb5a286dcfd277f3de5'
group by 1,2)
select
dt,COUNT(DISTINCT tx_from_address) as active_addresses, sum(txtransaction) as TRANSACTIon_count
from raw
where txtransaction <> 0
group by 1
order by 1
Run a query to Download Data