2844Applications on Algorand-TOTAL
Updated 2022-07-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT 'SECOND HALF OF 2021' AS "PERIOD" ,COUNT(DISTINCT BLOCK_ID) AS "TOTAL BLOCK",COUNT (TX_ID) AS "TOTAL TRASACTIONS",
COUNT(DISTINCT SENDER) AS "UNIQUE USERS",
"TOTAL TRASACTIONS"/ "TOTAL BLOCK" AS "AVG TRANCATIONS PER BLOCK", COUNT(DISTINCT APP_ID) AS "NUMBER OF APP"
from flipside_prod_db.algorand.application_call_transaction
WHERE BLOCK_TIMESTAMP::DATE >= '2021-06-01' AND BLOCK_TIMESTAMP::DATE<'2022-01-01'
UNION
SELECT 'FIRST HALF OF 2022' AS "PERIOD" ,COUNT(DISTINCT BLOCK_ID) AS "TOTAL BLOCK",COUNT (TX_ID) AS "TOTAL TRASACTIONS",
COUNT(DISTINCT SENDER) AS "UNIQUE USERS",
"TOTAL TRASACTIONS" / "TOTAL BLOCK" AS "AVG TRANCATIONS PER BLOCK",COUNT(DISTINCT APP_ID) AS "NUMBER OF APP"
from flipside_prod_db.algorand.application_call_transaction
WHERE BLOCK_TIMESTAMP::DATE>= '2022-01-01' AND BLOCK_TIMESTAMP::DATE<'2022-07-01'
Run a query to Download Data