Dashboard Contents

• Total daily network fees

• Average network fee per transaction

• Average amount of fees paid by unique transacting addresses

• Master query from which all data and other queries are based

USD values are estimated. Block timestamps for txs and prices don't line up perfectly so everything is a close estimate.

Follow me on Twitter and check out my Medium

Tables and Schema

Tables Used

• Optimism
• Arbitrum
• Polygon
• Solana
• BSC
• Ethereum
• Avalanche

Schema Used

• .core.fact_hourly_token_prices
• .core.fact_transactions