PREVIEW / stock_30min / 2016-09-28

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-28.parquet
  size:    1.6 MB
  rows:    81,737
  symbols: 3,235

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-28 04:00:00	AAPL	Stock	28.275	28.275	28.275	28.275	480.0
2016-09-28 05:30:00	AAPL	Stock	28.3275	28.3275	28.27	28.27	2000.0
2016-09-28 06:00:00	AAPL	Stock	28.27	28.3425	28.27	28.3425	19576.0
2016-09-28 06:30:00	AAPL	Stock	28.3375	28.3425	28.3	28.3	10000.0
2016-09-28 07:00:00	AAPL	Stock	28.3125	28.355	28.3125	28.355	8000.0
2016-09-28 07:30:00	AAPL	Stock	28.3525	28.415	28.3525	28.4	85156.0
2016-09-28 08:00:00	AAPL	Stock	28.385	28.4375	28.355	28.425	236352.0
2016-09-28 08:30:00	AAPL	Stock	28.4375	28.4375	28.3925	28.41	125292.0
2016-09-28 09:00:00	AAPL	Stock	28.41	28.46	28.39	28.4325	308548.0
2016-09-28 09:30:00	AAPL	Stock	28.42	28.6125	28.4125	28.6075	20725236.0
2016-09-28 10:00:00	AAPL	Stock	28.6088	28.66	28.5125	28.5875	14818644.0
2016-09-28 10:30:00	AAPL	Stock	28.5875	28.6088	28.4362	28.4625	10854048.0
2016-09-28 11:00:00	AAPL	Stock	28.46	28.484	28.3975	28.44	8593224.0
2016-09-28 11:30:00	AAPL	Stock	28.44	28.4575	28.3875	28.4525	6026272.0
2016-09-28 12:00:00	AAPL	Stock	28.45	28.4525	28.3825	28.4125	4352888.0
2016-09-28 12:30:00	AAPL	Stock	28.4138	28.4212	28.3575	28.395	4220568.0
2016-09-28 13:00:00	AAPL	Stock	28.393	28.44	28.38	28.43	3588848.0
2016-09-28 13:30:00	AAPL	Stock	28.4325	28.52	28.43	28.475	5456424.0
2016-09-28 14:00:00	AAPL	Stock	28.4775	28.5225	28.455	28.4975	5362324.0
2016-09-28 14:30:00	AAPL	Stock	28.496	28.525	28.4578	28.5162	4978560.0
2016-09-28 15:00:00	AAPL	Stock	28.5162	28.5375	28.495	28.503	5640372.0
2016-09-28 15:30:00	AAPL	Stock	28.5025	28.515	28.4625	28.4875	8287384.0
2016-09-28 16:00:00	AAPL	Stock	28.4875	28.5075	28.4325	28.47	6296664.0
2016-09-28 16:30:00	AAPL	Stock	28.4725	28.4875	28.47	28.47	11252.0
2016-09-28 17:00:00	AAPL	Stock	28.47	28.485	28.47	28.47	3480.0
2016-09-28 17:30:00	AAPL	Stock	28.4875	28.4875	28.475	28.48	22564.0
2016-09-28 18:00:00	AAPL	Stock	28.48	28.48	28.475	28.475	9696.0
2016-09-28 18:30:00	AAPL	Stock	28.47	28.47	28.4675	28.4675	12340.0
2016-09-28 19:00:00	AAPL	Stock	28.4675	28.4775	28.46	28.465	41744.0
2016-09-28 19:30:00	AAPL	Stock	28.465	28.4875	28.4575	28.4625	39084.0
2016-09-28 05:00:00	MSFT	Stock	57.9	57.9	57.9	57.9	100.0
2016-09-28 08:00:00	MSFT	Stock	57.9	58.0	57.9	58.0	572.0
2016-09-28 08:30:00	MSFT	Stock	57.95	57.95	57.95	57.95	600.0
2016-09-28 09:00:00	MSFT	Stock	57.99	58.01	57.86	57.87	21948.0
2016-09-28 09:30:00	MSFT	Stock	57.87	57.99	57.67	57.9	2374569.0
2016-09-28 10:00:00	MSFT	Stock	57.9	57.99	57.86	57.94	969749.0
2016-09-28 10:30:00	MSFT	Stock	57.945	57.98	57.79	57.825	1154969.0
2016-09-28 11:00:00	MSFT	Stock	57.82	57.83	57.72	57.815	854581.0
2016-09-28 11:30:00	MSFT	Stock	57.82	57.925	57.75	57.905	784455.0
2016-09-28 12:00:00	MSFT	Stock	57.9	57.97	57.86	57.87	902944.0
2016-09-28 12:30:00	MSFT	Stock	57.865	57.9	57.8	57.85	784109.0
2016-09-28 13:00:00	MSFT	Stock	57.86	57.86	57.77	57.785	983841.0
2016-09-28 13:30:00	MSFT	Stock	57.79	57.82	57.78	57.8	898881.0
2016-09-28 14:00:00	MSFT	Stock	57.79	57.97	57.79	57.935	1883332.0
2016-09-28 14:30:00	MSFT	Stock	57.93	58.06	57.88	58.02	1153878.0
2016-09-28 15:00:00	MSFT	Stock	58.03	58.05	57.92	57.97	1241258.0
2016-09-28 15:30:00	MSFT	Stock	57.97	58.05	57.91	58.01	2672696.0
2016-09-28 16:00:00	MSFT	Stock	58.03	58.04	58.01	58.03	2435881.0
2016-09-28 16:30:00	MSFT	Stock	58.03	58.05	58.03	58.05	10359.0
2016-09-28 17:00:00	MSFT	Stock	58.03	58.03	57.99	57.99	49352.0

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

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