Quickstart

A quick introduction to using the Developer API

Data Caveats

  • SQL: Our Explorer data is powered by Snowflake SQL.

  • Timestamps: All timestamps are in Coordinated Universal Time (UTC).

  • Prices: All prices-related data are in USD denomination unless otherwise stated

  • Address Casing: All EVM addresses are in lower casing.

  • Native token: Native tokens are presented by zero address for the respective chain. E.g for Ethereum and most EVM chains: 0x0000000000000000000000000000000000000000, Tron: T9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwb

TL;DR

  1. Run the following to get started quickly, run your query and retrieve the results:

run.py
import requests

response = requests.post(
    "https://api.allium.so/api/v1/developer/ethereum/sql/",
    headers={"X-API-Key": "APIKEY_12345"},
    json={"query": "select * from ethereum.blocks limit 100"},
)

print(response.json())
  1. Done🎉🎉🎉! Results should appear in the response as a JSON

[
    {
        "timestamp": "2023-02-06T02:05:47",
        "number": 16566648,
        "hash": "0x95366ab75e5bb4e519c2cdc300aa59057fd70eefe70e85ae74ef39dbf0e7465f",
        "parent_hash": "0xeb3562a07e055cd3657c4968142cdb6f1cb17b9e9bd6872b8506deab9364c612",
        "nonce": "0x0000000000000000",
        "sha3_uncles": "0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347",
        "logs_bloom": "0x0aa33cca8ca490e219601315f3110a2f380086409c8f1b3088f90033d4032bd552194d9a8af0b8914cc0d3d0dab1a56aa30bc6729e862d8c771194f15cbea23693a95504bd80bc2e695263ec0135502820c1702757cc0ea225112fd7cee938591f8680661ae2460ab8a49221c3b29865850010a81c1b1ea146128c5149dab17cfd5396d63ba2011e24cd1768e932ea06630214810308895b68668a410a120024de8905181e847be5aa0064cc8c03ac282e18655c6328a2027b635b32a06db3544b18747333131862082118a08e93809766c1aac69be818f4468c482f72c2f0670271fc7838e2a09aac2d05a5246055481d4440278c78204889b7aa5998d3bdf9",
        "transactions_root": "0x4f82ecaf8372b41978c5a55f20c49c7917ddf29cba7ca8f53e7af0b808f2aa2b",
        "state_root": "0x79d4ad6284316b59310c7ce4b81c3b3088cb8aba2bfb32f139c4513bc5e5ea7e",
        "receipts_root": "0x50222328e45eb5df8974a7f98691268dec57342dbe0fa9b35a7c7c4da09c3881",
        "miner": "0x690b9a9e9aa1c9db991c7721a92d351db4fac990",
        "difficulty": 0,
        "total_difficulty": 5.875000371659836e+22,
        "size": 62219,
        "extra_data": "0x406275696c64657230783639",
        "gas_limit": 30000000,
        "gas_used": 12252816,
        "transaction_count": 121,
        "base_fee_per_gas": 16491874515,
        "_created_at": null,
        "_updated_at": null
    },
    {
        "timestamp": "2023-02-06T02:05:11",
        "number": 16566645,
        "hash": "0x10ef85e873a1c64fcda73de7df45d9ac1ad481905140e2786e5a809e512fb0e7",
        "parent_hash": "0x4f3316d717a05c6180d14ad9cf4264d848a993f37e37b88137ddb833788cfc5c",
        "nonce": "0x0000000000000000",
        "sha3_uncles": "0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347",
        "logs_bloom": "0x2cfb886b8110d860691e3caab455c5a94a84053d8c430e09c03f24a6dee3d5041387a677ac43139939462e505bc5699f8f0f33689a86fc6ede39f69b107ea619df39519dd191ecb97f1b52d8c577183da8b6b17c5ff51a51a2abb8ab8bfdfcb8eb54084cc65fd5f2bdd93f6a04fbf9fd8f4f08cb4d185e6b0b0105f31cfecec81ed1db4e9b672fbe75cf7d7a2b9f9c257fccb499e1817c5e4f13297761bab0a3de8d019771eb7ce239825dbc2dc3a4f78e5c0c1ffa3effa6c3ed07569c593dcbc7be31c6bb3a0f7820834caa0e035733cc5547fb37ebe17116e81d2b7e12f61e8797f0de32b87f242a27bd1c75070b9e1fb832efbdefc8f8ae67e8f0e135ecab",
        "transactions_root": "0x7244a7edd518c848178a01cd3738e3fdb427d6da169364b932628f75b974a3c8",
        "state_root": "0xb98236186b2d639dc05beb44a5b4f26587ddd8d42bf5af8a652d5ad5ab4252f7",
        "receipts_root": "0x3afabed06e28f5090884401a0458bf186feae7286f9e8d1af6b3987f1b688e89",
        "miner": "0x5f525f637759fca7c9d1c0c4f9d479d6e8d8cef5",
        "difficulty": 0,
        "total_difficulty": 5.875000371659836e+22,
        "size": 168292,
        "extra_data": "0xd883010a1a846765746888676f312e31392e34856c696e7578",
        "gas_limit": 30000000,
        "gas_used": 20480025,
        "transaction_count": 180,
        "base_fee_per_gas": 15256260037,
        "_created_at": null,
        "_updated_at": null
    }
]

Last updated