Polaris_9RNearest TC Block
Updated 2023-04-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
35
36
›
⌄
WITH nearest_before AS (
SELECT
CASE
WHEN '{{timestamp_unix_seconds}}' = '' THEN TO_TIMESTAMP_TZ(CURRENT_TIMESTAMP)
ELSE TO_TIMESTAMP_TZ('{{timestamp_unix_seconds}}'::NUMBER)
END AS INPUT_TIMESTAMP,
CASE
WHEN '{{timestamp_unix_seconds}}' = '' THEN (EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) * 1e9)::NUMBER
ELSE ('{{timestamp_unix_seconds}}'::NUMBER * 1e9)::NUMBER
END AS INPUT_UNIX_NANO,
*
FROM thorchain.core.dim_block
WHERE
CASE WHEN '{{timestamp_unix_seconds}}' = '' THEN timestamp <= (EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) * 1e9)::NUMBER
ELSE timestamp <= ('{{timestamp_unix_seconds}}'::NUMBER * 1e9)::NUMBER
END
ORDER BY timestamp DESC
LIMIT 1
),
nearest_after AS (
SELECT
CASE
WHEN '{{timestamp_unix_seconds}}' = '' THEN TO_TIMESTAMP_TZ(CURRENT_TIMESTAMP)
ELSE TO_TIMESTAMP_TZ('{{timestamp_unix_seconds}}'::NUMBER)
END AS INPUT_TIMESTAMP,
CASE
WHEN '{{timestamp_unix_seconds}}' = '' THEN (EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) * 1e9)::NUMBER
ELSE ('{{timestamp_unix_seconds}}'::NUMBER * 1e9)::NUMBER
END AS INPUT_UNIX_NANO,
*
FROM thorchain.core.dim_block
WHERE
CASE WHEN '{{timestamp_unix_seconds}}' = '' THEN timestamp >= (EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) * 1e9)::NUMBER
ELSE timestamp >= ('{{timestamp_unix_seconds}}'::NUMBER * 1e9)::NUMBER
END
ORDER BY timestamp ASC
Run a query to Download Data