JUP Perps Space Cadets CommunityLast Tracked Perps Tx
Updated 2024-06-10
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
›
⌄
with cte1 AS (
SELECT
livequery.live.udf_api(
'GET',
'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
{ 'Content-Type': 'application/json' },
{
'sheets_id' : '1QMy-OCO8NFtb7chUXcAvWARPkgpvmK9Y5K0tXpMEGUI',
'tab_name' : 'last_tracked_tx'
}
) as response
)
SELECT
value:block_timestamp AS last_timestamp
--, value:ins_name::string AS action_type
, value:tx_id AS last_tracked_tx
FROM cte1
, lateral flatten (input => response:data)
QueryRunArchived: QueryRun has been archived