Query editor
WITH raw_pools AS (SELECThttp_get('https://api.indexer.omnipair.fi/api/v1/pools?limit=1000&sortBy=tvl&sortOrder=desc') AS response),parsed_data AS (SELECT json_parse(response) AS parsed_jsonFROM raw_pools),pools_extracted AS (SELECTCAST(json_extract(parsed_json, '$.data.pools') AS ARRAY(JSON)) AS pools_arrayFROM parsed_data),unnested AS (SELECT poolFROM pools_extracted,UNNEST(pools_array) AS t(pool)),pool_metadata AS (SELECTjson_extract_scalar(pool, '$.id') AS id,json_extract_scalar(pool, '$.pair_address') AS pool_address,json_extract_scalar(pool, '$.token0.symbol') || '/' ||json_extract_scalar(pool, '$.token1.symbol') AS pair,json_extract_scalar(pool, '$.token0.address') AS token0_mint,json_extract_scalar(pool, '$.token1.address') AS token1_mint,CAST(json_extract_scalar(pool, '$.token0.decimals') AS DOUBLE) AS dec0,CAST(json_extract_scalar(pool, '$.token1.decimals') AS DOUBLE) AS dec1,CAST(json_extract_scalar(pool, '$.total_debts.token0') AS DOUBLE) AS raw_debt0,CAST(json_extract_scalar(pool, '$.total_debts.token1') AS DOUBLE) AS raw_debt1,CAST(json_extract_scalar(pool, '$.interest_rates.token0') AS DOUBLE) AS interest_rate0,CAST(json_extract_scalar(pool, '$.interest_rates.token1') AS DOUBLE) AS interest_rate1FROM unnested),vault_balances AS (SELECTlb.token_balance_owner AS pool_address,lb.token_mint_address,CAST(lb.token_balance AS DOUBLE) AS token_balanceFROM solana_utils.latest_balances lbWHERE lb.token_balance_owner IN (SELECT pool_address FROM pool_metadata)AND lb.token_balance > 0AND lb.updated_at >= DATE '2026-02-16'),pool_balances AS (SELECTpool_address,token_mint_address,SUM(token_balance) AS total_balanceFROM vault_balancesGROUP BY pool_address, token_mint_address),all_mints AS (SELECT array_join(array_agg(DISTINCT token_mint_address), ',') AS mint_listFROM pool_balances),