1) Go to https://account.anyblock.tools/auth/login/ and sign up for a free account.
2) You will receive an API key and SQL username/password.
Your API key is used to replace $mytoken
in standard queries.
Queries to the xDai chain use the xdai eth.events endpoint: https://api.eth.events/ethereum/xdai/mainnet/es/
Example Queries are located here: https://www.anyblockanalytics.com/docs/elastic/example-queries/
Documentation regarding ElasticSearch API calls is available here: https://www.anyblockanalytics.com/docs/elastic
For example, this curl query will show us data about the last 2 blocks.
curl -X POST \https://api.eth.events/ethereum/xdai/mainnet/es/block/search/ \-H 'Authorization: Bearer $mytoken' \-H 'Content-Type: application/json' \-d '{"sort": {"number.num": "desc"},"size": 2}'
1) Download a SQL client Anyblock Analytics favors PGAdmin4
2) Click on Server -> Create -> Server
3) In the General Tab, choose a Name for your server instance
4) Go to the Connection Tab, and fill in the information from your AnyBlock Analytics Account and click Save:
| |
Host name.address | sql.anyblock.tools |
Port | 45432 |
Maintenance database | ethereum_ethereum_mainnet (or another db from the list) |
Username | <your_username> |
Password | <your_password> |
5) You will see a list of all databases.
Click on ethereum_poa_xdai to interact with xDai data.
To Query the DB, go to Tools -> Query Tool
6) Try a Query!
Check you are in the xDai database
Enter your Query (this query shows info about the most recent block)
Click the lighting icon to execute
Output from query
7) Explore different queries and information in the SQL documentation and tutorials available here: https://www.anyblockanalytics.com/blog/basic-sql-usage-examples/
Example Query to find transactions for the EternalStorageProxy token contract
SELECT * FROM txWHERE tx.to = '0x7301CFA0e1756B71869E93d4e4Dca5c7d0eb0AA6'LIMIT 50