Persistence Layer

[byte-bandit]

Background

The database should contain historic and live price data information on token/GRAIN pairs, so that the following information can ultimately be constructed upon request, fulfilling the Datafeed API:

⏰ Estimate: 2 days

Search Symbols

[
    {
        "symbol": "<short symbol name>",
        "description": "<symbol description>",
        "exchange": "<symbol exchange name>",
        "ticker": "<symbol ticker name>",
        "type": "stock"
    },
]

Resolve symbol

{
    ticker: 'BTCUSD',
    name: 'BTCUSD',
    description: 'Bitcoin/USD',
    type: symbolItem.type,
    session: '24x7',
    timezone: 'Etc/UTC',
    exchange: 'Example Exchange',
    minmov: 1,
    pricescale: 100,
    has_intraday: false,
    visible_plots_set: 'ohlcv',
    has_weekly_and_monthly: false,
    supported_resolutions: ['1', '5', '30', '60', '1D', '1W'],
    volume_precision: 2,
    data_status: 'streaming',
}

Get Bars

{
  open: price,
  high: price,
  low: price,
  close: price,
  time: time.getTime(),
}

Done when

• A db schema is defined the allows speedy on-demand query and construction of all information outlined above
• SQL migrations are written and tested

Notes

• A lot of the information can likely be hard-coded and won't need to be stored with the token
• One table of token definitions, one table of historic price data?