Question

A token's aggregate DEX liquidity is the sum of pool liquidity over every pool in the universe (same network) whose base token is that token; every pool of a qualifying token matches. Find DEX liquidity pools in the top-200-by-24h-volume universe of each supported network with base token's aggregate DEX liquidity greater than $50M, network equal to base. Scope: only entities with a known value for token dex liquidity usd, network in the snapshot; entities lacking any of them are out of scope and must not be returned. Entity ids are pool ids of the form network:pooladdress exactly as listed in the snapshot. EVM pool addresses (0x…) are lowercase hex and case-insensitive; Solana and other base58 addresses are CASE-SENSITIVE and must be returned exactly as shown. Across ALL entities that match the conditions above, what is the median Base token DEX liquidity (USD) (Sum of pool_liquidity_usd over every fetched pool on the same network whose base token has the same contract address (the token's aggregate liquidity within the supported pool universe).)? Median = the middle value, or the mean of the two middle values for an even count. Answer in absolute USD. Clarification: in "network equal to base", base is the network id of the Base L2 chain (the value of the network field), not the pool's base token; the condition keeps only pools whose network field equals "base".