PREVIEW / stock_30min / 2016-07-07

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-07.parquet
  size:    1.6 MB
  rows:    81,082
  symbols: 3,261

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-07-07 05:30:00	AAPL	Stock	23.9225	23.9225	23.9225	23.9225	644.0
2016-07-07 06:00:00	AAPL	Stock	23.9225	23.9225	23.9	23.9	3756.0
2016-07-07 07:00:00	AAPL	Stock	23.92	23.94	23.9	23.9	22420.0
2016-07-07 07:30:00	AAPL	Stock	23.8875	23.8875	23.8775	23.8775	12940.0
2016-07-07 08:00:00	AAPL	Stock	23.9	23.915	23.8875	23.9	54896.0
2016-07-07 08:30:00	AAPL	Stock	23.9125	23.93	23.8925	23.93	32580.0
2016-07-07 09:00:00	AAPL	Stock	23.9375	23.95	23.9125	23.935	88408.0
2016-07-07 09:30:00	AAPL	Stock	23.925	24.1225	23.9225	24.0812	17150184.0
2016-07-07 10:00:00	AAPL	Stock	24.08	24.095	24.0475	24.065	7646852.0
2016-07-07 10:30:00	AAPL	Stock	24.0675	24.125	24.005	24.025	7718556.0
2016-07-07 11:00:00	AAPL	Stock	24.025	24.0675	24.0025	24.0425	5097984.0
2016-07-07 11:30:00	AAPL	Stock	24.0425	24.0475	23.97	24.0472	4682828.0
2016-07-07 12:00:00	AAPL	Stock	24.045	24.07	24.025	24.0675	4961328.0
2016-07-07 12:30:00	AAPL	Stock	24.0675	24.07	23.9875	23.9975	5458408.0
2016-07-07 13:00:00	AAPL	Stock	23.9975	24.015	23.9625	23.9775	3988348.0
2016-07-07 13:30:00	AAPL	Stock	23.9775	24.01	23.9475	23.9825	3547672.0
2016-07-07 14:00:00	AAPL	Stock	23.9838	24.0025	23.9325	23.9675	4027728.0
2016-07-07 14:30:00	AAPL	Stock	23.97	23.98	23.905	23.9212	3757236.0
2016-07-07 15:00:00	AAPL	Stock	23.9212	23.9775	23.9125	23.95	5155332.0
2016-07-07 15:30:00	AAPL	Stock	23.95	24.0025	23.9375	23.985	8664056.0
2016-07-07 16:00:00	AAPL	Stock	23.985	24.0335	23.9125	23.97	7078868.0
2016-07-07 16:30:00	AAPL	Stock	23.975	23.985	23.965	23.965	582916.0
2016-07-07 17:00:00	AAPL	Stock	23.985	23.985	23.96	23.9825	52716.0
2016-07-07 17:30:00	AAPL	Stock	23.965	23.975	23.96	23.9675	15200.0
2016-07-07 18:00:00	AAPL	Stock	23.9675	23.97	23.9675	23.97	21096.0
2016-07-07 18:30:00	AAPL	Stock	23.965	23.9675	23.9625	23.9675	5780.0
2016-07-07 19:00:00	AAPL	Stock	23.9675	23.9675	23.9625	23.9625	15740.0
2016-07-07 19:30:00	AAPL	Stock	23.9625	23.965	23.96	23.965	20256.0
2016-07-07 04:00:00	MSFT	Stock	51.3	51.3	51.3	51.3	100.0
2016-07-07 07:00:00	MSFT	Stock	51.35	51.36	51.35	51.36	600.0
2016-07-07 07:30:00	MSFT	Stock	51.38	51.39	51.38	51.39	3034.0
2016-07-07 08:00:00	MSFT	Stock	51.39	51.41	51.38	51.41	9300.0
2016-07-07 08:30:00	MSFT	Stock	51.56	51.56	51.56	51.56	100.0
2016-07-07 09:00:00	MSFT	Stock	51.42	51.47	51.42	51.46	4205.0
2016-07-07 09:30:00	MSFT	Stock	51.45	51.61	51.285	51.55	2321355.0
2016-07-07 10:00:00	MSFT	Stock	51.555	51.58	51.46	51.53	1259708.0
2016-07-07 10:30:00	MSFT	Stock	51.53	51.6	51.38	51.43	1287409.0
2016-07-07 11:00:00	MSFT	Stock	51.43	51.52	51.3	51.34	1192701.0
2016-07-07 11:30:00	MSFT	Stock	51.345	51.367	51.24	51.3	897870.0
2016-07-07 12:00:00	MSFT	Stock	51.29	51.38	51.241	51.355	733157.0
2016-07-07 12:30:00	MSFT	Stock	51.355	51.395	51.12	51.125	855436.0
2016-07-07 13:00:00	MSFT	Stock	51.14	51.286	51.09	51.25	923248.0
2016-07-07 13:30:00	MSFT	Stock	51.26	51.295	51.14	51.23	769545.0
2016-07-07 14:00:00	MSFT	Stock	51.222	51.285	51.11	51.22	967193.0
2016-07-07 14:30:00	MSFT	Stock	51.23	51.25	51.08	51.115	1350461.0
2016-07-07 15:00:00	MSFT	Stock	51.115	51.265	51.07	51.257	1657178.0
2016-07-07 15:30:00	MSFT	Stock	51.26	51.405	51.22	51.38	2538786.0
2016-07-07 16:00:00	MSFT	Stock	51.38	51.566	51.34	51.38	1554756.0
2016-07-07 16:30:00	MSFT	Stock	51.38	51.38	51.34	51.34	1112.0
2016-07-07 18:00:00	MSFT	Stock	51.34	51.35	51.34	51.35	808.0

> showing 50 of 81,082 rows — these rows as CSV

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