SELECT hour::DATE AS dt,token_address,decimals,AVG(price) AS price_daily FROM solana.price.ez_prices_hourly

GROUP BY 1,2,3

), t as (SELECT BLOCK_TIMESTAMP,SWAPPER,TX_ID,'Jupiter' AS PROGRAM,(SWAP_FROM_AMOUNT*price_daily)/pow(10,decimals) AS AMOUNT_USD

FROM solana.defi.fact_swaps

JOIN pricet ON swap_from_mint=token_address AND dt=block_timestamp::DATE

WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-INTERVAL '6 MONTHS'

AND swap_program like 'jupiter%'

AND SUCCEEDED=1)

select * from t order by amount_usd desc limit 100