kasadeghUntitled Query
    Updated 2022-11-21

    with algorand_usdc_transfer as (
    select chain,log_volume, count(*) as transfer_count
    from
    (
    SELECT
    'algorand' as chain,
    TX_ID,
    amount as volume,
    floor(log(2,volume)) log_volume

    FROM algorand.core.ez_transfer
    where ASSET_NAME= 'USDC' --or asset_id = '31566704'
    AND block_timestamp::date >='{{start_time}}' and block_timestamp::date <='{{end_date}}'
    and volume!=0
    )
    group by 1,2
    order by 2
    )
    SELECT chain, log_volume, transfer_count / (select sum(transfer_count) from algorand_usdc_transfer)
    FROM algorand_usdc_transfer
    Run a query to Download Data