flipsidecryptoBitcoin Latency - Historical Avg
Updated 2023-11-02
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
›
⌄
-- forked from Aurora Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/50b4ac17-4e9f-4f25-b3c9-0cd4a49d645d
-- forked from Near Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/8cc6cc1f-cdd3-41ac-85e3-20fc309b3c47
-- forked from Flow Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/6c7c2641-92ab-40ee-9f15-13a90eb531bf
-- forked from Ethereum Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/34d1c0f5-32c0-4526-b857-47c6dd7924bd
-- forked from BSC Latency - Historical Avg+ @ https://flipsidecrypto.xyz/edit/queries/7856c112-a52c-4870-97c1-d484d5c7b9cf
-- forked from Avalanche Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/88bc0fe2-de85-4e7b-bd57-0cd695de597b
-- forked from Arbitrum Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/169619c9-09b8-4074-8ad8-d9ca8b2581fb
select
lower(table_name) as table_name,
avg(seconds_behind / 60) as mins_behind
from bi_analytics.core.fact_data_latency
where recorded_timestamp::DATE >= current_date - 3
and chain = 'bitcoin'
group by 1
order by 1
Run a query to Download Data