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)

, price as (

select hour::date as date,

iff(symbol = 'ETH', 'tETH', symbol) as price_symbol,

blockchain,

--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

'orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE', -- ORCA

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', -- USDT

'ibc/D79E7D83AB399BFFF93433E54FAA480C191248FC556924A2A8351AE2638B3877', -- TIA

'ibc/698350B8A61D575025F3ED13E9AC9C0F45C89DEFE92F76D5838F1D3C1A7FF7C9', -- STTIA

'0x917cee801a67f933f2e6b33fc0cd1ed2d5909d88', -- WEETHS

'3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh' -- WBTC

)

group by 1,2,3