Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.18 KB

2024-04-30.md

File metadata and controls

204 lines (157 loc) · 8.18 KB

invarch Summary (Daily)

Source: invarch.polkaholic.io

Relay Chain: polkadot Para ID: 3340

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 1,291,227 1,297,849 6,623 251 76,473 26,969 3,272
2024-04-29 1,284,677 1,291,226 6,550 240 76,476 24,585 3,330
2024-04-28 1,278,061 1,284,676 6,616 262 76,531 22,281 3,625
2024-04-27 1,271,404 1,278,060 6,657 187 76,538 22,013 3,270
2024-04-26 1,264,750 1,271,403 6,654 207 76,540 22,256 3,585
2024-04-25 1,258,129 1,264,749 6,621 275 76,568 28,391 4,119
2024-04-24 1,251,555 1,258,128 6,574 208 76,569 22,915 3,090
2024-04-23 1,244,980 1,251,554 6,575 166 76,570 21,521 2,890
2024-04-22 1,238,461 1,244,979 6,519 215 76,573 21,710 3,435
2024-04-21 1,232,310 1,238,460 6,151 336 76,583 23,841 3,439
2024-04-20 1,225,854 1,232,309 6,456 407 76,644 51,079 11,107
2024-04-19 1,219,394 1,225,853 6,460 131 70,524 19,971 2,345
2024-04-18 1,212,971 1,219,393 6,423 105 70,523 18,826 2,029
2024-04-17 1,206,551 1,212,970 6,420 100 70,522 17,929 1,915
2024-04-16 1,200,009 1,206,550 6,542 150 70,523 22,904 2,617
2024-04-15 1,193,361 1,200,008 6,648 171 70,527 25,332 2,993
2024-04-14 1,186,684 1,193,360 6,677 296 70,526 26,684 3,802
2024-04-13 1,180,140 1,186,683 6,544 217 70,531 118,696 27,323
2024-04-12 1,173,527 1,180,139 6,613 148 46,971 200,880 47,230
2024-04-11 1,166,838 1,173,526 6,689 62 1,899 17,616 1,302
2024-04-10 1,160,183 1,166,837 6,655 70 1,899 18,108 1,604
2024-04-09 1,153,530 1,160,182 6,653 77 1,898 18,383 1,588
2024-04-08 1,146,866 1,153,529 6,664 112 1,898 21,785 1,936
2024-04-07 1,140,282 1,146,865 6,584 95 1,898 19,344 1,697
2024-04-06 1,133,623 1,140,281 6,659 60 1,897 16,809 1,421
2024-04-05 1,126,993 1,133,622 6,630 79 1,897 18,060 1,534
2024-04-04 1,120,388 1,126,992 6,605 105 1,897 18,885 1,927
2024-04-03 1,114,286 1,120,387 6,102 105 1,896 18,510 1,773
2024-04-02 1,107,615 1,114,285 6,671 97 1,895 21,760 1,824
2024-04-01 1,100,966 1,107,614 6,649 124 1,895 21,084 2,075

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-04-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)) = "2024-04-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)) = "2024-04-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)) = "2024-04-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)) = "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_polkadot.balances3340` 
 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_polkadot.events3340` 
 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_polkadot.transfers3340` 
 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_polkadot.xcmtransfers` 
 where destination_para_id = 3340 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_polkadot.xcmtransfers` 
 where origination_para_id = 3340 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_polkadot.xcm` 
 where destination_para_id = 3340 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_polkadot.xcm` 
 where origination_para_id = 3340 and LAST_DAY(date(origination_ts)) = "2024-04-30" 
 group by logDT 
order by logDT

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