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.symbol') AS token0_symbol,json_extract_scalar(pool, '$.token1.symbol') AS token1_symbol,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, '$.utilization.token0') AS DOUBLE) AS util0,CAST(json_extract_scalar(pool, '$.utilization.token1') AS DOUBLE) AS util1,CAST(json_extract_scalar(pool, '$.swap_fee_bps') AS DOUBLE) AS swap_fee_bps,CAST(json_extract_scalar(pool, '$.apr.apr') AS DOUBLE) AS apr,CAST(json_extract_scalar(pool, '$.apr.apr_breakdown.token0_apr') AS DOUBLE) AS token0_apr,CAST(json_extract_scalar(pool, '$.apr.apr_breakdown.token1_apr') AS DOUBLE) AS token1_apr,CAST(json_extract_scalar(pool, '$.volume_24h.volumeUsd') AS DOUBLE) AS volume_usd_24h,CAST(json_extract_scalar(pool, '$.total_fees_paid.total_fee_paid_in_token0') AS DOUBLE) AS raw_fees0,CAST(json_extract_scalar(pool, '$.total_fees_paid.total_fee_paid_in_token1') AS DOUBLE) AS raw_fees1FROM 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,