Custom Event Tables with BigQuery
I previously wrote about how to use BigQuery to analyse Ethereum datasets. This is quick and easy for datasets that already have event tables thanks to the hard work of the Blockchain BigQuery team, but what if you want to analyse events that aren’t already broken out into their own tables? There is a global event table, bigquery-public-data.crypto_ethereum.logs, but event data is in its raw format there - not easy to query on. Fortunately, thanks to BigQuery’s support for user-defined functi...
Custom Event Tables with BigQuery
I previously wrote about how to use BigQuery to analyse Ethereum datasets. This is quick and easy for datasets that already have event tables thanks to the hard work of the Blockchain BigQuery team, but what if you want to analyse events that aren’t already broken out into their own tables? There is a global event table, bigquery-public-data.crypto_ethereum.logs, but event data is in its raw format there - not easy to query on. Fortunately, thanks to BigQuery’s support for user-defined functi...
A response to Vitalik's thoughts on ENS fee reform
Today, Vitalik published a thoughtful piece on ENS name registration fees, and mechanisms for making the namespace more sustainable in the long run. It makes some excellent points, and moves away from a simple Harberger Tax model to a more nuanced model that takes into account some essential demands of decentralised naming systems, such as the need for stability in how a name resolves. I will try and write up a more detailed response later, but for now I wanted to higlight a few points and de...
A response to Vitalik's thoughts on ENS fee reform
Today, Vitalik published a thoughtful piece on ENS name registration fees, and mechanisms for making the namespace more sustainable in the long run. It makes some excellent points, and moves away from a simple Harberger Tax model to a more nuanced model that takes into account some essential demands of decentralised naming systems, such as the need for stability in how a name resolves. I will try and write up a more detailed response later, but for now I wanted to higlight a few points and de...
Ethereum analytics with BigQuery
While Dune Analytics has rightly gotten a lot of positive attention recently for providing an easy-to-use platform for doing analytics over Ethereum datasets, you may not know that Google also provides a comprehensive dataset of Ethereum data on its large-scale analytics querying platform, BigQuery. Not only are the datasets comprehensive - even including a table of call execution traces for every Ethereum transaction - they also benefit from BigQuery’s distributed nature, meaning that even l...
Ethereum analytics with BigQuery
While Dune Analytics has rightly gotten a lot of positive attention recently for providing an easy-to-use platform for doing analytics over Ethereum datasets, you may not know that Google also provides a comprehensive dataset of Ethereum data on its large-scale analytics querying platform, BigQuery. Not only are the datasets comprehensive - even including a table of call execution traces for every Ethereum transaction - they also benefit from BigQuery’s distributed nature, meaning that even l...
