KeyrockAptos - THALA - Pool TVL MOD/THL 80:20
Updated 2024-03-05
999
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 THALAos - Liquidswap - Pool TVL THALA/MOD @ https://flipsidecrypto.xyz/edit/queries/2d1b2a25-d2bf-4e2c-a735-efc9f58acc76
-- forked from THALAos - Liquidswap - Pool TVL THALA/MOD @ https://flipsidecrypto.xyz/edit/queries/fabfc538-e66e-4ef5-8e97-70be31893b79
/*
https://www.geckoterminal.com/THALAos/pools/60f989de-2cf7-4df9-a022-149f204e3fd2
https://tracemove.io/transaction/0xc2812ac8b8b0579d1fea13cf92c108d5d4c7699741746a8a1160f088631ca6d2
https://tracemove.io/transaction/version/4183960
*/
/*
WITH
THALA_CTE AS (
WITH raw_data AS (
SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/thala/market_chart?vs_currency=usd&days=max') AS resp
)
SELECT
'prices' AS key,
TO_TIMESTAMP(value[0]::string) AS day_price,
value[1] AS THALA_price
FROM
raw_data,
LATERAL FLATTEN (input => resp:data:prices)
),
MOD_CTE AS (
WITH raw_data AS (
SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/move-dollar/market_chart?vs_currency=usd&days=max') AS resp
)
SELECT
QueryRunArchived: QueryRun has been archived