TOKEN_IN,

sum ((AMOUNT_IN/pow(10,DECIMALS)) * PRICE_USD) as USD

FROM near.core.ez_dex_swaps

LEFT JOIN (SELECT date_trunc ('day',TIMESTAMP) as datea,SYMBOL,avg (PRICE_USD) as PRICE_USD FROM near.core.fact_prices GROUP BY 1,2) b

on (datea::date = date_trunc ('day',BLOCK_TIMESTAMP)

and SYMBOL = TOKEN_IN)

JOIN near.core.dim_token_labels on TOKEN_CONTRACT = TOKEN_IN_CONTRACT

LEFT JOIN near.core.fact_transactions using (TX_HASH)

WHERE TX_STATUS = 'Success'

AND AMOUNT_IN is not NULL

AND BLOCK_TIMESTAMP >= '2023-01-01'

GROUP BY 1