datavortexHourlypricr
Updated 2025-01-20
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
›
⌄
⌄
/*
WITH api_data AS (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/official-trump/market_chart?vs_currency=usd&days=30&interval=daily'
) AS market_data
),
flattened_prices AS (
SELECT
DATEADD(
'millisecond',
data.value[0]::bigint,
'1970-01-01 00:00:00'
) AS date,
data.value[1]::float AS price_usd
FROM api_data, LATERAL FLATTEN(input => market_data:data:prices) data
)
SELECT
date::date AS "Date",
price_usd AS "Price (USD)"
FROM flattened_prices
ORDER BY date ASC;
*/
SELECT
date_trunc('hour', hour) as hourly,
symbol,price
from solana.price.ez_prices_hourly
where token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
order by date_trunc('hour', hour)
QueryRunArchived: QueryRun has been archived