Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.95 KB

2022-05-31.md

File metadata and controls

205 lines (158 loc) · 9.95 KB

Moonriver Summary (Daily)

Source: moonriver.polkaholic.io

Relay Chain: kusama Para ID: 2023

Daily Summary for Month ending in 2022-05-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
2022-05-31 1,929,360 1,935,609 6,250 78 25 215,464 679,916 13,726 ($8,811,259.38) 155 ($379,986.04) 137 ($398,206.04) 150 146
2022-05-30 1,923,018 1,929,359 6,342 47 19 215,098 547,401 9,898 ($7,911,750.58) 89 ($38,307.83) 102 ($55,730.27) 78 123
2022-05-29 1,916,696 1,923,017 6,322 39 15 214,959 501,674 9,050 ($8,900,705.25) 76 ($70,852.69) 115 ($122,477.23) 88 139
2022-05-28 1,910,396 1,916,695 6,300 43 13 214,745 519,152 10,027 ($9,878,304.42) 84 ($274,716.08) 99 ($231,776.64) 76 124
2022-05-27 1,904,160 1,910,395 6,236 109 30 214,601 606,291 12,495 ($31,330,669.06) 106 ($202,576.21) 94 ($155,533.03) 113 121
2022-05-26 1,897,841 1,904,159 6,319 56 23 214,435 611,364 12,089 ($15,476,833.45) 89 ($186,758.37) 78 ($310,842.01) 98 106
2022-05-25 1,891,570 1,897,840 6,271 49 21 214,316 565,888 10,838 ($17,198,238.70) 99 ($313,017.13) 71 ($841,562.70) 101 100
2022-05-24 1,885,373 1,891,569 6,197 63 33 214,195 627,584 11,532 ($12,244,782.74) 110 ($251,340.46) 90 ($170,833.79) 104 117
2022-05-23 1,879,125 1,885,372 6,248 61 26 214,055 700,019 14,850 ($13,424,126.43) 91 ($393,459.22) 137 ($330,873.08) 95 153
2022-05-22 1,872,891 1,879,124 6,234 48 18 212,811 681,858 10,597 ($10,261,706.07) 83 ($576,366.34) 51 ($114,760.74) 85 69
2022-05-21 1,866,737 1,872,890 6,154 36 13 212,664 599,820 11,612 ($11,690,659.96) 127 ($930,804.30) 40 ($80,236.72) 118 61
2022-05-20 1,860,590 1,866,736 6,147 62 24 212,354 672,629 11,801 ($7,638,172.04) 88 ($259,195.64) 32 ($32,711.72) 88 40
2022-05-19 1,854,341 1,860,589 6,249 37 19 212,148 655,868 12,582 ($22,124,326.88) 180 ($759,577.66) 122 ($175,773.10) 152 153
2022-05-18 1,848,184 1,854,340 6,157 143 28 211,659 611,055 11,722 ($7,701,496.39) 106 ($168,801.76) 87 ($130,423.98) 111 99
2022-05-17 1,841,870 1,848,183 6,314 151 20 211,263 649,809 13,878 ($12,287,408.05) 195 ($282,213.62) 126 ($304,674.64) 184 143
2022-05-16 1,835,596 1,841,869 6,274 200 36 210,747 771,487 21,552 ($29,519,408.20) 399 ($2,088,978.09) 161 ($546,626.38) 400 168
2022-05-15 1,829,406 1,835,595 6,190 140 33 210,575 691,979 15,478 ($27,823,281.64) 211 ($904,314.29) 73 ($207,090.04) 211 84
2022-05-14 1,823,226 1,829,405 6,180 135 26 210,395 627,507 13,223 ($8,042,258.19) 91 ($259,001.40) 59 ($117,585.57) 91 64
2022-05-13 1,817,043 1,823,225 6,183 172 35 210,280 779,448 20,101 ($15,769,715.55) 136 ($336,863.11) 77 ($170,166.49) 124 86
2022-05-12 1,811,148 1,817,042 5,895 173 47 210,102 1,034,087 24,380 ($37,532,227.25) 179 ($372,318.82) 122 ($264,817.16) 147 125
2022-05-11 1,805,457 1,811,147 5,691 197 42 209,889 1,122,452 31,042 ($26,962,859.71) 129 ($317,647.54) 117 ($442,468.05) 128 117
2022-05-10 1,800,753 1,805,456 4,704 131 36 209,721 845,016 23,573 ($21,157,384.25) 111 ($276,728.92) 69 ($197,123.93) 116 77
2022-05-09 1,796,576 1,800,752 4,177 90 20 209,459 712,224 17,784 ($33,810,947.52) 67 ($789,280.51) 75 ($269,540.15) 67 84
2022-05-08 1,792,457 1,796,575 4,119 46 21 209,276 567,409 13,231 ($14,204,733.80) 65 ($174,496.34) 34 ($52,105.08) 65 50
2022-05-07 1,788,407 1,792,456 4,050 48 24 209,132 489,045 10,418 ($8,987,215.77) 61 ($89,837.49) 42 ($22,799.73) 59 61
2022-05-06 1,784,360 1,788,406 4,047 44 21 208,982 517,578 11,899 ($8,919,052.05) 63 ($319,074.67) 56 ($125,049.71) 61 76
2022-05-05 1,780,428 1,784,359 3,932 53 20 208,617 564,301 14,548 ($24,327,602.46) 76 ($384,675.24) 56 ($133,827.40) 70 75
2022-05-04 1,776,643 1,780,427 3,785 45 26 208,240 564,755 14,002 ($19,389,142.05) 88 ($89,310.88) 57 ($71,734.55) 79 77
2022-05-03 1,772,889 1,776,642 3,754 50 24 207,988 471,712 10,386 ($6,195,253.83) 63 ($95,728.51) 59 ($113,631.30) 70 76
2022-05-02 1,769,145 1,772,888 3,744 69 31 207,754 516,905 11,511 ($12,790,467.91) 62 ($247,191.34) 45 ($112,203.13) 62 61
2022-05-01 1,765,262 1,769,144 3,883 56 21 207,526 559,072 12,150 ($18,924,045.00) 78 ($163,713.20) 51 ($53,294.75) 71 61

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-05-31" 
 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-05-31" 
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-05-31" 
 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-05-31" 
 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-05-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.balances2023` 
 where LAST_DAY(date(ts)) = "2022-05-31" 
 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-05-31" 
 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-05-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 = 2023 and LAST_DAY(date(origination_ts)) = "2022-05-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 = 2023 and LAST_DAY(date(origination_ts)) = "2022-05-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 = 2023 and LAST_DAY(date(origination_ts)) = "2022-05-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 = 2023 and LAST_DAY(date(origination_ts)) = "2022-05-31" 
 group by logDT 
order by logDT

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