Yousefi_1994V3 Pools
Updated 2025-02-08
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 V3_CURRENT_VALID_POOLS AS (
SELECT
LIVEQUERY.LIVE.UDF_API('POST', 'https://the-graph.icecreamswap.com/subgraphs/name/icecreamswap/exchange-v3-core', {'Content-Type': 'application/json'},
{
'query':
'{
pools(where: {id_in: ["0x6063d72ab87a879ba25c68ad09af3937f55a99a8","0x132fa466b0d5b13c6d52471921a7567fd48e7f7e",
"0xbe49470bdbb3c5b05ad5555205dd0a505f8dcca7","0x77e4805b77265e9725e305f45eec304097894e98","0x53433de7e902d0ca281d823a40f036a2fe8266ef",
"0x33edea45492a06b1be26af25e72e28a2d6b20336","0x36d8b0bb39a997867c44ff5a7a04f57c05959026","0x0bebca26ff83a9f3935bc75b9cc9ba7c56deecfe",
"0xb30af70c9bf734e90f841f429bb6f76e7188a28a","0xb3b315c10c9183224ec6a49839b80a7799f70727","0x86a9a9368dc9a55d2a92c372abef83350d4d5feb",
"0x0e1a82c5733d51b5c2d8bcd745d0cb9b2b7de554","0xeb87d0e8bb5327912a144bd77d80d21c95d08ca2","0xe2407c758c31358a01970fdd44fb6be850e2117f",
"0x0357a5a8296b7f263bca7e1cfbcf51971c94796e","0x553db750d2c18a424a145b9440d3aa788b1baee7","0xa5ef23ee0283ee5ccc7571a9665ac7e07be01311",
"0x07adc40c6350a810c0eb2d6eb20cd0fba7055c68","0x2d1417ac98fb53a6b6c3c3fb52e5484498898f13","0x1edfc749e42eeef74071ec0a34f01f29f1088be3",
"0xe1dd5e7bf7a55a1892487b038cb5f8e4d5423b77","0xe858528b41be9271529f7d07c3905302d614f3af","0xdc935f1c4679466210ab02603881775542bce668",
"0xcfbc45ca10ab32d174351a7398461ad50d6f9a7b","0xf64b900e5dd4e6a358bee114206e291058aee682","0xfe12e740bc938ea3f354cbc4088781e2fe160b70",
"0x5a0da1c36a0c1da2d4dc58bc10b4bec9c62e7abb","0x3783eba239a07041f1d2247d2a8fb702112f6bd4","0x0f42ba37a73fc4e9fd889b87034d4ea7922ed79e",
"0x8e3b63686ec7798ea901d31d0e6450102a64afb0","0x60bb57c6dbdf716564bc03b6135f5c1ed5ed8603","0xcdda4add83408b62b256b2666dc87b1ef990d56d",
"0x7f9a0fbaf2bccca3f15751fcaaec9f323cdbf04c","0x3c6acac0ae4cfed13c19207ddf452a18bbd5d599","0x4b6ab3ff02a6b880dda319d4969c81672080ca65",
"0x00333930ee5db0bcd6c0d94c21aa254749e5aa31","0xe09ae08411234c2ca1168e6885f2a2b1656151d9","0xb9988f509dd3413123bf28e1d9945e7dc4a0c8cc",
"0xab9d068f9a4e7c5ed89ace8b70c7edf15d831466","0xabf97ac46d27ae1272c4d17507041c97610f9d1e","0x2442e7bcedb25fb733a2f898a28f60d37df3b7bf",
"0x5a848c716a1b03dddb35624ffb95ecbd18b50e16","0x3e0cd40c4fcbbc28a569807e926f76b686c095dc","0x9b435de7e3504200965161d61ce8afddc3677ae2",
"0x1a1ab0fb7aa3d7842a58bc38b2298357b2d2a49e","0xceea465337fcbeee79e0531e37ea1f92558879f5","0xc159752064b85547c23d6c02b2c0ae85004099fa",
"0xd073b7518d68b32848f7edcc515b29dd8a9594b3","0xdbc7d0dbfbe519e20ca92921ff4702e09b20ea3a","0x386cb37013571da4c4e127d1829276e93f619205"]})
{
id
totalValueLockedUSD
}
}'
}
) AS RESPONSE
),
V3_CURRENT_VALID_POOLS_DETAILS AS (
SELECT
VALUE:id AS POOL_ADDRESS,
VALUE:totalValueLockedUSD::FLOAT AS CURRENT_TVL_USD
QueryRunArchived: QueryRun has been archived