addresses AS (

SELECT

TO_ADDRESS

FROM

ethereum.core.fact_traces

WHERE

FROM_ADDRESS = '0x2313f80d53c649c7b2c9c4d101b796f34cbe80f3'

AND TYPE = 'CREATE'

AND TX_STATUS = 'SUCCESS'

),

transfers AS (

SELECT

TX_HASH,

CONTRACT_ADDRESS,

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week,

SUM(

iff(

FROM_ADDRESS IN (

SELECT

TO_ADDRESS

FROM

addresses

),

- RAW_AMOUNT,

RAW_AMOUNT

)

) AS dust

FROM

ethereum.core.fact_token_transfers

WHERE

(

FROM_ADDRESS IN (

SELECT

TO_ADDRESS

FROM