SELECT

date_trunc('hour', block_timestamp) AS hour,

COUNT(DISTINCT tx_id) AS hourly_swaps,

COUNT(DISTINCT swapper) AS hourly_swappers,

SUM(swap_from_amount_usd) AS hourly_volume

FROM

solana.defi.ez_dex_swaps

WHERE

swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

GROUP BY

date_trunc('hour', block_timestamp)

SELECT

hour,

hourly_swaps,

hourly_swappers,

hourly_volume,

SUM(hourly_swaps) OVER (ORDER BY hour) AS accumulative_swaps,

SUM(hourly_swappers) OVER (ORDER BY hour) AS accumulative_swappers,

SUM(hourly_volume) OVER (ORDER BY hour) AS accumulative_volume

FROM

hourly_data

ORDER BY

hour;