SELECT

DISTINCT address

FROM flipside_prod_db.crosschain.address_labels

WHERE address_name LIKE 'celsius wallet'

SELECT

date_trunc('week', block_timestamp) as day,

symbol,

sum(AMOUNT_USD) as value

FROM ethereum.core.ez_token_transfers

WHERE FROM_ADDRESS in (SELECT * FROM tab1)

and NOT TO_ADDRESS in (SELECT * FROM tab1)

AND AMOUNT_USD is not NULL

GROUP BY 1,2