zakkisyedTVL Inflow in ETH mainnet
    Updated 2024-05-09
    WITH daily_eth_sums AS (
    SELECT
    DATE_TRUNC('hour', block_timestamp) AS date,
    SUM(value) AS daily_sum
    FROM
    ethereum.core.fact_traces
    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_TRUNC('hour', block_timestamp) ASC
    )
    SELECT
    date,
    daily_sum,
    SUM(daily_sum) OVER (ORDER BY date ASC) AS cumulative_eth
    FROM
    daily_eth_sums
    ORDER BY
    date DESC;

    QueryRunArchived: QueryRun has been archived