select recorded_at::date as day,

symbol as tokens,

avg (price) as price_token

from osmosis.core.dim_prices

group by 1,2

union ALL

select hour::date as day,

case when symbol = 'USDC' then 'USDC.axl'

when symbol = 'USDT' then 'USDT.axl'

when symbol = 'aTUSD' then 'USDC.grv'

when symbol = 'sUSD' then 'USDT.grv'

when symbol = 'iUSD' then 'USDX'

when symbol = 'WETH' then 'WETH.axl'

when symbol = 'aWETH' then 'WETH.grv'

when symbol = 'WBTC' then 'WBTC.axl'

when symbol = 'uWBTC' then 'WBTC.grv'

when symbol = 'DAI' then 'DAI.axl'

when symbol = 'aDAI' then 'DAI.grv'

when symbol = 'FRAX' then 'FRAX.axl'

else symbol end as tokens,

avg (price) as price_token

from ethereum.core.fact_hourly_token_prices

group by 1,2)

select

case

when block_timestamp < '2022-11-07' then 'Before FTX crisis'

when block_timestamp >= '2022-11-07' then 'After FTX crisis'

end as time_gp,

count (distinct tx_id) as no_swaps,

count (distinct trader) as no_traders,

sum(FROM_AMOUNT*price_token/pow(10,FROM_DECIMAL)) as transfer_usd,

avg(FROM_AMOUNT*price_token/pow(10,FROM_DECIMAL)) as avg_transfer_usd,