flipsidecryptoTraces, Avalanche, Current
Updated 2023-12-14
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 Receipts, Avalanche, Current @ https://flipsidecrypto.xyz/edit/queries/cbc0f381-fdb7-482c-a30a-cf5f21cd06d7
-- forked from Event Logs, Avalanche, Current @ https://flipsidecrypto.xyz/edit/queries/62a72177-7cd7-4e00-b6c2-425004f23f55
-- forked from Blocks, Avalanche, Current @ https://flipsidecrypto.xyz/edit/queries/bfd435ee-cb8e-4323-993f-d52d4670181d
with test_data as (
select
*,
max(max_block) over (order by test_timestamp) -
min(min_block) over (order by test_timestamp) + 1 as total_blocks_at_time
from
bi_analytics.core.fact_data_observability_results
),
proportions as (
select
blockchain,
test_name,
test_timestamp,
blocks_impacted_count / total_blocks_at_time as proportion_impacted
from
test_data
)
select
blockchain,
test_name,
proportion_impacted as incomplete,
1 - proportion_impacted as complete,
max(test_timestamp)
from proportions
where blockchain = 'avalanche' and test_name = 'traces'
group by 1,2,3
Run a query to Download Data