check_skedPolygon x Avalanche TXs and TPS
Updated 2023-07-07
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
›
⌄
SELECT
matic.dt AS matic_dt,
matic.matic_TXS,
matic.matic_TPS,
matic_successful.matic_successful_txs AS matic_successful_txs,
matic_successful.matic_successful_txs * 100.0 / matic.matic_TXS AS matic_successful_percent,
avax.dt AS avax_dt,
avax.avax_TXS,
avax.avax_TPS,
avax_successful.avax_successful_txs AS avax_successful_txs,
avax_successful.avax_successful_txs * 100.0 / avax.avax_TXS AS avax_successful_percent
FROM
(
SELECT
date_trunc('day', block_timestamp) AS dt,
COUNT(DISTINCT TX_HASH) AS matic_TXS,
COUNT(DISTINCT TX_HASH) / 86400.0 AS matic_TPS
FROM
polygon.core.fact_transactions
WHERE
dt >= CURRENT_DATE - INTERVAL '400 DAY'
GROUP BY
dt
) matic
JOIN (
SELECT
date_trunc('day', block_timestamp) AS dt,
COUNT(DISTINCT TX_HASH) AS avax_TXS,
COUNT(DISTINCT TX_HASH) / 86400.0 AS avax_TPS
FROM
avalanche.core.fact_transactions
WHERE
dt >= CURRENT_DATE - INTERVAL '400 DAY'
GROUP BY
dt
) avax ON matic.dt = avax.dt
Run a query to Download Data