MostlyData_Time to Inclusion vs P. Fee (Jito NOT Trader API) - by leader
Updated 2024-11-26
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 Time to Inclusion (Jito NOT Trader API) - by leader @ https://flipsidecrypto.xyz/studio/queries/376d3331-803f-4786-931f-2f0857665017
-- forked from Time to Inclusion (Jito consumers) - by leader @ https://flipsidecrypto.xyz/studio/queries/7fb73def-143e-47cc-99e9-32f95590d271
-- forked from 95th percentile Time to Inclusion (Jito consumers) - by leader @ https://flipsidecrypto.xyz/studio/queries/06ff6d88-8bed-49fd-bcc8-38725f978cec
-- forked from Txs Time to Inclusion - by leader @ https://flipsidecrypto.xyz/studio/queries/7409973a-9f6e-49de-a9ef-2eed936d26f2
-- forked from Txs Time to Inclusion @ https://flipsidecrypto.xyz/studio/queries/45bc2fc8-24e7-4e94-bea3-9d69dee27b56
with leader_blocks as(
select
block_id
from solana.gov.fact_rewards_fee
where
vote_pubkey = '{{leader}}'
and ( (
'{{n_days}}' = 0
and block_timestamp >= cast('{{start_date}}' as timestamp)
and block_timestamp < cast('{{end_date}}' as timestamp)
)
or
(
'{{n_days}}' != 0
and block_timestamp > current_date() - interval '{{n_days}} days'
))
)
,jito_tipers as (
select
distinct(tx_from) as sender_address
from solana.core.fact_transfers tr
QueryRunArchived: QueryRun has been archived