PREVIEW / stock_5min / 2012-04-18

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-04-18.parquet
  size:    4.7 MB
  rows:    319,444
  symbols: 3,499

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
2012-04-18 04:00:00	AAPL	Stock	21.7982	21.8929	21.7982	21.8929	170660.0
2012-04-18 04:05:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	16800.0
2012-04-18 04:15:00	AAPL	Stock	21.8932	21.8964	21.8932	21.8964	11200.0
2012-04-18 04:30:00	AAPL	Stock	21.9089	21.9089	21.9089	21.9089	2800.0
2012-04-18 04:35:00	AAPL	Stock	21.8936	21.8936	21.875	21.8757	28000.0
2012-04-18 04:40:00	AAPL	Stock	21.8575	21.8575	21.8571	21.8571	11200.0
2012-04-18 04:45:00	AAPL	Stock	21.8396	21.8396	21.8214	21.8393	22400.0
2012-04-18 05:00:00	AAPL	Stock	21.8071	21.8071	21.7893	21.7893	16800.0
2012-04-18 05:05:00	AAPL	Stock	21.7918	21.7918	21.7893	21.7893	9800.0
2012-04-18 05:10:00	AAPL	Stock	21.7875	21.7875	21.7825	21.7825	11200.0
2012-04-18 05:20:00	AAPL	Stock	21.75	21.75	21.75	21.75	2800.0
2012-04-18 05:40:00	AAPL	Stock	21.775	21.775	21.775	21.775	8400.0
2012-04-18 05:45:00	AAPL	Stock	21.7439	21.7439	21.7439	21.7439	2800.0
2012-04-18 05:50:00	AAPL	Stock	21.7321	21.7321	21.6911	21.7143	28000.0
2012-04-18 05:55:00	AAPL	Stock	21.6796	21.6964	21.6793	21.6889	28000.0
2012-04-18 06:00:00	AAPL	Stock	21.6896	21.6907	21.68	21.68	12600.0
2012-04-18 06:05:00	AAPL	Stock	21.6825	21.6825	21.6825	21.6825	2800.0
2012-04-18 06:10:00	AAPL	Stock	21.6807	21.6839	21.6807	21.6839	19040.0
2012-04-18 06:20:00	AAPL	Stock	21.6875	21.6929	21.6875	21.6929	5600.0
2012-04-18 06:25:00	AAPL	Stock	21.6929	21.6929	21.6929	21.6929	2800.0
2012-04-18 06:30:00	AAPL	Stock	21.6964	21.6964	21.6964	21.6964	5600.0
2012-04-18 06:35:00	AAPL	Stock	21.7139	21.7143	21.6875	21.7089	61740.0
2012-04-18 06:40:00	AAPL	Stock	21.6968	21.6968	21.6968	21.6968	2800.0
2012-04-18 07:00:00	AAPL	Stock	21.705	21.7143	21.6961	21.7	92148.0
2012-04-18 07:05:00	AAPL	Stock	21.7143	21.7143	21.6811	21.6811	89544.0
2012-04-18 07:10:00	AAPL	Stock	21.6875	21.6929	21.6811	21.6929	32704.0
2012-04-18 07:15:00	AAPL	Stock	21.7071	21.7089	21.7071	21.7071	22400.0
2012-04-18 07:20:00	AAPL	Stock	21.7096	21.7096	21.6993	21.7071	24360.0
2012-04-18 07:25:00	AAPL	Stock	21.7004	21.7004	21.6989	21.6989	13412.0
2012-04-18 07:30:00	AAPL	Stock	21.6996	21.7143	21.6932	21.7143	53200.0
2012-04-18 07:35:00	AAPL	Stock	21.7089	21.7125	21.6986	21.7071	14000.0
2012-04-18 07:40:00	AAPL	Stock	21.6986	21.6986	21.6929	21.6932	15400.0
2012-04-18 07:45:00	AAPL	Stock	21.6932	21.6968	21.6932	21.6968	5600.0
2012-04-18 07:50:00	AAPL	Stock	21.7014	21.7143	21.6932	21.7143	46816.0
2012-04-18 07:55:00	AAPL	Stock	21.7146	21.7846	21.7043	21.76	145040.0
2012-04-18 08:00:00	AAPL	Stock	21.7629	21.8693	21.6818	21.85	1036280.0
2012-04-18 08:05:00	AAPL	Stock	21.8571	21.9464	21.85	21.9304	1148000.0
2012-04-18 08:10:00	AAPL	Stock	21.9286	21.9714	21.9286	21.9396	1215592.0
2012-04-18 08:15:00	AAPL	Stock	21.9396	21.9821	21.9357	21.9464	1315888.0
2012-04-18 08:20:00	AAPL	Stock	21.9464	21.9536	21.9171	21.9532	608356.0
2012-04-18 08:25:00	AAPL	Stock	21.9539	21.96	21.9179	21.9386	484008.0
2012-04-18 08:30:00	AAPL	Stock	21.9329	21.9554	21.9286	21.9457	872200.0
2012-04-18 08:35:00	AAPL	Stock	21.95	21.9504	21.9111	21.9311	534828.0
2012-04-18 08:40:00	AAPL	Stock	21.9246	21.9275	21.8943	21.9107	487928.0
2012-04-18 08:45:00	AAPL	Stock	21.9107	21.9171	21.8568	21.8568	951748.0
2012-04-18 08:50:00	AAPL	Stock	21.8514	21.8568	21.8043	21.8146	1265712.0
2012-04-18 08:55:00	AAPL	Stock	21.8143	21.8464	21.7986	21.8368	1013292.0
2012-04-18 09:00:00	AAPL	Stock	21.8389	21.8782	21.8321	21.8529	486836.0
2012-04-18 09:05:00	AAPL	Stock	21.8561	21.8611	21.8493	21.8611	391804.0
2012-04-18 09:10:00	AAPL	Stock	21.8575	21.8889	21.8536	21.8779	366968.0

> showing 50 of 319,444 rows — these rows as CSV

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