Skip to content

Latest commit

 

History

History
203 lines (156 loc) · 8.62 KB

2024-02-29.md

File metadata and controls

203 lines (156 loc) · 8.62 KB

Moonriver Summary (Daily)

Source: moonriver.polkaholic.io

Relay Chain: kusama Para ID: 2023

Daily Summary for Month ending in 2024-02-29

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-02-29 6,239,850 6,246,585 6,736 213 865,695 745,828 28,998 ($4,207,027.58)
2024-02-28 6,233,132 6,239,849 6,718 210 860,915 697,141 24,140 ($2,580,665.07)
2024-02-27 6,226,395 6,233,131 6,737 187 857,154 674,979 22,065 ($2,985,381.10)
2024-02-26 6,219,641 6,226,394 6,754 197 853,515 665,413 24,507 ($2,080,922.25)
2024-02-25 6,212,924 6,219,640 6,717 179 850,560 677,069 26,423 ($952,515.16)
2024-02-24 6,206,307 6,212,923 6,617 205 847,741 670,585 27,159 ($1,428,555.39)
2024-02-23 6,199,683 6,206,306 6,624 130 845,166 657,778 25,173 ($1,872,963.40)
2024-02-22 6,193,247 6,199,682 6,436 121 842,591 634,675 24,725 ($3,136,534.40)
2024-02-21 6,186,633 6,193,246 6,614 141 840,111 650,614 23,466 ($19,170,411.37)
2024-02-20 6,179,975 6,186,632 6,658 164 837,508 663,392 24,065 ($2,784,504.03)
2024-02-19 6,173,421 6,179,974 6,554 162 835,130 722,159 27,577 ($4,598,593.77)
2024-02-18 6,166,849 6,173,420 6,572 202 832,429 738,459 27,665 ($2,792,182.11)
2024-02-17 6,160,293 6,166,848 6,556 118 829,079 630,225 23,886 ($1,255,123.73)
2024-02-16 6,154,052 6,160,292 6,241 89 825,907 645,892 27,232 ($1,537,944.70)
2024-02-15 6,149,287 6,154,051 4,765 88 823,031 595,545 24,923 ($1,564,739.57)
2024-02-14 6,142,914 6,149,286 6,373 128 819,695 600,666 22,282 ($2.04)
2024-02-13 6,136,470 6,142,913 6,444 112 817,164 781,253 41,163
2024-02-12 6,129,712 6,136,469 6,758 143 812,681 777,183 38,596 ($2,914,402.74)
2024-02-11 6,122,955 6,129,711 6,757 133 808,629 763,824 32,839 ($0.69)
2024-02-10 6,116,215 6,122,954 6,740 129 802,215 659,106 25,310
2024-02-09 6,109,503 6,116,214 6,712 117 798,302 636,793 21,891 ($76,064.59)
2024-02-08 6,102,824 6,109,502 6,679 143 795,698 771,386 32,576 ($235,119.99)
2024-02-07 6,096,127 6,102,823 6,697 136 790,543 761,174 35,453 ($13.40)
2024-02-06 6,089,320 6,096,126 6,807 108 786,395 690,469 33,660
2024-02-05 6,082,542 6,089,319 6,778 117 782,496 622,379 23,935 ($27,796.11) 25 ($9,143.04) 42 ($20.29)
2024-02-04 6,075,769 6,082,541 6,773 80 778,633 630,013 23,417 ($606,896.31) 22 ($17,625.81) 44 ($391.23)
2024-02-03 6,068,984 6,075,768 6,785 107 774,622 756,589 43,345 ($646,958.86) 17 ($7,674.90) 19 ($9,196.17)
2024-02-02 6,062,210 6,068,983 6,774 114 770,790 669,547 33,463 ($953,454.78) 26 ($40,502.56) 21 ($1,478.56) 15
2024-02-01 6,055,490 6,062,209 6,720 118 767,385 592,393 19,670 ($1,240,761.70) 21 ($9,387.62) 30 ($2,632.95) 101 24

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-02-29" 
 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-02-29" 
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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 group by logDT 
order by logDT

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