date_trunc(day,BLOCK_TIMESTAMP)::date as date,

case

when SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'Swap to USDC'

when SWAP_TO_MINT = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'Swap to USDT'

else 'Swap to other' end as destination_token,

case

when SWAP_FROM_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'Swap from USDC'

when SWAP_FROM_MINT = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'Swap from USDT'

else 'Swap from other' end as Origin_token,

-- count(distinct tx_id) as transactions,

count(DISTINCT (case when SWAP_TO_MINT in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt

,'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc

,'H5kMHghGUKo4MnGEp4mpAMxveDwnRZ4hXeZMWfp5EzGF' --UXD

,'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'--USDH

,'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'--pai

,'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71' --nirv

,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6oc'

,'9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' -- 'UST'

,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' --dai

) THEN tx_id end)) as swap_to_tx,

sum(case when SWAP_TO_MINT in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt

,'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc

,'H5kMHghGUKo4MnGEp4mpAMxveDwnRZ4hXeZMWfp5EzGF' --UXD

,'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'--USDH

,'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'--pai

,'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71' --nirv

,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6oc'

,'9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' -- 'UST'

,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' --dai

) THEN SWAP_TO_AMOUNT end) as swap_to_amt,

COUNT(DISTINCT (case WHEN SWAP_FROM_MINT in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt

,'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc

,'H5kMHghGUKo4MnGEp4mpAMxveDwnRZ4hXeZMWfp5EzGF' --UXD

,'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'--USDH

,'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'--pai