ethereum-burn-stats icon indicating copy to clipboard operation
ethereum-burn-stats copied to clipboard

Set last block for `base fee` histogram

Open greg7mdp opened this issue 2 years ago • 1 comments

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?

greg7mdp avatar May 01 '22 14:05 greg7mdp

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

mohamedmansour avatar May 03 '22 18:05 mohamedmansour