Mrftispiritual-black copy
    Updated 2024-11-24
    -- forked from spiritual-black @ https://flipsidecrypto.xyz/studio/queries/d901923a-84ab-4c24-b31c-3f9d78038c27

    WITH transfers AS (
    WITH tbl3 AS (
    WITH tbl AS (
    SELECT
    to_address AS "Address",
    SUM(amount) AS "Input"
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    contract_address = LOWER('0x358d94b5b2F147D741088803d932Acb566acB7B6') --rSWELL
    GROUP BY 1
    ),
    tbl2 AS (
    SELECT
    from_address AS "Address",
    SUM(amount) AS "Output"
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    contract_address = LOWER('0x358d94b5b2F147D741088803d932Acb566acB7B6') --rSWELL
    GROUP BY 1
    )
    SELECT
    tbl."Address",
    COALESCE(tbl."Input", 0) AS "Input tokens",
    COALESCE(tbl2."Output", 0) AS "Output tokens"
    FROM
    tbl
    LEFT JOIN tbl2 ON tbl."Address" = tbl2."Address"
    )
    SELECT
    "Address",
    "Input tokens" - "Output tokens" AS "Token Balance",
    MIN(DATE_TRUNC('day', block_timestamp)) AS first_transaction_date
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived