CartanGroupMarket Cap APTOS copy
Updated 2024-10-14
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
›
⌄
with price_aptos as (
SELECT 'Aptos [APT]' as network,
TO_TIMESTAMP(value[0]::string) as date,
value[1] as price,
((price - LAG(price)over(ORDER BY date))/LAG(price)over(ORDER BY date))*100 as daily_change
FROM (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/aptos/market_chart?vs_currency=usd&days=365&interval=daily&precision=3') as response
),LATERAL FLATTEN (input => response:data:prices)
)
,
market_cap as (
SELECT
TO_TIMESTAMP(value[0]::string) as date,
value[1] as market_cap_usd
FROM (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/aptos/market_chart?vs_currency=usd&days=365&interval=daily&precision=3') as response
),LATERAL FLATTEN (input => response:data:market_caps)
)
,
trading_volume as (
SELECT
TO_TIMESTAMP(value[0]::string) as date,
value[1] as trading_volume_usd
FROM (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/aptos/market_chart?vs_currency=usd&days=365&interval=daily&precision=3') as response
),LATERAL FLATTEN (input => response:data:total_volumes)
)
SELECT
a.date,
price,
IFF(price > LAG(price) over (ORDER BY date), '🟢', IFF(price = LAG(price) over (ORDER BY date), '⚪', '🔴')) as " ",
QueryRunArchived: QueryRun has been archived