Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.22 KB

2024-07-31.md

File metadata and controls

205 lines (158 loc) · 8.22 KB

invarch Summary (Daily)

Source: invarch.polkaholic.io

Relay Chain: polkadot Para ID: 3340

Daily Summary for Month ending in 2024-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
2024-07-31 1,942,750 1,949,900 7,151 69 76,550 21,857 1,538
2024-07-30 1,935,612 1,942,749 7,138 98 76,550 32,036 1,863
2024-07-29 1,928,468 1,935,611 7,144 68 76,549 20,070 1,696
2024-07-28 1,921,342 1,928,467 7,126 79 76,549 24,317 1,840
2024-07-27 1,914,204 1,921,341 7,138 92 76,549 22,398 1,880
2024-07-26 1,907,072 1,914,203 7,132 67 76,550 19,718 1,615
2024-07-25 1,899,952 1,907,071 7,120 57 76,550 18,069 1,344
2024-07-24 1,892,814 1,899,951 7,138 106 76,550 27,448 2,143
2024-07-23 1,885,720 1,892,813 7,094 66 76,549 21,781 1,569
2024-07-22 1,878,606 1,885,719 7,114 90 76,549 22,540 1,956
2024-07-21 1,871,475 1,878,605 7,131 71 76,549 22,675 1,640
2024-07-20 1,864,368 1,871,474 7,107 128 76,549 30,700 2,212
2024-07-19 1,857,251 1,864,367 7,117 82 76,548 21,355 1,681
2024-07-18 1,850,123 1,857,250 7,128 76 76,548 19,962 1,660
2024-07-17 1,842,985 1,850,122 7,138 79 76,548 23,791 1,759
2024-07-16 1,835,853 1,842,984 7,132 81 76,548 20,692 1,734
2024-07-15 1,828,732 1,835,852 7,121 96 76,548 24,362 2,186
2024-07-14 1,821,609 1,828,731 7,123 132 76,548 26,735 2,055
2024-07-13 1,814,502 1,821,608 7,107 114 76,548 22,495 2,167
2024-07-12 1,807,348 1,814,501 7,154 77 76,546 25,051 1,577
2024-07-11 1,800,197 1,807,347 7,151 62 76,546 18,874 1,333
2024-07-10 1,793,039 1,800,196 7,158 88 76,546 22,689 1,955
2024-07-09 1,785,892 1,793,038 7,147 87 21,109 1,846
2024-07-08 1,778,735 1,785,891 7,157 82 23,238 1,826
2024-07-07 1,771,570 1,778,734 7,165 109 24,473 1,867
2024-07-06 1,764,475 1,771,569 7,095 94 21,651 1,951
2024-07-05 1,757,415 1,764,474 7,060 77 18,630 1,641
2024-07-04 1,750,361 1,757,414 7,054 82 17,850 1,407
2024-07-03 1,743,235 1,750,360 7,126 129 22,173 1,994
2024-07-02 1,736,110 1,743,234 7,125 113 22,668 2,298
2024-07-01 1,728,957 1,736,109 7,153 113 24,272 2,280

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-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.extrinsics3340`  
where signed and LAST_DAY(date(block_time)) = "2024-07-31" 
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-07-31" 
 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-07-31" 
 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-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.balances3340` 
 where LAST_DAY(date(ts)) = "2024-07-31" 
 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-07-31" 
 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-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 = 3340 and LAST_DAY(date(origination_ts)) = "2024-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 = 3340 and LAST_DAY(date(origination_ts)) = "2024-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 = 3340 and LAST_DAY(date(origination_ts)) = "2024-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 = 3340 and LAST_DAY(date(origination_ts)) = "2024-07-31" 
 group by logDT 
order by logDT

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