Introducing the Uniswap data extractor
The Uniswap data extractor allows anyone to download Uniswap's V3 historical data directly to Excel in just a few clicks. No need to be a data wizard or a subgraph expert, the new Uniswap data extractor now allows on-chain data to be easily queried. No technical experience required!!!
Go ahead and try it out -> https://www.uniswap.shippooor.xyz/
How does it work?
The Uniswap data extractor allows users to browse from multiple data sets such as Swaps, Position Snapshots, Daily Pool Data, and Uniswap Daily metrics.
Moreover, the extractor allows users to query data from every chain where Uniswap is deployed.
Users can then sort, filter, and extract that data directly to Excel. No complicated GraphQL queries, just a simple UI to produce rich analytics in an easy-to-manipulate format.
Let's look at an example where we want to query Uniswap's V3 historical daily trading volume on Ethereum. We first select Ethereum from the Chain drop-down list. We then select the Uniswap Day Data Dataset. We then click on the download as Excel button and there it is. It's as simple as that!
Let's run through a second example where we want to query every swap in the ETH/UNI pool over the last 10 days. Let's first select the Swaps dataset.
Then let's filter by the UNI/ETH 0.3% pool and select swaps that occurred in the last 10 days.
Finally, let's click on the Export to Excel button. There you go!
Looking for a specific hourly time series? Select your desired token and run a query from the Token Hour Data dataset.
Let's select the relevant token, let's say UNI.
The extractor allows users to query larger sets of data. In this case, we want to download the UNI hourly price time series since the launch of V3. The extractor has a LOAD ALL button allowing users to download all of the relevant data even if the displayed data on the UI stops after 1,000 entries.
Just wait for a few minutes for the subgraph to complete your query and export the resulting data to Excel.
For more advanced users the extractor can also be used as a query builder. The extractor can display subgraph queries directly in the UI by clicking on the View GraphQl Query button. Not only does this make the tool more useful it also makes the whole thing a lot more transparent.
We hope you will find the extractor useful. We're always happy to get some user feedback. Our Twitter DMs are open.
Thanks to the Uniswap Foundation for supporting our efforts in building this new tool. We're looking forward to continuing contributing to the Uniswap ecosystem and continue making on-chain data easily accessible to the masses. We hope this tool will help increase the number of crypto researchers and analysts contributing to the space.