MahrooUntitled Query
    Updated 2022-10-05
    select date_trunc('day', block_timestamp) as day, count(distinct TX_HASH) as hash, count(distinct TX_SIGNER) as address, sum (TRANSACTION_FEE/1e24) as Fees,
    case when TX_RECEIVER='zomland.near' then 'Zomland' else 'Other tokens' end as Type
    from near.core.fact_transactions
    where tx_status = 'Success'
    group by Type, day
    Run a query to Download Data