Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.79 KB

2024-04-30.md

File metadata and controls

204 lines (157 loc) · 8.79 KB

phala Summary (Daily)

Source: phala.polkaholic.io

Relay Chain: polkadot Para ID: 2035

Daily Summary for Month ending in 2024-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
2024-04-30 5,040,936 5,048,080 7,145 136,406 5,264 2,159,333 135,953 ($162,571.75)
2024-04-29 5,033,811 5,040,935 7,125 136,931 5,263 2,164,407 135,813 ($431,193.09)
2024-04-28 5,026,659 5,033,810 7,152 139,119 5,259 2,182,033 136,307 ($154,797.14)
2024-04-27 5,019,493 5,026,658 7,166 136,181 5,258 2,154,055 134,895 ($221,799.18)
2024-04-26 5,012,342 5,019,492 7,151 136,580 5,256 2,143,123 134,254 ($48,788.42)
2024-04-25 5,005,192 5,012,341 7,150 137,755 5,253 2,144,295 133,449 ($185,802.86)
2024-04-24 4,998,024 5,005,191 7,168 140,414 5,244 2,175,123 134,061 ($78,870.90)
2024-04-23 4,990,855 4,998,023 7,169 142,796 5,250 2,225,479 133,273 ($536,677.47)
2024-04-22 4,983,727 4,990,854 7,128 141,260 5,244 2,201,163 128,784 ($101,025.59)
2024-04-21 4,976,926 4,983,726 6,801 134,045 5,233 2,092,850 121,353 ($39,221.70)
2024-04-20 4,969,760 4,976,925 7,166 144,652 5,239 2,265,276 133,751 ($39,649.85)
2024-04-19 4,962,606 4,969,759 7,154 140,953 5,241 2,233,530 133,008 ($27,248.38)
2024-04-18 4,955,456 4,962,605 7,150 144,686 5,240 2,283,406 134,261 ($59,600.72)
2024-04-17 4,948,305 4,955,455 7,151 129,441 5,227 2,114,580 128,902 ($51,619.31)
2024-04-16 4,941,164 4,948,304 7,141 140,002 5,227 2,240,478 132,569 ($147,417.72)
2024-04-15 4,934,017 4,941,163 7,147 142,881 5,225 2,271,753 134,648 ($618,439.41)
2024-04-14 4,926,855 4,934,016 7,162 141,236 5,219 2,250,227 135,346 ($456,534.25)
2024-04-13 4,919,742 4,926,854 7,113 145,104 5,212 2,314,648 139,747 ($116,641.07)
2024-04-12 4,912,620 4,919,741 7,122 145,854 5,209 2,324,932 140,128 ($215,147.77)
2024-04-11 4,905,464 4,912,619 7,156 147,024 5,202 2,345,751 141,382 ($39,368.89)
2024-04-10 4,898,313 4,905,463 7,151 147,059 5,197 2,344,848 141,556 ($416,331.24)
2024-04-09 4,891,153 4,898,312 7,160 147,953 5,188 2,358,660 142,120 ($168,669.02)
2024-04-08 4,883,994 4,891,152 7,159 146,788 5,186 2,339,532 140,750 ($529,820.33)
2024-04-07 4,876,858 4,883,993 7,136 143,944 5,186 2,319,150 141,594 ($352,605.59)
2024-04-06 4,869,704 4,876,857 7,154 140,954 5,184 2,299,411 142,155 ($100,794.14)
2024-04-05 4,862,595 4,869,703 7,109 139,076 5,181 2,271,415 140,267 ($56,091.40)
2024-04-04 4,855,449 4,862,594 7,146 140,293 5,180 2,288,881 141,554 ($399,549.35)
2024-04-03 4,848,305 4,855,448 7,144 139,468 5,171 2,280,215 140,848 ($124,670.20)
2024-04-02 4,841,163 4,848,304 7,142 139,131 5,170 2,275,031 140,877 ($198,566.27)
2024-04-01 4,834,015 4,841,162 7,148 139,533 5,168 2,280,698 141,009 ($271,481.11)

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.blocks2035`  
 where LAST_DAY(date(block_time)) = "2024-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.extrinsics2035`  
where signed and LAST_DAY(date(block_time)) = "2024-04-30" 
group by logDT 
order by logDT

Active Accounts

Schema

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

Passive Accounts

Schema

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

New Accounts

Schema

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

Events

Schema

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

Transfers:

Schema

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

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