magkizzy total transaction count, average transaction & unique users
    Updated 2025-02-20
    select
    count(distinct tx_hash) AS total_transaction_count,
    count(distinct origin_from_address) AS total_unique_users
    from
    monad.testnet.fact_event_logs
    where
    contract_address = lower('0xB7736a4a238B5A977d4A712Cec8074d2B66938A9')
    and tx_succeeded = 'TRUE'
    and topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    and block_timestamp >= '2025-02-19 04:00:00'
    ;
    QueryRunArchived: QueryRun has been archived