Hossein2023-07-09 03:38 PM
    Updated 2023-07-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