Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.63 KB

2024-01-31.md

File metadata and controls

205 lines (158 loc) · 8.63 KB

nodle Summary (Daily)

Source: nodle.polkaholic.io

Relay Chain: polkadot Para ID: 2026

Daily Summary for Month ending in 2024-01-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
2024-01-31 4,308,870 4,315,925 7,056 10,757 939,380 342,486 251,863 1
2024-01-30 4,301,874 4,308,869 6,996 10,245 938,956 344,158 256,584 5
2024-01-29 4,294,899 4,301,873 6,975 9,848 937,667 337,461 253,927 4
2024-01-28 4,287,930 4,294,898 6,969 10,271 936,330 335,258 246,537 2
2024-01-27 4,280,955 4,287,929 6,975 10,687 934,723 334,971 242,967 2
2024-01-26 4,273,976 4,280,954 6,979 10,460 933,269 335,639 245,920 1
2024-01-25 4,266,991 4,273,975 6,985 10,039 931,923 332,209 245,746 2 1
2024-01-24 4,260,020 4,266,990 6,971 9,281 930,628 324,039 243,633 ($837.45) 4
2024-01-23 4,253,076 4,260,019 6,944 9,148 929,425 321,354 242,081 1
2024-01-22 4,246,092 4,253,075 6,984 9,928 928,056 330,489 244,264 1
2024-01-21 4,239,134 4,246,091 6,958 9,744 926,758 320,245 236,865 1
2024-01-20 4,232,115 4,239,133 7,019 9,181 925,098 309,469 230,056 2 4
2024-01-19 4,225,093 4,232,114 7,022 9,086 924,024 317,446 235,767 2
2024-01-18 4,218,071 4,225,092 7,022 8,604 922,413 307,112 232,128
2024-01-17 4,211,067 4,218,070 7,004 8,936 921,169 306,500 230,664 ($13.09) 1
2024-01-16 4,204,091 4,211,066 6,976 8,560 920,131 314,990 240,316 ($0.55) 4
2024-01-15 4,197,142 4,204,090 6,949 9,244 918,616 324,252 244,803 ($21.75) 1
2024-01-14 4,190,169 4,197,141 6,973 9,145 917,601 307,347 227,841 ($0.59) 3
2024-01-13 4,183,182 4,190,168 6,987 9,262 916,191 304,262 224,794 ($1.43) 3
2024-01-12 4,176,204 4,183,181 6,978 8,309 914,598 299,749 225,734 (-) 1
2024-01-11 4,169,267 4,176,203 6,937 9,234 913,435 307,134 228,442 (-) 1
2024-01-10 4,162,255 4,169,266 7,012 9,079 912,276 303,968 227,589 ($0.85) 4 5
2024-01-09 4,155,263 4,162,254 6,992 9,814 911,137 330,814 251,686 ($0.29) 1
2024-01-08 4,148,206 4,155,262 7,057 9,360 909,613 274,699 199,029 ($1.85)
2024-01-07 4,142,094 4,148,205 6,112 10,147 908,508 293,962 215,552 ($4.35)
2024-01-06 4,135,057 4,142,093 7,037 9,427 907,049 286,865 211,540 ($1.41) 2
2024-01-05 4,128,005 4,135,056 7,052 10,009 905,819 293,465 213,574 ($11.48)
2024-01-04 4,120,959 4,128,004 7,046 8,693 904,631 289,802 219,132 ($22.21) 1
2024-01-03 4,113,913 4,120,958 7,046 7,924 903,550 284,806 219,194 ($0.73)
2024-01-02 4,106,908 4,113,912 7,005 8,424 902,448 285,718 216,929 ($0.66) 1
2024-01-01 4,099,866 4,106,907 7,042 7,834 901,281 274,034 209,117 ($2.21)

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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-31" 
 group by logDT 
order by logDT

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