PREVIEW / stock_5min / 2011-05-27

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-05-27.parquet
  size:    4.7 MB
  rows:    322,995
  symbols: 3,534

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-05-27 05:05:00	AAPL	Stock	11.9732	11.9732	11.9732	11.9732	2800.0
2011-05-27 07:20:00	AAPL	Stock	11.9889	11.9889	11.9889	11.9889	2800.0
2011-05-27 07:35:00	AAPL	Stock	11.9804	11.9804	11.9804	11.9804	2800.0
2011-05-27 07:40:00	AAPL	Stock	11.9804	11.9804	11.9804	11.9804	2800.0
2011-05-27 08:00:00	AAPL	Stock	11.9714	11.9875	11.9714	11.9839	22820.0
2011-05-27 08:05:00	AAPL	Stock	11.9886	11.9886	11.9864	11.9864	5600.0
2011-05-27 08:10:00	AAPL	Stock	11.9857	11.9857	11.9857	11.9857	2800.0
2011-05-27 08:15:00	AAPL	Stock	11.9857	11.9857	11.9857	11.9857	2800.0
2011-05-27 08:20:00	AAPL	Stock	11.9861	11.9929	11.9861	11.9929	81200.0
2011-05-27 08:25:00	AAPL	Stock	11.9936	11.995	11.9861	11.9861	32844.0
2011-05-27 08:30:00	AAPL	Stock	11.9946	12.0	11.9946	12.0	177296.0
2011-05-27 08:35:00	AAPL	Stock	11.9993	11.9996	11.9986	11.9986	16800.0
2011-05-27 08:40:00	AAPL	Stock	11.9986	11.9986	11.9911	11.9911	35980.0
2011-05-27 08:45:00	AAPL	Stock	11.9911	11.9925	11.9911	11.9925	14000.0
2011-05-27 08:50:00	AAPL	Stock	11.9943	11.9964	11.9943	11.9964	7616.0
2011-05-27 08:55:00	AAPL	Stock	11.9889	11.9889	11.9857	11.9857	58800.0
2011-05-27 09:00:00	AAPL	Stock	11.9893	11.9893	11.9821	11.9857	53284.0
2011-05-27 09:05:00	AAPL	Stock	11.9918	11.9918	11.9821	11.9821	53200.0
2011-05-27 09:10:00	AAPL	Stock	11.9875	11.9886	11.9818	11.9839	36400.0
2011-05-27 09:15:00	AAPL	Stock	11.9793	11.9821	11.9793	11.9821	5600.0
2011-05-27 09:20:00	AAPL	Stock	11.9821	11.9839	11.9821	11.9839	41748.0
2011-05-27 09:25:00	AAPL	Stock	11.9825	11.9846	11.96	11.96	380940.0
2011-05-27 09:30:00	AAPL	Stock	11.9571	11.9818	11.9443	11.9489	9516164.0
2011-05-27 09:35:00	AAPL	Stock	11.9479	11.9632	11.9464	11.95	4043592.0
2011-05-27 09:40:00	AAPL	Stock	11.9496	11.9575	11.9396	11.9568	4796428.0
2011-05-27 09:45:00	AAPL	Stock	11.9586	11.9796	11.9571	11.9619	5523140.0
2011-05-27 09:50:00	AAPL	Stock	11.9632	11.9643	11.9489	11.9625	3385760.0
2011-05-27 09:55:00	AAPL	Stock	11.9636	11.9714	11.9525	11.9607	3548132.0
2011-05-27 10:00:00	AAPL	Stock	11.9607	11.9679	11.9532	11.9618	4321268.0
2011-05-27 10:05:00	AAPL	Stock	11.9611	11.9654	11.9514	11.959	2482816.0
2011-05-27 10:10:00	AAPL	Stock	11.9593	11.9654	11.95	11.9575	3096408.0
2011-05-27 10:15:00	AAPL	Stock	11.9564	11.97	11.9557	11.97	2188088.0
2011-05-27 10:20:00	AAPL	Stock	11.9711	11.9925	11.9586	11.9925	3914232.0
2011-05-27 10:25:00	AAPL	Stock	11.9925	12.015	11.9893	12.01	6832560.0
2011-05-27 10:30:00	AAPL	Stock	12.01	12.0107	12.0	12.005	2640316.0
2011-05-27 10:35:00	AAPL	Stock	12.0071	12.0164	12.0025	12.0039	2891812.0
2011-05-27 10:40:00	AAPL	Stock	12.005	12.0246	12.0039	12.0243	3818556.0
2011-05-27 10:45:00	AAPL	Stock	12.0246	12.055	12.0225	12.0462	8417892.0
2011-05-27 10:50:00	AAPL	Stock	12.0444	12.0486	12.0382	12.0385	2755592.0
2011-05-27 10:55:00	AAPL	Stock	12.0382	12.0414	12.0307	12.0397	3594192.0
2011-05-27 11:00:00	AAPL	Stock	12.0393	12.0439	12.0332	12.0386	2915500.0
2011-05-27 11:05:00	AAPL	Stock	12.0393	12.0396	12.0286	12.0332	2648296.0
2011-05-27 11:10:00	AAPL	Stock	12.0343	12.0368	12.0293	12.0321	1632708.0
2011-05-27 11:15:00	AAPL	Stock	12.0321	12.0396	12.0311	12.0386	2493260.0
2011-05-27 11:20:00	AAPL	Stock	12.0382	12.0446	12.0325	12.0332	3073168.0
2011-05-27 11:25:00	AAPL	Stock	12.0346	12.0364	12.0268	12.0346	2414916.0
2011-05-27 11:30:00	AAPL	Stock	12.0343	12.0354	12.0279	12.0286	2220484.0
2011-05-27 11:35:00	AAPL	Stock	12.0289	12.0357	12.0289	12.0339	1507716.0
2011-05-27 11:40:00	AAPL	Stock	12.035	12.0354	12.0316	12.0323	876400.0
2011-05-27 11:45:00	AAPL	Stock	12.0318	12.0343	12.0308	12.0321	1136604.0

> showing 50 of 322,995 rows — these rows as CSV

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