flyingfishPerps Pools - SOL copy
Updated 2024-06-25
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
›
⌄
⌄
-- forked from Perps Pools - SOL @ https://flipsidecrypto.xyz/edit/queries/8758fe39-3e36-4396-bf25-6ab108cf06e7
-- forked from Decoding Solana Account Data @ https://flipsidecrypto.xyz/edit/queries/625d6fa3-ff81-4d37-a220-bae03620b192
-- forked from Solana Helius RPC call @ https://flipsidecrypto.xyz/edit/queries/4921e564-086c-4a06-b8c7-f3c73781f788
with raw_data as (
select 'AbgwUV2DP5E+HiRzxzQGVOuHKQA1FRxAK9DjyXy0JEiG5yA0swtN/AabiFf+q4GE+2h/Y0YYwDXaxDncGus7VZig8AAAAAABm7wyoY2HHAc1XdJRYSQVxCBMq4Adue7CkmUDUbFm0m4JAO8Ni2/aLOukHaFdQJXR2jkqDS+O0MbHvA9M+sjCgLVtAjIAAAAAAAAAAwAAAACAxqR+jQMAAAAAAAAAAAAAAAAAAAAAAEBLTAAAAAAABLtAd4owAQD4Tdx4IWYAAAEBAQEBAQEwEQAAAAAAAEykoRsGAAAAS1X+w1/mBAAHYirqnSgCABEK7ndsOQAAA1ot8JUCAAAHpt8HAAAAAIqnohwAAAAAAAAAAAAAAACnnnpmAAAAAAoAAAAAAAAA/f8AAAAAAAAAAA==' as account_data
union all
select 'AbgwUV2DP5E+HiRzxzQGVOuHKQA1FRxAK9DjyXy0JEiG5yA0swtN/AabiFf+q4GE+2h/Y0YYwDXaxDncGus7VZig8AAAAAABm7wyoY2HHAc1XdJRYSQVxCBMq4Adue7CkmUDUbFm0m4JAO8Ni2/aLOukHaFdQJXR2jkqDS+O0MbHvA9M+sjCgLVtAjIAAAAAAAAAAwAAAACAxqR+jQMAAAAAAAAAAAAAAAAAAAAAAEBLTAAAAAAABLtAd4owAQD4Tdx4IWYAAAEBAQEBAQEwEQAAAAAAAGOmGhwGAAAANLsOzV/mBAAFe9HvnygCADtKwb1sOQAAA1ot8JUCAAAHpt8HAAAAAO2oohwAAAAAAAAAAAAAAADEnnpmAAAAAAoAAAAAAAAA/f8AAAAAAAAAAA==' as account_data
union all
select 'AbgwUV2DP5E+HiRzxzQGVOuHKQA1FRxAK9DjyXy0JEiG5yA0swtN/AabiFf+q4GE+2h/Y0YYwDXaxDncGus7VZig8AAAAAABm7wyoY2HHAc1XdJRYSQVxCBMq4Adue7CkmUDUbFm0m4JAO8Ni2/aLOukHaFdQJXR2jkqDS+O0MbHvA9M+sjCgLVtAjIAAAAAAAAAAwAAAACAxqR+jQMAAAAAAAAAAAAAAAAAAAAAAEBLTAAAAAAABLtAd4owAQD4Tdx4IWYAAAEBAQEBAQEwEQAAAAAAAL5wDDANAAAAsJJpWtrkBACzrOhf7BoCAPbUiJu3NwAAnGinrxMDAACqy/MHAAAAAOwmpBwAAAAAAAAAAAAAAAAlvnpmAAAAAAoAAAAAAAAA/f8AAAAAAAAAAA==' as ccount_data
union all
select 'AbgwUV2DP5E+HiRzxzQGVOuHKQA1FRxAK9DjyXy0JEiG5yA0swtN/AabiFf+q4GE+2h/Y0YYwDXaxDncGus7VZig8AAAAAABm7wyoY2HHAc1XdJRYSQVxCBMq4Adue7CkmUDUbFm0m4JAO8Ni2/aLOukHaFdQJXR2jkqDS+O0MbHvA9M+sjCgLVtAjIAAAAAAAAAAwAAAACAxqR+jQMAAAAAAAAAAAAAAAAAAAAAAEBLTAAAAAAABLtAd4owAQD4Tdx4IWYAAAEBAQEBAQEwEQAAAAAAAL5wDDANAAAAsJJpWtrkBACzrOhf7BoCAPbUiJu3NwAAtmFaENQCAABgt+4HAAAAAOwmpBwAAAAAAAAAAAAAAAAlvnpmAAAAAAoAAAAAAAAA/f8AAAAAAAAAAA==' as account_data
)
/*
select
'fact_transactions' as tbl
, max(block_timestamp) as last_tsp
, max(block_id) as last_block
, iff(last_block >= 273949968, 'TRUE', '-') as trigger_
, last_block - 273949968 as lag
from solana.core.fact_transactions
where block_timestamp > current_timestamp - interval '1 hour'
union all
select
'fact_events' as tbl
, max(block_timestamp) as last_tsp
, max(block_id) as last_block
, iff(last_block >= 273949968, 'TRUE', '-') as trigger_
, last_block - 273949968 as lag
from solana.core.fact_events
where block_timestamp > current_timestamp - interval '1 hour'
*/
select
QueryRunArchived: QueryRun has been archived