Skip to content

Latest commit

 

History

History
202 lines (155 loc) · 7.45 KB

2022-04-30.md

File metadata and controls

202 lines (155 loc) · 7.45 KB
Raw

Turing Summary (Daily)

Source: turing.polkaholic.io

Relay Chain: kusama Para ID: 2114

Daily Summary for Month ending in 2022-04-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
2022-04-30 99,431 103,438 4,008 6 20 8,021
2022-04-29 95,489 99,430 3,942 6 20 7,886
2022-04-28 91,558 95,488 3,931 6 20 7,868
2022-04-27 87,663 91,557 3,895 6 20 7,792
2022-04-26 83,734 87,662 3,929 6 20 7,863
2022-04-25 79,838 83,733 3,896 6 20 7,794
2022-04-24 75,930 79,837 3,908 6 20 7,821
2022-04-23 72,024 75,929 3,906 6 20 7,814
2022-04-22 68,133 72,023 3,891 6 20 7,788
2022-04-21 64,271 68,132 3,862 6 20 7,729
2022-04-20 60,466 64,270 3,805 6 20 7,612
2022-04-19 56,753 60,465 3,713 6 20 7,431
2022-04-18 53,037 56,752 3,716 1 7 20 7,439 1
2022-04-17 49,273 53,036 3,764 6 20 7,533
2022-04-16 45,658 49,272 3,615 6 20 7,232
2022-04-15 41,973 45,657 3,685 3 28 20 7,394 3
2022-04-14 38,271 41,972 3,702 6 18 7,406
2022-04-13 34,528 38,270 3,743 1 7 18 7,496 1
2022-04-12 30,867 34,527 3,661 2 7 18 7,337 1
2022-04-11 27,113 30,866 3,754 6 17 7,513
2022-04-10 23,351 27,112 3,762 6 17 7,527
2022-04-09 19,548 23,350 3,803 6 17 7,611
2022-04-08 15,818 19,547 3,730 6 17 7,462
2022-04-07 12,077 15,817 3,741 7 7 17 7,523 3
2022-04-06 8,349 12,076 3,728 4 15 7,458
2022-04-05 4,496 8,348 3,853 4 15 7,711
2022-04-04 436 4,495 4,060 5 5 15 8,143
2022-04-03 1 435 435 8 5 15 907 2

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)) = "2022-04-30" 
 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)) = "2022-04-30" 
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)) = "2022-04-30" 
 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)) = "2022-04-30" 
 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)) = "2022-04-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.balances2114` 
 where LAST_DAY(date(ts)) = "2022-04-30" 
 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)) = "2022-04-30" 
 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)) = "2022-04-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 = 2114 and LAST_DAY(date(origination_ts)) = "2022-04-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 = 2114 and LAST_DAY(date(origination_ts)) = "2022-04-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 = 2114 and LAST_DAY(date(origination_ts)) = "2022-04-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 = 2114 and LAST_DAY(date(origination_ts)) = "2022-04-30" 
 group by logDT 
order by logDT

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