Skip to content

Latest commit

 

History

History
203 lines (156 loc) · 7.95 KB

2024-02-29.md

File metadata and controls

203 lines (156 loc) · 7.95 KB

invarch Summary (Daily)

Source: invarch.polkaholic.io

Relay Chain: polkadot Para ID: 3340

Daily Summary for Month ending in 2024-02-29

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-02-29 888,755 895,428 6,674 123 1,888 21,437 2,134
2024-02-28 882,239 888,754 6,516 147 1,888 22,917 2,532
2024-02-27 875,505 882,238 6,734 84 1,888 18,577 1,592
2024-02-26 868,628 875,504 6,877 116 1,887 21,008 2,309
2024-02-25 861,735 868,627 6,893 127 1,886 19,791 2,403
2024-02-24 854,848 861,734 6,887 114 1,885 19,584 1,916
2024-02-23 847,957 854,847 6,891 167 1,885 20,056 2,780
2024-02-22 841,044 847,956 6,913 185 1,882 22,500 3,040
2024-02-21 834,165 841,043 6,879 138 1,863 20,018 2,630
2024-02-20 827,285 834,164 6,880 201 1,855 21,813 2,986
2024-02-19 820,389 827,284 6,896 199 1,840 23,402 2,967
2024-02-18 813,520 820,388 6,869 145 1,817 20,554 2,278
2024-02-17 806,630 813,519 6,890 145 1,817 21,234 2,623
2024-02-16 799,755 806,629 6,875 128 1,815 19,576 2,428
2024-02-15 792,885 799,754 6,870 142 1,813 20,066 2,546
2024-02-14 786,025 792,884 6,860 154 1,812 21,040 2,567
2024-02-13 779,154 786,024 6,871 168 1,811 21,055 2,764
2024-02-12 772,261 779,153 6,893 164 1,811 21,340 2,786
2024-02-11 765,369 772,260 6,892 163 1,811 20,792 2,916
2024-02-10 758,492 765,368 6,877 205 1,811 20,840 2,914
2024-02-09 751,610 758,491 6,882 216 1,785 23,183 3,522
2024-02-08 744,733 751,609 6,877 647 1,783 30,801 5,382
2024-02-07 737,843 744,732 6,890 378 1,779 27,108 4,517
2024-02-06 730,975 737,842 6,868 218 1,775 22,518 3,758
2024-02-05 724,102 730,974 6,873 195 1,775 21,975 3,435
2024-02-04 717,209 724,101 6,893 262 1,774 21,065 3,725
2024-02-03 710,305 717,208 6,904 163 1,774 19,466 2,780
2024-02-02 703,438 710,304 6,867 196 1,774 20,711 3,444
2024-02-01 696,545 703,437 6,893 290 1,774 21,594 3,845

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

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