Exporting account transactions as a CSV file

Velas is an AI-powered delegated Proof-of-Stake (AIDPOS) which claims to have the capacity to process 50k+ t/ps without giving way to security or decentralization applications. It is a project that combines blockchain and innovative AI technologies to create a transparent, community driven, and decentralized ecosystem of product and services.

In this tutorial, we’ll take a look at how we can export account transactions and other details as a CSV file using Bitquery.

First of all, to get started, sign up on our Blockchain IDE and get you API keys. Then you can proceed to using Bitquery’s GraphQL IDE to get all your required data in the form of a CSV file.

To get started, let’s consider the details related to Velas blocks and try to extract them.

When you run the query in Bitquery’s GraphQL IDE, you can see the a drop down option against the word Ethereum in the lower section of the screen.

1

Upon clicking on the dropdown button, you need to select “Ethereum.blocks” and then moving towards the right, under the Using tab you need to select Table widget from the dropdown menu.

Picture2

Using the plus sign at the bottom of the scree you can add the columns that you would like to have in your CSV file. For this example, we’ll be adding the height, transaction count and reward currency symbol.

Picture3

Clicking on the CSV button you can download the CSV file easily.

You can add or delete columns as per your own convenience in the file and get the required data in the CSV format.

You can get the above query using the following link

Let’s consider another example in which we’ll try to get the table for transfers.
Here we’ve taken six columns, namely the timestamp, amount, currency symbol, currency address, sender’s address and receiver’s address .

Picture4

For the display, we have chosen Ethereum.transfers from the dropdown menu here and under the Using tab, we have opted for the Table Widget. After clicking on the view button we get the following CSV file.

Picture5

You can even change the view to JSON to get the results of your query in case you don’t need a CSV file.

Picture6

This is how easily you can get all your desired information in the form of a downloadable CSV file.

Conclusion

From this tutorial, you must’ve got an idea about how Bitquery simplifies the process of extracting the data from the blockchain network and store it in CSV format conveniently. Let’s quickly walk through the steps that need to be followed for extracting data in CSV format.

  1. Sign up/ Log in onto the Bitquery’s GraphQL IDE

  2. Run your Velas blockchain network related query

  3. Under the Display tab’s dropdown menu in the lower section of the page, select the field whose data you want as such: ethereum.feild
    For eg. If you want to query about the transactions, under the Display tab’s dropdown menu you’ll choose “ethereum.transaction”

  4. Then under the Using tab, you’ll select the “Table Widget”

  5. Then you Click on View and run the query to get the CSV file.

  6. Once the CSV file is displayed, you can download it by clicking on the CSV button at the bottom left corner of the window.

Also Read

About Bitquery

Bitquery is a set of software tools that parse, index, access, search, and use information across blockchain networks in a unified way. We are crossing the ‘chain-chasm’ by delivering set of products that can work across blockchains. Our products include:

Coinpath APIs provide blockchain money flow analysis for more than 24 blockchains. With Coinpath’s APIs, you can monitor blockchain transactions, investigate crypto crimes such as bitcoin money laundering, and create crypto forensics tools. You can refer to this article to get started with Coinpath

Digital Assets API provides index information related to all major cryptocurrencies, coins, and tokens.

DEX API provides real-time deposits and transactions, trades, and other related data on different DEX protocols like Uniswap, SushiSawap, Kyber Network, Airswap, Matching Network, etc.

If you have any questions about our products, ask them on our Telegram channel or email us at hello@bitquery.io . Also, subscribe to our newsletter and stay updated about the latest in the cryptocurrency world.