feyikemiPrice stats
Updated 2025-01-09
999
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 CURRENT_PRICE AS (
SELECT
TOKEN_ADDRESS,
hour,
price,
ROW_NUMBER() OVER (PARTITION BY TOKEN_ADDRESS ORDER BY hour DESC) AS rn
FROM bsc.price.ez_prices_hourly
WHERE
token_address = '0x4d3dc895a9edb234dfa3e303a196c009dc918f84' -- $ZBU Contract Address
ORDER BY hour DESC
LIMIT 1
),
PRICE_24H AS (
SELECT
TOKEN_ADDRESS,
hour,
price,
ROW_NUMBER() OVER (PARTITION BY TOKEN_ADDRESS ORDER BY hour DESC) AS rn
FROM
bsc.price.ez_prices_hourly
WHERE
token_address = '0x4d3dc895a9edb234dfa3e303a196c009dc918f84' -- $ZBU Contract Address
AND hour <= DATEADD(hour, -24, CURRENT_TIMESTAMP)
ORDER BY hour DESC
LIMIT 1
),
price_7d AS (
SELECT
TOKEN_ADDRESS,
hour,
price,
ROW_NUMBER() OVER (PARTITION BY TOKEN_ADDRESS ORDER BY hour DESC) AS rn
FROM bsc.price.ez_prices_hourly
WHERE
QueryRunArchived: QueryRun has been archived