zakkisyedETH Mainnet TVL on KelpDAO: MMM Campaign
    Updated 2024-05-23
    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
    QueryRunArchived: QueryRun has been archived