WITH

weeth as (

SELECT

date_trunc('day', block_timestamp) as day,

to_address as address,

SUM(amount_usd) as amount

FROM

ethereum.core.ez_token_transfers

WHERE contract_address = lower('0x35fA164735182de50811E8e2E824cFb9B6118ac2')

GROUP BY 1, 2

UNION ALL

SELECT

date_trunc('day', block_timestamp) as day,

from_address as address,

-SUM(amount_usd) as amount

FROM

ethereum.core.ez_token_transfers

WHERE contract_address = lower('0x35fA164735182de50811E8e2E824cFb9B6118ac2')

GROUP BY 1, 2

),

agg as (

SELECT

address as wallet_address,

SUM(amount) as balance

FROM

weeth where address <> '0x0000000000000000000000000000000000000000' and day<'2024-03-18'

GROUP BY 1

),

etherfi_list as (

SELECT

distinct wallet_address, balance as eETH_deposited

from agg where eETH_deposited is not null and eETH_deposited>0

),