Ethereum ETL

Ethereum transaction traces are now available in BigQuery. Read my article on how to query balances for all Ethereum addresses @medvedev1088/how-to-query-balances-for-all-ethereum-addresses-in-bigquery-fb594e4034a7" target="_blank" rel="nofollow noopener">medium.com/@medvedev1088/…

Lastly, a special shoutout to community tools like @AlchemyPlatform and @EthereumETL that do all of the heavy lifting that makes this type of data extraction possible.

Yes, Nansen is HIRING! All the positions are remote. We have a globally distributed team. Apply to Site Reliability Engineer (Engineering) grnh.se/276f64594us via @greenhouse or ape into our application process!

I've noticed that a lot of people are unaware of the excellent BigQuery datasets that are available for analysing Ethereum data courtesy of @EthereumETL - so I've written an explainer post about how to use them: mirror.xyz/nick.eth/INhEm…

@iamwil I used @EthereumETL on Google BigQuery.

We're excited to announce that Nansen has raised a $12 million Series A round led by @a16z! Read the announcement below: nansen.ai/post/nansen-ra…

🚀🚀🚀🚀🚀

First green scaling solution for $ETH added to the @googlecloud crypto datasets. I'm looking forward to seeing many energy-efficient, cloud-enabled Dapps built on this integration! Well done @HelixTech_xyz @0xPolygon @EvgeMedvedev

Polygon data available in Google BigQuery coindesk.com/google-cloud-n…

We've made @0xPolygon data available on @googlecloud BigQuery 🥳 decrypt.co/72203/googles-…

Blockchain analytics for @0xPolygon, an Ethereum scaling solution, have arrived on @Google's Cloud platform. @JamieCrawleyCD reports trib.al/vbNSCLP

Nansen subscribers can now claim a small gift from us and our friends at @0xPolygon 🎁 Just log in to your dashboard: pro.nansen.ai ... and look for this button:

1000 stars on our GitHub repository github.com/blockchain-etl… 🎉

@ASvanevik @EthereumETL Pool events have been added too: SELECT * FROM `blockchain-etl.ethereum_uniswap.UniswapV3Pool_event_Mint`

@ASvanevik @EthereumETL Swaps too: SELECT * FROM `blockchain-etl.ethereum_uniswap.UniswapV3Pool_event_Swap`

Check out @Uniswap V3 in BigQuery: SELECT * FROM `blockchain-etl.ethereum_uniswap.UniswapV3Factory_event_PoolCreated`

4/ My updated approve() price checker script is here, using amazing @EthereumETL data set. gist.github.com/miohtama/3e618…

Check out the explainer article with ERP diagrams for the Ethereum dataset in BigQuery from Rif rifkiamil.medium.com/full-relationa…

#Ethereum has a lot more data structures then #Bitcoin, so I thought it might help see a diagram of all the tables. Examples coming soon for Eth Internal Transaction rifkiamil.medium.com/simplified-rel… Thank you @GCPcloud @BlockchainETL @EthereumETL for supporting #opensource & #opendata

More 🚨 Advanced Smart Alerts are coming: - Hot Contracts 🔥 - DEX Markets 📈 - Gas Prices ⛽ - ETH2 Alerts Ξ Subscribe to nansen.ai to get access to these new features.