DATE_TRUNC('hour', block_timestamp) as hour,

close,

SUM(amount) as volume,

COUNT(DISTINCT TX_ID) as no_of_votes

FROM solana.core.fact_transfers a

JOIN solana.core.ez_token_prices_hourly b

on DATE_TRUNC('hour', a.block_timestamp) = b.recorded_hour

where a.mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and a.tx_to = '9un5wqE3q4oCjyrDkwsdD48KteCJitQX5978Vh7KKxHo'

and b.token_address = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and amount*close >= 10

GROUP BY hour, close