BLOCK_TIMESTAMP::DATE as date,

CASE

when CONTRACT_ADDRESS = '0x6b175474e89094c44da98b954eedeac495271d0f' then 'DAI'

when CONTRACT_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'WETH'

when CONTRACT_ADDRESS = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'USDC'

when CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'USDT'

when CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'USDT'

end as token1,

CASE

when TO_ADDRESS = lower('0x75cDBD0e66Fdf4E2C80334F72B39628105fbeB20') then 'cDAI_v3'

when TO_ADDRESS = lower('0xB785E7e71F099adA43222E690Ee0bf701f80396') then 'aUSDC_v3'

when TO_ADDRESS = lower('0x6F7ccb0cfD6130E75e88e4c72168fD8A6926c943') then 'aETH_v1'

when TO_ADDRESS = lower('0x3d2821E59F330105c1C3aaB8c289Bce15F688f8A') then 'borrow_aETH_v2'

when TO_ADDRESS = lower('0x0F533F6b042593C00C9F4A2AD28106F524FCEb94') then 'aDAI_v3'

when TO_ADDRESS = lower('0x111A75E91625142E85193b67B10E53Acf82838cD') then 'borrow_cUSDT_v1'

when TO_ADDRESS = lower('0x9b76B4d09229c339B049053F171BFB22cbE50092') then 'borrow_aETH_v1'

when TO_ADDRESS = lower('0x33bA6A0B16750206195c777879Edd8706204154B') then 'borrow_aUSDC_v1'

when TO_ADDRESS = lower('0xf2ccd85a3428d7a560802b2dd99130be62556d30') then 'cDAI_v2'

when TO_ADDRESS = lower('0x654316A63E68f1c0823f0518570bc108de377831') then 'aDAI_v2'

when TO_ADDRESS = lower('0x0BC09825Ce9433B2cDF60891e1B50a300b069Dd2') then 'aUSDC_v2'

when TO_ADDRESS = lower('0x21F9151d6e06f834751b614C2Ff40Fc28811B235') then 'stETH_v1'

when TO_ADDRESS = lower('0xB1125ba5878cF3A843bE686c6c2486306f03E301') then 'rETH_v1'

when TO_ADDRESS = lower('0x317916f91050Ee7e4F53F7c94e83FBD4eCAdec7e') then 'aDAI_v1'

when TO_ADDRESS = lower('0x641a6e03FA9511BDE6a07793B04Cb00Aba8305c0') then 'cDAI_v1'

when TO_ADDRESS = lower('0x9ea5Cfd876260eDadaB461f013c24092dDBD531d') then 'aUSDC_v1'

when TO_ADDRESS = lower('0xB785E7e71F099adA43222E1690Ee0bf701f80396') then 'aUSDC_v3'

when TO_ADDRESS = lower('0x5ebc7a6f0ecbc069065fce49b0ed28b5e6dbdaf8') then 'aUSDC'

when TO_ADDRESS = lower('0x04dcaaa85569cbfd5bcae97d7db72d8334fc51e5') then 'cUSDC'

when TO_ADDRESS = lower('0x8ccfbc13159c5916dbbf5815d899411aeb1876ef') then 'cDAI'

when TO_ADDRESS = lower('0x07ced903e6ad0278cc32bc83a3fc97112f763722') then 'Volts Pool'

when TO_ADDRESS = lower('0x2657101a6bb5538dd84b0b8c8e2deac667b9c66c') then 'Volts Pool'

when TO_ADDRESS = lower('0x13e9053d9090ed6a1fae3f59f9bd3c1fca4c5726') then 'Volts Pool'

end as token2,

concat(token1, ' => ', token2) as swap,

COUNT(DISTINCT tx_hash) as tx_cnt,