zakkisyedECO Inc. 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 = '0xa201d3c815ac9d4d8830fb3de2b490b5b0069aca' -- ECO Inc
    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 = '0xa201d3c815ac9d4d8830fb3de2b490b5b0069aca' -- ECO Inc
    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;

    Run a query to Download Data