SELECT

b.balance_date,

CASE WHEN pool_name REGEXP 'USDT' THEN 'USDT'

WHEN pool_name REGEXP 'USDC' THEN 'USDC' ELSE

'DAI' END AS token,

--p.pool_name,

p.platform, SUM(balance) AS daily_supply

FROM

ethereum.erc20_balances b

INNER JOIN

ethereum.dex_liquidity_pools p ON b.user_address = p.pool_address

WHERE balance_date > CURRENT_DATE - interval '9 months' AND balance > 0 AND pool_name REGEXP '(USDC|DAI|USDT).+ LP$'

GROUP BY 1,2,3