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

mondov