PREVIEW / stock_30min / 2013-08-21

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-21.parquet
  size:    1.5 MB
  rows:    78,592
  symbols: 3,526

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
2013-08-21 04:00:00	AAPL	Stock	17.9196	17.9196	17.9089	17.9089	14000.0
2013-08-21 05:00:00	AAPL	Stock	17.9136	17.9136	17.9136	17.9136	2800.0
2013-08-21 05:30:00	AAPL	Stock	17.9143	17.9143	17.8775	17.8775	5600.0
2013-08-21 06:00:00	AAPL	Stock	17.8607	17.8929	17.8607	17.8929	5600.0
2013-08-21 06:30:00	AAPL	Stock	17.8571	17.8946	17.8568	17.8811	260288.0
2013-08-21 07:00:00	AAPL	Stock	17.8575	17.9289	17.8575	17.925	123620.0
2013-08-21 07:30:00	AAPL	Stock	17.9146	17.9864	17.9146	17.9554	398804.0
2013-08-21 08:00:00	AAPL	Stock	17.9471	17.9964	17.8571	17.9857	1018612.0
2013-08-21 08:30:00	AAPL	Stock	17.9839	17.9925	17.9504	17.9521	1191344.0
2013-08-21 09:00:00	AAPL	Stock	17.95	17.9907	17.9411	17.975	1037484.0
2013-08-21 09:30:00	AAPL	Stock	17.9689	18.1125	17.9532	18.0896	58543296.0
2013-08-21 10:00:00	AAPL	Stock	18.0896	18.0921	17.9179	17.9286	39456396.0
2013-08-21 10:30:00	AAPL	Stock	17.9293	18.0411	17.9179	18.0079	31082072.0
2013-08-21 11:00:00	AAPL	Stock	18.0079	18.0571	17.9696	18.0221	21609308.0
2013-08-21 11:30:00	AAPL	Stock	18.0231	18.0373	17.9554	17.9969	16546908.0
2013-08-21 12:00:00	AAPL	Stock	17.9957	18.0143	17.9654	17.9936	11801944.0
2013-08-21 12:30:00	AAPL	Stock	17.9936	17.9954	17.9468	17.9643	7817068.0
2013-08-21 13:00:00	AAPL	Stock	17.9629	17.9652	17.9218	17.9537	14288568.0
2013-08-21 13:30:00	AAPL	Stock	17.9561	17.9893	17.9475	17.9757	10650892.0
2013-08-21 14:00:00	AAPL	Stock	17.9743	18.0357	17.9	17.9932	35424396.0
2013-08-21 14:30:00	AAPL	Stock	17.9907	18.0521	17.9886	18.0361	20707484.0
2013-08-21 15:00:00	AAPL	Stock	18.0393	18.0429	17.9911	17.9982	13960156.0
2013-08-21 15:30:00	AAPL	Stock	18.0018	18.0164	17.9321	17.9436	31968692.0
2013-08-21 16:00:00	AAPL	Stock	17.9439	18.0625	17.8954	17.9196	10605616.0
2013-08-21 16:30:00	AAPL	Stock	17.9196	18.0022	17.9054	17.9439	2191784.0
2013-08-21 17:00:00	AAPL	Stock	17.9246	17.9414	17.9214	17.9218	238980.0
2013-08-21 17:30:00	AAPL	Stock	17.9218	17.9382	17.9154	17.9268	73360.0
2013-08-21 18:00:00	AAPL	Stock	17.9189	17.9286	17.9189	17.9286	284116.0
2013-08-21 18:30:00	AAPL	Stock	17.9357	17.9389	17.9286	17.9286	28532.0
2013-08-21 19:00:00	AAPL	Stock	17.9254	17.9254	17.9164	17.9164	59024.0
2013-08-21 19:30:00	AAPL	Stock	17.9146	17.9196	17.8982	17.9	266644.0
2013-08-21 07:30:00	MSFT	Stock	31.58	31.58	31.58	31.58	200.0
2013-08-21 08:00:00	MSFT	Stock	31.58	31.6	31.5	31.5	2300.0
2013-08-21 08:30:00	MSFT	Stock	31.51	31.51	31.51	31.51	800.0
2013-08-21 09:00:00	MSFT	Stock	31.57	31.64	31.57	31.63	15325.0
2013-08-21 09:30:00	MSFT	Stock	31.61	31.93	31.54	31.85	3323938.0
2013-08-21 10:00:00	MSFT	Stock	31.853	31.99	31.84	31.911	2443176.0
2013-08-21 10:30:00	MSFT	Stock	31.915	31.94	31.85	31.85	3315668.0
2013-08-21 11:00:00	MSFT	Stock	31.85	31.89	31.83	31.87	2199196.0
2013-08-21 11:30:00	MSFT	Stock	31.87	31.905	31.79	31.84	2561222.0
2013-08-21 12:00:00	MSFT	Stock	31.84	31.86	31.81	31.84	932574.0
2013-08-21 12:30:00	MSFT	Stock	31.84	32.01	31.84	31.91	1861720.0
2013-08-21 13:00:00	MSFT	Stock	31.91	31.92	31.82	31.82	803484.0
2013-08-21 13:30:00	MSFT	Stock	31.82	31.85	31.79	31.81	849687.0
2013-08-21 14:00:00	MSFT	Stock	31.805	31.805	31.6	31.71	4157848.0
2013-08-21 14:30:00	MSFT	Stock	31.71	32.0	31.71	31.91	3053612.0
2013-08-21 15:00:00	MSFT	Stock	31.9	32.0	31.83	31.83	2013847.0
2013-08-21 15:30:00	MSFT	Stock	31.83	31.84	31.58	31.61	4956709.0
2013-08-21 16:00:00	MSFT	Stock	31.61	31.9	31.55	31.604	4236160.0
2013-08-21 16:30:00	MSFT	Stock	31.57	31.97	31.54	31.6	39561.0

> showing 50 of 78,592 rows — these rows as CSV

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