Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.76 KB

2023-11-30.md

File metadata and controls

204 lines (157 loc) · 8.76 KB

nodle Summary (Daily)

Source: nodle.polkaholic.io

Relay Chain: polkadot Para ID: 2026

Daily Summary for Month ending in 2023-11-30

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-11-30 3,875,261 3,882,324 7,064 4,641 3,147 29,913 720 865,580 207,939 162,650 1
2023-11-29 3,868,204 3,875,260 7,057 4,236 2,737 30,719 1,181 864,862 208,456 161,925
2023-11-28 3,861,144 3,868,203 7,060 4,334 2,908 29,955 863,683 206,005 162,206
2023-11-27 3,854,081 3,861,143 7,063 4,267 2,942 30,149 862,904 203,756 161,405
2023-11-26 3,847,013 3,854,080 7,068 4,659 3,215 29,440 862,360 202,717 157,194
2023-11-25 3,839,959 3,847,012 7,054 3,958 2,553 29,202 563 861,653 174,040 133,768
2023-11-24 3,832,944 3,839,958 7,015 4,326 2,686 29,635 586 861,092 204,891 161,380 6
2023-11-23 3,825,880 3,832,943 7,064 4,345 2,899 29,556 688 860,510 204,031 160,332
2023-11-22 3,818,806 3,825,879 7,074 4,419 2,939 29,426 859,829 203,268 159,678
2023-11-21 3,811,753 3,818,805 7,053 4,108 2,749 29,569 562 859,253 199,466 157,905
2023-11-20 3,804,711 3,811,752 7,042 4,716 3,314 29,256 576 858,699 202,154 157,260
2023-11-19 3,797,660 3,804,710 7,051 4,541 3,239 28,838 597 858,125 195,211 151,216
2023-11-18 3,790,618 3,797,659 7,042 3,848 2,753 28,587 857,547 168,042 127,378
2023-11-17 3,783,630 3,790,617 6,988 4,193 2,792 28,631 508 856,856 195,510 154,075
2023-11-16 3,776,608 3,783,629 7,022 3,970 2,768 28,985 523 856,350 194,898 154,890 1
2023-11-15 3,769,559 3,776,607 7,049 4,300 2,915 28,820 552 855,828 198,277 156,005 1
2023-11-14 3,762,521 3,769,558 7,038 4,531 3,035 29,088 563 855,281 200,873 156,917
2023-11-13 3,755,506 3,762,520 7,015 4,490 3,089 29,417 549 854,726 200,639 157,311
2023-11-12 3,748,480 3,755,505 7,026 4,460 3,055 29,054 854,185 195,020 151,653
2023-11-11 3,741,422 3,748,479 7,058 4,283 2,947 28,371 586 853,588 195,503 153,084 1
2023-11-10 3,734,363 3,741,421 7,059 4,337 3,007 28,641 512 853,007 196,344 153,892 1 1
2023-11-09 3,727,307 3,734,362 7,056 4,372 3,008 28,832 480 852,498 198,679 155,820
2023-11-08 3,720,243 3,727,306 7,064 4,668 3,200 28,561 852,028 199,475 154,892
2023-11-07 3,713,187 3,720,242 7,056 4,717 3,202 28,927 606 851,503 201,581 155,246
2023-11-06 3,706,152 3,713,186 7,035 4,736 3,253 29,077 519 850,911 200,520 155,174
2023-11-05 3,699,068 3,706,151 7,084 4,635 3,220 28,582 576 850,430 194,655 149,753
2023-11-04 3,692,029 3,699,067 7,039 4,324 2,871 27,981 640 849,878 190,794 147,435
2023-11-03 3,684,953 3,692,028 7,076 4,317 2,892 28,673 504 849,242 193,591 150,875
2023-11-02 3,677,872 3,684,952 7,081 4,349 2,960 29,249 603 848,746 199,668 156,912 1
2023-11-01 3,670,776 3,677,871 7,096 4,561 3,113 29,540 551 848,144 204,016 159,603

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)) = "2023-11-30" 
 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)) = "2023-11-30" 
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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 group by logDT 
order by logDT

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