PREVIEW / stock_5min / 2016-09-02

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-09-02.parquet
  size:    5.1 MB
  rows:    339,571
  symbols: 3,221

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
2016-09-02 04:15:00	AAPL	Stock	26.7275	26.7275	26.7275	26.7275	400.0
2016-09-02 06:10:00	AAPL	Stock	26.745	26.7625	26.745	26.7625	13592.0
2016-09-02 06:15:00	AAPL	Stock	26.7625	26.77	26.7625	26.77	20860.0
2016-09-02 06:25:00	AAPL	Stock	26.7125	26.7125	26.7125	26.7125	400.0
2016-09-02 07:00:00	AAPL	Stock	26.725	26.725	26.725	26.725	2400.0
2016-09-02 07:05:00	AAPL	Stock	26.72	26.72	26.7125	26.7125	11000.0
2016-09-02 07:10:00	AAPL	Stock	26.7125	26.7125	26.7125	26.7125	1200.0
2016-09-02 07:15:00	AAPL	Stock	26.72	26.72	26.72	26.72	2000.0
2016-09-02 07:20:00	AAPL	Stock	26.72	26.72	26.72	26.72	1948.0
2016-09-02 07:25:00	AAPL	Stock	26.7475	26.75	26.7475	26.75	3740.0
2016-09-02 07:35:00	AAPL	Stock	26.745	26.76	26.745	26.75	39868.0
2016-09-02 07:40:00	AAPL	Stock	26.7525	26.7625	26.75	26.75	29400.0
2016-09-02 07:45:00	AAPL	Stock	26.75	26.7525	26.75	26.7525	7544.0
2016-09-02 07:50:00	AAPL	Stock	26.75	26.7625	26.75	26.7625	15480.0
2016-09-02 07:55:00	AAPL	Stock	26.7625	26.7625	26.75	26.75	5680.0
2016-09-02 08:00:00	AAPL	Stock	26.7625	26.8	26.7125	26.8	64044.0
2016-09-02 08:05:00	AAPL	Stock	26.7875	26.7975	26.7675	26.7675	17740.0
2016-09-02 08:10:00	AAPL	Stock	26.7625	26.7725	26.7275	26.75	78920.0
2016-09-02 08:15:00	AAPL	Stock	26.76	26.7875	26.76	26.7875	10464.0
2016-09-02 08:20:00	AAPL	Stock	26.7625	26.775	26.7625	26.775	4704.0
2016-09-02 08:25:00	AAPL	Stock	26.77	26.7725	26.715	26.75	104688.0
2016-09-02 08:30:00	AAPL	Stock	26.7175	26.845	26.7175	26.8375	185816.0
2016-09-02 08:35:00	AAPL	Stock	26.8375	26.8925	26.8375	26.88	351552.0
2016-09-02 08:40:00	AAPL	Stock	26.885	26.91	26.855	26.89	132344.0
2016-09-02 08:45:00	AAPL	Stock	26.8925	26.8975	26.875	26.895	56680.0
2016-09-02 08:50:00	AAPL	Stock	26.8825	26.8825	26.855	26.855	42988.0
2016-09-02 08:55:00	AAPL	Stock	26.865	26.895	26.865	26.895	60376.0
2016-09-02 09:00:00	AAPL	Stock	26.8975	26.91	26.8975	26.905	31024.0
2016-09-02 09:05:00	AAPL	Stock	26.89	26.905	26.865	26.875	22368.0
2016-09-02 09:10:00	AAPL	Stock	26.87	26.9075	26.87	26.8875	74764.0
2016-09-02 09:15:00	AAPL	Stock	26.89	26.9125	26.89	26.9125	25884.0
2016-09-02 09:20:00	AAPL	Stock	26.9125	26.9425	26.9125	26.935	57124.0
2016-09-02 09:25:00	AAPL	Stock	26.92	26.945	26.8875	26.935	67368.0
2016-09-02 09:30:00	AAPL	Stock	26.9325	27.0	26.875	26.929	6965828.0
2016-09-02 09:35:00	AAPL	Stock	26.93	26.935	26.825	26.8662	3779224.0
2016-09-02 09:40:00	AAPL	Stock	26.87	26.9675	26.868	26.957	2202752.0
2016-09-02 09:45:00	AAPL	Stock	26.9575	26.975	26.9025	26.9125	2194924.0
2016-09-02 09:50:00	AAPL	Stock	26.9125	26.9375	26.88	26.9365	2201796.0
2016-09-02 09:55:00	AAPL	Stock	26.935	26.9375	26.885	26.91	1333372.0
2016-09-02 10:00:00	AAPL	Stock	26.91	26.9425	26.895	26.9345	1273228.0
2016-09-02 10:05:00	AAPL	Stock	26.935	26.955	26.9	26.905	1432576.0
2016-09-02 10:10:00	AAPL	Stock	26.905	26.9225	26.8582	26.8582	1503800.0
2016-09-02 10:15:00	AAPL	Stock	26.8575	26.9	26.8425	26.8575	1266440.0
2016-09-02 10:20:00	AAPL	Stock	26.8598	26.8625	26.8075	26.862	1519120.0
2016-09-02 10:25:00	AAPL	Stock	26.8625	26.8715	26.8475	26.8675	953896.0
2016-09-02 10:30:00	AAPL	Stock	26.87	26.875	26.8362	26.855	1299940.0
2016-09-02 10:35:00	AAPL	Stock	26.853	26.8775	26.8375	26.8775	1250784.0
2016-09-02 10:40:00	AAPL	Stock	26.8775	26.8975	26.87	26.8975	992504.0
2016-09-02 10:45:00	AAPL	Stock	26.8975	26.905	26.8788	26.8925	785904.0
2016-09-02 10:50:00	AAPL	Stock	26.8925	26.9075	26.8875	26.8875	602492.0

> showing 50 of 339,571 rows — these rows as CSV

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