primo_datanear_performance
Updated 2023-04-30
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
›
⌄
--- How does NEAR stock up to other L1s in terms of speed and performance?
--- How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
-- https://app.flipsidecrypto.com/velocity/queries/33b46682-1c05-4100-8bc5-95dbe95d4e32
-- https://app.flipsidecrypto.com/dashboard/solana-tps-TEcObr
-- https://app.flipsidecrypto.com/dashboard/solana-tps-QynVnR
select s.dt
, s.txns_total_ct sol_txns_total_ct
, s.tpm sol_tpm
, s.txn_failures_pct sol_txn_failures_pct
, n.txns_total_ct near_txns_total_ct
, n.tpm near_tpm
, n.txn_failures_pct near_txn_failures_pct
, e.txns_total_ct ethereum_txns_total_ct
, e.tpm ethereum_tpm
, e.txn_failures_pct ethereum_txn_failures_pct
, a.txns_total_ct avalanche_txns_total_ct
, a.tpm avalanche_tpm
, a.txn_failures_pct avalanche_txn_failures_pct
, b.txns_total_ct bsc_txns_total_ct
, b.tpm bsc_tpm
, b.txn_failures_pct bsc_txn_failures_pct
, f.txns_total_ct flow_txns_total_ct
, f.tpm flow_tpm
, f.txn_failures_pct flow_txn_failures_pct
from
(
select date(block_timestamp) dt
, count(distinct (case when succeeded = FALSE then tx_id else NULL end)) txn_failures_ct
, count(distinct tx_id) txns_total_ct
, (txns_total_ct / 1440) tpm
, (txn_failures_ct / txns_total_ct) * 100 txn_failures_pct
from solana.core.fact_transactions
where date(block_timestamp) >current_date - {{last_n_days}} - 1
and date(block_timestamp) < current_date
Run a query to Download Data