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