pcwcfa
MetricsDAO Live Course Badges
Mar 1, 2023 - Use this dashboard to see if you're one of the MetricsDAO badge holders. Alternatively, you also can use OpenSea.com to view your badge. It may be in your profile's -> more -> hidden folder.
Blockchain Analytics Course Segment 3 Dex Bounty Dashboard
Aug 20, 2022 - This dashboard addresses the questions posed in the BCA Course dex bounty if there are correlations in Uniswap-v2 and Sushiswap activities.
MetricsApp Stats
May 10, 2023 - Displays the MetricsApp marketplaces and challenges and the challenge submissions and their review scores.
Deep Dive on Polygon zkEVM and zkSync Era Wallet Populations
Jul 13, 2023 - Recall from the zkSync Era Bridge tab that there is a discrepancy between Flipside and Etherscan of ~26 ETH on 2023-07-22. This is a deep dive into the reason for the discrepancy. Short version: The difference is due to fees paid for bridging tokens (USDC for example) for ETH bridged in via third-party bridges. There is no data issue on either Flipside or Dune. Both are correctly showing direct user wallet interactions with the official zkSync Era Bridge, but the fees and third-party bridge-ins need to be accounted for separately using internal transactions.
Web3 Analytics 101 Cohort 4 Session 4 Dashboard
Feb 28, 2023 - Going beyond the EZ tables with use cases, background, techniques, and tables.
xMetrics Holders by Amount
Mar 8, 2023 - Shows the number of xMetrics holders by tier. Masters means >= 2000, thousandnaires >= 1000, and so on.
Avalanche Block and Transaction Performance
Jun 27, 2022 - This dashboard addresses the following queries: 1) Show the average TPS per second by the hour. 2) What's the average number of transactions per block? What's the max number of transactions we've seen in a block and the minimum? 3) Show the average time between blocks over time 4) Show transaction gas price over time. 5) Note any other interesting findings on the number of transactions, blocks, or gas for the Avalanche blockchain!