price_list as (

select

block_timestamp::date as day,

swap_from_mint,

avg (swap_to_amount/swap_from_amount) as price_usd

from solana.fact_swaps

where swap_to_mint in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')

and succeeded = 1

and swap_to_amount > 0

and swap_from_amount > 0

group by 1,2

case swap_from_mint

when 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'

when 'So11111111111111111111111111111111111111112' then 'SOL'

when '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' then 'Raydium'

when 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'

when 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then 'ATLAS'

when 'DFL1zNkaGPWm1BqAVqRjCZvHmwTFrEaJtbzJWgseoNJh' then 'DFL'

when '2FPyTwcZLUg1MDrwsyoP4D6s1tM7hAkHYRjkNb5w6Pxk' then 'ETH'

when 'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk' then 'POLIS'

when 'ChVzxWRmrTeSgwd3Ui3UumcN8KX7VK3WaD4KGeSKpypj' then 'Sushi'

when 'SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt' then 'SRM'

when 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' then 'GST'

when 'METAewgxyPbgwsseH8T16a39CQ5VyVxZi9zXiDPY18m' then 'MPLX'

when 'CWBzupvyXN1Cf5rsBEHbzfTFvreLfUaJ77BMNLVJ739y' then 'ATPAY'

when '9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then 'BTC'

when '7dHbWXmci3dT8UFYWYZweBLXgycu7Y3iL6trKn1Y7ARj' then 'stSOL'

when 'HHjoYwUp5aU6pnrvN4s2pwEErwXNZKhxKGYjRJMoBjLw' then 'PIP'

when 'MangoCzJ36AjZyKwVj3VnYU4GTonjfVEnJmvvWaxLac' then 'MNGO'

when '2KE2UNJKB6RGgb78DxJbi2HXSfCs1EocHj4FDMZPr4HA' then 'Slow'

end as token,

count(distinct(tx_id)) "Swaps Count",