set search_path to stoxnet;
create table quote (
    id serial primary key,
    company_id integer,
    name varchar(50),
    symbol varchar(10),
    last_price float,
    turnover float,
    quantity integer,
    internal_turnover float,
    internal_quantity integer,
    open_price float,
    bid_price float,
    ask_price float,
    day_low_price float,
    day_high_price float,
    close_price float,
    change_percent float,
    change_percent_1m float,
    tick_size integer,
    sector_index integer,
    market_cap_category integer,
    marketvalue float,
    date_time timestamp,
    close_date_time timestamp,
    created timestamp);

