Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 7.8 KB

2023-12-31.md

File metadata and controls

205 lines (158 loc) · 7.8 KB

invarch Summary (Daily)

Source: invarch.polkaholic.io

Relay Chain: polkadot Para ID: 3340

Daily Summary for Month ending in 2023-12-31

Date Start Block End Block # Blocks # Extrinsics # Active Accounts # Passive Accounts # New Accounts # Addresses # Events # Transfers ($USD) # XCM Transfers In ($USD) # XCM Transfers Out ($USD) # XCM In # XCM Out Issues
2023-12-31 474,071 480,996 6,926 15 1,382 14,362 388
2023-12-30 467,103 474,070 6,968 38 1,382 26,542 3,472
2023-12-29 460,129 467,102 6,974 1 13,950
2023-12-28 453,174 460,128 6,955 1 13,912
2023-12-27 446,182 453,173 6,992 1 13,986
2023-12-26 439,213 446,181 6,969 1 13,939
2023-12-25 432,241 439,212 6,972 1 13,946
2023-12-24 425,254 432,240 6,987 1 13,979
2023-12-23 418,294 425,253 6,960 1 13,922
2023-12-22 411,380 418,293 6,914 1 13,830
2023-12-21 404,441 411,379 6,939 1 13,880
2023-12-20 397,450 404,440 6,991 1 13,984
2023-12-19 390,425 397,449 7,025 1 14,052
2023-12-18 383,430 390,424 6,995 1 13,992
2023-12-17 376,407 383,429 7,023 1 14,048
2023-12-16 369,418 376,406 6,989 1 13,980
2023-12-15 362,411 369,417 7,007 1 14,016
2023-12-14 355,395 362,410 7,016 1 14,034
2023-12-13 348,367 355,394 7,028 1 14,058
2023-12-12 341,341 348,366 7,026 1 14,054
2023-12-11 334,308 341,340 7,033 1 14,068
2023-12-10 327,293 334,307 7,015 1 14,032
2023-12-09 320,284 327,292 7,009 1 14,020
2023-12-08 313,265 320,283 7,019 1 14,039
2023-12-07 306,252 313,264 7,013 1 14,028
2023-12-06 299,228 306,251 7,024 1 14,050
2023-12-05 292,208 299,227 7,020 1 14,042
2023-12-04 285,192 292,207 7,016 1 14,034
2023-12-03 278,146 285,191 7,046 1 14,094
2023-12-02 271,097 278,145 7,049 1 14,100
2023-12-01 264,082 271,096 7,015 1 14,032

Sample Queries:

You can generate the above summary data using the following queries using the public dataset bigquery-public-data.crypto_polkadot in Google BigQuery:

Blocks

Schema

SELECT date(block_time) as logDT, MIN(number) startBN, MAX(number) endBN, COUNT(*) numBlocks 
 FROM `bigquery-public-data.crypto_polkadot.blocks3340`  
 where LAST_DAY(date(block_time)) = "2023-12-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_polkadot.extrinsics3340`  
where signed and LAST_DAY(date(block_time)) = "2023-12-31" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsactive3340` 
 where LAST_DAY(date(ts)) = "2023-12-31" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountspassive3340` 
 where LAST_DAY(date(ts)) = "2023-12-31" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsnew3340` 
 where LAST_DAY(date(ts)) = "2023-12-31" 
 group by logDT
 order by logDT

Addresses with Balances

Schema

SELECT date(ts) as logDT,
 COUNT(distinct address_pubkey) numAddress 
 FROM `bigquery-public-data.crypto_polkadot.balances3340` 
 where LAST_DAY(date(ts)) = "2023-12-31" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.events3340` 
 where LAST_DAY(date(block_time)) = "2023-12-31" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.transfers3340` 
 where LAST_DAY(date(block_time)) = "2023-12-31" 
 group by logDT 
 order by logDT

XCM Transfers In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersOut 
 FROM `bigquery-public-data.crypto_polkadot.xcmtransfers` 
 where destination_para_id = 3340 and LAST_DAY(date(origination_ts)) = "2023-12-31" 
 group by logDT order by logDT

XCM Transfers Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersIn 
 FROM `bigquery-public-data.crypto_polkadot.xcmtransfers` 
 where origination_para_id = 3340 and LAST_DAY(date(origination_ts)) = "2023-12-31" 
 group by logDT 
order by logDT

XCM Messages In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesOut 
 FROM `bigquery-public-data.crypto_polkadot.xcm` 
 where destination_para_id = 3340 and LAST_DAY(date(origination_ts)) = "2023-12-31" 
 group by logDT order by logDT

XCM Messages Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesIn 
 FROM `bigquery-public-data.crypto_polkadot.xcm` 
 where origination_para_id = 3340 and LAST_DAY(date(origination_ts)) = "2023-12-31" 
 group by logDT 
order by logDT

Report source: https://cdn.polkaholic.io/substrate-etl/polkadot/3340.json | See Definitions for details