with arbitrum_prices AS (

SELECT

prices.block_timestamp::date AS day,

prices.token_contract,

prices.symbol,

CASE

WHEN prices.symbol = 'WETH' THEN 'Native Coin'

WHEN prices.symbol IN ('USDC', 'USDT', 'DAI', 'FRAX', 'TUSD') THEN 'Stablecoins'

ELSE 'Other Tokens'

END AS token_type,

AVG(contracts.token_decimals) AS decimals,

AVG(prices.price) AS price

FROM (

SELECT

block_timestamp,

token_in AS token_contract,

symbol_in AS symbol,

(amount_out / amount_in) AS price

FROM

arbitrum.sushi.ez_swaps

WHERE

block_timestamp::date BETWEEN (CURRENT_DATE - {{days_back}} - 1) AND (CURRENT_DATE - 1)

AND symbol_out IN ('USDC', 'USDT', 'DAI', 'FRAX', 'TUSD')

AND amount_in > 0

AND amount_out > 0

UNION

SELECT

block_timestamp,

token_out AS token_contract,

symbol_out AS symbol,

(amount_in / amount_out) AS price

FROM

arbitrum.sushi.ez_swaps

WHERE