datavortexTransaction Per Second(Solana vs Ethereum)
Updated 2024-11-05
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
›
⌄
WITH EthereumTransactions AS (
SELECT
DATE_TRUNC('day', block_timestamp_hour) AS TransactionDate,
SUM(transaction_count_success) AS DailySuccessfulTransactions,
SUM(transaction_count_success) / 86400.0 AS DailyTPS
FROM
ethereum.stats.ez_core_metrics_hourly
WHERE
DATE_TRUNC('month', block_timestamp_hour) = '2024-10-01'
GROUP BY
TransactionDate
),
SolanaTransactions AS (
SELECT
DATE_TRUNC('day', block_timestamp_hour) AS TransactionDate,
SUM(transaction_count_success) AS DailySuccessfulTransactions,
SUM(transaction_count_success) / 86400.0 AS DailyTPS
FROM
solana.stats.ez_core_metrics_hourly
WHERE
DATE_TRUNC('month', block_timestamp_hour) = '2024-10-01'
GROUP BY
TransactionDate
)
SELECT
ETH.TransactionDate,
ETH.DailySuccessfulTransactions AS EthereumSuccessfulTransactions,
ETH.DailyTPS AS EthereumTPS,
SOL.DailySuccessfulTransactions AS SolanaSuccessfulTransactions,
SOL.DailyTPS AS SolanaTPS
FROM
EthereumTransactions ETH
FULL OUTER JOIN
SolanaTransactions SOL ON ETH.TransactionDate = SOL.TransactionDate
QueryRunArchived: QueryRun has been archived