PREVIEW / stock_5min / 2011-07-29

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-07-29.parquet
  size:    5.0 MB
  rows:    333,634
  symbols: 3,549

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-07-29 04:00:00	AAPL	Stock	13.9286	13.9286	13.8968	13.8968	8400.0
2011-07-29 04:05:00	AAPL	Stock	13.8821	13.8821	13.8821	13.8821	2800.0
2011-07-29 04:10:00	AAPL	Stock	13.8889	13.8889	13.8757	13.8786	16800.0
2011-07-29 04:15:00	AAPL	Stock	13.8889	13.8893	13.8889	13.8893	5600.0
2011-07-29 04:20:00	AAPL	Stock	13.8918	13.8918	13.8918	13.8918	2800.0
2011-07-29 04:25:00	AAPL	Stock	13.8946	13.895	13.8946	13.895	5600.0
2011-07-29 04:30:00	AAPL	Stock	13.9189	13.9271	13.9189	13.9271	8400.0
2011-07-29 04:35:00	AAPL	Stock	13.9268	13.9332	13.9268	13.9332	5600.0
2011-07-29 04:45:00	AAPL	Stock	13.9161	13.9161	13.9161	13.9161	2800.0
2011-07-29 04:55:00	AAPL	Stock	13.9036	13.9036	13.9036	13.9036	2800.0
2011-07-29 05:25:00	AAPL	Stock	13.93	13.93	13.93	13.93	2800.0
2011-07-29 05:30:00	AAPL	Stock	13.9225	13.9225	13.9225	13.9225	2800.0
2011-07-29 05:50:00	AAPL	Stock	13.9161	13.9161	13.9161	13.9161	2800.0
2011-07-29 06:05:00	AAPL	Stock	13.9239	13.9239	13.9239	13.9239	2800.0
2011-07-29 06:35:00	AAPL	Stock	13.92	13.92	13.92	13.92	2800.0
2011-07-29 06:40:00	AAPL	Stock	13.9104	13.9104	13.9104	13.9104	3304.0
2011-07-29 06:45:00	AAPL	Stock	13.8982	13.8982	13.875	13.875	16800.0
2011-07-29 07:00:00	AAPL	Stock	13.8904	13.8929	13.8893	13.8893	25200.0
2011-07-29 07:05:00	AAPL	Stock	13.8929	13.8936	13.8929	13.8929	22400.0
2011-07-29 07:10:00	AAPL	Stock	13.8993	13.9104	13.8979	13.8979	14000.0
2011-07-29 07:15:00	AAPL	Stock	13.9007	13.9196	13.9007	13.9075	46900.0
2011-07-29 07:20:00	AAPL	Stock	13.9018	13.9071	13.8946	13.8968	25200.0
2011-07-29 07:30:00	AAPL	Stock	13.8964	13.8964	13.8929	13.8929	32340.0
2011-07-29 07:35:00	AAPL	Stock	13.9036	13.9036	13.8929	13.8929	29680.0
2011-07-29 07:40:00	AAPL	Stock	13.8921	13.8921	13.8911	13.8921	11200.0
2011-07-29 07:50:00	AAPL	Stock	13.8929	13.8929	13.8857	13.8929	85400.0
2011-07-29 07:55:00	AAPL	Stock	13.8979	13.9093	13.8979	13.9093	47600.0
2011-07-29 08:00:00	AAPL	Stock	13.9079	13.9429	13.9014	13.9304	859460.0
2011-07-29 08:05:00	AAPL	Stock	13.93	13.935	13.9057	13.9057	172844.0
2011-07-29 08:10:00	AAPL	Stock	13.9107	13.9139	13.9	13.9007	98476.0
2011-07-29 08:15:00	AAPL	Stock	13.9036	13.9036	13.9004	13.9036	25200.0
2011-07-29 08:20:00	AAPL	Stock	13.9064	13.935	13.9054	13.925	233744.0
2011-07-29 08:25:00	AAPL	Stock	13.9214	13.9286	13.9143	13.9146	109116.0
2011-07-29 08:30:00	AAPL	Stock	13.9125	13.9132	13.875	13.885	1692572.0
2011-07-29 08:35:00	AAPL	Stock	13.885	13.9104	13.8839	13.8968	375844.0
2011-07-29 08:40:00	AAPL	Stock	13.9	13.91	13.8839	13.8929	773360.0
2011-07-29 08:45:00	AAPL	Stock	13.8907	13.8993	13.8857	13.8882	276332.0
2011-07-29 08:50:00	AAPL	Stock	13.8882	13.8911	13.87	13.875	437724.0
2011-07-29 08:55:00	AAPL	Stock	13.875	13.8761	13.8571	13.8646	583492.0
2011-07-29 09:00:00	AAPL	Stock	13.8679	13.8689	13.8482	13.8554	795284.0
2011-07-29 09:05:00	AAPL	Stock	13.8561	13.8568	13.8254	13.8329	513632.0
2011-07-29 09:10:00	AAPL	Stock	13.8389	13.8593	13.8329	13.8393	432208.0
2011-07-29 09:15:00	AAPL	Stock	13.8393	13.8496	13.8361	13.8489	93912.0
2011-07-29 09:20:00	AAPL	Stock	13.8493	13.8661	13.8464	13.8661	150080.0
2011-07-29 09:25:00	AAPL	Stock	13.86	13.8639	13.8225	13.8443	572236.0
2011-07-29 09:30:00	AAPL	Stock	13.8443	13.9104	13.7143	13.8839	22847468.0
2011-07-29 09:35:00	AAPL	Stock	13.8889	13.9039	13.835	13.8471	15214080.0
2011-07-29 09:40:00	AAPL	Stock	13.8475	13.8693	13.8321	13.8321	10718428.0
2011-07-29 09:45:00	AAPL	Stock	13.8325	13.8325	13.7719	13.8271	19167008.0
2011-07-29 09:50:00	AAPL	Stock	13.8275	13.8657	13.8146	13.8504	15492176.0

> showing 50 of 333,634 rows — these rows as CSV

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