kirastudioCosmos Monthly Data
Updated 2023-08-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS month,
SUM(
8 * 4 + -- 8 bytes for each of the 4 numerical fields (ATTACHED_GAS, BLOCK_ID, GAS_USED, TRANSACTION_FEE)
32 + --unique key
64 + --signature
-- OCTET_LENGTH(TX_LOG) +
OCTET_LENGTH(MSGS))/(1024*1024) AS Size_in_MB
FROM
cosmos.core.fact_transactions
WHERE
BLOCK_TIMESTAMP >= '2021-01-01'
AND BLOCK_TIMESTAMP <= '2023-07-31'
GROUP BY 1
ORDER BY month DESC;
select min(block_timestamp) from cosmos.core.fact_transactions
Run a query to Download Data