SELECT

DATE_TRUNC('day', block_timestamp) AS date,

SUM(CASE WHEN amount_usd > 50000 THEN amount_usd ELSE 0 END) AS whale_volume,

SUM(CASE WHEN amount_usd <= 50000 THEN amount_usd ELSE 0 END) AS retail_volume

FROM avalanche.core.ez_token_transfers

WHERE to_address IN (SELECT DISTINCT pool_address FROM avalanche.defi.dim_dex_liquidity_pools)

AND block_timestamp >= DATEADD(MONTH, -6, CURRENT_DATE)

GROUP BY 1

SELECT date, whale_volume, retail_volume

FROM whale_vs_retail

ORDER BY 1