PlaywoTPS Comparison Overall
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
›
⌄
WITH timeframe AS (
SELECT date_day AS date
FROM crosschain.core.dim_dates
WHERE date_day >= CURRENT_DATE - 180
AND date_day < CURRENT_DATE
),
osmo_txs AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(*) AS txs
FROM osmosis.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND tx_succeeded
GROUP BY date
),
cosm_txs AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(*) AS txs
FROM cosmos.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND tx_succeeded
GROUP BY date
),
evmo_txs AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(*) AS txs
FROM evmos.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND tx_succeeded
GROUP BY date
),
eth_txs AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(*) AS txs
FROM ethereum.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND status = 'SUCCESS'
GROUP BY date
),
poly_txs AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(*) AS txs
FROM polygon.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND status = 'SUCCESS'
GROUP BY date
),
Run a query to Download Data