date_trunc('hour', block_timestamp) as date,

avg(token_price) as "SWEAT (USD)",

max(token_price) as "SWEAT (USD) - Max",

round("SWEAT (USD)"/0.00714,2) as "ROI"

FROM ethereum.core.ez_token_transfers

WHERE contract_address = '0xb4b9dc1c77bdbb135ea907fd5a08094d98883a35' AND block_timestamp > '2022-09-13 08:00:00.000'

AND token_price IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC