Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.05 KB

2024-04-30.md

File metadata and controls

204 lines (157 loc) · 8.05 KB
Raw

Turing Summary (Daily)

Source: turing.polkaholic.io

Relay Chain: kusama Para ID: 2114

Daily Summary for Month ending in 2024-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
2024-04-30 4,961,721 4,968,458 6,738 20 10,224 121,135 7
2024-04-29 4,954,950 4,961,720 6,771 14 10,224 112,128 8
2024-04-28 4,948,176 4,954,949 6,774 45 10,224 112,401 5
2024-04-27 4,941,400 4,948,175 6,776 19 10,224 112,036 7
2024-04-26 4,934,626 4,941,399 6,774 16 10,224 120,999 7
2024-04-25 4,927,855 4,934,625 6,771 20 10,224 112,114 7
2024-04-24 4,921,049 4,927,854 6,806 13 10,223 112,174 4
2024-04-23 4,914,242 4,921,048 6,807 40 10,223 121,408 20
2024-04-22 4,907,449 4,914,241 6,793 53 10,220 112,618 77
2024-04-21 4,900,661 4,907,448 6,788 31 10,218 112,256 9
2024-04-20 4,893,938 4,900,660 6,723 19 10,217 119,615 5
2024-04-19 4,887,450 4,893,937 6,488 18 10,217 99,581 3
2024-04-18 4,880,795 4,887,449 6,655 30 10,217 111,200 13
2024-04-17 4,874,036 4,880,794 6,759 8 10,217 120,852 3
2024-04-16 4,867,291 4,874,035 6,745 14 10,217 112,027 4
2024-04-15 4,860,637 4,867,290 6,654 16 10,216 111,852 6
2024-04-14 4,853,997 4,860,636 6,640 15 10,214 111,746 7
2024-04-13 4,847,331 4,853,996 6,666 17 10,213 111,782 4
2024-04-12 4,840,631 4,847,330 6,700 10 10,212 111,823 4
2024-04-11 4,833,942 4,840,630 6,689 22 10,212 118,858 12
2024-04-10 4,827,273 4,833,941 6,669 16 10,212 113,679 4
2024-04-09 4,820,620 4,827,272 6,653 23 10,210 111,821 7
2024-04-08 4,814,016 4,820,619 6,604 33 10,210 111,729 14
2024-04-07 4,807,377 4,814,015 6,639 46 10,209 111,995 13
2024-04-06 4,800,769 4,807,376 6,608 23 10,209 111,630 4
2024-04-05 4,794,149 4,800,768 6,620 36 10,209 111,715 9
2024-04-04 4,787,496 4,794,148 6,653 27 10,208 111,664 9
2024-04-03 4,780,828 4,787,495 6,668 41 10,208 111,690 4
2024-04-02 4,774,161 4,780,827 6,667 30 10,205 111,520 11
2024-04-01 4,767,606 4,774,160 6,555 29 10,205 111,262 4

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

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