select * from (

VALUES

('A.cfdd90d4a00f7b5b.TeleportedTetherToken','USDT'),

('A.0f9df91c9121c460.BloctoToken','BLT'),

('A.231cc0dbbcffc4b7.RLY','RLY'),

('A.b19436aae4d94622.FiatToken','USDC'),

('A.142fa6570b62fd97.StarlyToken','STARLY'),

('A.1654653399040a61.FlowToken','WFLOW'),

('A.d01e482eb680ec9f.REVV','REVV'),

('A.231cc0dbbcffc4b7.ceWBTC','WBTC'),

('A.231cc0dbbcffc4b7.ceWETH','WETH'),

('A.231cc0dbbcffc4b7.ceMATIC','WMATIC'),

('A.231cc0dbbcffc4b7.ceBUSD','BUSD'),

('A.231cc0dbbcffc4b7.ceUSDT','USDT'),

('A.231cc0dbbcffc4b7.ceAVAX','WAVAX'),

('A.231cc0dbbcffc4b7.ceFTM','FTM'),

('A.231cc0dbbcffc4b7.ceDAI','DAI')

) as a (token_address, symbol)

,

token_price as (

select

date_trunc('day',hour) as date,

b.token_address,

b.symbol ,

median(price) as price

from ethereum.price.ez_prices_hourly a

join token_info b ON a.symbol = b.symbol

group by 1 , 2 , 3

,

main as (

select

tx_id,

block_timestamp,