WITH ALL_UNI_POOLS AS (

SELECT

POOL_ADDRESS,

TOKEN0,

TOKEN1,

PLATFORM

FROM

ethereum.core.dim_dex_liquidity_pools

WHERE PLATFORM = 'uniswap-v2' OR PLATFORM = 'uniswap-v3')

BALANCE_DATE,

SUM(AMOUNT_USD) AS BALANCE_USD,

PLATFORM,

(CASE

WHEN PLATFORM= 'uniswap-v2' THEN 'uniswap'

ELSE 'uniswap'

END) AS GENERAL_PLATFORM

ethereum.erc20_balances, ALL_UNI_POOLS

WHERE USER_ADDRESS = POOL_ADDRESS

AND (CONTRACT_ADDRESS = TOKEN0 OR CONTRACT_ADDRESS= TOKEN1)

AND BALANCE_DATE >= CURRENT_DATE - 90

AND AMOUNT_USD < 500000000

AND AMOUNT_USD IS NOT NULL

GROUP BY BALANCE_DATE,PLATFORM