theericstone2023-07-25 08:30 PM

    /*with raw as (
    SELECT
    livequery.live.udf_api(
    'POST',
    'https://api.thegraph.com/subgraphs/name/messari/uniswap-v3-polygon',
    {'Content-Type': 'application/json'},
    {'query':'{
    liquidityPools(first: 200, orderBy: totalValueLockedUSD, orderDirection: desc) {
    id
    totalLiquidity
    name
    inputTokens {
    id
    symbol
    }}
    }',
    'variables':{}
    }
    ) as rawoutput
    )
    */


    SELECT
    playgrounds.query_subgraph(
    'ELUcwgpm14LKPLrBRuVvPvNKHQ9HvwmtKgKSH6123cr7',
    {
    'query': '{
    liquidityPools(first: 200, orderBy: totalValueLockedUSD, orderDirection: desc) {
    id
    totalLiquidity
    name
    inputTokens {
    id
    symbol
    Run a query to Download Data