PREVIEW / stock_30min / 2015-06-03

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-03.parquet
  size:    1.6 MB
  rows:    82,212
  symbols: 3,494

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
2015-06-03 04:00:00	AAPL	Stock	32.5175	32.5825	32.515	32.515	7480.0
2015-06-03 04:30:00	AAPL	Stock	32.525	32.525	32.515	32.52	3600.0
2015-06-03 05:00:00	AAPL	Stock	32.55	32.55	32.55	32.55	400.0
2015-06-03 05:30:00	AAPL	Stock	32.535	32.535	32.535	32.535	2400.0
2015-06-03 06:00:00	AAPL	Stock	32.54	32.54	32.54	32.54	800.0
2015-06-03 06:30:00	AAPL	Stock	32.54	32.5875	32.54	32.5875	6020.0
2015-06-03 07:00:00	AAPL	Stock	32.5875	32.65	32.575	32.625	60156.0
2015-06-03 07:30:00	AAPL	Stock	32.6375	32.6875	32.6325	32.6875	217684.0
2015-06-03 08:00:00	AAPL	Stock	32.685	32.6875	32.575	32.6725	418572.0
2015-06-03 08:30:00	AAPL	Stock	32.6675	32.685	32.6525	32.655	204412.0
2015-06-03 09:00:00	AAPL	Stock	32.6625	32.7	32.6475	32.6725	371440.0
2015-06-03 09:30:00	AAPL	Stock	32.665	32.6975	32.56	32.67	17855256.0
2015-06-03 10:00:00	AAPL	Stock	32.67	32.735	32.5802	32.695	14085036.0
2015-06-03 10:30:00	AAPL	Stock	32.6975	32.7298	32.67	32.709	8029432.0
2015-06-03 11:00:00	AAPL	Stock	32.7075	32.715	32.6125	32.6248	6317860.0
2015-06-03 11:30:00	AAPL	Stock	32.625	32.6598	32.565	32.6125	8287492.0
2015-06-03 12:00:00	AAPL	Stock	32.615	32.645	32.5025	32.545	7655472.0
2015-06-03 12:30:00	AAPL	Stock	32.545	32.5575	32.475	32.5375	8870444.0
2015-06-03 13:00:00	AAPL	Stock	32.5375	32.545	32.5	32.5188	5210532.0
2015-06-03 13:30:00	AAPL	Stock	32.5175	32.56	32.4925	32.5568	5647104.0
2015-06-03 14:00:00	AAPL	Stock	32.5575	32.605	32.55	32.58	6654332.0
2015-06-03 14:30:00	AAPL	Stock	32.5778	32.59	32.5175	32.535	4713176.0
2015-06-03 15:00:00	AAPL	Stock	32.535	32.5575	32.4935	32.515	6206772.0
2015-06-03 15:30:00	AAPL	Stock	32.5138	32.55	32.495	32.54	11483040.0
2015-06-03 16:00:00	AAPL	Stock	32.53	32.5525	32.5275	32.5425	3753416.0
2015-06-03 16:30:00	AAPL	Stock	32.545	32.6118	32.54	32.545	146392.0
2015-06-03 17:00:00	AAPL	Stock	32.55	32.55	32.54	32.5475	36976.0
2015-06-03 17:30:00	AAPL	Stock	32.545	32.5475	32.5425	32.5425	20584.0
2015-06-03 18:00:00	AAPL	Stock	32.5448	32.545	32.53	32.545	40140.0
2015-06-03 18:30:00	AAPL	Stock	32.5475	32.55	32.5275	32.55	20776.0
2015-06-03 19:00:00	AAPL	Stock	32.545	32.55	32.54	32.54	33388.0
2015-06-03 19:30:00	AAPL	Stock	32.5425	32.5475	32.535	32.5475	34688.0
2015-06-03 04:00:00	MSFT	Stock	47.02	47.02	47.0	47.0	600.0
2015-06-03 04:30:00	MSFT	Stock	46.94	47.02	46.94	47.02	200.0
2015-06-03 06:30:00	MSFT	Stock	47.03	47.03	47.03	47.03	100.0
2015-06-03 07:00:00	MSFT	Stock	47.1	47.1	47.1	47.1	700.0
2015-06-03 07:30:00	MSFT	Stock	47.11	47.21	47.11	47.19	1800.0
2015-06-03 08:00:00	MSFT	Stock	47.19	47.27	47.12	47.2	6413.0
2015-06-03 08:30:00	MSFT	Stock	47.25	47.26	47.2	47.22	17900.0
2015-06-03 09:00:00	MSFT	Stock	47.22	47.37	47.15	47.36	54143.0
2015-06-03 09:30:00	MSFT	Stock	47.31	47.525	47.13	47.51	3166700.0
2015-06-03 10:00:00	MSFT	Stock	47.51	47.735	47.41	47.66	1909864.0
2015-06-03 10:30:00	MSFT	Stock	47.67	47.72	47.61	47.66	1222687.0
2015-06-03 11:00:00	MSFT	Stock	47.66	47.665	47.38	47.402	1177347.0
2015-06-03 11:30:00	MSFT	Stock	47.41	47.46	47.09	47.14	1623429.0
2015-06-03 12:00:00	MSFT	Stock	47.13	47.19	46.98	47.05	1393530.0
2015-06-03 12:30:00	MSFT	Stock	47.05	47.145	46.96	47.12	1182318.0
2015-06-03 13:00:00	MSFT	Stock	47.11	47.34	47.09	47.28	4699276.0
2015-06-03 13:30:00	MSFT	Stock	47.28	47.3	47.2	47.25	647953.0
2015-06-03 14:00:00	MSFT	Stock	47.255	47.32	47.12	47.12	1318718.0

> showing 50 of 82,212 rows — these rows as CSV

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