PREVIEW / stock_30min / 2014-03-05

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-05.parquet
  size:    1.6 MB
  rows:    81,430
  symbols: 3,528

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
2014-03-05 04:30:00	AAPL	Stock	18.9736	18.9736	18.9736	18.9736	2800.0
2014-03-05 05:00:00	AAPL	Stock	18.9832	18.9832	18.9832	18.9832	5600.0
2014-03-05 05:30:00	AAPL	Stock	18.9889	18.9904	18.9889	18.9904	14000.0
2014-03-05 07:00:00	AAPL	Stock	18.9921	19.0357	18.9921	19.0039	91252.0
2014-03-05 07:30:00	AAPL	Stock	19.0357	19.0521	19.0357	19.0521	99652.0
2014-03-05 08:00:00	AAPL	Stock	19.0289	19.0446	18.9286	18.9782	610064.0
2014-03-05 08:30:00	AAPL	Stock	18.9661	18.9661	18.9261	18.9482	370860.0
2014-03-05 09:00:00	AAPL	Stock	18.9475	18.9604	18.9343	18.9411	272552.0
2014-03-05 09:30:00	AAPL	Stock	18.9614	19.0396	18.9114	18.9164	30301460.0
2014-03-05 10:00:00	AAPL	Stock	18.9218	19.0096	18.8975	19.0045	18077892.0
2014-03-05 10:30:00	AAPL	Stock	19.0054	19.0221	18.9393	18.9729	11585196.0
2014-03-05 11:00:00	AAPL	Stock	18.975	18.9939	18.9514	18.9593	7591696.0
2014-03-05 11:30:00	AAPL	Stock	18.9582	18.9768	18.9286	18.9729	7175280.0
2014-03-05 12:00:00	AAPL	Stock	18.9732	19.0107	18.9571	19.0096	6004516.0
2014-03-05 12:30:00	AAPL	Stock	19.0104	19.0811	19.0	19.0704	16175516.0
2014-03-05 13:00:00	AAPL	Stock	19.0697	19.0982	19.0371	19.0468	12418812.0
2014-03-05 13:30:00	AAPL	Stock	19.0479	19.0621	19.0182	19.0224	8272040.0
2014-03-05 14:00:00	AAPL	Stock	19.0239	19.0525	18.9932	19.0179	7510664.0
2014-03-05 14:30:00	AAPL	Stock	19.0189	19.0221	18.9929	19.0096	5756604.0
2014-03-05 15:00:00	AAPL	Stock	19.0056	19.0414	18.9893	19.0346	8850100.0
2014-03-05 15:30:00	AAPL	Stock	19.0311	19.0404	19.0129	19.0129	14998928.0
2014-03-05 16:00:00	AAPL	Stock	19.0129	19.0204	18.9656	19.0129	5575472.0
2014-03-05 16:30:00	AAPL	Stock	19.0215	19.0215	19.0111	19.0129	693644.0
2014-03-05 17:00:00	AAPL	Stock	19.0179	19.0179	19.0107	19.0179	24360.0
2014-03-05 17:30:00	AAPL	Stock	19.0114	19.0207	19.0114	19.0179	36008.0
2014-03-05 18:00:00	AAPL	Stock	19.0107	19.0175	19.0107	19.0175	21560.0
2014-03-05 18:30:00	AAPL	Stock	19.0107	19.0129	19.0107	19.0129	47880.0
2014-03-05 19:00:00	AAPL	Stock	19.0196	19.0214	19.0186	19.0186	22204.0
2014-03-05 19:30:00	AAPL	Stock	19.0179	19.0211	19.0129	19.0161	55300.0
2014-03-05 08:00:00	MSFT	Stock	38.4	38.41	38.39	38.39	1300.0
2014-03-05 08:30:00	MSFT	Stock	38.36	38.36	38.36	38.36	1500.0
2014-03-05 09:00:00	MSFT	Stock	38.36	38.38	38.26	38.26	7900.0
2014-03-05 09:30:00	MSFT	Stock	38.26	38.27	37.94	38.01	3809213.0
2014-03-05 10:00:00	MSFT	Stock	38.02	38.1	37.93	37.98	1973282.0
2014-03-05 10:30:00	MSFT	Stock	37.985	38.12	37.985	38.03	1617451.0
2014-03-05 11:00:00	MSFT	Stock	38.03	38.09	37.97	37.976	1093668.0
2014-03-05 11:30:00	MSFT	Stock	37.97	38.03	37.954	37.975	827529.0
2014-03-05 12:00:00	MSFT	Stock	37.98	38.005	37.93	37.974	822881.0
2014-03-05 12:30:00	MSFT	Stock	37.97	38.01	37.95	37.983	659528.0
2014-03-05 13:00:00	MSFT	Stock	37.99	38.05	37.97	38.0	745182.0
2014-03-05 13:30:00	MSFT	Stock	37.99	38.01	37.95	37.98	740944.0
2014-03-05 14:00:00	MSFT	Stock	37.98	38.02	37.96	37.99	884782.0
2014-03-05 14:30:00	MSFT	Stock	37.98	38.03	37.97	38.0	780158.0
2014-03-05 15:00:00	MSFT	Stock	38.005	38.037	37.99	38.035	885022.0
2014-03-05 15:30:00	MSFT	Stock	38.03	38.15	38.01	38.11	2566346.0
2014-03-05 16:00:00	MSFT	Stock	38.11	38.346	37.98	38.11	1465056.0
2014-03-05 16:30:00	MSFT	Stock	38.09	38.11	38.026	38.1	311542.0
2014-03-05 17:00:00	MSFT	Stock	38.118	38.14	38.048	38.09	1038.0
2014-03-05 17:30:00	MSFT	Stock	38.1	38.1	38.1	38.1	300.0
2014-03-05 19:30:00	MSFT	Stock	38.08	38.08	38.08	38.08	175.0

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

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