KeyrockUSDC/USDC on Aptos
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 wETH/USDCW @ https://flipsidecrypto.xyz/edit/queries/44d65c5c-7204-4b32-b927-d2ac4d2eebfd
/*
https://www.geckoterminal.com/USDCWos/pools/3bbb2b35-542c-4374-856b-3c24659d5c44
*/
WITH
USDCW_CTE AS (
WITH raw_data AS (
SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/usd-coin-wormhole-from-ethereum/market_chart?vs_currency=usd&days=max') AS resp
)
SELECT
'prices' AS key,
TO_TIMESTAMP(value[0]::string) AS day_price,
value[1] AS USDCW_price
FROM
raw_data,
LATERAL FLATTEN (input => resp:data:prices)
),
USDC_CTE AS (
WITH raw_data AS (
SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/usd-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 usdc_price
FROM
raw_data,
LATERAL FLATTEN (input => resp:data: prices)
),
QueryRunArchived: QueryRun has been archived