Query editor
WITH liquidity_summary AS (SELECTliquidity.day,pool.address,CONCAT(pool.blockchain, '_', pool.project, '_', pool.other_symbol, '_', SUBSTRING(CAST(pool.address AS varchar), -3)) AS pool_id,liquidity.balance_usd AS TVL,SUM(liquidity.balance_usd) OVER (ORDER BY liquidity.day) AS agg_TVL,liquidity.balance_usd / SUM(liquidity.balance_usd) OVER (ORDER BY liquidity.day) AS "Pool Distribution (%)"FROM query_4283750 AS liquidityLEFT JOIN "query_3993441(token_address='0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409', start_date='2023-04-28 11:15:10')" AS poolON liquidity.address = pool.addressAND liquidity.blockchain = pool.blockchainWHEREliquidity.day > DATE_ADD('day', -2, CURRENT_TIMESTAMP))SELECT * FROM liquidity_summaryWHERE "Pool Distribution (%)" > 1e-4