datavortexSwap Per second
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
›
⌄
WITH SolanaSwaps AS (
SELECT
COUNT(DISTINCT tx_id) AS SolanaDistinctTx,
COUNT(DISTINCT tx_id) / (60 * 60 * 24 * 31) AS AverageSolanaSwapsPerSecond
FROM
solana.defi.ez_dex_swaps
WHERE
block_timestamp BETWEEN '2024-10-01' AND '2024-10-31'
),
EthereumSwaps AS (
SELECT
COUNT(DISTINCT tx_hash) AS EthereumDistinctTx,
COUNT(DISTINCT tx_hash) / (60 * 60 * 24 * 31) AS AverageEthereumSwapsPerSecond
FROM
ethereum.defi.ez_dex_swaps
WHERE
block_timestamp BETWEEN '2024-10-01' AND '2024-10-31'
)
SELECT
(SELECT AverageSolanaSwapsPerSecond FROM SolanaSwaps) AS AverageSolanaSwapsPerSecond,
(SELECT AverageEthereumSwapsPerSecond FROM EthereumSwaps) AS AverageEthereumSwapsPerSecond;
QueryRunArchived: QueryRun has been archived