SELECT

date(recorded_hour) as date1,

median(price) as token_price

FROM osmosis.price.ez_prices

WHERE symbol LIKE 'AXL'

GROUP BY 1

), tab1 as (

SELECT

created_at,

id,

amount,

data,

fees,

data:call:receipt:from as user,

data:call:chain as source_chain,

data:call:returnValues:destinationChain as destination_chain,

fees:token:token_price:usd as token_price1,

case when NOT token_price1 is NULL

then token_price1

when data:approved:returnValues:symbol LIKE '%USDC%' then 1

when data:approved:returnValues:symbol LIKE '%USDT%' then 1

when data:approved:returnValues:symbol LIKE '%DAI%' then 1

when data:approved:returnValues:symbol LIKE '%MAI%' then 1

when call:returnValues:symbol LIKE '%USDC%' then 1

when call:returnValues:symbol LIKE '%USDT%' then 1

when call:returnValues:symbol LIKE '%DAI%' then 1

when call:returnValues:symbol LIKE '%MAI%' then 1

when call:returnValues:symbol LIKE 'AXL' then token_price

end as token_price2

FROM axelar.axelscan.fact_gmp

LEFT outer JOIN tab0

on date1 = date(created_at)

WHERE not amount is NULL

AND SIMPLIFIED_STATUS LIKE 'received'