whitelisted AS(

select

block_timestamp,

tx_hash,

to_address AS user,

amount AS whitelist_amount,

amount_usd,

symbol,

FROM base.core.ez_token_transfers

WHERE block_timestamp::date >= '2025-01-09'

AND contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'

AND to_address not in ('0xe6ec4c661f0b822ba2851b4a1de9ad64132fbfe3','0xdda04ab22bd06ef490621eace04219798dd71bfd')

AND tx_hash = '0x96f04e65252e38752d13071255b946c982ed1fd8b6569e3903cca00e290d477b'

),

uniswap_datas as (

SELECT * FROM base.core.ez_decoded_event_logs

WHERE contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'

AND block_timestamp::date >= '2025-01-09'

),

uniswap_lp AS(

SELECT

block_timestamp, tx_hash,event_name,

(CASE WHEN event_name = 'DecreaseLiquidity' THEN -(decoded_log:amount0/pow(10,18)) ELSE (decoded_log:amount0/pow(10,18)) END) AS amount,

origin_from_address AS user

FROM base.core.ez_decoded_event_logs

WHERE tx_hash in (SELECT tx_hash FROM uniswap_datas)

AND event_name IN ('DecreaseLiquidity','IncreaseLiquidity','SwapAndIncreaseLiquidity')

AND block_timestamp::date >= '2025-01-09'