mamad-5XN3k32023-12-18 12:07 PM
    Updated 2023-12-18
    select
    distinct EVENT_RESOURCE,
    count(distinct TX_HASH)
    from aptos.core.fact_events
    where EVENT_RESOURCE ilike '%stake%'
    --and EVENT_RESOURCE not ilike '%unstake%'
    and BLOCK_TIMESTAMP::date >= '2023-12-10'
    group by 1
    Run a query to Download Data