kasadeghUntitled Query
    Updated 2022-11-22

    SELECT
    'algorand' as chain,
    block_timestamp::date as day,
    sum(amount) as total_volume,
    avg(amount) as avg_volume,
    median(amount) as median_volume,
    count(distinct TX_ID) as tx_count,
    count(DISTINCT ASSET_SENDER) as senders_cnt,
    count(DISTINCT RECEIVER) as receivers_cnt
    FROM algorand.core.ez_transfer
    where asset_id = '31566704'
    and amount!=0
    GROUP BY 1,2
    order by 2

    Run a query to Download Data