MLDZMNtxn4
    Updated 2023-07-21
    select
    date_trunc('{{Time_basis}}',BLOCK_TIMESTAMP) as date,
    STATUS,
    count(distinct tx_hash) as no_txn
    from aurora.core.fact_transactions
    group by 1,2 having STATUS is not null
    Run a query to Download Data