Swap activity across all hours of the day (Last 30 Days)

victor-sanzcapdetSwap activity across all hours of the day (Last 30 Days)

Updated 2025-02-10

SELECT

EXTRACT(HOUR FROM block_timestamp) AS hour_of_day,

COUNT(tx_hash) AS swap_count

FROM

aptos.defi.ez_dex_swaps

WHERE

block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)

GROUP BY

hour_of_day

ORDER BY

hour_of_day ASC;

Last run: 3 months ago

255B

flipside