Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 7.95 KB

2023-12-31.md

File metadata and controls

205 lines (158 loc) · 7.95 KB

manta Summary (Daily)

Source: manta.polkaholic.io

Relay Chain: polkadot Para ID: 2104

Daily Summary for Month ending in 2023-12-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-12-31 2,009,667 2,016,762 7,096 33 28,435
2023-12-30 2,002,535 2,009,666 7,132 33 28,576
2023-12-29 1,995,421 2,002,534 7,114 33 28,504
2023-12-28 1,988,301 1,995,420 7,120 33 28,528
2023-12-27 1,981,179 1,988,300 7,122 5 33 28,576 5
2023-12-26 1,974,048 1,981,178 7,131 1 33 28,580 1
2023-12-25 1,966,913 1,974,047 7,135 4 33 28,620
2023-12-24 1,959,781 1,966,912 7,132 33 28,580 1
2023-12-23 1,952,660 1,959,780 7,121 33 28,532
2023-12-22 1,945,567 1,952,659 7,093 9 33 28,492
2023-12-21 1,938,454 1,945,566 7,113 33 28,500
2023-12-20 1,931,318 1,938,453 7,136 33 28,592
2023-12-19 1,924,166 1,931,317 7,152 33 28,656
2023-12-18 1,917,016 1,924,165 7,150 33 28,636
2023-12-17 1,909,863 1,917,015 7,153 33 28,663
2023-12-16 1,902,707 1,909,862 7,156 33 28,672
2023-12-15 1,895,576 1,902,706 7,131 1 33 28,585
2023-12-14 1,888,422 1,895,575 7,154 13 33 28,773
2023-12-13 1,881,258 1,888,421 7,164 2 33 28,743 4
2023-12-12 1,874,083 1,881,257 7,175 29 28,748
2023-12-11 1,866,924 1,874,082 7,159 7 29 28,739 2
2023-12-10 1,859,774 1,866,923 7,150 28 28,640
2023-12-09 1,852,618 1,859,773 7,156 28 28,664
2023-12-08 1,845,461 1,852,617 7,157 28 28,668
2023-12-07 1,838,301 1,845,460 7,160 4 28 28,684 1
2023-12-06 1,831,140 1,838,300 7,161 4 28 28,684
2023-12-05 1,823,979 1,831,139 7,161 1 5 28 28,694
2023-12-04 1,816,823 1,823,978 7,156 4 28 28,664
2023-12-03 1,809,652 1,816,822 7,171 4 28 28,727
2023-12-02 1,802,481 1,809,651 7,171 4 28 28,724
2023-12-01 1,795,327 1,802,480 7,154 2 6 28 28,675

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

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