SELECT

date(recorded_hour) AS date1,

median(price) AS token_price

FROM osmosis.price.ez_prices

WHERE symbol LIKE 'AXL'

GROUP BY date1

), tab1 AS (

SELECT

created_at,

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 fees:token:token_price:usd IS NOT NULL THEN fees:token:token_price:usd

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 data:call:returnValues:symbol LIKE '%USDC%' THEN 1

WHEN data:call:returnValues:symbol LIKE '%USDT%' THEN 1

WHEN data:call:returnValues:symbol LIKE '%DAI%' THEN 1

WHEN data:call:returnValues:symbol LIKE '%MAI%' THEN 1

WHEN data:call:returnValues:symbol LIKE 'AXL' THEN tab0.token_price

END AS token_price2

FROM axelar.axelscan.fact_gmp

LEFT OUTER JOIN tab0

ON date(tab0.date1) = date(axelar.axelscan.fact_gmp.created_at)

WHERE amount IS NOT NULL

AND SIMPLIFIED_STATUS LIKE 'received'

AND (fees:token:token_price:usd IS NOT NULL OR token_price2 IS NOT NULL)