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

case

when mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'

when mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'

when mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST'

when mint = 'H5kMHghGUKo4MnGEp4mpAMxveDwnRZ4hXeZMWfp5EzGF' then 'UXD'

when mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'

when mint = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'

when mint = 'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71' then 'NIRV'

when mint = 'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6oc' then 'FRAX'

when mint = 'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' then 'DAI'

end as token,

sum(amount) as toal_amount,

count(tx_id) as transaction_count

from solana.core.fact_transfers

where

mint in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt

,'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc

,'H5kMHghGUKo4MnGEp4mpAMxveDwnRZ4hXeZMWfp5EzGF' --UXD

,'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'--USDH

,'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'--pai

,'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71' --nirv

,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6oc'

,'9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' -- 'UST'

,'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' -- 'DAI'

)

AND BLOCK_TIMESTAMP::date >= CURRENT_DATE - 60

group by 1,2

order by 1