SpiltadavidDaily Transfer Volume for axlusdc and axlusdt
    Updated 2022-12-22
    select
    date_trunc('day', block_timestamp),
    Case
    when currency like '%B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4%' then 'axlusdc'
    else 'axlusdt'
    end as Currency_type,
    sum(amount/1e6)


    from terra.core.ez_transfers
    where currency like '%B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4%' --axlusdc
    or currency like '%CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF%' --axlusdt
    group by 1,2

    Run a query to Download Data