SELECT

s.trader,

SUM(s.amount_out_usd) AS initial_wnear_balance

FROM

near.defi.ez_dex_swaps s

WHERE

s.block_timestamp < '2024-01-01'

AND s.symbol_out = 'wNEAR'

GROUP BY

s.trader

HAVING

SUM(s.amount_out_usd) BETWEEN 10000 AND 99999

),

near_swaps_2024 AS (

SELECT

s.trader,

s.block_timestamp::DATE AS swap_date,

CONCAT(s.symbol_in, ' -> wNEAR') AS token_pair,

s.amount_in_usd AS token_swap_value_usd,

s.amount_out_usd AS usd_received

FROM

near.defi.ez_dex_swaps s

WHERE

s.block_timestamp >= '2024-01-01'

AND s.block_timestamp <= '2024-12-31'

AND s.symbol_out = 'wNEAR'

AND s.symbol_in IS NOT NULL

AND s.amount_in_usd IS NOT NULL

),

tracked_traders AS (

SELECT

ns.trader,

ns.swap_date,

ns.token_pair,

ns.token_swap_value_usd,