with pricet as (

select timestamp::date as day,

token_contract as Token1,

avg (price_usd) as USDPrice

from flow.core.fact_prices

where timestamp::date >= '2022-12-17'

group by 1,2

union ALL

select block_timestamp::date as day,

swap_from_mint as token1,

median (swap_to_amount/swap_from_amount) as USD_Price

from solana.fact_swaps

where swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') --USDC,USDT

and swap_to_amount > 0

and swap_from_amount > 0

and succeeded = 'TRUE'

and block_timestamp::date >= '2022-12-17'

group by 1,2

union ALL

select timestamp::date as day,

token_contract as Token1,

avg (price_usd) as USDPrice

from near.core.fact_prices

where timestamp::date >= '2022-12-17'

and symbol = 'wNEAR'

group by 1,2),

maintable as (

select 'Ethereum' as chain,

block_timestamp::date as date,

case when date >= '2022-12-24' and date < '2023-01-04' then 'Holidays'