-
Notifications
You must be signed in to change notification settings - Fork 6
/
bot.sql
84 lines (73 loc) · 2.51 KB
/
bot.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
PRAGMA auto_vacuum = INCREMENTAL;
CREATE TABLE IF NOT EXISTS candlesticks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
exchange VARCHAR(255) NULL,
symbol VARCHAR(255) NULL,
period VARCHAR(255) NULL,
time INTEGER NULL,
open REAL NULL,
high REAL NULL,
low REAL NULL,
close REAL NULL,
volume REAL NULL
);
CREATE UNIQUE INDEX unique_candle
ON candlesticks (exchange, symbol, period, time);
CREATE INDEX time_idx ON candlesticks (time);
CREATE INDEX exchange_symbol_idx ON candlesticks (exchange, symbol);
CREATE TABLE IF NOT EXISTS candlesticks_log (
id INTEGER PRIMARY KEY AUTOINCREMENT,
income_at BIGINT NULL,
exchange VARCHAR(255) NULL,
symbol VARCHAR(255) NULL,
period VARCHAR(255) NULL,
time INTEGER NULL,
open REAL NULL,
high REAL NULL,
low REAL NULL,
close REAL NULL,
volume REAL NULL
);
CREATE INDEX candle_idx ON candlesticks_log (exchange, symbol, period, time);
CREATE TABLE IF NOT EXISTS ticker (
id INTEGER PRIMARY KEY AUTOINCREMENT,
exchange VARCHAR(255) NULL,
symbol VARCHAR(255) NULL,
ask REAL NULL,
bid REAL NULL,
updated_at INT NULL
);
CREATE UNIQUE INDEX ticker_unique
ON ticker (exchange, symbol);
CREATE TABLE IF NOT EXISTS ticker_log (
id INTEGER PRIMARY KEY AUTOINCREMENT,
exchange VARCHAR(255) NULL,
symbol VARCHAR(255) NULL,
ask REAL NULL,
bid REAL NULL,
income_at BIGINT NULL
);
CREATE INDEX ticker_log_idx ON ticker_log (exchange, symbol);
CREATE INDEX ticker_log_time_idx ON ticker_log (exchange, symbol, income_at);
CREATE TABLE IF NOT EXISTS signals (
id INTEGER PRIMARY KEY AUTOINCREMENT,
exchange VARCHAR(255) NULL,
symbol VARCHAR(255) NULL,
ask REAL NULL,
bid REAL NULL,
options TEXT NULL,
side VARCHAR(50) NULL,
strategy VARCHAR(50) NULL,
income_at BIGINT NULL,
state VARCHAR(50) NULL
);
CREATE INDEX symbol_idx ON signals (exchange, symbol);
CREATE TABLE IF NOT EXISTS logs (
uuid VARCHAR(64) PRIMARY KEY,
level VARCHAR(32) NOT NULL,
message TEXT NULL,
created_at INT NOT NULL
);
CREATE INDEX created_at_idx ON logs (created_at);
CREATE INDEX level_created_at_idx ON logs (level, created_at);
CREATE INDEX level_idx ON logs (level);