PREVIEW / stock_30min / 2016-05-19

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-19.parquet
  size:    1.6 MB
  rows:    81,178
  symbols: 3,280

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-05-19 04:00:00	AAPL	Stock	23.65	23.665	23.65	23.6575	1556.0
2016-05-19 04:30:00	AAPL	Stock	23.6375	23.6375	23.6125	23.6125	3200.0
2016-05-19 05:00:00	AAPL	Stock	23.6075	23.62	23.6075	23.6075	3724.0
2016-05-19 05:30:00	AAPL	Stock	23.62	23.64	23.62	23.64	1200.0
2016-05-19 06:00:00	AAPL	Stock	23.655	23.655	23.655	23.655	400.0
2016-05-19 06:30:00	AAPL	Stock	23.6375	23.6375	23.6375	23.6375	7600.0
2016-05-19 07:00:00	AAPL	Stock	23.655	23.67	23.65	23.67	15180.0
2016-05-19 07:30:00	AAPL	Stock	23.7	23.7025	23.6875	23.69	12108.0
2016-05-19 08:00:00	AAPL	Stock	23.6925	23.6925	23.625	23.6375	96256.0
2016-05-19 08:30:00	AAPL	Stock	23.6362	23.6375	23.58	23.61	114544.0
2016-05-19 09:00:00	AAPL	Stock	23.61	23.6675	23.5875	23.66	112636.0
2016-05-19 09:30:00	AAPL	Stock	23.6575	23.66	23.4125	23.43	20500332.0
2016-05-19 10:00:00	AAPL	Stock	23.4275	23.54	23.4125	23.505	10229524.0
2016-05-19 10:30:00	AAPL	Stock	23.5055	23.53	23.42	23.4275	8674964.0
2016-05-19 11:00:00	AAPL	Stock	23.4275	23.4925	23.4	23.435	8047304.0
2016-05-19 11:30:00	AAPL	Stock	23.4325	23.48	23.3925	23.4625	5226476.0
2016-05-19 12:00:00	AAPL	Stock	23.4605	23.525	23.4325	23.435	5103644.0
2016-05-19 12:30:00	AAPL	Stock	23.4375	23.47	23.4	23.4225	3807744.0
2016-05-19 13:00:00	AAPL	Stock	23.42	23.5175	23.4132	23.5025	4978636.0
2016-05-19 13:30:00	AAPL	Stock	23.505	23.555	23.49	23.495	5665092.0
2016-05-19 14:00:00	AAPL	Stock	23.495	23.54	23.4825	23.51	4096356.0
2016-05-19 14:30:00	AAPL	Stock	23.5125	23.5225	23.415	23.4225	5854224.0
2016-05-19 15:00:00	AAPL	Stock	23.425	23.5825	23.4225	23.5575	6795080.0
2016-05-19 15:30:00	AAPL	Stock	23.5562	23.5975	23.54	23.55	9662196.0
2016-05-19 16:00:00	AAPL	Stock	23.55	23.5725	23.4602	23.57	3307028.0
2016-05-19 16:30:00	AAPL	Stock	23.5725	23.5825	23.5575	23.56	105204.0
2016-05-19 17:00:00	AAPL	Stock	23.585	23.585	23.5575	23.585	5728.0
2016-05-19 17:30:00	AAPL	Stock	23.575	23.575	23.565	23.57	6472.0
2016-05-19 18:00:00	AAPL	Stock	23.585	23.5875	23.56	23.5825	29104.0
2016-05-19 18:30:00	AAPL	Stock	23.5825	23.5825	23.575	23.575	6020.0
2016-05-19 19:00:00	AAPL	Stock	23.5825	23.5825	23.57	23.57	5548.0
2016-05-19 19:30:00	AAPL	Stock	23.565	23.59	23.565	23.5775	10936.0
2016-05-19 07:00:00	MSFT	Stock	50.69	50.7	50.69	50.7	3000.0
2016-05-19 07:30:00	MSFT	Stock	50.64	50.71	50.64	50.71	3300.0
2016-05-19 08:00:00	MSFT	Stock	50.68	50.7	50.6	50.6	1200.0
2016-05-19 08:30:00	MSFT	Stock	50.55	50.6	50.52	50.54	6180.0
2016-05-19 09:00:00	MSFT	Stock	50.53	50.54	50.45	50.54	3595.0
2016-05-19 09:30:00	MSFT	Stock	50.47	50.62	49.94	49.95	3153643.0
2016-05-19 10:00:00	MSFT	Stock	49.95	50.08	49.84	49.99	3660687.0
2016-05-19 10:30:00	MSFT	Stock	49.995	50.078	49.9	49.95	1627577.0
2016-05-19 11:00:00	MSFT	Stock	49.96	50.015	49.84	49.885	1428495.0
2016-05-19 11:30:00	MSFT	Stock	49.885	49.98	49.82	49.96	1939666.0
2016-05-19 12:00:00	MSFT	Stock	49.96	50.07	49.92	49.98	1089863.0
2016-05-19 12:30:00	MSFT	Stock	49.975	50.01	49.89	49.94	632531.0
2016-05-19 13:00:00	MSFT	Stock	49.94	50.175	49.92	50.16	937835.0
2016-05-19 13:30:00	MSFT	Stock	50.155	50.23	50.079	50.08	880708.0
2016-05-19 14:00:00	MSFT	Stock	50.08	50.27	50.08	50.25	1003686.0
2016-05-19 14:30:00	MSFT	Stock	50.25	50.25	50.05	50.065	904212.0
2016-05-19 15:00:00	MSFT	Stock	50.07	50.34	50.065	50.235	1308257.0
2016-05-19 15:30:00	MSFT	Stock	50.23	50.37	50.19	50.32	2194281.0

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

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