Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 7.69 KB

2023-11-30.md

File metadata and controls

204 lines (157 loc) · 7.69 KB

invarch Summary (Daily)

Source: invarch.polkaholic.io

Relay Chain: polkadot Para ID: 3340

Daily Summary for Month ending in 2023-11-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
2023-11-30 257,035 264,081 7,047 1 14,096
2023-11-29 249,998 257,034 7,037 1 14,076
2023-11-28 242,948 249,997 7,050 1 14,102
2023-11-27 235,891 242,947 7,057 1 14,116
2023-11-26 228,799 235,890 7,092 1 14,186
2023-11-25 221,730 228,798 7,069 1 14,140
2023-11-24 214,713 221,729 7,017 1 14,036
2023-11-23 207,653 214,712 7,060 1 14,122
2023-11-22 200,576 207,652 7,077 1 14,156
2023-11-21 193,510 200,575 7,066 1 14,134
2023-11-20 186,436 193,509 7,074 1 14,150
2023-11-19 179,350 186,435 7,086 1 14,174
2023-11-18 172,288 179,349 7,062 1 14,126
2023-11-17 165,233 172,287 7,055 2 1 14,126
2023-11-16 158,176 165,232 7,057 1 14,116
2023-11-15 151,122 158,175 7,054 1 14,110
2023-11-14 144,051 151,121 7,071 1 14,143
2023-11-13 137,000 144,050 7,051 1 14,104
2023-11-12 129,926 136,999 7,074 1 14,150
2023-11-11 122,844 129,925 7,082 1 14,166
2023-11-10 115,792 122,843 7,052 2 1 14,119
2023-11-09 108,750 115,791 7,042 1 14,086
2023-11-08 101,679 108,749 7,071 1 14,144
2023-11-07 94,619 101,678 7,060 1 14,122
2023-11-06 87,576 94,618 7,043 1 14,088
2023-11-05 80,502 87,575 7,074 1 14,150
2023-11-04 73,439 80,501 7,063 1 14,128
2023-11-03 66,378 73,438 7,061 1 14,124
2023-11-02 59,381 66,377 6,997 1 13,996
2023-11-01 52,427 59,380 6,954 2 1 13,918 1

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.blocks3340`  
 where LAST_DAY(date(block_time)) = "2023-11-30" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_polkadot.extrinsics3340`  
where signed and LAST_DAY(date(block_time)) = "2023-11-30" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsactive3340` 
 where LAST_DAY(date(ts)) = "2023-11-30" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountspassive3340` 
 where LAST_DAY(date(ts)) = "2023-11-30" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsnew3340` 
 where LAST_DAY(date(ts)) = "2023-11-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_polkadot.balances3340` 
 where LAST_DAY(date(ts)) = "2023-11-30" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.events3340` 
 where LAST_DAY(date(block_time)) = "2023-11-30" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.transfers3340` 
 where LAST_DAY(date(block_time)) = "2023-11-30" 
 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 = 3340 and LAST_DAY(date(origination_ts)) = "2023-11-30" 
 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 = 3340 and LAST_DAY(date(origination_ts)) = "2023-11-30" 
 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 = 3340 and LAST_DAY(date(origination_ts)) = "2023-11-30" 
 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 = 3340 and LAST_DAY(date(origination_ts)) = "2023-11-30" 
 group by logDT 
order by logDT

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