select * from ( values

('USDC', 'USD Coin', 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'),

('SOL', 'Solana', 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL'),

('WIF', 'DogWifHat', '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH'),

('tETH', 'Turbo ETH', 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn'),

('ORCA', 'Orca', '2tGbYEm4nuPFyS6zjDTELzEhvVKizgKewi6xT7AaSKzn'),

('USDT', 'Tether USD', 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm'),

('TIA', 'Celestia', '9RryNMhAVJpAwAGjCAMKbbTFwgjapqPkzpGMfTQhEjf8'),

('STTIA', 'Stride Staked TIA', 'V5m1Cc9VK61mKL8xVYrjR7bjD2BC5VpADLa6ws3G8KM'),

('WEETHS', 'Super Symbiotic LRT', 'F72PqK74jc28zjC7kWDk6ykJ2ZAbjNzn2jaAY9v9M6om'),

('WBTC', 'Wrapped BTC', '7UTjr1VC6Z9DPsWD6mh5wPzNtufN17VnzpKS3ASpfAji')

) as t(symbol, name, mint)

, eth_price as (

select

hour,

price,

'ETH' as eth_symbol,

'Eth1111111111111111111111111111111111111111' as eth_mint

from crosschain.price.ez_prices_hourly

where blockchain = 'ethereum'

and is_native

and hour >= '2024-08-29'

, price as (

select

hour::date as price_date,

iff(token_address = '7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs', 'tETH', symbol) as price_symbol,

avg(price) as price

from crosschain.price.ez_prices_hourly

where token_address in (

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', -- USDC

'So11111111111111111111111111111111111111112', -- SOL

'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm', -- WIF

'7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs', -- ETH