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
|
---
--- We need to run some tests where we don't provide for the schema within
--- the pgloader command itself, so we prepare the schema "manually" here in
--- advance.
---
drop table if exists intf_derivatives, intf_stocks;
create table intf_stocks
(
ticker text,
quote_date date,
open numeric,
high numeric,
low numeric,
close numeric,
volume bigint
);
create table intf_derivatives
(
ticker text,
quote_date date,
open numeric,
high numeric,
low numeric,
close numeric,
volume bigint,
openint bigint
);
|
