Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.02 KB

2023-08-31.md

File metadata and controls

205 lines (158 loc) · 8.02 KB

manta Summary (Daily)

Source: manta.polkaholic.io

Relay Chain: polkadot Para ID: 2104

Daily Summary for Month ending in 2023-08-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-08-31 1,141,396 1,148,468 7,073 8 7 25 28,447 1 ($0.29) 8 ($0.34) 5 7
2023-08-30 1,134,291 1,141,395 7,105 21 6 25 28,747 4 ($0.35) 20 ($0.21) 15 22
2023-08-29 1,127,126 1,134,290 7,165 5 26 28,708
2023-08-28 1,119,997 1,127,125 7,129 25 8 1 26 28,798 3 1
2023-08-27 1,112,824 1,119,996 7,173 17 6 1 25 28,919 1 1 ($0.20) 2 ($0.04) 2 6
2023-08-26 1,105,688 1,112,823 7,136 5 25 28,595
2023-08-25 1,098,743 1,105,687 6,945 5 25 27,828
2023-08-24 1,091,606 1,098,742 7,137 5 25 28,596
2023-08-23 1,084,430 1,091,605 7,176 1 6 25 28,762 1
2023-08-22 1,077,246 1,084,429 7,184 5 25 28,784
2023-08-21 1,070,137 1,077,245 7,109 5 25 28,487 1
2023-08-20 1,062,969 1,070,136 7,168 5 25 28,720
2023-08-19 1,055,795 1,062,968 7,174 5 25 28,744
2023-08-18 1,048,619 1,055,794 7,176 4 8 25 28,801 3 4
2023-08-17 1,041,444 1,048,618 7,175 5 25 28,748
2023-08-16 1,034,278 1,041,443 7,166 5 25 28,712
2023-08-15 1,027,120 1,034,277 7,158 5 25 28,680
2023-08-14 1,019,973 1,027,119 7,147 2 7 1 25 28,673 1 5 1
2023-08-13 1,012,801 1,019,972 7,172 5 24 28,736
2023-08-12 1,005,635 1,012,800 7,166 5 24 28,715
2023-08-11 998,538 1,005,634 7,097 1 6 24 28,452 2 1
2023-08-10 991,367 998,537 7,171 7 6 24 28,820 6 6 7
2023-08-09 984,191 991,366 7,176 2 6 24 28,775 1 2
2023-08-08 977,013 984,190 7,178 2 6 24 28,796 6 2
2023-08-07 969,829 977,012 7,184 7 7 1 24 28,856 1 3 1 6
2023-08-06 962,653 969,828 7,176 5 23 28,752
2023-08-05 955,474 962,652 7,179 5 23 28,764
2023-08-04 948,288 955,473 7,186 5 8 23 28,869 1 ($0.04) 1
2023-08-03 941,135 948,287 7,153 5 23 28,667 2
2023-08-02 933,959 941,134 7,176 5 23 28,752
2023-08-01 926,801 933,958 7,158 5 23 28,687

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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-31" 
 group by logDT 
order by logDT

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