with arbitrum as (select origin_from_address as "Swapper", amount_in_usd as "Swap Volume ($USD)", block_timestamp::date as "Date",

symbol_in || '➡' || symbol_out as "Swap Route",

case when token_in=lower('0x23ee2343b892b1bb63503a4fabc840e0e2c6810f') then '🔴Sell' else '🟢Buy' end as "Action", 'Arbitrum' as "Chain"

, tx_hash as "TX Hash"

from arbitrum.defi.ez_dex_swaps

where (token_in=lower('0x23ee2343b892b1bb63503a4fabc840e0e2c6810f') or token_out=lower('0x23ee2343b892b1bb63503a4fabc840e0e2c6810f'))

and block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}'

order by 2 desc

limit 100),

bsc as (select origin_from_address as "Swapper", amount_in_usd as "Swap Volume ($USD)", block_timestamp::date as "Date",

symbol_in || '➡' || symbol_out as "Swap Route",

case when token_in=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') then '🔴Sell' else '🟢Buy' end as "Action", 'BSC' as "Chain"

, tx_hash as "TX Hash"

from bsc.defi.ez_dex_swaps

where (token_in=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65') or token_out=lower('0x8b1f4432f943c465a973fedc6d7aa50fc96f1f65'))

and block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and amount_in_usd is not null

order by 2 desc

limit 100),

avalanche as (select origin_from_address as "Swapper", amount_in_usd as "Swap Volume ($USD)", block_timestamp::date as "Date",

symbol_in || '➡' || symbol_out as "Swap Route",

case when token_in=lower('0x44c784266cf024a60e8acf2427b9857ace194c5d') then '🔴Sell' else '🟢Buy' end as "Action", 'Avalanche' as "Chain"

, tx_hash as "TX Hash"

from avalanche.defi.ez_dex_swaps

where (token_in=lower('0x44c784266cf024a60e8acf2427b9857ace194c5d') or token_out=lower('0x44c784266cf024a60e8acf2427b9857ace194c5d'))

and block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and amount_in_usd is not null