This very unofficial API provides access to snapshots of Alkimi Exchange transaction totals stored in two MySQL tables: `5min_data` and `daily_data`.
It is a temporary solution while the official API is finished and was primarily for entries into the Worm Hackathon giveaway Thomas ran.
The data is loaded into these tables by regular scraping and manual inputs so may be less reliable than ideal. It is made available until the official Ads Explorers API is available.
NB: There are occasional gaps in the 5 minute data.
`GET`
Base URL: https://arena.alkimist.xyz/TX/api.php
| Parameter | Description | Possible Values | Default Value |
| — | — | — | — |
| `format` | Response format | `json`, `csv`, `min` | `json` |
| `table` | Table to query | `5min_data`, `daily_data` | `daily_data` |
| `startDate` | Start date for data retrieval (YYYY-MM-DD) | Any valid date | None |
| `endDate` | End date for data retrieval (YYYY-MM-DD) | Any valid date | None |
| `fields` | Comma-separated list of additional fields to include | Any valid column names from the selected table | None (all fields) |
| `latest` | Retrieve only the latest data point | `true`, `false` | `false` |
| `latestTotal` | Retrieve only the latest total transactions | `true`, `false` | `false` |
| `latest-since-midnight` | Retrieve only tx since midnight GMT | `true`, `false` | `false` |
| `day-of-prices` | Retrieve a full 24h of price data | `yes`, `no` | `no` |
| `revenue-estimate` | Calculate a revenue estimate based on the tx in the row. Also requires values for `slot`, `CPM`, `fee` | `yes`, `no` | `no` |
| `api-key` | Required to access data | Request from thomas | none |
The API returns data in the specified format (`json`, `csv`, `min`).
If no data is found for the given parameters, the API will return an error message in the requested format.
| Column | Data Type | Description |
| — | — | — |
| `Date` | date | Date of the data |
| `Total TX` | int | Total transactions for the day |
| `Daily TPS` | decimal(10,2) | Average transactions per second for the day |
| `3 Day MA` | decimal(10,2) | 3-day moving average of total transactions |
| `7 Day MA` | decimal(10,2) | 7-day moving average of total transactions |
| `14 Day MA` | decimal(10,2) | 14-day moving average of total transactions |
| `Change` | decimal(5,2) | Percentage change in total transactions from the previous day |
| `price` | decimal(15,15) | $ADS price as of the close of that day, from CMC. |
| Column | Data Type | Description |
| — | — | — |
| `total` | decimal(10,2) | Accumulated total transactions for the day |
| `timestamp` | datetime | Timestamp of the data |
| `TPS` | decimal(10,2) | Transactions per second in the last 5 minutes |
| `daily_prediction` | decimal(10,2) | Predicted total transactions for the day |
| `transactions` | int | Number of transactions in the last 5 minutes |
| `20_minute_MA` | decimal(10,2) | 20-minute moving average of transactions |
| `1_hour_MA` | decimal(10,2) | 1-hour moving average of transactions |
| `3_hour_MA` | decimal(10,2) | 3-hour moving average of transactions |
| `price` | decimal(15,15) | $ADS price as of the snapshot, from CMC. |