Hossein2023-07-09 03:38 PM
Updated 2023-07-10
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc('week', block_timestamp)::date as week,
event_name,
count(distinct tx_hash) as transactions,
sum(transactions) over (partition by event_name order by week) as cumulative_transactions
from avalanche.core.ez_decoded_event_logs
where tx_status = 'SUCCESS'
and contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
group by 1, 2
order by 1, 2
Run a query to Download Data