SELECT

CASE

WHEN SYMBOL_OUT NOT IN ('USD', 'USDT', 'USDC') THEN SYMBOL_OUT

ELSE SYMBOL_IN

END AS Token,

CASE

WHEN SYMBOL_OUT NOT IN ('USD', 'USDT', 'USDC') THEN TOKEN_OUT

ELSE TOKEN_IN

END AS Token_Contract,

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Trade_Date,

TRADER,

SUM(

CASE

WHEN SYMBOL_OUT NOT IN ('USD', 'USDT', 'USDC') THEN AMOUNT_OUT_USD

WHEN SYMBOL_IN NOT IN ('USD', 'USDT', 'USDC') THEN - AMOUNT_IN_USD

ELSE AMOUNT_OUT_USD - AMOUNT_IN_USD

END

) AS Net_Buy_Volume

FROM

crosschain.defi.ez_dex_swaps

WHERE

BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP - interval '90 days'

AND BLOCKCHAIN != 'osmosis'

AND (

AMOUNT_OUT_USD > 100

OR AMOUNT_IN_USD > 100

) -- Minimum threshold

GROUP BY

Token,

Token_Contract,

Trade_Date,

TRADER

),

rolling_stats AS (

SELECT