Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.78 KB

2021-11-30.md

File metadata and controls

204 lines (157 loc) · 8.78 KB

Moonriver Summary (Daily)

Source: moonriver.polkaholic.io

Relay Chain: kusama Para ID: 2023

Daily Summary for Month ending in 2021-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
2021-11-30 991,472 996,843 5,372 1,466 348 125,110 1,203,238 31,382 ($86,368,100.76)
2021-11-29 985,703 991,471 5,769 1,091 316 123,224 904,903 26,127 ($52,744,469.07)
2021-11-28 979,998 985,702 5,705 821 285 121,460 830,221 19,691 ($44,660,211.61)
2021-11-27 974,127 979,997 5,871 732 320 120,648 767,973 16,362 ($37,978,632.49)
2021-11-26 968,212 974,126 5,915 889 316 120,205 860,295 18,887 ($56,955,752.30)
2021-11-25 962,323 968,211 5,889 1,071 360 119,443 830,328 23,692 ($66,445,489.99)
2021-11-24 956,251 962,322 6,072 1,496 410 119,207 824,662 29,089 ($71,405,770.75)
2021-11-23 950,024 956,250 6,227 1,333 444 118,062 878,894 21,401 ($55,729,166.21)
2021-11-22 943,888 950,023 6,136 1,794 874 117,363 831,757 22,691 ($66,353,329.43)
2021-11-21 937,747 943,887 6,141 202 61 116,496 883,570 22,038 ($58,394,317.52)
2021-11-20 931,604 937,746 6,143 178 78 115,701 824,802 21,528 ($42,673,181.32)
2021-11-19 925,681 931,603 5,923 207 51 115,084 1,110,168 32,827 ($73,927,777.42)
2021-11-18 919,912 925,680 5,769 66,250 262 113,577 712,998 27,781 ($64,320,049.17)
2021-11-17 914,636 919,911 5,276 314,391 412 112,345 1,985,967 52,795 ($18,260,986.91)
2021-11-16 909,528 914,635 5,108 490,022 385 107,565 3,120,323 49,585 ($24,154,749.02)
2021-11-15 904,548 909,527 4,980 446,099 219 98,157 3,022,941 43,931 ($42,244,829.04)
2021-11-14 899,432 904,547 5,116 470,072 319 95,289 3,093,743 31,996 ($31,191,832.16)
2021-11-13 894,403 899,431 5,029 462,467 289 89,345 3,109,952 28,461 ($20,538,518.11)
2021-11-12 889,319 894,402 5,084 430,403 294 87,011 2,919,148 30,438 ($18,202,606.09)
2021-11-11 883,992 889,318 5,327 371,471 374 85,215 2,558,107 33,860 ($27,499,737.54)
2021-11-10 878,622 883,991 5,370 331,776 416 80,825 2,286,728 29,637 ($58,724,933.00)
2021-11-09 873,350 878,621 5,272 308,523 407 78,198 2,148,401 24,963 ($64,003,286.28)
2021-11-08 867,976 873,349 5,374 255,328 778 76,663 1,737,220 32,030 ($206,729,181.40)
2021-11-07 862,403 867,975 5,573 202,820 565 71,824 1,386,918 23,430 ($24,140,964.79)
2021-11-06 856,966 862,402 5,437 170,942 647 69,476 1,139,479 23,385 ($40,228,544.84)
2021-11-05 851,608 856,965 5,358 124,215 615 69,088 854,137 24,916 ($71,349,530.46)
2021-11-04 846,137 851,607 5,471 115,748 654 67,369 814,394 26,237 ($75,047,433.75)
2021-11-03 840,453 846,136 5,684 86,434 479 63,160 645,999 21,724 ($56,270,255.52)
2021-11-02 834,810 840,452 5,643 69,450 502 62,322 519,466 17,088 ($27,215,851.97)
2021-11-01 829,171 834,809 5,639 70,039 544 61,847 504,390 18,343 ($42,475,753.21)

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)) = "2021-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)) = "2021-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)) = "2021-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)) = "2021-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)) = "2021-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)) = "2021-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)) = "2021-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)) = "2021-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)) = "2021-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)) = "2021-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)) = "2021-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)) = "2021-11-30" 
 group by logDT 
order by logDT

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