Methodology

For this dashboard, multiple flipside schemas and tables were used:

To analyze uniswap metrics, the table crosschain.ez_dex_swaps was helpful as it provided us with all swaps across all chains neccessary (except for blast). To get the metrics for blast, we used the table blast.core.fact_transactions in combination with blast.core.dim_labels and blast.core.dim_contracts to identify transactions to Uniswap contracts and other DEX's contracts.
When comparing with all transactions on chains, the table crosschain.stats.ez_core_metrics_hourly came in handy as it includes the metrics about succeful transactions and number of users.
When calculating the amount of ETH burnt, the block_header_json:baseFeePerGas from ethereum.core.fact_blocks provided us with base fee, which we used to calculate ETH burnt by different DEXs and sectors. (ethereum.core.dim_labels, ethereum.core.dim_contracts to get the sectors, dexs)
Whenever the price data was needed, the table crosschain.price.ez_prices_hourly was used

Dashboard	Creator	Published
Uniswap Market Share and Fees Jun 5, 2024	mondov	Jun 5, 2024
Uniswap on Layer 2s Nov 10, 2023	mondov	Nov 10, 2023
BaseSwap vs other DEXes on Base Oct 23, 2023	mondov	Oct 23, 2023

mondov