TheLaughingManlatest time
Updated 2024-06-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from initial_time @ https://flipsidecrypto.xyz/edit/queries/f798b07b-1cc7-4859-85bd-0f3ec27f3fb8
with prev as (
select livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/f798b07b-1cc7-4859-85bd-0f3ec27f3fb8/latest-run') as resp
)
,
flattened as (
select
value[0] as prev_time
from prev, lateral FLATTEN (input=> resp:data:result:rows)
)
SELECT
prev_time
, CURRENT_TIMESTAMP as cur_time
from flattened
QueryRunArchived: QueryRun has been archived