SELECT

price,

hour,

token_address

FROM

kaia.price.ez_prices_hourly p

WHERE

p.token_address = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'

),

platform_data AS (

SELECT

s.platform,

COUNT(DISTINCT s.tx_hash) AS TotalSwaps,

SUM(s.amount_in * p.price) AS TotalSwapVolume

FROM

kaia.defi.ez_dex_swaps s

JOIN price p ON s.token_in = p.token_address

AND date_trunc('hour', s.block_timestamp) = p.hour

WHERE

s.token_in = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'

GROUP BY

s.platform

*

platform_data

ORDER BY

TotalSwapVolume DESC;