PREVIEW / stock_5min / 2017-11-02

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-02.parquet
  size:    5.5 MB
  rows:    354,403
  symbols: 2,943

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2017-11-02 04:00:00	AAPL	Stock	41.7	41.7	41.7	41.7	400.0
2017-11-02 04:10:00	AAPL	Stock	41.72	41.72	41.72	41.72	400.0
2017-11-02 04:30:00	AAPL	Stock	41.7375	41.7375	41.7375	41.7375	400.0
2017-11-02 04:35:00	AAPL	Stock	41.7375	41.7375	41.7375	41.7375	928.0
2017-11-02 04:45:00	AAPL	Stock	41.7375	41.745	41.7375	41.745	2400.0
2017-11-02 04:55:00	AAPL	Stock	41.75	41.75	41.7375	41.7375	6016.0
2017-11-02 05:30:00	AAPL	Stock	41.7275	41.7275	41.7275	41.7275	400.0
2017-11-02 05:35:00	AAPL	Stock	41.6975	41.6975	41.6975	41.6975	400.0
2017-11-02 06:10:00	AAPL	Stock	41.7275	41.7375	41.7275	41.7375	1200.0
2017-11-02 06:25:00	AAPL	Stock	41.7425	41.745	41.7375	41.7375	2428.0
2017-11-02 06:30:00	AAPL	Stock	41.745	41.745	41.745	41.745	2988.0
2017-11-02 06:35:00	AAPL	Stock	41.78	41.78	41.7375	41.7375	1864.0
2017-11-02 06:40:00	AAPL	Stock	41.7425	41.7875	41.7425	41.775	5032.0
2017-11-02 06:45:00	AAPL	Stock	41.7875	41.7875	41.7875	41.7875	5744.0
2017-11-02 06:50:00	AAPL	Stock	41.7625	41.7625	41.6975	41.6975	11776.0
2017-11-02 06:55:00	AAPL	Stock	41.775	41.775	41.6975	41.705	5672.0
2017-11-02 07:00:00	AAPL	Stock	41.7625	41.775	41.6925	41.75	16808.0
2017-11-02 07:05:00	AAPL	Stock	41.775	41.775	41.7625	41.7625	4152.0
2017-11-02 07:10:00	AAPL	Stock	41.7625	41.7825	41.7625	41.775	12296.0
2017-11-02 07:15:00	AAPL	Stock	41.775	41.845	41.775	41.845	28592.0
2017-11-02 07:20:00	AAPL	Stock	41.8425	41.8425	41.815	41.815	8156.0
2017-11-02 07:25:00	AAPL	Stock	41.8175	41.825	41.81	41.825	19920.0
2017-11-02 07:30:00	AAPL	Stock	41.8225	41.83	41.8225	41.83	14088.0
2017-11-02 07:35:00	AAPL	Stock	41.83	41.905	41.83	41.905	42636.0
2017-11-02 07:40:00	AAPL	Stock	41.875	41.9	41.875	41.8975	8980.0
2017-11-02 07:45:00	AAPL	Stock	41.8975	41.9	41.8775	41.9	4560.0
2017-11-02 07:50:00	AAPL	Stock	41.8875	41.9	41.88	41.9	16456.0
2017-11-02 07:55:00	AAPL	Stock	41.9	41.975	41.9	41.9675	73772.0
2017-11-02 08:00:00	AAPL	Stock	41.775	41.975	41.725	41.9575	201916.0
2017-11-02 08:05:00	AAPL	Stock	41.95	41.9875	41.94	41.9875	23720.0
2017-11-02 08:10:00	AAPL	Stock	41.99	42.04	41.9825	42.0275	133184.0
2017-11-02 08:15:00	AAPL	Stock	42.0475	42.07	42.015	42.06	78356.0
2017-11-02 08:20:00	AAPL	Stock	42.0625	42.0625	42.03	42.0475	42780.0
2017-11-02 08:25:00	AAPL	Stock	42.0475	42.06	41.965	41.97	77588.0
2017-11-02 08:30:00	AAPL	Stock	41.975	42.0	41.945	41.945	70280.0
2017-11-02 08:35:00	AAPL	Stock	41.955	41.96	41.9025	41.905	80640.0
2017-11-02 08:40:00	AAPL	Stock	41.905	41.9225	41.87	41.9225	97184.0
2017-11-02 08:45:00	AAPL	Stock	41.88	41.9175	41.85	41.9175	90656.0
2017-11-02 08:50:00	AAPL	Stock	41.9175	41.9175	41.875	41.9125	16952.0
2017-11-02 08:55:00	AAPL	Stock	41.9125	41.92	41.9	41.9	19648.0
2017-11-02 09:00:00	AAPL	Stock	41.9	41.92	41.8875	41.89	21336.0
2017-11-02 09:05:00	AAPL	Stock	41.9	41.91	41.89	41.89	11460.0
2017-11-02 09:10:00	AAPL	Stock	41.91	41.91	41.8625	41.8625	38076.0
2017-11-02 09:15:00	AAPL	Stock	41.885	41.92	41.8625	41.92	39244.0
2017-11-02 09:20:00	AAPL	Stock	41.8875	41.92	41.8875	41.8925	34116.0
2017-11-02 09:25:00	AAPL	Stock	41.9125	41.9375	41.875	41.885	110304.0
2017-11-02 09:30:00	AAPL	Stock	41.895	41.9325	41.6925	41.705	3768148.0
2017-11-02 09:35:00	AAPL	Stock	41.7025	41.72	41.475	41.5525	2588980.0
2017-11-02 09:40:00	AAPL	Stock	41.5575	41.595	41.4925	41.5125	1648124.0
2017-11-02 09:45:00	AAPL	Stock	41.51	41.705	41.51	41.655	2261200.0

> showing 50 of 354,403 rows — these rows as CSV

> unlock the full archive -- $79 one-time