Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.12 KB

2024-03-31.md

File metadata and controls

205 lines (158 loc) · 8.12 KB

litentry Summary (Daily)

Source: litentry.polkaholic.io

Relay Chain: polkadot Para ID: 2013

Daily Summary for Month ending in 2024-03-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-03-31 4,593,975 4,601,124 7,150 52 4,719 23,475 6
2024-03-30 4,586,826 4,593,974 7,149 52 4,719 23,494 11
2024-03-29 4,579,760 4,586,825 7,066 59 4,719 23,419 8
2024-03-28 4,572,904 4,579,759 6,856 34 4,719 22,796 9
2024-03-27 4,566,082 4,572,903 6,822 44 4,719 22,880 2
2024-03-26 4,559,226 4,566,081 6,856 56 4,719 20,842 4
2024-03-25 4,552,386 4,559,225 6,840 52 4,719 23,009 10
2024-03-24 4,545,535 4,552,385 6,851 47 4,715 23,012 2
2024-03-23 4,538,702 4,545,534 6,833 59 4,714 23,048 8
2024-03-22 4,531,846 4,538,701 6,856 41 4,711 22,913 1
2024-03-21 4,524,978 4,531,845 6,868 24 4,710 22,794
2024-03-20 4,518,203 4,524,977 6,775 50 4,710 20,581 5
2024-03-19 4,511,415 4,518,202 6,788 47 4,708 22,813
2024-03-18 4,504,535 4,511,414 6,880 62 4,708 23,100 4
2024-03-17 4,497,650 4,504,534 6,885 95 4,705 23,375 16
2024-03-16 4,490,729 4,497,649 6,921 54 4,704 23,085 1
2024-03-15 4,483,826 4,490,728 6,903 44 4,705 20,763 7
2024-03-14 4,476,918 4,483,825 6,908 60 4,707 23,134 5
2024-03-13 4,469,801 4,476,917 7,117 89 4,708 23,710 2
2024-03-12 4,462,700 4,469,800 7,101 52 4,708 23,377 6
2024-03-11 4,455,605 4,462,699 7,095 84 4,708 23,588 2
2024-03-10 4,448,624 4,455,604 6,981 67 4,708 23,233 12
2024-03-09 4,441,749 4,448,623 6,875 81 4,710 23,133 15
2024-03-08 4,434,856 4,441,748 6,893 83 4,716 23,177 12
2024-03-07 4,427,960 4,434,855 6,896 67 4,718 20,919 6
2024-03-06 4,421,110 4,427,959 6,850 47 4,718 22,917 5
2024-03-05 4,415,336 4,421,109 5,774 53 4,719 17,488 12
2024-03-04 4,411,407 4,415,335 3,929 51 4,719 12,454 1
2024-03-03 4,407,466 4,411,406 3,941 60 4,720 12,008 14
2024-03-02 4,402,941 4,407,465 4,525 63 4,718 14,062 3
2024-03-01 4,395,812 4,402,940 7,129 50 4,718 23,684 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-03-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-03-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-03-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-03-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-03-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-03-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-03-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-03-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-03-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-03-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-03-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-03-31" 
 group by logDT 
order by logDT

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