PREVIEW / stock_5min / 2014-04-22

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-04-22.parquet
  size:    5.4 MB
  rows:    358,452
  symbols: 3,564

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-04-22 04:45:00	AAPL	Stock	18.9589	18.9589	18.9589	18.9589	2800.0
2014-04-22 04:50:00	AAPL	Stock	18.9589	18.9589	18.9589	18.9589	2800.0
2014-04-22 05:25:00	AAPL	Stock	18.9036	18.9036	18.9036	18.9036	2800.0
2014-04-22 05:35:00	AAPL	Stock	18.9143	18.9179	18.9143	18.9179	34384.0
2014-04-22 06:00:00	AAPL	Stock	18.92	18.92	18.92	18.92	2800.0
2014-04-22 06:05:00	AAPL	Stock	18.9529	18.9529	18.9529	18.9529	2940.0
2014-04-22 06:35:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	2800.0
2014-04-22 07:15:00	AAPL	Stock	18.9293	18.9304	18.9275	18.9275	16240.0
2014-04-22 07:20:00	AAPL	Stock	18.9268	18.9321	18.9268	18.9321	16016.0
2014-04-22 07:25:00	AAPL	Stock	18.93	18.93	18.9286	18.9286	11200.0
2014-04-22 07:30:00	AAPL	Stock	18.915	18.9189	18.9107	18.9107	39060.0
2014-04-22 07:40:00	AAPL	Stock	18.9179	18.9196	18.9179	18.9196	56000.0
2014-04-22 07:45:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	2800.0
2014-04-22 07:50:00	AAPL	Stock	18.9154	18.9154	18.9068	18.9089	39200.0
2014-04-22 07:55:00	AAPL	Stock	18.8996	18.8996	18.8661	18.8707	134372.0
2014-04-22 08:00:00	AAPL	Stock	18.8796	18.9464	18.8786	18.8954	115080.0
2014-04-22 08:05:00	AAPL	Stock	18.8964	18.8964	18.8929	18.8929	25788.0
2014-04-22 08:10:00	AAPL	Stock	18.8896	18.8929	18.8871	18.8871	63280.0
2014-04-22 08:15:00	AAPL	Stock	18.8846	18.8929	18.8821	18.8929	102200.0
2014-04-22 08:20:00	AAPL	Stock	18.8929	18.8996	18.8857	18.8857	145600.0
2014-04-22 08:25:00	AAPL	Stock	18.8929	18.9	18.8893	18.8993	39564.0
2014-04-22 08:30:00	AAPL	Stock	18.9032	18.9068	18.9032	18.9068	22820.0
2014-04-22 08:35:00	AAPL	Stock	18.9018	18.9068	18.9018	18.9018	44800.0
2014-04-22 08:40:00	AAPL	Stock	18.9054	18.9311	18.905	18.9311	349804.0
2014-04-22 08:45:00	AAPL	Stock	18.9311	18.9393	18.9286	18.9368	123144.0
2014-04-22 08:50:00	AAPL	Stock	18.9296	18.9393	18.9286	18.9393	151956.0
2014-04-22 08:55:00	AAPL	Stock	18.9321	18.9321	18.9318	18.9318	11200.0
2014-04-22 09:00:00	AAPL	Stock	18.9214	18.9214	18.9214	18.9214	2800.0
2014-04-22 09:05:00	AAPL	Stock	18.9175	18.9207	18.9139	18.9164	50708.0
2014-04-22 09:10:00	AAPL	Stock	18.9157	18.9179	18.9107	18.9179	116340.0
2014-04-22 09:15:00	AAPL	Stock	18.9125	18.9289	18.9111	18.9289	68460.0
2014-04-22 09:20:00	AAPL	Stock	18.9286	18.9286	18.9107	18.9107	53200.0
2014-04-22 09:25:00	AAPL	Stock	18.9107	18.9143	18.8546	18.8675	511196.0
2014-04-22 09:30:00	AAPL	Stock	18.8682	18.9036	18.8593	18.8829	6585908.0
2014-04-22 09:35:00	AAPL	Stock	18.8832	18.9	18.875	18.875	3225936.0
2014-04-22 09:40:00	AAPL	Stock	18.8768	18.8861	18.8036	18.8282	5727540.0
2014-04-22 09:45:00	AAPL	Stock	18.8248	18.8432	18.8093	18.8368	4088140.0
2014-04-22 09:50:00	AAPL	Stock	18.83	18.85	18.8214	18.8386	3441424.0
2014-04-22 09:55:00	AAPL	Stock	18.8296	18.8757	18.8229	18.8696	3656156.0
2014-04-22 10:00:00	AAPL	Stock	18.8696	18.8918	18.8614	18.8775	3883040.0
2014-04-22 10:05:00	AAPL	Stock	18.8864	18.8882	18.8743	18.875	1722756.0
2014-04-22 10:10:00	AAPL	Stock	18.8764	18.8893	18.875	18.8893	1821204.0
2014-04-22 10:15:00	AAPL	Stock	18.8893	18.8925	18.8661	18.8707	1947092.0
2014-04-22 10:20:00	AAPL	Stock	18.8709	18.89	18.8696	18.8757	1285228.0
2014-04-22 10:25:00	AAPL	Stock	18.8793	18.8925	18.8789	18.8886	3159324.0
2014-04-22 10:30:00	AAPL	Stock	18.8882	18.9104	18.8879	18.8908	2971276.0
2014-04-22 10:35:00	AAPL	Stock	18.8961	18.9079	18.8904	18.8975	1476104.0
2014-04-22 10:40:00	AAPL	Stock	18.8914	18.8964	18.8686	18.885	1622320.0
2014-04-22 10:45:00	AAPL	Stock	18.8873	18.8873	18.87	18.8846	1207024.0
2014-04-22 10:50:00	AAPL	Stock	18.8861	18.9082	18.8825	18.8982	1716680.0

> showing 50 of 358,452 rows — these rows as CSV

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