select date, hourly_sum as ETH_TVL,
sum(hourly_sum) OVER (ORDER BY date ASC) as cumulative_eth_TVL
from(
SELECT
DATE_TRUNC('hour', block_timestamp) AS date,
SUM(value) AS hourly_sum
FROM
ethereum.core.fact_transactions
WHERE
LOWER(to_address) = LOWER('0x036676389e48133b63a802f8635ad39e752d375d')
and block_timestamp >= '2024-05-08 04:30:00.000'
GROUP BY
DATE_TRUNC('hour', block_timestamp)
)
ORDER BY date desc