Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.53 KB

2022-03-31.md

File metadata and controls

205 lines (158 loc) · 9.53 KB

Moonriver Summary (Daily)

Source: moonriver.polkaholic.io

Relay Chain: kusama Para ID: 2023

Daily Summary for Month ending in 2022-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
2022-03-31 1,657,252 1,660,606 3,355 179 115 200,509 639,440 14,674 ($19,024,348.43) 83 ($148,811.81) 162 186
2022-03-30 1,653,944 1,657,251 3,308 181 93 200,234 587,659 12,315 ($15,377,149.48) 59 ($142,382.99) 114 138
2022-03-29 1,650,558 1,653,943 3,386 205 117 199,946 656,385 13,727 ($27,362,715.79) 64 ($86,102.93) 120 186
2022-03-28 1,647,198 1,650,557 3,360 270 151 199,617 692,895 15,084 ($29,040,928.93) 43 ($147,231.66) 92 152
2022-03-27 1,643,566 1,647,197 3,632 261 119 199,303 535,148 9,848 ($16,670,254.02) 44 ($116,571.26) 94 70
2022-03-26 1,639,906 1,643,565 3,660 274 104 199,063 498,502 8,572 ($13,913,492.81) 51 ($393,661.02) 102 86
2022-03-25 1,636,230 1,639,905 3,676 251 122 198,823 585,355 11,146 ($23,072,044.50) 55 ($688,259.80) 114 146
2022-03-24 1,632,515 1,636,229 3,715 261 118 198,528 549,813 10,113 ($12,390,990.20) 49 ($240,395.24) 98 104
2022-03-23 1,628,752 1,632,514 3,763 276 118 198,247 559,464 10,425 ($15,030,653.46) 53 ($316,737.99) 112 122
2022-03-22 1,624,773 1,628,751 3,979 325 133 197,953 626,172 12,576 ($37,348,942.24) 74 ($323,522.16) 148 116
2022-03-21 1,620,505 1,624,772 4,268 291 121 197,635 622,026 10,042 ($15,269,653.74) 54 ($137,345.50) 109 112
2022-03-20 1,616,324 1,620,504 4,181 376 131 197,333 814,874 16,572 ($40,552,246.08) 77 ($655,835.39) 152 92
2022-03-19 1,612,027 1,616,323 4,297 213 97 197,054 546,276 8,167 ($12,411,386.59) 49 ($143,614.12) 98 62
2022-03-18 1,607,774 1,612,026 4,253 221 100 196,765 522,009 7,933 ($8,915,395.84) 66 ($867,985.62) 132 112
2022-03-17 1,603,692 1,607,773 4,082 202 99 196,479 539,072 7,704 ($10,288,531.69) 53 ($378,925.18) 106 116
2022-03-16 1,599,612 1,603,691 4,080 322 126 196,233 592,321 9,405 ($11,470,386.30) 61 ($54,097.62) 120 92
2022-03-15 1,595,539 1,599,611 4,073 338 133 195,963 636,704 10,253 ($23,177,808.93) 62 ($49,992.70) 4 ($9.66) 128 76
2022-03-14 1,591,479 1,595,538 4,060 261 125 195,685 540,909 7,811 ($13,663,437.77) 49 ($193,595.79) 98 68
2022-03-13 1,587,350 1,591,478 4,129 206 95 195,423 509,418 7,526 ($13,388,378.17) 61 ($202,305.69) 122 50
2022-03-12 1,583,187 1,587,349 4,163 226 101 195,157 476,691 6,291 ($18,771,549.45) 55 ($96,748.59) 110 36
2022-03-11 1,579,102 1,583,186 4,085 258 115 194,938 592,914 8,262 ($12,360,535.52) 94 ($325,244.60) 188 46
2022-03-10 1,575,108 1,579,101 3,994 236 93 194,657 613,959 9,856 ($19,662,775.94) 94 ($156,144.38) 1 ($0.51) 188 86
2022-03-09 1,571,230 1,575,107 3,878 320 133 194,332 690,533 12,405 ($15,850,256.47) 79 ($142,589.07) 162 76
2022-03-08 1,567,268 1,571,229 3,962 290 104 192,083 564,741 8,156 ($13,524,090.18) 41 ($287,256.97) 84 58
2022-03-07 1,563,411 1,567,267 3,857 310 106 191,339 693,926 9,529 ($13,736,942.77) 16 ($24,851.13) 32 32
2022-03-06 1,559,410 1,563,410 4,001 231 113 190,557 585,104 7,572 ($10,476,790.14) 19 ($37,609.69) 38 22
2022-03-05 1,555,453 1,559,409 3,957 280 106 190,292 624,640 7,481 ($11,237,269.98) 49 ($92,393.46) 3 40
2022-03-04 1,551,438 1,555,452 4,015 306 107 189,968 645,676 8,670 ($13,590,993.16) 27 ($45,552.53) 24 23
2022-03-03 1,547,431 1,551,437 4,007 329 124 189,747 658,377 9,575 ($15,161,104.02) 57 ($129,714.75) 114 46
2022-03-02 1,543,266 1,547,430 4,165 417 144 189,383 728,141 10,986 ($22,102,521.51) 54 ($211,920.00) 108 54
2022-03-01 1,539,200 1,543,265 4,066 366 107 189,118 677,819 11,383 ($28,656,160.80) 45 ($251,556.51) 90 72

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

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