Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.14 KB

2024-06-30.md

File metadata and controls

204 lines (157 loc) · 8.14 KB

invarch Summary (Daily)

Source: invarch.polkaholic.io

Relay Chain: polkadot Para ID: 3340

Daily Summary for Month ending in 2024-06-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-06-30 1,721,814 1,728,956 7,143 112 21,157 2,097
2024-06-29 1,714,662 1,721,813 7,152 104 27,057 2,139
2024-06-28 1,707,501 1,714,661 7,161 103 21,278 2,093
2024-06-27 1,700,396 1,707,500 7,105 95 26,553 2,056
2024-06-26 1,693,262 1,700,395 7,134 91 23,962 2,107
2024-06-25 1,686,157 1,693,261 7,105 89 22,122 1,898
2024-06-24 1,679,044 1,686,156 7,113 90 23,618 1,886
2024-06-23 1,671,934 1,679,043 7,110 96 76,538 23,013 2,040
2024-06-22 1,664,813 1,671,933 7,121 71 76,538 19,709 1,582
2024-06-21 1,657,676 1,664,812 7,137 94 76,538 20,512 1,952
2024-06-20 1,650,534 1,657,675 7,142 73 76,538 19,033 1,731
2024-06-19 1,643,404 1,650,533 7,130 114 76,538 29,185 1,927
2024-06-18 1,636,329 1,643,403 7,075 84 76,541 18,192 1,649
2024-06-17 1,629,226 1,636,328 7,103 111 76,541 25,180 2,136
2024-06-16 1,622,104 1,629,225 7,122 113 76,541 23,300 2,173
2024-06-15 1,614,981 1,622,103 7,123 122 76,543 23,277 2,658
2024-06-14 1,607,850 1,614,980 7,131 103 76,544 23,576 2,227
2024-06-13 1,600,696 1,607,849 7,154 94 76,544 22,254 2,005
2024-06-12 1,593,549 1,600,695 7,147 114 76,542 22,532 2,138
2024-06-11 1,586,393 1,593,548 7,156 94 76,542 21,670 1,998
2024-06-10 1,579,261 1,586,392 7,132 94 76,542 20,867 1,997
2024-06-09 1,572,123 1,579,260 7,138 102 76,541 22,054 2,156
2024-06-08 1,565,012 1,572,122 7,111 101 76,541 25,372 2,181
2024-06-07 1,557,889 1,565,011 7,123 139 76,541 23,130 2,599
2024-06-06 1,550,806 1,557,888 7,083 115 76,539 23,147 2,320
2024-06-05 1,543,683 1,550,805 7,123 108 76,539 23,155 2,299
2024-06-04 1,536,553 1,543,682 7,130 135 76,538 27,490 2,331
2024-06-03 1,529,421 1,536,552 7,132 126 76,524 25,459 2,589
2024-06-02 1,522,291 1,529,420 7,130 122 76,524 23,214 2,420
2024-06-01 1,515,167 1,522,290 7,124 142 76,524 25,027 2,742

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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-30" 
 group by logDT 
order by logDT

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