0xHaM-dUntitled Query
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
block_timestamp::date as date,
EVENT_NAME,
ADDRESS_NAME,
count(distinct origin_from_address) as Users_Count,
count(distinct tx_hash) as tx_cnt,
sum(tx_cnt) over (partition by EVENT_NAME order by date) as cum_tx_cnt
from gnosis.core.fact_event_logs a join gnosis.core.dim_labels b on a.CONTRACT_ADDRESS= b.address
where block_timestamp >= CURRENT_DATE - 60
and EVENT_NAME != 'Approval'
group by 1,2,3
Run a query to Download Data