PREVIEW / stock_5min / 2011-06-29

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-29.parquet
  size:    4.9 MB
  rows:    332,403
  symbols: 3,550

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
2011-06-29 04:15:00	AAPL	Stock	12.0	12.0	12.0	12.0	2800.0
2011-06-29 04:20:00	AAPL	Stock	12.0161	12.0161	12.0161	12.0161	2800.0
2011-06-29 04:25:00	AAPL	Stock	12.0	12.0	12.0	12.0	2800.0
2011-06-29 06:40:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	2800.0
2011-06-29 06:45:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	2800.0
2011-06-29 07:00:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	12600.0
2011-06-29 07:05:00	AAPL	Stock	12.0357	12.0536	12.0354	12.0536	65380.0
2011-06-29 07:10:00	AAPL	Stock	12.0443	12.0446	12.0357	12.0443	52360.0
2011-06-29 07:15:00	AAPL	Stock	12.0446	12.0536	12.0443	12.0536	35840.0
2011-06-29 07:25:00	AAPL	Stock	12.0414	12.0536	12.0414	12.0536	43820.0
2011-06-29 07:30:00	AAPL	Stock	12.0429	12.0536	12.0429	12.0536	11200.0
2011-06-29 07:35:00	AAPL	Stock	12.0546	12.0546	12.0421	12.0429	63420.0
2011-06-29 07:40:00	AAPL	Stock	12.0432	12.0554	12.0429	12.0554	57960.0
2011-06-29 07:45:00	AAPL	Stock	12.0482	12.0482	12.0429	12.0429	81200.0
2011-06-29 07:50:00	AAPL	Stock	12.0482	12.0482	12.0411	12.0411	52472.0
2011-06-29 07:55:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	11200.0
2011-06-29 08:00:00	AAPL	Stock	12.0336	12.0357	12.0179	12.0321	157528.0
2011-06-29 08:05:00	AAPL	Stock	12.0304	12.0357	12.025	12.0357	149016.0
2011-06-29 08:10:00	AAPL	Stock	12.0421	12.0443	12.0314	12.0357	112308.0
2011-06-29 08:15:00	AAPL	Stock	12.0311	12.0357	12.0296	12.0304	122892.0
2011-06-29 08:20:00	AAPL	Stock	12.0321	12.0321	12.025	12.0268	133140.0
2011-06-29 08:25:00	AAPL	Stock	12.0257	12.0346	12.0254	12.0339	84560.0
2011-06-29 08:30:00	AAPL	Stock	12.0336	12.0432	12.0304	12.0432	132244.0
2011-06-29 08:35:00	AAPL	Stock	12.04	12.0443	12.035	12.035	163856.0
2011-06-29 08:40:00	AAPL	Stock	12.0339	12.0393	12.0321	12.0368	92148.0
2011-06-29 08:45:00	AAPL	Stock	12.0407	12.0425	12.02	12.0375	317324.0
2011-06-29 08:50:00	AAPL	Stock	12.0368	12.0443	12.0286	12.0357	110488.0
2011-06-29 08:55:00	AAPL	Stock	12.0439	12.0571	12.0411	12.0546	326984.0
2011-06-29 09:00:00	AAPL	Stock	12.0532	12.0629	12.0446	12.05	400512.0
2011-06-29 09:05:00	AAPL	Stock	12.0504	12.0714	12.0196	12.025	999208.0
2011-06-29 09:10:00	AAPL	Stock	12.025	12.0354	12.0196	12.0196	217280.0
2011-06-29 09:15:00	AAPL	Stock	12.0225	12.0243	12.005	12.0104	470456.0
2011-06-29 09:20:00	AAPL	Stock	12.015	12.0246	12.0136	12.0179	81480.0
2011-06-29 09:25:00	AAPL	Stock	12.0136	12.0136	11.9911	12.0021	707168.0
2011-06-29 09:30:00	AAPL	Stock	12.0014	12.0132	11.9411	11.9643	16610916.0
2011-06-29 09:35:00	AAPL	Stock	11.9629	11.9637	11.9032	11.9036	14386092.0
2011-06-29 09:40:00	AAPL	Stock	11.9036	11.9196	11.8932	11.8968	9884756.0
2011-06-29 09:45:00	AAPL	Stock	11.8979	11.95	11.8946	11.9349	11243960.0
2011-06-29 09:50:00	AAPL	Stock	11.9393	11.9443	11.9129	11.9177	6425916.0
2011-06-29 09:55:00	AAPL	Stock	11.9204	11.9318	11.9107	11.925	4153016.0
2011-06-29 10:00:00	AAPL	Stock	11.9271	11.9314	11.8854	11.9079	9249856.0
2011-06-29 10:05:00	AAPL	Stock	11.9068	11.9171	11.8879	11.9004	7094948.0
2011-06-29 10:10:00	AAPL	Stock	11.9	11.9254	11.8951	11.9245	6316072.0
2011-06-29 10:15:00	AAPL	Stock	11.9246	11.9368	11.9175	11.9241	7471268.0
2011-06-29 10:20:00	AAPL	Stock	11.9237	11.9518	11.9214	11.9439	6387416.0
2011-06-29 10:25:00	AAPL	Stock	11.945	11.9471	11.9164	11.9293	6658456.0
2011-06-29 10:30:00	AAPL	Stock	11.9296	11.9511	11.9161	11.9493	5562396.0
2011-06-29 10:35:00	AAPL	Stock	11.9501	11.98	11.9429	11.9796	8041208.0
2011-06-29 10:40:00	AAPL	Stock	11.98	11.9936	11.97	11.9775	4837112.0
2011-06-29 10:45:00	AAPL	Stock	11.9779	11.9843	11.9632	11.9811	4664268.0

> showing 50 of 332,403 rows — these rows as CSV

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