Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 7.79 KB

2023-05-31.md

File metadata and controls

205 lines (158 loc) · 7.79 KB

manta Summary (Daily)

Source: manta.polkaholic.io

Relay Chain: polkadot Para ID: 2104

Daily Summary for Month ending in 2023-05-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
2023-05-31 490,960 498,027 7,068 9 21,252
2023-05-30 483,869 490,959 7,091 6 3 9 21,367 5
2023-05-29 476,979 483,868 6,890 9 20,718
2023-05-28 469,867 476,978 7,112 9 21,372
2023-05-27 462,776 469,866 7,091 5 1 9 21,348 1
2023-05-26 455,825 462,775 6,951 2 1 9 20,915
2023-05-25 448,943 455,824 6,882 4 2 9 20,721
2023-05-24 441,908 448,942 7,035 9 21,153
2023-05-23 434,773 441,907 7,135 9 21,453
2023-05-22 427,728 434,772 7,045 9 21,183
2023-05-21 420,823 427,727 6,905 9 20,763
2023-05-20 413,889 420,822 6,934 9 20,850
2023-05-19 407,010 413,888 6,879 9 20,673
2023-05-18 400,394 407,009 6,616 9 19,899
2023-05-17 393,608 400,393 6,786 9 20,410 2
2023-05-16 386,752 393,607 6,856 9 20,616
2023-05-15 379,936 386,751 6,816 4 2 9 20,522
2023-05-14 373,229 379,935 6,707 9 20,169
2023-05-13 366,183 373,228 7,046 9 21,186
2023-05-12 359,025 366,182 7,158 9 21,522
2023-05-11 351,966 359,024 7,059 1 9 21,225
2023-05-10 344,915 351,965 7,051 8 21,201
2023-05-09 337,807 344,914 7,108 9 21,372
2023-05-08 330,870 337,806 6,937 9 20,859
2023-05-07 323,813 330,869 7,057 9 21,219
2023-05-06 316,752 323,812 7,061 9 21,231
2023-05-05 309,755 316,751 6,997 9 21,027
2023-05-04 302,712 309,754 7,043 9 21,177
2023-05-03 295,589 302,711 7,123 9 21,420
2023-05-02 288,527 295,588 7,062 9 21,234
2023-05-01 281,525 288,526 7,002 9 21,054

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.blocks2104`  
 where LAST_DAY(date(block_time)) = "2023-05-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

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

Active Accounts

Schema

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

Passive Accounts

Schema

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

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsnew2104` 
 where LAST_DAY(date(ts)) = "2023-05-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.balances2104` 
 where LAST_DAY(date(ts)) = "2023-05-31" 
 group by logDT 
 order by logDT

Events

Schema

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

Transfers:

Schema

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

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