SELECT

recorded_at::date AS day,

address AS token_contract,

symbol,

AVG(price) AS price

FROM

osmosis.core.dim_prices

JOIN

osmosis.core.dim_labels

ON

dim_prices.symbol = dim_labels.project_name

WHERE

recorded_at::date >= '2022-01-01'

AND price > 0

GROUP BY

day,

token_contract,

symbol

),

Osmosis AS (

SELECT

swaps.block_timestamp,

swaps.tx_id AS tx,

'Osmosis' AS dex,

swaps.trader AS swapper,

swaps.from_currency AS from_token_contract,

swaps.to_currency AS to_token_contract,

CASE

WHEN from_token_contract = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858' THEN 'axlUSDC'

WHEN from_token_contract = 'ibc/9F9B07EF9AD291167CF5700628145DE1DEB777C2CFC7907553B24446515F6D0E' THEN 'USDC'

WHEN from_token_contract = 'ibc/5973C068568365FFF40DEDCF1A1CB7582B6116B731CD31A12231AE25E20B871F' THEN 'EEUR'

ELSE prices_from.symbol

END AS from_token,

CASE

WHEN to_token_contract = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858' THEN 'axlUSDC'