0xpblaptos volume USDT/APT Volume
Updated 2024-03-21
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 volume USDT/APT Volume @ https://flipsidecrypto.xyz/edit/queries/59af45d0-9970-49e2-af89-8c121874ccba
-- forked from aptos volume USDT/APT Volume @ https://flipsidecrypto.xyz/edit/queries/70b6bb3f-2baa-4481-9fac-8ef6c57aa51d
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,
LATERAL FLATTEN (input => resp:data:prices)
),
event_summary AS (
SELECT
QueryRunArchived: QueryRun has been archived