Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 10.4 KB

2023-04-30.md

File metadata and controls

204 lines (157 loc) · 10.4 KB

polkadot Summary (Daily)

Source: polkadot.polkaholic.io

Relay Chain: polkadot Para ID: 0

Daily Summary for Month ending in 2023-04-30

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-04-30 15,309,453 15,323,836 14,384 6,624 3,862 1,493 843 1,092,876 627,470 5,768 ($10,670,876.42) 137 ($167,001.04) 132 ($181,116.32) 151 141
2023-04-29 15,295,075 15,309,452 14,378 6,685 3,912 1,478 828 1,092,611 621,925 5,761 ($13,155,204.49) 170 ($209,216.31) 165 ($212,448.61) 200 181
2023-04-28 15,280,679 15,295,074 14,396 7,420 4,126 1,531 927 1,092,448 630,396 6,261 ($23,573,690.10) 158 ($642,446.28) 177 ($339,153.70) 182 185
2023-04-27 15,266,283 15,280,678 14,396 7,816 4,246 1,445 773 1,092,081 641,588 6,625 ($41,967,031.21) 147 ($448,268.12) 147 ($626,609.31) 176 161
2023-04-26 15,251,887 15,266,282 14,396 8,153 4,563 1,584 746 1,091,720 645,990 7,394 ($34,627,821.71) 167 ($485,895.47) 183 ($559,225.67) 195 195
2023-04-25 15,237,499 15,251,886 14,388 7,114 4,073 1,282 731 1,091,524 614,849 5,935 ($24,017,721.50) 176 ($692,013.07) 208 ($600,074.10) 215 236
2023-04-24 15,223,104 15,237,498 14,395 7,133 4,229 1,434 753 1,091,222 625,242 6,236 ($33,908,779.36) 157 ($493,223.56) 145 ($596,831.40) 183 149
2023-04-23 15,208,708 15,223,103 14,396 6,934 4,003 1,412 714 1,091,007 610,703 6,017 ($26,439,966.48) 153 ($759,531.31) 160 ($500,383.40) 180 177
2023-04-22 15,194,340 15,208,707 14,368 6,740 3,701 1,479 685 1,090,927 623,655 6,011 ($14,262,775.16) 178 ($496,886.75) 184 ($363,067.18) 202 194
2023-04-21 15,179,968 15,194,339 14,372 7,912 4,195 1,678 729 1,090,607 624,709 7,147 ($44,125,339.80) 129 ($253,095.52) 256 ($533,635.49) 169 283
2023-04-20 15,165,576 15,179,967 14,392 7,692 4,256 1,535 782 1,090,302 633,040 6,863 ($55,241,433.89) 151 ($560,210.25) 191 ($192,006.18) 170 198
2023-04-19 15,151,185 15,165,575 14,391 8,854 4,831 1,708 957 1,089,979 632,836 7,680 ($94,498,313.25) 179 ($1,025,900.17) 196 ($303,759.02) 209 215
2023-04-18 15,136,791 15,151,184 14,394 8,320 4,754 1,693 1,006 1,089,523 638,159 7,138 ($28,075,627.84) 173 ($523,451.32) 121 ($183,048.89) 224 155
2023-04-17 15,122,393 15,136,790 14,398 8,363 4,747 1,716 958 1,089,071 647,652 7,342 ($36,309,195.24) 209 ($1,201,170.30) 183 ($259,869.74) 235 194
2023-04-16 15,107,995 15,122,392 14,398 7,959 4,510 1,743 1,047 1,088,740 644,250 6,796 ($26,839,494.03) 178 ($282,302.82) 150 ($477,582.51) 202 158
2023-04-15 15,093,600 15,107,994 14,395 8,158 4,595 1,605 940 800,042 648,703 7,093 ($22,625,581.80) 164 ($1,484,881.95) 224 ($659,265.90) 206 254
2023-04-14 15,079,207 15,093,599 14,393 9,660 5,474 1,851 1,122 1,087,797 656,027 8,597 ($39,291,281.42) 222 ($702,731.35) 171 ($372,012.25) 264 203
2023-04-13 15,064,824 15,079,206 14,383 8,366 4,777 1,726 952 1,087,332 647,010 7,174 ($21,336,863.30) 183 ($459,949.93) 200 ($1,401,124.43) 217 219
2023-04-12 15,050,439 15,064,823 14,385 7,902 4,429 1,584 875 1,086,905 646,974 6,833 ($77,393,057.75) 170 ($799,848.97) 158 ($342,010.93) 193 173
2023-04-11 15,036,043 15,050,438 14,396 9,017 5,054 1,746 1,013 1,086,509 660,722 7,740 ($34,169,714.24) 191 ($707,710.71) 177 ($500,035.32) 210 187
2023-04-10 15,021,645 15,036,042 14,398 7,699 4,516 1,561 895 1,086,118 642,192 6,596 ($22,173,355.02) 122 ($318,338.51) 165 ($358,052.67) 140 174
2023-04-09 15,007,248 15,021,644 14,397 6,283 3,735 1,341 801 1,085,700 628,554 5,442 ($10,597,190.69) 116 ($503,718.89) 129 ($213,738.96) 141 133
2023-04-08 14,992,873 15,007,247 14,375 6,227 3,619 1,469 856 1,085,324 626,209 5,441 ($10,113,042.27) 141 ($154,423.37) 176 ($369,153.34) 132 164
2023-04-07 14,978,480 14,992,872 14,393 8,922 5,345 1,560 1,143 1,084,863 656,577 7,997 ($34,821,389.75) 173 ($432,313.06) 191 ($483,378.98) 205 205
2023-04-06 14,964,096 14,978,479 14,384 7,580 4,314 1,577 904 1,084,473 636,857 6,567 ($21,495,816.48) 166 178
2023-04-05 14,949,703 14,964,095 14,393 7,788 4,466 1,739 986 1,084,027 643,713 6,754 ($44,572,721.29) 119 ($158,382.07) 136 ($207,827.08) 132 140
2023-04-04 14,935,309 14,949,702 14,394 7,948 4,527 1,728 1,031 1,083,522 646,036 7,262 ($29,789,554.47) 154 ($333,776.72) 176 ($154,556.83) 182 193
2023-04-03 14,920,911 14,935,308 14,398 8,187 4,635 1,809 1,027 1,082,926 647,169 7,320 ($41,697,355.14) 179 ($420,087.72) 185 ($317,540.64) 194 189
2023-04-02 14,906,514 14,920,910 14,397 7,951 4,456 1,684 1,040 1,082,344 643,817 7,073 ($16,845,831.85) 226 ($1,439,175.75) 199 ($778,381.50) 249 210
2023-04-01 14,892,125 14,906,513 14,389 7,492 4,250 1,722 997 1,081,738 641,116 6,649 ($21,321,277.24) 118 ($212,027.94) 121 ($68,640.43) 133 122

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.blocks0`  
 where LAST_DAY(date(block_time)) = "2023-04-30" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

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

Active Accounts

Schema

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

Passive Accounts

Schema

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

New Accounts

Schema

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

Events

Schema

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

Transfers:

Schema

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

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