theericstone2023-07-25 08:30 PM
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
›
⌄
⌄
/*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