ethereum-burn-stats
ethereum-burn-stats copied to clipboard
Set last block for `base fee` histogram
Currently the web site displays the fees (base + priority) for a number of blocks up to the current one. Is it possible to see the fees up to a specific block?
I'm asking this because I saw something really interesting last night, but unfortunately I didn't take a screenshot and now I don't have a way to get back to it.
Would it be possible to provide a last block in the url, such as https://watchtheburn.com?last_block=14689112
?
I don't have a historical snapshot in the UI, if you are comfortable with SQLite, to unblock you, I can share the DB, it is: https://wormhole.app/x5d5A#4wzZ-OlXcttgS8WeqZb4IQ
If you want more tooling than SQLite, you can migrate it to PostgreSQL (because it supports big numbers) with this script https://github.com/mohamedmansour/ethereum-burn-stats/tree/main/migration
And do aggregations/selects/etc.
The db basically has all the replay actions:
number INTEGER PRIMARY KEY,
timestamp INTEGER,
base_fee NUMERIC(256),
burned NUMERIC(256),
gas_target INTEGER,
gas_used INTEGER,
gas_used_percentage INTEGER,
priority_fee NUMERIC(256),
rewards NUMERIC(256),
tips NUMERIC(256),
transactions INTEGER,
type2_transactions INTEGER