KeyrockAptos - Pancakeswap - Pool TVL stAPT/APT copy
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 - Pancakeswap - Pool TVL APT/CAKE @ https://flipsidecrypto.xyz/edit/queries/e9a37637-98fc-4b2c-958c-936b51e57902
-- forked from Aptos - Liquidswap - Pool TVL APT/stAPT @ https://flipsidecrypto.xyz/edit/queries/fabfc538-e66e-4ef5-8e97-70be31893b79
/*
https://www.geckoterminal.com/aptos/pools/be1f6e62-db08-428c-945b-22ebce1002a3
*/
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)
),
stAPT_CTE AS (
WITH raw_data AS (
SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/amnis-staked-aptos-coin/market_chart?vs_currency=usd&days=max') AS resp
)
SELECT
'prices' AS key,
TO_TIMESTAMP(value[0]::string) AS day_price,
value[1] AS stAPT_price
FROM
raw_data,
QueryRunArchived: QueryRun has been archived