damidezBlast token copy
Updated 2024-12-17
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
›
⌄
WITH LatestPrice AS (
SELECT
DATE_TRUNC('hour', hour) AS hourly,
price,
FROM
blast.price.ez_prices_hourly
WHERE
TOKEN_ADDRESS = LOWER('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')
AND symbol = 'BLAST'
AND hour::date = '2024-07-26'
ORDER BY hour desc
limit 1;
),
MinPrice AS (
SELECT
MIN(price) AS min_price
FROM
blast.price.ez_prices_hourly
WHERE
TOKEN_ADDRESS = LOWER('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')
AND symbol = 'BLAST'
AND hour::date >= '2024-06-26'
AND hour::date <= '2024-07-26'
)
SELECT
Round(lp.price, 6) AS latest_price,
Round(mp.min_price, 6) AS ATL,
((lp.price - mp.min_price) / mp.min_price) * 100 AS percentage_change
FROM
LatestPrice lp, MinPrice mp
QueryRunArchived: QueryRun has been archived