polygon_prices AS (

SELECT

prices.block_timestamp::date AS day,

prices.token_contract,

prices.symbol,

CASE

WHEN symbol = 'WMATIC' THEN 'Native Coin'

WHEN symbol IN ('USDC', 'USDT', 'BUSD', '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

polygon.sushi.ez_swaps

WHERE

block_timestamp::date >=CURRENT_DATE- INTERVAL '{{period}}'

AND symbol_out IN ('USDC', 'USDT', 'BUSD', '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

polygon.sushi.ez_swaps

WHERE

block_timestamp::date >=CURRENT_DATE- INTERVAL '{{period}}'