SELECT

hour,

price,

symbol,

token_address,

decimals

FROM solana.price.ez_prices_hourly

),

volume AS (

SELECT

v.block_timestamp,

v.amount,

v.mint,

p.symbol,

p.hour,

(v.amount / POW(10, p.decimals)) * p.price AS volume_usd

FROM solana.core.fact_transfers v

JOIN prices p

ON v.mint = p.token_address

AND v.block_timestamp = p.hour

SELECT *

FROM volume;