Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.11 KB

2024-05-31.md

File metadata and controls

205 lines (158 loc) · 8.11 KB

litentry Summary (Daily)

Source: litentry.polkaholic.io

Relay Chain: polkadot Para ID: 2013

Daily Summary for Month ending in 2024-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
2024-05-31 5,016,184 5,023,256 7,073 28 4,746 23,074 3
2024-05-30 5,009,096 5,016,183 7,088 31 4,745 23,161 3
2024-05-29 5,002,037 5,009,095 7,059 21 4,745 20,858 1
2024-05-28 4,994,908 5,002,036 7,129 28 4,745 23,248
2024-05-27 4,987,788 4,994,907 7,120 26 4,745 23,232
2024-05-26 4,980,713 4,987,787 7,075 41 4,745 23,248 8
2024-05-25 4,973,648 4,980,712 7,065 38 4,744 23,223 3
2024-05-24 4,966,743 4,973,647 6,905 21 4,744 22,767
2024-05-23 4,960,093 4,966,742 6,650 18 4,744 22,228
2024-05-22 4,953,307 4,960,092 6,786 30 4,744 22,588
2024-05-21 4,946,780 4,953,306 6,527 29 4,744 19,882 2
2024-05-20 4,939,684 4,946,779 7,096 34 4,742 23,279 1
2024-05-19 4,932,547 4,939,683 7,137 28 4,742 23,316 3
2024-05-18 4,925,450 4,932,546 7,097 31 4,742 23,264
2024-05-17 4,918,433 4,925,449 7,017 33 4,742 23,111 10
2024-05-16 4,911,400 4,918,432 7,033 42 4,741 23,209 3
2024-05-15 4,904,297 4,911,399 7,103 27 4,740 23,258 1
2024-05-14 4,897,431 4,904,296 6,866 16 4,740 22,691
2024-05-13 4,890,693 4,897,430 6,738 24 4,740 20,283
2024-05-12 4,883,967 4,890,692 6,726 29 4,740 22,501 2
2024-05-11 4,877,244 4,883,966 6,723 34 4,739 22,523
2024-05-10 4,870,536 4,877,243 6,708 33 4,738 22,473 3
2024-05-09 4,863,971 4,870,535 6,565 25 4,738 19,922 1
2024-05-08 4,857,192 4,863,970 6,779 33 4,737 22,612 3
2024-05-07 4,850,494 4,857,191 6,698 32 4,738 22,440 5
2024-05-06 4,843,566 4,850,493 6,928 37 4,738 22,929 2
2024-05-05 4,836,894 4,843,565 6,672 33 4,738 20,195 6
2024-05-04 4,830,212 4,836,893 6,682 41 4,738 22,446 3
2024-05-03 4,823,679 4,830,211 6,533 25 4,738 22,030 2
2024-05-02 4,816,886 4,823,678 6,793 37 4,738 20,440 2
2024-05-01 4,810,132 4,816,885 6,754 49 4,737 22,643 3

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.blocks2013`  
 where LAST_DAY(date(block_time)) = "2024-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.extrinsics2013`  
where signed and LAST_DAY(date(block_time)) = "2024-05-31" 
group by logDT 
order by logDT

Active Accounts

Schema

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

Passive Accounts

Schema

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

New Accounts

Schema

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

Events

Schema

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

Transfers:

Schema

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

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