Updated 2025-01-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
›
⌄
WITH price_data AS (
SELECT
token_address,
symbol,
decimals,
price,
DATE_TRUNC('day', hour) AS day
FROM
aptos.price.ez_prices_hourly
),
current_price AS (
SELECT
token_address,
symbol,
decimals,
price AS current_price,
hour AS current_hour
FROM
aptos.price.ez_prices_hourly
WHERE
hour = (SELECT MAX(hour) FROM aptos.price.ez_prices_hourly WHERE token_address = aptos.price.ez_prices_hourly.token_address)
),
price_change_24hr AS (
SELECT
token_address,
symbol,
decimals,
price AS price_24hr,
hour AS hour_24hr
FROM
aptos.price.ez_prices_hourly
WHERE
hour = (SELECT MAX(hour) FROM aptos.price.ez_prices_hourly WHERE token_address = aptos.price.ez_prices_hourly.token_address AND hour <= current_timestamp - INTERVAL '1 DAY')
),
price_change_7d AS (
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived