Skip to content

Latest commit

 

History

History
202 lines (155 loc) · 8.03 KB

2023-02-28.md

File metadata and controls

202 lines (155 loc) · 8.03 KB
Raw

Turing Summary (Daily)

Source: turing.polkaholic.io

Relay Chain: kusama Para ID: 2114

Daily Summary for Month ending in 2023-02-28

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
2023-02-28 2,055,484 2,062,530 7,047 67 69 2 7,584 93,718 6 2 1 2 1
2023-02-27 2,048,432 2,055,483 7,052 73 78 2 2 7,584 100,636 15 8 7 8 7
2023-02-26 2,041,336 2,048,431 7,096 50 60 2 7,583 100,476 6 3 2 3 2
2023-02-25 2,034,256 2,041,335 7,080 62 62 2 7,583 100,343 8 3 4 3 4
2023-02-24 2,027,168 2,034,255 7,088 82 66 2 2 7,583 93,254 5 7 2 7 2
2023-02-23 2,020,082 2,027,167 7,086 64 67 2 7,581 100,223 12 5 6 5 6
2023-02-22 2,012,997 2,020,081 7,085 49 65 2 1 7,581 100,079 7 4 3 4 3
2023-02-21 2,005,986 2,012,996 7,011 71 60 3 2 7,580 99,966 13 3 6 3 6
2023-02-20 1,998,952 2,005,985 7,034 57 71 4 7,579 95,966 10 1 4 1 4
2023-02-19 1,991,909 1,998,951 7,043 101 74 3 1 7,579 97,269 12 1 8 1 8
2023-02-18 1,984,820 1,991,908 7,089 53 61 3 2 7,578 100,344 8 5 3 5 3
2023-02-17 1,977,746 1,984,819 7,074 64 64 4 3 7,576 100,349 15 4 5 7 7
2023-02-16 1,970,658 1,977,745 7,088 61 70 5 3 7,574 100,484 12 3 6 3 6
2023-02-15 1,963,585 1,970,657 7,073 49 62 3 7,573 93,235 10 1 5 1 6
2023-02-14 1,956,513 1,963,584 7,072 43 65 3 1 7,573 100,233 6 1 4 1 4
2023-02-13 1,949,452 1,956,512 7,061 58 69 2 1 7,572 100,185 9 4 6 4 6
2023-02-12 1,942,392 1,949,451 7,060 47 64 2 3 7,573 100,133 12 6 6 6 6
2023-02-11 1,935,345 1,942,391 7,047 52 62 2 7,570 97,951 3 4 2 4 2
2023-02-10 1,928,300 1,935,344 7,045 40 52 2 7,570 95,115 7 3 3
2023-02-09 1,921,583 1,928,299 6,717 61 64 10 1 7,570 87,303 16 2 4 2 4
2023-02-08 1,914,545 1,921,582 7,038 63 64 3 3 7,570 100,293 16 3 9 3 12
2023-02-07 1,907,493 1,914,544 7,052 123 113 10 9 7,567 99,759 18 2 3 2 3
2023-02-06 1,900,433 1,907,492 7,060 85 71 7 7 7,558 98,862 15 2 5 2 5
2023-02-05 1,893,363 1,900,432 7,070 45 64 2 1 7,551 91,423 5 4 4 4 4
2023-02-04 1,886,312 1,893,362 7,051 51 58 2 2 7,550 98,468 15 4 7 4 7
2023-02-03 1,879,268 1,886,311 7,044 64 73 2 1 7,549 98,503 10 2 8 2 8
2023-02-02 1,872,223 1,879,267 7,045 69 72 4 3 7,549 98,467 9 3 4 3 4
2023-02-01 1,865,173 1,872,222 7,050 128 132 71 70 7,546 91,788 79 3 5 3 5

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.blocks2114`  
 where LAST_DAY(date(block_time)) = "2023-02-28" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_kusama.extrinsics2114`  
where signed and LAST_DAY(date(block_time)) = "2023-02-28" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsactive2114` 
 where LAST_DAY(date(ts)) = "2023-02-28" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountspassive2114` 
 where LAST_DAY(date(ts)) = "2023-02-28" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsnew2114` 
 where LAST_DAY(date(ts)) = "2023-02-28" 
 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.balances2114` 
 where LAST_DAY(date(ts)) = "2023-02-28" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.events2114` 
 where LAST_DAY(date(block_time)) = "2023-02-28" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.transfers2114` 
 where LAST_DAY(date(block_time)) = "2023-02-28" 
 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 = 2114 and LAST_DAY(date(origination_ts)) = "2023-02-28" 
 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 = 2114 and LAST_DAY(date(origination_ts)) = "2023-02-28" 
 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 = 2114 and LAST_DAY(date(origination_ts)) = "2023-02-28" 
 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 = 2114 and LAST_DAY(date(origination_ts)) = "2023-02-28" 
 group by logDT 
order by logDT

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