kirastudioPolygon Monthly Data
Updated 2023-08-15
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((((LENGTH(input_data)-2) / 2) + {{fixed_data}})/(1024*1024)) AS data_size_in_MB
FROM polygon.core.fact_transactions ft
WHERE block_timestamp >= '{{from_date}}'
AND block_timestamp < '{{to_date}}'
--and tx_hash = '0x5eda9c074c7a4c90824e24c200e1448851ea500dd38e38d018612a574e636730'
group by 1
order by 1 DESC
--fixed data size is 116 including chain ID: 4 bytes
--3+9+3+21+9+68*344
--input data should be 344 bytes
--traces data: 457
--0x5eda9c074c7a4c90824e24c200e1448851ea500dd38e38d018612a574e636730
-- transaction size
--0.01424407959
Run a query to Download Data