amirreza-UD67Mc transaction speed between avax and near network
Updated 2022-07-20
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 Near AS
(SELECT
DATE_TRUNC('day', minute) AS date,
ROUND(max(txn)) AS max_txn
FROM (
SELECT
DATE_TRUNC('minute', block_timestamp) AS MINUTE,
COUNT(TXN_HASH) AS txn
FROM
flipside_prod_db.mdao_near.transactions
WHERE
block_timestamp::date >= '2022-06-01'
GROUP BY
MINUTE)
GROUP BY
date
ORDER BY
date),
Avalanche AS (
SELECT
DATE_TRUNC('day', MINUTE) AS date,
ROUND(max(txn)) AS max_txn
FROM (
SELECT
DATE_TRUNC('minute', block_timestamp) AS MINUTE,
COUNT(tx_hash) AS txn
FROM
avalanche.core.fact_transactions
WHERE
block_timestamp::date >= '2022-06-01'
GROUP BY
MINUTE
)
GROUP BY
date
ORDER BY
Run a query to Download Data