KeyrockAptos - Liquidswap - Pool TVL APT/USDT
Updated 2024-10-25
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
›
⌄
⌄
-- forked from Aptos - Liquidswap - Pool TVL APT/USDT @ https://flipsidecrypto.xyz/edit/queries/fabfc538-e66e-4ef5-8e97-70be31893b79
/*
https://www.geckoterminal.com/aptos/pools/60f989de-2cf7-4df9-a022-149f204e3fd2
https://tracemove.io/transaction/0xc2812ac8b8b0579d1fea13cf92c108d5d4c7699741746a8a1160f088631ca6d2
https://tracemove.io/transaction/version/4183960
*/
WITH
apt_CTE AS (
WITH raw_data AS (
SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/aptos/market_chart?vs_currency=usd&days=max') AS resp
)
SELECT
'prices' AS key,
TO_TIMESTAMP(value[0]::string) AS day_price,
value[1] AS apt_price
FROM
raw_data,
LATERAL FLATTEN (input => resp:data:prices)
),
USDT_CTE AS (
WITH raw_data AS (
SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/tether/market_chart?vs_currency=usd&days=max') AS resp
)
SELECT
'prices' AS key,
TO_TIMESTAMP(value[0]::string) AS day_price,
value[1] AS USDT_price
FROM
raw_data,
QueryRunArchived: QueryRun has been archived