select block_timestamp::Date as day,

sum (amount_in) as volume1,

sum (amount_out) as volume2,

volume2/volume1 as europrice

from ethereum.defi.ez_dex_swaps

where token_in = '0x1abaea1f7c830bd89acc67ec4af516284b1bc33c'

and symbol_out in ('USDC','USDT')

and amount_in > 0

and amount_out > 0

group by 1),

mintst as (

select date_trunc (day,block_timestamp) as date1,

'Stablecoin' as token_type,

case when contract_address = '0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7' then 'USDT'

when contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e' then 'USDC'

when contract_address = '0x00000000efe302beaa2b3e6e1b18d08d69a9012a' then 'aUSD (Agora)'

when contract_address = '0xabe7a9dfda35230ff60d1590a929ae0644c47dc1' then 'aUSD (StableJack)'

when contract_address = '0xd586e7f844cea2f87f50152665bcbc2c279d8d70' then 'DAI'

when contract_address = '0xab05b04743e0aeaf9d2ca81e5d3b8385e4bf961e' then 'USDS'

when contract_address = '0x111111111111ed1d73f860f57b2798b683f2d325' then 'YUSD'

when contract_address = '0xf14f4ce569cb3679e99d5059909e23b07bd2f387' then 'NXUSD'

when contract_address = '0x130966628846bfd36ff31a822705796e8cb8c18d' then 'MIM'

when contract_address = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd' then 'EURC'

when contract_address = '0x1c20e891bab6b1727d14da358fae2984ed9b59eb' then 'TUSD'

when contract_address = '0xd24c2ad096400b6fbcd2ad8b24e7acbc21a1da64' then 'FRAX'

when contract_address = '0x53fc82f14f009009b440a706e31c9021e1196a2f' then 'BUIDL'

when contract_address = '0x7678e162f38ec9ef2bfd1d0aaf9fd93355e5fa0b' then 'VEUR'

when contract_address = '0xdbdd50997361522495ecfe57ebb6850da0e4c699' then 'BNUSD'

when contract_address = '0x323665443cef804a3b5206103304bd4872ea4253' then 'USDV'

when contract_address = '0x0f577433bf59560ef2a79c124e9ff99fca258948' then 'MONEY'

else null end as symbol,

contract_address as token_contract,

sum (case when contract_address in ('0xc891eb4cbdeff6e073e859e987815ed1505c2acd','0x7678e162f38ec9ef2bfd1d0aaf9fd93355e5fa0b') then amount*europrice else amount end) as Minted_Volume1

from avalanche.core.ez_token_transfers t1 left outer join europricet t2 on t1.block_timestamp::Date = t2.day