Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.97 KB

2024-03-31.md

File metadata and controls

205 lines (158 loc) · 8.97 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2024-03-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-03-31 5,920,955 5,927,776 6,822 184,523 27,198 2,858,463 132,906 ($2,021,677.87)
2024-03-30 5,914,163 5,920,954 6,792 177,016 27,184 2,745,602 132,424 ($1,336,325.95)
2024-03-29 5,907,414 5,914,162 6,749 167,688 27,169 2,611,560 132,650 ($2,503,281.21)
2024-03-28 5,900,673 5,907,413 6,741 175,043 27,152 2,709,970 132,649 ($2,439,643.16)
2024-03-27 5,894,075 5,900,672 6,598 163,669 27,157 2,543,810 129,749 ($3,078,742.23)
2024-03-26 5,887,431 5,894,074 6,644 158,473 27,093 2,489,776 131,738 ($6,445,757.28)
2024-03-25 5,880,815 5,887,430 6,616 155,894 27,025 2,454,385 131,333 ($2,893,366.41)
2024-03-24 5,874,232 5,880,814 6,583 148,178 27,018 2,359,141 130,425 ($2,220,884.89)
2024-03-23 5,867,703 5,874,231 6,529 150,029 27,010 2,369,724 128,517 ($1,200,487.53)
2024-03-22 5,861,218 5,867,702 6,485 151,588 26,993 2,378,701 127,885 ($731,471.10)
2024-03-21 5,854,689 5,861,217 6,529 150,691 26,988 2,402,797 129,144 ($2,429,628.86)
2024-03-20 5,848,126 5,854,688 6,563 153,234 26,951 2,417,155 128,821 ($2,206,433.51)
2024-03-19 5,841,528 5,848,125 6,598 148,682 26,970 2,353,259 127,579 ($1,815,520.83)
2024-03-18 5,834,958 5,841,527 6,570 148,048 26,951 2,374,892 129,473 ($2,226,319.12)
2024-03-17 5,828,341 5,834,957 6,617 145,852 26,947 2,333,991 129,180 ($7,368,770.58)
2024-03-16 5,821,740 5,828,340 6,601 141,329 26,892 2,275,632 126,955 ($2,592,795.21)
2024-03-15 5,815,156 5,821,739 6,584 143,968 26,881 2,295,021 125,526 ($1,485,656.16)
2024-03-14 5,808,536 5,815,155 6,620 143,122 26,859 2,292,803 127,264 ($1,159,671.96)
2024-03-13 5,801,916 5,808,535 6,620 141,593 26,856 2,285,806 127,599 ($1,272,713.04)
2024-03-12 5,795,322 5,801,915 6,594 140,972 26,840 2,269,696 125,925 ($1,204,801.08)
2024-03-11 5,788,814 5,795,321 6,508 133,820 26,839 2,164,479 123,119 ($1,212,135.54)
2024-03-10 5,782,169 5,788,813 6,645 133,374 26,824 2,171,412 126,241 ($1,580,724.81)
2024-03-09 5,775,643 5,782,168 6,526 132,874 26,792 2,164,103 125,251 ($1,139,098.59)
2024-03-08 5,769,072 5,775,642 6,571 138,402 26,780 2,233,269 127,417 ($1,536,261.82)
2024-03-07 5,762,556 5,769,071 6,516 136,935 26,776 2,191,077 122,929 ($1,734,260.38)
2024-03-06 5,755,930 5,762,555 6,626 139,619 26,756 2,250,516 127,465 ($841,518.22)
2024-03-05 5,749,324 5,755,929 6,606 137,447 26,751 2,227,784 126,604 ($869,945.26)
2024-03-04 5,742,946 5,749,323 6,378 132,016 26,750 2,141,226 122,066 ($642,526.79)
2024-03-03 5,736,355 5,742,945 6,591 132,721 26,722 2,172,395 125,112 ($541,549.50)
2024-03-02 5,729,740 5,736,354 6,615 133,416 26,712 2,184,609 126,350 ($680,337.10)
2024-03-01 5,723,097 5,729,739 6,643 135,348 26,696 2,207,951 126,657 ($865,806.43)

Sample Queries:

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

Blocks

Schema

SELECT date(block_time) as logDT, MIN(number) startBN, MAX(number) endBN, COUNT(*) numBlocks 
 FROM `bigquery-public-data.crypto_kusama.blocks2004`  
 where LAST_DAY(date(block_time)) = "2024-03-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_kusama.extrinsics2004`  
where signed and LAST_DAY(date(block_time)) = "2024-03-31" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsactive2004` 
 where LAST_DAY(date(ts)) = "2024-03-31" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountspassive2004` 
 where LAST_DAY(date(ts)) = "2024-03-31" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsnew2004` 
 where LAST_DAY(date(ts)) = "2024-03-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_kusama.balances2004` 
 where LAST_DAY(date(ts)) = "2024-03-31" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.events2004` 
 where LAST_DAY(date(block_time)) = "2024-03-31" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.transfers2004` 
 where LAST_DAY(date(block_time)) = "2024-03-31" 
 group by logDT 
 order by logDT

XCM Transfers In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersOut 
 FROM `bigquery-public-data.crypto_kusama.xcmtransfers` 
 where destination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2024-03-31" 
 group by logDT order by logDT

XCM Transfers Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersIn 
 FROM `bigquery-public-data.crypto_kusama.xcmtransfers` 
 where origination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2024-03-31" 
 group by logDT 
order by logDT

XCM Messages In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesOut 
 FROM `bigquery-public-data.crypto_kusama.xcm` 
 where destination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2024-03-31" 
 group by logDT order by logDT

XCM Messages Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesIn 
 FROM `bigquery-public-data.crypto_kusama.xcm` 
 where origination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2024-03-31" 
 group by logDT 
order by logDT

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