0xHaM-dUntitled Query
    Updated 2022-10-16
    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