Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.6 KB

2022-10-31.md

File metadata and controls

205 lines (158 loc) · 8.6 KB

nodle Summary (Daily)

Source: nodle.polkaholic.io

Relay Chain: polkadot Para ID: 2026

Daily Summary for Month ending in 2022-10-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
2022-10-31 1,307,336 1,314,476 7,141 1,093 794 637,111 103,053 81,166
2022-10-30 1,300,214 1,307,335 7,122 24,677 24,370 636,640 286,569 99,848
2022-10-29 1,293,084 1,300,213 7,130 887 642 659,561 114,362 83,370
2022-10-28 1,285,947 1,293,083 7,137 1,042 715 653,848 144,248 108,222
2022-10-27 1,278,833 1,285,946 7,114 1,025 706 646,111 108,513 79,598
2022-10-26 1,271,709 1,278,832 7,124 9,537 9,275 641,902 180,652 89,563
2022-10-25 1,264,636 1,271,708 7,073 21,221 20,901 645,560 289,757 112,826
2022-10-24 1,257,627 1,264,635 7,009 10,589 10,308 659,325 211,235 105,624
2022-10-23 1,250,574 1,257,626 7,053 1,054 738 659,593 121,831 89,673
2022-10-22 1,243,528 1,250,573 7,046 987 707 653,746 125,946 92,237
2022-10-21 1,236,481 1,243,527 7,047 2,729 2,421 646,881 142,568 97,992
2022-10-20 1,229,457 1,236,480 7,024 23,968 23,571 642,272 321,714 123,051
2022-10-19 1,222,355 1,229,456 7,102 1,022 712 656,204 127,348 96,790
2022-10-18 1,215,225 1,222,354 7,130 17,327 17,025 651,098 260,506 114,952
2022-10-17 1,208,068 1,215,224 7,157 1,219 920 661,901 131,583 98,380
2022-10-16 1,200,911 1,208,067 7,157 1,263 911 656,122 132,591 94,826
2022-10-15 1,193,765 1,200,910 7,146 980 689 648,182 126,466 94,629
2022-10-14 1,186,641 1,193,764 7,124 13,431 13,124 642,336 236,864 114,163
2022-10-13 1,179,500 1,186,640 7,141 15,182 14,878 646,979 252,144 116,880
2022-10-12 1,172,368 1,179,499 7,132 18,930 18,635 653,252 275,272 118,349
2022-10-11 1,165,233 1,172,367 7,135 27,318 26,996 665,349 350,850 130,563
2022-10-10 1,158,121 1,165,232 7,112 38,741 38,433 683,554 428,142 135,215
2022-10-09 1,150,968 1,158,120 7,153 5,250 4,939 716,738 167,112 100,922
2022-10-08 1,143,820 1,150,967 7,148 3,474 3,141 712,672 141,873 93,595
2022-10-07 1,136,676 1,143,819 7,144 6,985 6,617 709,479 173,437 98,972
2022-10-06 1,129,508 1,136,675 7,168 2,992 2,666 708,926 147,425 101,395
2022-10-05 1,122,372 1,129,507 7,136 4,381 4,004 704,706 164,536 107,569
2022-10-04 1,115,219 1,122,371 7,153 6,093 5,597 701,118 171,998 107,651
2022-10-03 1,108,078 1,115,218 7,141 6,574 6,112 701,509 179,609 108,878
2022-10-02 1,100,936 1,108,077 7,142 6,517 6,135 700,565 176,122 105,026
2022-10-01 1,093,803 1,100,935 7,133 5,817 5,412 699,703 174,466 107,057

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.blocks2026`  
 where LAST_DAY(date(block_time)) = "2022-10-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

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

Active Accounts

Schema

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

Passive Accounts

Schema

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

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsnew2026` 
 where LAST_DAY(date(ts)) = "2022-10-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.balances2026` 
 where LAST_DAY(date(ts)) = "2022-10-31" 
 group by logDT 
 order by logDT

Events

Schema

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

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.transfers2026` 
 where LAST_DAY(date(block_time)) = "2022-10-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 = 2026 and LAST_DAY(date(origination_ts)) = "2022-10-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 = 2026 and LAST_DAY(date(origination_ts)) = "2022-10-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 = 2026 and LAST_DAY(date(origination_ts)) = "2022-10-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 = 2026 and LAST_DAY(date(origination_ts)) = "2022-10-31" 
 group by logDT 
order by logDT

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