Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.87 KB

2022-08-31.md

File metadata and controls

205 lines (158 loc) · 9.87 KB

Moonriver Summary (Daily)

Source: moonriver.polkaholic.io

Relay Chain: kusama Para ID: 2023

Daily Summary for Month ending in 2022-08-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-08-31 2,474,690 2,480,899 6,210 89 42 229,165 478,245 5,455 ($3,786,518.78) 42 ($50,905.27) 31 ($37,023.19) 40 53
2022-08-30 2,468,572 2,474,689 6,118 86 43 229,082 471,694 5,555 ($3,602,831.20) 42 ($59,734.16) 23 ($25,583.02) 42 44
2022-08-29 2,462,385 2,468,571 6,187 87 44 229,001 498,372 6,056 ($5,218,011.66) 36 ($92,115.86) 47 ($131,916.86) 44 84
2022-08-28 2,456,332 2,462,384 6,053 74 36 228,899 470,416 5,271 ($2,755,157.00) 35 ($23,251.21) 23 ($64,656.74) 33 44
2022-08-27 2,450,163 2,456,331 6,169 51 31 228,837 492,339 5,765 ($3,155,165.98) 32 ($63,087.43) 29 ($15,770.23) 32 53
2022-08-26 2,444,089 2,450,162 6,074 96 41 228,784 534,359 6,707 ($3,667,753.10) 66 ($117,077.12) 54 ($63,272.49) 62 84
2022-08-25 2,438,143 2,444,088 5,946 70 30 228,715 635,381 5,890 ($4,825,628.25) 51 ($241,251.80) 40 ($303,480.68) 51 79
2022-08-24 2,432,319 2,438,142 5,824 75 36 228,618 474,197 6,457 ($13,977,319.76) 52 ($115,082.72) 35 ($251,770.14) 26 38
2022-08-23 2,426,539 2,432,318 5,780 93 42 228,539 499,856 6,986 ($3,920,359.24) 61 ($82,742.11) 43 ($42,760.66) 59 80
2022-08-22 2,420,627 2,426,538 5,912 70 38 228,446 491,371 6,804 ($10,201,264.54) 36 ($84,357.33) 61 ($72,429.31) 33 78
2022-08-21 2,414,798 2,420,626 5,829 179 36 228,361 582,906 11,059 ($13,325,934.74) 88 ($268,665.15) 55 ($101,559.84) 82 68
2022-08-20 2,409,165 2,414,797 5,633 59 37 228,299 459,832 5,887 ($3,659,579.08) 40 ($191,884.92) 37 ($62,280.30) 48 77
2022-08-19 2,403,581 2,409,164 5,584 91 40 228,205 567,258 9,547 ($7,886,648.40) 41 ($341,780.85) 58 ($245,103.86) 56 97
2022-08-18 2,397,956 2,403,580 5,625 84 38 228,124 528,655 8,930 ($10,196,214.50) 82 ($443,390.48) 64 ($392,647.28) 78 92
2022-08-17 2,392,266 2,397,955 5,690 80 29 228,031 510,553 8,864 ($12,348,139.38) 45 ($228,566.77) 34 ($132,475.90) 62 79
2022-08-16 2,386,499 2,392,265 5,767 116 37 227,935 486,535 5,867 ($5,180,704.35) 37 ($66,420.21) 45 ($105,202.06) 65 90
2022-08-15 2,380,719 2,386,498 5,780 70 33 227,837 542,104 6,763 ($4,166,510.99) 34 ($62,576.34) 65 ($61,868.02) 54 114
2022-08-14 2,374,825 2,380,718 5,894 57 27 227,760 482,266 6,707 ($7,027,024.21) 74 ($709,715.40) 78 ($535,390.26) 74 109
2022-08-13 2,368,879 2,374,824 5,946 80 37 227,669 497,145 12,021 ($12,240,295.44) 37 ($259,540.13) 75 ($128,005.59) 37 99
2022-08-12 2,362,968 2,368,878 5,911 64 34 227,599 504,045 6,246 ($5,810,747.29) 64 ($135,858.98) 39 ($37,217.15) 69 72
2022-08-11 2,357,065 2,362,967 5,903 89 34 227,519 562,713 8,144 ($6,706,088.24) 94 ($194,961.51) 44 ($29,934.87) 101 79
2022-08-10 2,351,055 2,357,064 6,010 156 39 227,404 570,734 9,119 ($15,277,879.62) 133 ($359,353.95) 69 ($343,442.33) 141 111
2022-08-09 2,345,152 2,351,054 5,903 91 39 227,291 596,852 8,915 ($7,892,118.38) 157 ($308,932.87) 87 ($153,670.93) 172 130
2022-08-08 2,339,303 2,345,151 5,849 141 53 227,152 600,009 12,357 ($16,238,327.34) 233 ($2,290,801.38) 97 ($913,629.49) 245 131
2022-08-07 2,333,517 2,339,302 5,786 208 45 227,026 735,354 19,133 ($22,854,111.27) 80 ($265,463.42) 104 ($402,200.39) 86 129
2022-08-06 2,327,743 2,333,516 5,774 355 55 226,891 795,853 19,299 ($33,543,223.90) 122 ($655,159.55) 68 ($332,565.10) 122 80
2022-08-05 2,322,158 2,327,742 5,585 75 34 226,753 546,052 9,886 ($4,176,143.40) 53 ($240,353.81) 36 ($147,899.97) 58 51
2022-08-04 2,316,562 2,322,157 5,596 67 32 226,658 525,857 7,941 ($5,337,147.98) 65 ($167,566.83) 57 ($31,273.74) 65 85
2022-08-03 2,310,995 2,316,561 5,567 90 36 226,538 574,102 8,792 ($8,131,043.11) 37 ($22,431.70) 27 ($21,394.01) 38 45
2022-08-02 2,305,494 2,310,994 5,501 220 42 226,439 787,717 13,042 ($24,000,654.92) 55 ($158,202.47) 59 ($112,297.97) 62 94
2022-08-01 2,299,970 2,305,493 5,524 128 33 227,538 643,842 12,070 ($10,722,399.50) 41 ($64,925.28) 56 ($128,347.68) 47 78

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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-31" 
 group by logDT 
order by logDT

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