Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.56 KB

2023-10-31.md

File metadata and controls

205 lines (158 loc) · 9.56 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2023-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
2023-10-31 4,936,954 4,942,661 5,708 121,336 868 606 25 25,895 1,974,740 112,838 ($478,048.39) 2 ($37.43) 2
2023-10-30 4,931,194 4,936,953 5,760 120,460 867 474 17 25,894 1,957,631 111,776 ($381,323.06) 5 ($98.34) 1 ($17.36) 6 2
2023-10-29 4,925,357 4,931,193 5,837 123,812 802 436 14 25,896 1,998,156 113,350 ($515,531.19) 2 ($43.14) 4 ($148.87) 3 5
2023-10-28 4,919,225 4,925,356 6,132 131,613 800 444 17 25,893 2,129,183 120,038 ($466,429.12) 3 ($406.38) 5 ($352.67) 3 6
2023-10-27 4,913,099 4,919,224 6,126 132,946 839 631 40 25,896 2,129,361 120,805 ($2,373,803.62) 1 ($41.73) 1 ($41.70) 2 2
2023-10-26 4,906,982 4,913,098 6,117 130,687 860 553 37 25,889 2,122,229 120,128 ($901,974.71) 7 ($91.84) 1 ($12.79) 14 8
2023-10-25 4,900,878 4,906,981 6,104 128,421 864 495 29 25,871 2,078,380 117,802 ($658,354.16) 1 ($1,011.16) 2 ($1,005.33) 1 2
2023-10-24 4,894,734 4,900,877 6,144 128,265 872 567 27 25,851 2,082,960 121,273 ($897,689.12) 3 ($91.99) 4 1
2023-10-23 4,888,674 4,894,733 6,060 125,031 846 603 14 25,845 2,014,879 117,421 ($345,420.96) 1 ($3.81) 1
2023-10-22 4,882,555 4,888,673 6,119 130,548 810 452 19 25,843 2,084,469 120,253 ($700,215.12) 1 1
2023-10-21 4,876,453 4,882,554 6,102 133,061 858 432 69 25,849 2,076,917 120,485 ($177,124.97) 1 ($0.74) 2 ($1.45) 1 2
2023-10-20 4,870,377 4,876,452 6,076 131,071 855 537 18 25,847 2,084,870 118,729 ($169,091.21) 1 ($515.49) 1
2023-10-19 4,864,249 4,870,376 6,128 127,745 859 443 13 25,849 2,056,968 119,901 ($577,131.35) 1 ($92.92) 1 ($37.42) 3 4
2023-10-18 4,858,121 4,864,248 6,128 128,774 860 519 27 25,856 2,067,333 120,526 ($695,012.04) 2 ($91.79) 2
2023-10-17 4,852,004 4,858,120 6,117 125,108 844 466 11 25,845 2,031,606 116,963 ($179,426.45) 1 ($32.39) 2 3
2023-10-16 4,845,897 4,852,003 6,107 127,640 893 551 22 25,853 2,066,860 119,494 ($779,595.28)
2023-10-15 4,839,808 4,845,896 6,089 130,899 825 475 21 25,847 2,095,480 121,960 ($1,144,578.79) 2 ($182.43) 1 ($5.77) 2 1
2023-10-14 4,833,727 4,839,807 6,081 125,062 859 483 32 25,838 2,008,298 117,644 ($1,613,017.53) 1 ($0.61) 1 2
2023-10-13 4,827,660 4,833,726 6,067 126,634 894 512 31 25,817 2,032,923 118,501 ($681,039.57) 2 ($197.57) 4 ($390.07) 4 6
2023-10-12 4,821,679 4,827,659 5,981 122,590 848 489 17 25,810 1,974,823 116,685 ($696,669.00) 1 ($36.72) 2 1
2023-10-11 4,815,933 4,821,678 5,746 119,479 855 426 23 25,802 1,918,379 113,462 ($309,580.25) 2 ($18.08) 1 3
2023-10-10 4,810,231 4,815,932 5,702 122,679 878 473 18 25,792 1,986,055 112,535 ($875,067.75) 2 ($82.34) 3 1
2023-10-09 4,804,696 4,810,230 5,535 119,655 871 416 24 25,790 1,926,330 110,452 ($320,540.20)
2023-10-08 4,798,925 4,804,695 5,771 128,706 847 465 29 25,775 2,043,758 117,710 ($1,132,993.43) 1 ($13.16) 1
2023-10-07 4,793,114 4,798,924 5,811 123,736 833 368 27 25,771 1,946,718 110,738 ($418,727.12) 1 ($0.73) 1
2023-10-06 4,787,374 4,793,113 5,740 121,993 816 641 18 25,777 1,920,071 111,180 ($234,529.27) 1 ($0.13) 1
2023-10-05 4,782,049 4,787,373 5,325 110,240 832 461 36 25,808 1,764,720 103,607 ($512,422.71) 2 ($187.24) 2 4
2023-10-04 4,776,618 4,782,048 5,431 113,210 801 425 22 25,780 1,808,601 105,691 ($257,741.86)
2023-10-03 4,770,585 4,776,617 6,033 123,598 817 456 16 25,789 1,986,978 117,390 ($665,067.22) 2 ($18.98) 1 ($3.85) 2 2
2023-10-02 4,764,566 4,770,584 6,019 124,023 869 27 25,794 1,999,738 118,904 ($1,344,076.24)
2023-10-01 4,758,501 4,764,565 6,065 123,316 831 404 37 25,784 2,006,440 117,256 ($472,541.53) 1 ($18.77) 1 ($16.92) 1 1

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)) = "2023-10-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)) = "2023-10-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)) = "2023-10-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)) = "2023-10-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)) = "2023-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_kusama.balances2004` 
 where LAST_DAY(date(ts)) = "2023-10-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)) = "2023-10-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)) = "2023-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_kusama.xcmtransfers` 
 where destination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2023-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_kusama.xcmtransfers` 
 where origination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2023-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_kusama.xcm` 
 where destination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2023-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_kusama.xcm` 
 where origination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2023-10-31" 
 group by logDT 
order by logDT

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