theericstonepull polygon univ3 pools form thegraph
Updated 2023-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- thank you messari!
-- https://thegraph.com/hosted-service/subgraph/messari/uniswap-v3-polygon
with toppools as (
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
value:id as pool_address,
value:name as pool_name,
value:inputTokens[0]:id as token0_address,
value:inputTokens[1]:id as token1_address,
value:inputTokens[0]:symbol as token0_symbol,
value:inputTokens[1]:symbol as token1_symbol
from raw, lateral flatten(input => parse_json(rawoutput:data:data:liquidityPools))
)
SELECT
fdel.contract_address as pool,
Run a query to Download Data