WITH ft_protocol_stats AS (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS HOUR,

COUNT(*) AS Tx,

SUM(decoded_log:ethAmount::NUMBER / 1e18) AS volume,

SUM(decoded_log:protocolEthAmount::NUMBER / 1e18) AS fees

FROM

base.core.fact_decoded_event_logs

WHERE

contract_address = '0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4'

AND block_timestamp > '2023-08-05'

AND decoded_log:shareAmount::NUMBER > 0

GROUP BY 1

HOUR,

Tx,

volume,

fees,

SUM(Tx) OVER (ORDER BY HOUR) AS cumulative_Tx,

SUM(volume) OVER (ORDER BY HOUR) AS cumulative_volume,

SUM(fees) OVER (ORDER BY HOUR) AS cumulative_fees

FROM ft_protocol_stats

order by HOUR;