PREVIEW / stock_30min / 2016-12-08

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-08.parquet
  size:    1.7 MB
  rows:    86,282
  symbols: 3,175

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-12-08 07:00:00	AAPL	Stock	27.7375	27.7375	27.7225	27.7225	1356.0
2016-12-08 07:30:00	AAPL	Stock	27.73	27.73	27.6375	27.69	61264.0
2016-12-08 08:00:00	AAPL	Stock	27.7275	27.7275	27.625	27.675	55036.0
2016-12-08 08:30:00	AAPL	Stock	27.6975	27.735	27.6725	27.73	37936.0
2016-12-08 09:00:00	AAPL	Stock	27.7	27.7375	27.69	27.7	36624.0
2016-12-08 09:30:00	AAPL	Stock	27.715	28.0325	27.65	28.0038	18259192.0
2016-12-08 10:00:00	AAPL	Stock	28.005	28.0072	27.885	27.9675	9049924.0
2016-12-08 10:30:00	AAPL	Stock	27.9675	27.9975	27.895	27.9825	5394308.0
2016-12-08 11:00:00	AAPL	Stock	27.9838	28.095	27.965	28.0125	8727832.0
2016-12-08 11:30:00	AAPL	Stock	28.015	28.045	27.9762	28.01	4168452.0
2016-12-08 12:00:00	AAPL	Stock	28.011	28.1	27.99	28.0718	4927560.0
2016-12-08 12:30:00	AAPL	Stock	28.07	28.1075	28.04	28.07	5497960.0
2016-12-08 13:00:00	AAPL	Stock	28.0725	28.075	28.015	28.06	3258460.0
2016-12-08 13:30:00	AAPL	Stock	28.0625	28.0875	28.025	28.0675	3912588.0
2016-12-08 14:00:00	AAPL	Stock	28.0675	28.08	27.9825	28.0375	4474336.0
2016-12-08 14:30:00	AAPL	Stock	28.035	28.0425	27.9475	28.0	4733208.0
2016-12-08 15:00:00	AAPL	Stock	28.0025	28.0045	27.9625	27.9688	4192112.0
2016-12-08 15:30:00	AAPL	Stock	27.97	28.05	27.9675	28.0275	10615512.0
2016-12-08 16:00:00	AAPL	Stock	28.03	28.0825	28.0075	28.06	9237788.0
2016-12-08 16:30:00	AAPL	Stock	28.06	28.0875	28.03	28.055	724740.0
2016-12-08 17:00:00	AAPL	Stock	28.03	28.0625	28.03	28.03	45400.0
2016-12-08 17:30:00	AAPL	Stock	28.0625	28.0875	28.05	28.065	24248.0
2016-12-08 18:00:00	AAPL	Stock	28.075	28.075	28.0425	28.0425	4732.0
2016-12-08 18:30:00	AAPL	Stock	28.0425	28.0475	28.0425	28.0425	2896.0
2016-12-08 19:00:00	AAPL	Stock	28.05	28.05	28.05	28.05	4400.0
2016-12-08 19:30:00	AAPL	Stock	28.0525	28.075	28.05	28.075	20768.0
2016-12-08 04:30:00	MSFT	Stock	61.23	61.23	61.23	61.23	1000.0
2016-12-08 06:00:00	MSFT	Stock	61.38	61.38	61.38	61.38	100.0
2016-12-08 07:30:00	MSFT	Stock	61.39	61.39	61.39	61.39	200.0
2016-12-08 08:00:00	MSFT	Stock	61.29	61.4	61.28	61.4	6333.0
2016-12-08 08:30:00	MSFT	Stock	61.28	61.28	61.28	61.28	1090.0
2016-12-08 09:00:00	MSFT	Stock	61.3	61.5	61.28	61.48	23732.0
2016-12-08 09:30:00	MSFT	Stock	61.3	61.58	61.017	61.39	3127315.0
2016-12-08 10:00:00	MSFT	Stock	61.395	61.525	61.29	61.5	1637114.0
2016-12-08 10:30:00	MSFT	Stock	61.5	61.54	61.3	61.32	1178525.0
2016-12-08 11:00:00	MSFT	Stock	61.315	61.335	61.19	61.208	1189323.0
2016-12-08 11:30:00	MSFT	Stock	61.21	61.23	61.04	61.18	930635.0
2016-12-08 12:00:00	MSFT	Stock	61.175	61.37	61.151	61.27	934722.0
2016-12-08 12:30:00	MSFT	Stock	61.26	61.336	61.195	61.27	781897.0
2016-12-08 13:00:00	MSFT	Stock	61.27	61.32	61.22	61.23	1017050.0
2016-12-08 13:30:00	MSFT	Stock	61.23	61.24	61.15	61.19	691036.0
2016-12-08 14:00:00	MSFT	Stock	61.19	61.2	60.92	61.059	998371.0
2016-12-08 14:30:00	MSFT	Stock	61.06	61.08	60.88	60.98	1416587.0
2016-12-08 15:00:00	MSFT	Stock	60.99	61.06	60.84	60.855	1265566.0
2016-12-08 15:30:00	MSFT	Stock	60.86	61.02	60.855	61.0	2708787.0
2016-12-08 16:00:00	MSFT	Stock	61.0	61.01	60.97	61.0	1985613.0
2016-12-08 16:30:00	MSFT	Stock	61.0	61.17	61.0	61.0	156579.0
2016-12-08 17:30:00	MSFT	Stock	61.09	61.09	61.09	61.09	116.0
2016-12-08 18:00:00	MSFT	Stock	61.09	61.17	61.09	61.17	7900.0
2016-12-08 18:30:00	MSFT	Stock	61.07	61.07	61.07	61.07	400.0

> showing 50 of 86,282 rows — these rows as CSV

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