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