PREVIEW / stock_5min / 2017-03-02

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-02.parquet
  size:    5.5 MB
  rows:    355,916
  symbols: 3,093

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-03-02 04:00:00	AAPL	Stock	35.0	35.0	35.0	35.0	800.0
2017-03-02 04:05:00	AAPL	Stock	34.9875	34.9875	34.9875	34.9875	1200.0
2017-03-02 04:10:00	AAPL	Stock	34.9525	34.9525	34.9475	34.9475	1472.0
2017-03-02 04:15:00	AAPL	Stock	34.9625	34.9625	34.9625	34.9625	400.0
2017-03-02 04:45:00	AAPL	Stock	34.9375	34.9375	34.9375	34.9375	400.0
2017-03-02 04:55:00	AAPL	Stock	34.89	34.89	34.89	34.89	656.0
2017-03-02 05:00:00	AAPL	Stock	34.8875	34.8875	34.8875	34.8875	512.0
2017-03-02 05:25:00	AAPL	Stock	34.95	34.95	34.95	34.95	1376.0
2017-03-02 05:35:00	AAPL	Stock	34.9675	34.9675	34.9675	34.9675	400.0
2017-03-02 05:40:00	AAPL	Stock	34.9675	34.975	34.9675	34.975	1776.0
2017-03-02 05:55:00	AAPL	Stock	34.95	34.95	34.95	34.95	1188.0
2017-03-02 06:05:00	AAPL	Stock	34.92	34.9575	34.92	34.9575	14412.0
2017-03-02 06:10:00	AAPL	Stock	34.9275	34.9275	34.9275	34.9275	1200.0
2017-03-02 06:15:00	AAPL	Stock	34.95	34.95	34.95	34.95	400.0
2017-03-02 06:40:00	AAPL	Stock	34.9075	34.9075	34.9075	34.9075	492.0
2017-03-02 06:50:00	AAPL	Stock	34.9475	34.95	34.9475	34.95	2800.0
2017-03-02 07:00:00	AAPL	Stock	34.9575	34.9575	34.9575	34.9575	472.0
2017-03-02 07:05:00	AAPL	Stock	34.975	34.975	34.955	34.9575	2400.0
2017-03-02 07:10:00	AAPL	Stock	34.97	34.9975	34.97	34.9975	7408.0
2017-03-02 07:20:00	AAPL	Stock	34.9775	34.9775	34.9775	34.9775	400.0
2017-03-02 07:25:00	AAPL	Stock	34.995	34.995	34.9825	34.995	11620.0
2017-03-02 07:30:00	AAPL	Stock	34.9875	34.9875	34.9825	34.9825	1200.0
2017-03-02 07:35:00	AAPL	Stock	34.9825	34.985	34.9825	34.985	888.0
2017-03-02 07:40:00	AAPL	Stock	34.9925	34.995	34.9825	34.9875	6640.0
2017-03-02 07:45:00	AAPL	Stock	34.9825	34.9825	34.9825	34.9825	400.0
2017-03-02 07:50:00	AAPL	Stock	34.9825	34.9875	34.9825	34.9875	3680.0
2017-03-02 07:55:00	AAPL	Stock	34.9875	34.9875	34.9775	34.9875	1284.0
2017-03-02 08:00:00	AAPL	Stock	34.9875	35.0025	34.95	35.0025	51848.0
2017-03-02 08:05:00	AAPL	Stock	35.0025	35.02	35.0025	35.01	9748.0
2017-03-02 08:10:00	AAPL	Stock	35.005	35.02	35.005	35.01	26880.0
2017-03-02 08:15:00	AAPL	Stock	35.0125	35.0125	35.0075	35.01	33296.0
2017-03-02 08:20:00	AAPL	Stock	35.01	35.0125	35.0075	35.0125	15112.0
2017-03-02 08:25:00	AAPL	Stock	35.0125	35.0125	35.005	35.005	46520.0
2017-03-02 08:30:00	AAPL	Stock	35.005	35.01	34.975	35.01	55104.0
2017-03-02 08:35:00	AAPL	Stock	35.0	35.0025	34.9925	34.9925	56332.0
2017-03-02 08:40:00	AAPL	Stock	34.995	35.005	34.9925	34.9975	43080.0
2017-03-02 08:45:00	AAPL	Stock	34.9925	34.9925	34.975	34.985	17332.0
2017-03-02 08:50:00	AAPL	Stock	34.985	34.9875	34.9825	34.9875	33068.0
2017-03-02 08:55:00	AAPL	Stock	34.9775	35.0025	34.9775	35.0	12304.0
2017-03-02 09:00:00	AAPL	Stock	35.0025	35.0025	34.975	34.975	29008.0
2017-03-02 09:05:00	AAPL	Stock	34.97	34.9825	34.97	34.975	5220.0
2017-03-02 09:10:00	AAPL	Stock	34.975	34.975	34.965	34.965	8268.0
2017-03-02 09:15:00	AAPL	Stock	34.975	34.975	34.9625	34.9625	8248.0
2017-03-02 09:20:00	AAPL	Stock	34.975	34.9775	34.955	34.9775	12488.0
2017-03-02 09:25:00	AAPL	Stock	34.9775	35.0	34.975	34.9875	65816.0
2017-03-02 09:30:00	AAPL	Stock	34.9925	35.0698	34.96	35.0525	6394268.0
2017-03-02 09:35:00	AAPL	Stock	35.0525	35.055	34.925	35.016	3379184.0
2017-03-02 09:40:00	AAPL	Stock	35.015	35.0425	34.99	35.0	2164732.0
2017-03-02 09:45:00	AAPL	Stock	34.9988	34.9988	34.9275	34.975	2014676.0
2017-03-02 09:50:00	AAPL	Stock	34.9738	34.9738	34.9075	34.91	1908532.0

> showing 50 of 355,916 rows — these rows as CSV

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