Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.61 KB

2024-01-31.md

File metadata and controls

205 lines (158 loc) · 9.61 KB

Moonriver Summary (Daily)

Source: moonriver.polkaholic.io

Relay Chain: kusama Para ID: 2023

Daily Summary for Month ending in 2024-01-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-01-31 6,049,486 6,055,489 6,004 122 764,661 692,003 29,385 ($1,950,150.61) 15 ($25,234.52) 28 ($6,917.79) 118 34
2024-01-30 6,043,713 6,049,485 5,773 90 759,468 665,314 29,807 ($1,265,794.09) 22 ($11,246.35) 30 ($9,196.34) 143 41
2024-01-29 6,037,860 6,043,712 5,853 85 756,156 550,484 24,588 ($1,317,600.25) 6 ($38.93) 27 ($237.45) 110 31
2024-01-28 6,032,013 6,037,859 5,847 134 752,811 548,427 17,346 ($2,321,855.49) 12 ($1,860.31) 37 ($797.48) 126 50
2024-01-27 6,026,223 6,032,012 5,790 130 749,938 594,005 26,351 ($2,623,207.01) 12 ($7,754.83) 41 ($1,555.06) 128 48
2024-01-26 6,020,514 6,026,222 5,709 109 746,491 518,241 18,091 ($1,909,434.59) 24 ($264,112.70) 25 ($2,572.38) 141 44
2024-01-25 6,015,169 6,020,513 5,345 127 741,762 494,777 15,799 ($1,102,519.76) 42 ($346,318.97) 35 ($424.64) 164 57
2024-01-24 6,009,597 6,015,168 5,572 140 739,955 582,133 21,059 ($3,980,879.70) 37 ($212,781.92) 61 ($909.30) 143 79
2024-01-23 6,002,673 6,009,596 6,924 165 738,181 662,859 21,186 ($5,938,302.93) 57 ($231,657.43) 56 ($3,874.59) 155 69
2024-01-22 5,995,703 6,002,672 6,970 128 735,890 703,402 26,748 ($2,932,995.03) 30 ($283,868.05) 70 ($1,871.32) 186 86
2024-01-21 5,988,783 5,995,702 6,920 102 732,831 691,863 33,177 ($1,469,109.20)
2024-01-20 5,981,877 5,988,782 6,906 124 729,503 741,935 31,749 ($2,359,174.40)
2024-01-19 5,974,946 5,981,876 6,931 151 724,999 627,543 23,804 ($3,228,031.89)
2024-01-18 5,968,019 5,974,945 6,927 181 722,738 631,387 25,006 ($2,408,913.83)
2024-01-17 5,961,133 5,968,018 6,886 148 720,832 698,988 28,480 ($2,690,105.85)
2024-01-16 5,954,238 5,961,132 6,895 133 718,368 754,251 24,868 ($2,973,852.30)
2024-01-15 5,947,346 5,954,237 6,892 161 716,041 717,667 34,017 ($3,924,265.42) 21 ($21,911.49) 79 ($75,818.64) 155 93
2024-01-14 5,940,476 5,947,345 6,870 146 713,473 753,409 31,777 ($4,696,502.92) 9 ($3,188.69) 44 ($5,054.08) 122 56
2024-01-13 5,933,605 5,940,475 6,871 172 710,328 834,654 36,196 ($8,243,010.22) 46 ($46,727.70) 73 ($4,194.94) 167 88
2024-01-12 5,926,687 5,933,604 6,918 198 705,852 846,960 38,981 ($5,667,893.83) 23 ($8,742.20) 66 ($5,200.52) 115 58
2024-01-11 5,919,807 5,926,686 6,880 194 702,409 776,712 35,357 ($4,824,007.27) 14 ($1,183.92) 82 ($11,856.02) 131 114
2024-01-10 5,912,949 5,919,806 6,858 182 698,429 752,791 32,051 ($5,787,406.78) 33 ($39,878.28) 78 ($12,318.92) 99 84
2024-01-09 5,906,221 5,912,948 6,728 176 695,295 779,911 30,610 ($4,789,214.46) 29 ($53,543.22) 73 ($10,325.65) 86 86
2024-01-08 5,899,429 5,906,220 6,792 206 691,407 754,246 30,292 ($4,946,335.49) 23 ($31,786.63) 85 ($10,673.64) 91 92
2024-01-07 5,892,616 5,899,428 6,813 148 687,607 612,940 18,999 ($5,100,269.56) 16 ($24,772.02) 61 ($10,351.12) 74 75
2024-01-06 5,885,827 5,892,615 6,789 163 684,323 645,700 23,382 ($6,929,804.60) 23 ($5,874.30) 72 ($10,734.36) 80 78
2024-01-05 5,879,098 5,885,826 6,729 153 680,665 771,506 29,344 ($22,344,460.27) 35 ($28,039.60) 88 ($16,179.04) 100 102
2024-01-04 5,872,407 5,879,097 6,691 238 677,680 848,794 33,980 ($15,769,085.30) 57 ($126,878.30) 136 ($227,264.51) 155 145
2024-01-03 5,865,726 5,872,406 6,654 247 674,671 791,645 28,691 ($17,867,415.91) 94 ($173,562.88) 155 ($50,809.35) 185 183 27 missing (0.40%)
2024-01-02 5,858,983 5,865,725 6,743 186 672,072 700,115 25,791 ($9,970,871.30) 17 ($5,287.97) 75 ($2,108.01) 54 73
2024-01-01 5,852,226 5,858,982 6,757 156 668,575 697,949 28,361 ($6,118,023.85) 22 ($233,952.54) 81 ($17,768.45) 78 91

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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-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)) = "2024-01-31" 
 group by logDT 
order by logDT

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