intellidegentBlocks and Transactions by Blockchain
Updated 2023-02-23
999
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 AGGREGATE AS (
SELECT
NETWORK,
INITCAP(BLOCKCHAIN) AS BLOCKCHAIN,
MIN(BLOCK_TIMESTAMP) AS BIRTHDAY,
MIN(BLOCK_NUMBER) AS FIRST_BLOCKID,
COUNT(BLOCK_NUMBER) AS BLOCKS2,
to_varchar(COUNT(BLOCK_NUMBER),'999,999,999,999,999') AS BLOCKS,
AVG(TX_COUNT) AS AVG_TX,
SUM(TX_COUNT) AS SUM_TX2,
to_varchar(SUM(TX_COUNT),'999,999,999,999,999') AS SUM_TX
FROM arbitrum.core.fact_blocks
GROUP BY NETWORK, BLOCKCHAIN
UNION
SELECT
NETWORK,
INITCAP(BLOCKCHAIN) AS BLOCKCHAIN,
MIN(BLOCK_TIMESTAMP) AS BIRTHDAY,
MIN(BLOCK_NUMBER) AS FIRST_BLOCKID,
COUNT(BLOCK_NUMBER) AS BLOCKS2,
to_varchar(COUNT(BLOCK_NUMBER),'999,999,999,999,999') AS BLOCKS,
AVG(TX_COUNT) AS AVG_TX,
SUM(TX_COUNT) AS SUM_TX2,
to_varchar(SUM(TX_COUNT),'999,999,999,999,999') AS SUM_TX
FROM avalanche.core.fact_blocks
GROUP BY NETWORK, BLOCKCHAIN
UNION
SELECT
NETWORK,
INITCAP(BLOCKCHAIN) AS BLOCKCHAIN,
MIN(BLOCK_TIMESTAMP) AS BIRTHDAY,
MIN(BLOCK_NUMBER) AS FIRST_BLOCKID,
Run a query to Download Data