Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 7.92 KB

2022-07-31.md

File metadata and controls

205 lines (158 loc) · 7.92 KB

litentry Summary (Daily)

Source: litentry.polkaholic.io

Relay Chain: polkadot Para ID: 2013

Daily Summary for Month ending in 2022-07-31

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-07-31 323,873 329,619 5,747 23 22 4,671 11,604
2022-07-30 318,022 323,872 5,851 24 19 4,671 11,815
2022-07-29 312,229 318,021 5,793 20 21 4,671 11,685
2022-07-28 306,495 312,228 5,734 20 20 4,671 11,565
2022-07-27 300,752 306,494 5,743 20 14 4,671 11,581
2022-07-26 294,943 300,751 5,809 23 15 4,671 11,726
2022-07-25 289,225 294,942 5,718 24 20 4,670 11,548
2022-07-24 283,492 289,224 5,733 41 26 4,671 11,651
2022-07-23 277,726 283,491 5,766 20 19 4,671 11,625
2022-07-22 272,065 277,725 5,661 26 21 4,671 11,445
2022-07-21 266,353 272,064 5,712 25 17 4,671 11,545
2022-07-20 260,774 266,352 5,579 52 29 4,671 34,898 4,732
2022-07-19 255,052 260,773 5,722 3 16 11,447
2022-07-18 249,315 255,051 5,737 3 16 11,480
2022-07-17 243,571 249,314 5,744 3 16 11,491
2022-07-16 237,812 243,570 5,759 3 16 11,521
2022-07-15 232,078 237,811 5,734 3 16 11,472
2022-07-14 226,370 232,077 5,708 3 16 11,419
2022-07-13 220,594 226,369 5,776 3 16 11,555
2022-07-12 214,870 220,593 5,724 3 16 11,451
2022-07-11 209,127 214,869 5,743 3 16 11,489
2022-07-10 203,425 209,126 5,702 3 16 11,407
2022-07-09 197,728 203,424 5,697 3 16 11,401
2022-07-08 191,980 197,727 5,748 3 16 11,499
2022-07-07 186,253 191,979 5,727 3 16 11,457
2022-07-06 180,542 186,252 5,711 3 16 11,425
2022-07-05 174,813 180,541 5,729 3 16 11,461
2022-07-04 169,096 174,812 5,717 3 16 11,438
2022-07-03 163,297 169,095 5,799 3 16 11,601
2022-07-02 157,560 163,296 5,737 3 16 11,477
2022-07-01 151,698 157,559 5,862 3 16 11,727

Sample Queries:

You can generate the above summary data using the following queries using the public dataset bigquery-public-data.crypto_polkadot in Google BigQuery:

Blocks

Schema

SELECT date(block_time) as logDT, MIN(number) startBN, MAX(number) endBN, COUNT(*) numBlocks 
 FROM `bigquery-public-data.crypto_polkadot.blocks2013`  
 where LAST_DAY(date(block_time)) = "2022-07-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_polkadot.extrinsics2013`  
where signed and LAST_DAY(date(block_time)) = "2022-07-31" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsactive2013` 
 where LAST_DAY(date(ts)) = "2022-07-31" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountspassive2013` 
 where LAST_DAY(date(ts)) = "2022-07-31" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsnew2013` 
 where LAST_DAY(date(ts)) = "2022-07-31" 
 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_polkadot.balances2013` 
 where LAST_DAY(date(ts)) = "2022-07-31" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.events2013` 
 where LAST_DAY(date(block_time)) = "2022-07-31" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.transfers2013` 
 where LAST_DAY(date(block_time)) = "2022-07-31" 
 group by logDT 
 order by logDT

XCM Transfers In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersOut 
 FROM `bigquery-public-data.crypto_polkadot.xcmtransfers` 
 where destination_para_id = 2013 and LAST_DAY(date(origination_ts)) = "2022-07-31" 
 group by logDT order by logDT

XCM Transfers Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersIn 
 FROM `bigquery-public-data.crypto_polkadot.xcmtransfers` 
 where origination_para_id = 2013 and LAST_DAY(date(origination_ts)) = "2022-07-31" 
 group by logDT 
order by logDT

XCM Messages In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesOut 
 FROM `bigquery-public-data.crypto_polkadot.xcm` 
 where destination_para_id = 2013 and LAST_DAY(date(origination_ts)) = "2022-07-31" 
 group by logDT order by logDT

XCM Messages Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesIn 
 FROM `bigquery-public-data.crypto_polkadot.xcm` 
 where origination_para_id = 2013 and LAST_DAY(date(origination_ts)) = "2022-07-31" 
 group by logDT 
order by logDT

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