Sbhn_NP2024-06-26 08:28 PM
    Updated 2024-10-15
    select date_trunc('month',block_timestamp) as date,
    count(DISTINCT sender) as contracts,
    count(*) as price_updates
    from aptos.core.fact_events
    join aptos.core.fact_transactions using(tx_hash)
    where event_type = '0x7e783b349d3e89cf5931af376ebeadbfab855b3fa239b7ada8f5a92fbea6b387::event::PriceFeedUpdate'
    group by 1
    QueryRunArchived: QueryRun has been archived