Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 9.68 KB

2022-11-30.md

File metadata and controls

204 lines (157 loc) · 9.68 KB

Moonriver Summary (Daily)

Source: moonriver.polkaholic.io

Relay Chain: kusama Para ID: 2023

Daily Summary for Month ending in 2022-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
2022-11-30 3,093,162 3,100,103 6,942 97 56 239,597 513,712 6,460 ($1,821,736.79) 23 ($77,729.22) 98 ($169,933.45) 70 112
2022-11-29 3,086,275 3,093,161 6,887 97 67 239,447 504,512 5,268 ($2,781,029.46) 24 ($144,228.35) 72 ($20,811.44) 64 88
2022-11-28 3,079,442 3,086,274 6,833 84 53 239,317 490,932 5,561 ($956,242.82) 41 ($81,831.42) 75 ($12,691.34) 67 92
2022-11-27 3,072,592 3,079,441 6,850 70 48 239,244 483,012 5,527 ($1,074,717.54) 48 ($121,430.86) 73 ($112,162.13) 72 86
2022-11-26 3,065,716 3,072,591 6,876 91 55 239,174 455,872 4,844 ($1,701,840.33) 23 ($44,451.76) 53 ($25,403.45) 53 69
2022-11-25 3,058,853 3,065,715 6,863 84 55 239,129 436,010 3,798 ($609,498.94) 20 ($1,629.83) 51 ($46,580.47) 38 59
2022-11-24 3,051,970 3,058,852 6,883 100 62 239,065 478,639 5,051 ($1,130,631.40) 42 ($17,014.62) 60 ($191,508.79) 78 78
2022-11-23 3,045,106 3,051,969 6,864 101 61 239,000 497,920 6,462 ($1,712,832.34) 39 ($67,518.57) 81 ($40,395.65) 68 85
2022-11-22 3,038,293 3,045,105 6,813 111 57 238,964 550,291 7,326 ($1,644,623.70) 68 ($60,786.33) 106 ($71,954.78) 96 117
2022-11-21 3,031,476 3,038,292 6,817 135 78 238,876 580,653 8,721 ($1,596,829.28) 34 ($8,241.39) 95 ($33,573.38) 78 99
2022-11-20 3,024,683 3,031,475 6,793 107 65 238,770 526,666 7,186 ($1,725,955.18) 47 ($130,471.30) 98 ($148,657.23) 85 133
2022-11-19 3,017,859 3,024,682 6,824 134 79 238,654 534,327 6,812 ($2,559,420.95) 39 ($110,678.79) 86 ($103,501.99) 74 125
2022-11-18 3,011,020 3,017,858 6,839 102 62 238,497 438,086 3,962 ($1,125,175.57) 51 ($13,814.07) 78 ($49,153.46) 86 107
2022-11-17 3,004,195 3,011,019 6,825 107 55 238,385 491,398 4,924 ($714,250.57) 49 ($79,063.65) 75 ($27,030.42) 89 115
2022-11-16 2,997,333 3,004,194 6,862 104 62 238,241 484,826 4,933 ($1,293,618.39) 34 ($14,102.32) 43 ($21,227.19) 60 78
2022-11-15 2,990,447 2,997,332 6,886 98 63 238,039 591,455 7,484 ($1,879,539.52) 58 ($36,516.31) 75 ($101,324.67) 87 92
2022-11-14 2,983,522 2,990,446 6,925 134 79 237,788 640,666 8,123 ($1,687,184.75) 72 ($95,452.57) 74 ($40,848.73) 96 94
2022-11-13 2,976,682 2,983,521 6,840 147 88 237,336 539,675 7,710 ($2,052,422.58) 68 ($136,690.22) 40 ($33,211.98) 66 58
2022-11-12 2,969,777 2,976,681 6,905 104 62 236,678 520,111 6,925 ($1,289,325.86) 70 ($69,301.05) 44 ($11,829.47) 68 68
2022-11-11 2,962,821 2,969,776 6,956 118 65 236,420 634,177 9,943 ($2,287,958.56) 82 ($126,463.90) 80 ($26,788.23) 82 110
2022-11-10 2,955,917 2,962,820 6,904 102 71 236,154 873,199 16,036 ($5,255,774.45) 112 ($209,235.00) 119 ($248,425.76) 112 153
2022-11-09 2,949,025 2,955,916 6,892 167 94 235,921 972,194 16,080 ($5,688,679.56) 129 ($127,120.87) 149 ($296,093.73) 135 197
2022-11-08 2,942,179 2,949,024 6,846 120 73 235,683 864,872 12,440 ($4,087,412.54) 91 ($362,017.40) 98 ($262,794.96) 91 120
2022-11-07 2,935,266 2,942,178 6,913 79 51 235,613 569,146 7,269 ($1,526,293.33) 66 ($66,299.81) 89 ($94,521.52) 67 120
2022-11-06 2,928,366 2,935,265 6,900 78 43 235,565 513,229 5,832 ($1,468,279.80) 29 ($14,289.74) 48 ($37,245.52) 30 79
2022-11-05 2,921,458 2,928,365 6,908 62 43 235,523 569,889 9,196 ($2,716,898.92) 58 ($71,924.55) 62 ($88,546.95) 61 75
2022-11-04 2,914,579 2,921,457 6,879 102 48 235,644 580,347 7,895 ($3,137,072.30) 79 ($59,652.78) 93 ($33,678.37) 79 124
2022-11-03 2,907,670 2,914,578 6,909 80 50 235,542 559,265 7,021 ($3,416,536.63) 49 ($101,040.07) 69 ($15,640.89) 49 89
2022-11-02 2,900,725 2,907,669 6,945 78 48 235,428 542,797 6,987 ($1,186,166.78) 90 ($57,638.98) 89 ($55,239.92) 92 116
2022-11-01 2,893,806 2,900,724 6,919 81 51 235,268 518,803 6,511 ($1,342,661.84) 87 ($294,010.41) 67 ($41,053.71) 86 84

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.blocks2023`  
 where LAST_DAY(date(block_time)) = "2022-11-30" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_kusama.extrinsics2023`  
where signed and LAST_DAY(date(block_time)) = "2022-11-30" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsactive2023` 
 where LAST_DAY(date(ts)) = "2022-11-30" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountspassive2023` 
 where LAST_DAY(date(ts)) = "2022-11-30" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsnew2023` 
 where LAST_DAY(date(ts)) = "2022-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_kusama.balances2023` 
 where LAST_DAY(date(ts)) = "2022-11-30" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.events2023` 
 where LAST_DAY(date(block_time)) = "2022-11-30" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.transfers2023` 
 where LAST_DAY(date(block_time)) = "2022-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_kusama.xcmtransfers` 
 where destination_para_id = 2023 and LAST_DAY(date(origination_ts)) = "2022-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_kusama.xcmtransfers` 
 where origination_para_id = 2023 and LAST_DAY(date(origination_ts)) = "2022-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_kusama.xcm` 
 where destination_para_id = 2023 and LAST_DAY(date(origination_ts)) = "2022-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_kusama.xcm` 
 where origination_para_id = 2023 and LAST_DAY(date(origination_ts)) = "2022-11-30" 
 group by logDT 
order by logDT

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