zakkisyedCommunity Treasury Balance
    Updated 2023-07-03
    WITH og AS (
    SELECT SUM(raw_amount / 1e18) AS outgoing, DATE_TRUNC('day', block_timestamp) AS date
    FROM ethereum.core.ez_token_transfers
    WHERE from_address = '0x8c02d4cc62f79aceb652321a9f8988c0f6e71e68' -- ECO Association
    AND contract_address = '0x8dbf9a4c99580fc7fd4024ee08f3994420035727'
    GROUP BY DATE_TRUNC('day', block_timestamp)
    ),
    ig AS (
    SELECT SUM(raw_amount / 1e18) AS incoming, DATE_TRUNC('day', block_timestamp) AS date
    FROM ethereum.core.ez_token_transfers
    WHERE to_address = '0x8c02d4cc62f79aceb652321a9f8988c0f6e71e68' -- ECO Association
    AND contract_address = '0x8dbf9a4c99580fc7fd4024ee08f3994420035727'
    GROUP BY DATE_TRUNC('day', block_timestamp)
    ),
    combined AS (
    SELECT COALESCE(og.date, ig.date) AS date,
    COALESCE(og.outgoing, 0) AS outgoing,
    COALESCE(ig.incoming, 0) AS incoming
    FROM og
    FULL OUTER JOIN ig ON og.date = ig.date
    ),
    cumulative AS (
    SELECT date,
    SUM(incoming - outgoing) OVER (ORDER BY date) AS cumulative_balance
    FROM combined
    )
    SELECT date, cumulative_balance
    FROM cumulative
    ORDER BY DATE DESC;

    Run a query to Download Data