PREVIEW / stock_5min / 2011-06-28

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-28.parquet
  size:    4.9 MB
  rows:    336,873
  symbols: 3,547

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-28 04:50:00	AAPL	Stock	11.8696	11.8696	11.8696	11.8696	2800.0
2011-06-28 07:00:00	AAPL	Stock	11.8575	11.8575	11.8575	11.8575	2800.0
2011-06-28 07:05:00	AAPL	Stock	11.8546	11.8546	11.8546	11.8546	2800.0
2011-06-28 07:10:00	AAPL	Stock	11.8593	11.8643	11.8561	11.8561	18200.0
2011-06-28 07:15:00	AAPL	Stock	11.8536	11.8571	11.8536	11.8571	11200.0
2011-06-28 07:20:00	AAPL	Stock	11.8636	11.8636	11.8554	11.8554	11200.0
2011-06-28 07:25:00	AAPL	Stock	11.8564	11.8564	11.8393	11.8393	81340.0
2011-06-28 07:30:00	AAPL	Stock	11.8289	11.8561	11.8289	11.8446	33600.0
2011-06-28 07:35:00	AAPL	Stock	11.8518	11.8571	11.8393	11.8457	118244.0
2011-06-28 07:40:00	AAPL	Stock	11.8468	11.8468	11.8468	11.8468	5600.0
2011-06-28 07:45:00	AAPL	Stock	11.8393	11.8393	11.8214	11.8382	103880.0
2011-06-28 07:55:00	AAPL	Stock	11.8429	11.8429	11.8386	11.8425	25200.0
2011-06-28 08:00:00	AAPL	Stock	11.8643	11.8643	11.8486	11.8518	83160.0
2011-06-28 08:05:00	AAPL	Stock	11.8536	11.8564	11.8525	11.855	23212.0
2011-06-28 08:10:00	AAPL	Stock	11.8571	11.8571	11.8482	11.8493	36400.0
2011-06-28 08:15:00	AAPL	Stock	11.8532	11.8679	11.8532	11.8679	67200.0
2011-06-28 08:20:00	AAPL	Stock	11.8711	11.8804	11.8711	11.8714	41580.0
2011-06-28 08:25:00	AAPL	Stock	11.875	11.9007	11.875	11.8846	199556.0
2011-06-28 08:30:00	AAPL	Stock	11.8946	11.9089	11.8929	11.9036	193200.0
2011-06-28 08:35:00	AAPL	Stock	11.9018	11.9096	11.8929	11.8932	124404.0
2011-06-28 08:40:00	AAPL	Stock	11.9004	11.9011	11.8889	11.8893	123200.0
2011-06-28 08:45:00	AAPL	Stock	11.8946	11.8982	11.8932	11.8964	53200.0
2011-06-28 08:50:00	AAPL	Stock	11.8929	11.8954	11.8889	11.8889	37296.0
2011-06-28 08:55:00	AAPL	Stock	11.8889	11.8986	11.8889	11.8986	143192.0
2011-06-28 09:00:00	AAPL	Stock	11.8986	11.9082	11.8929	11.9039	173992.0
2011-06-28 09:05:00	AAPL	Stock	11.9018	11.9107	11.9018	11.9057	95592.0
2011-06-28 09:10:00	AAPL	Stock	11.8586	11.9143	11.8586	11.9143	522564.0
2011-06-28 09:15:00	AAPL	Stock	11.9111	11.9143	11.9061	11.9075	275016.0
2011-06-28 09:20:00	AAPL	Stock	11.9046	11.9086	11.8989	11.9025	170100.0
2011-06-28 09:25:00	AAPL	Stock	11.9012	11.9196	11.8954	11.9179	1263220.0
2011-06-28 09:30:00	AAPL	Stock	11.9179	11.9714	11.9086	11.9682	18091052.0
2011-06-28 09:35:00	AAPL	Stock	11.9679	11.9893	11.9571	11.9857	11370324.0
2011-06-28 09:40:00	AAPL	Stock	11.9871	12.025	11.9704	12.015	14472976.0
2011-06-28 09:45:00	AAPL	Stock	12.0159	12.0196	11.9882	11.9929	10245060.0
2011-06-28 09:50:00	AAPL	Stock	11.9929	12.0125	11.9832	11.9871	6198500.0
2011-06-28 09:55:00	AAPL	Stock	11.9873	11.9893	11.9671	11.9682	7070308.0
2011-06-28 10:00:00	AAPL	Stock	11.9679	11.9846	11.9607	11.9804	6234396.0
2011-06-28 10:05:00	AAPL	Stock	11.9779	11.985	11.9671	11.9818	3004092.0
2011-06-28 10:10:00	AAPL	Stock	11.9818	12.005	11.9768	12.0043	6168876.0
2011-06-28 10:15:00	AAPL	Stock	12.0027	12.0079	11.9864	11.9921	5133464.0
2011-06-28 10:20:00	AAPL	Stock	11.9889	11.9954	11.9796	11.9896	3503976.0
2011-06-28 10:25:00	AAPL	Stock	11.9899	12.0	11.9804	11.9956	3240020.0
2011-06-28 10:30:00	AAPL	Stock	11.9946	12.005	11.9893	11.9907	5572560.0
2011-06-28 10:35:00	AAPL	Stock	11.9911	11.9925	11.9786	11.985	3359720.0
2011-06-28 10:40:00	AAPL	Stock	11.985	12.0	11.9821	11.9904	2542484.0
2011-06-28 10:45:00	AAPL	Stock	11.9921	11.9971	11.9811	11.9843	2287068.0
2011-06-28 10:50:00	AAPL	Stock	11.9846	11.9946	11.9821	11.9875	2283260.0
2011-06-28 10:55:00	AAPL	Stock	11.9875	12.0021	11.9807	11.9823	4859932.0
2011-06-28 11:00:00	AAPL	Stock	11.9849	11.9887	11.9725	11.9825	3366356.0
2011-06-28 11:05:00	AAPL	Stock	11.9821	11.9971	11.9789	11.9939	2640484.0

> showing 50 of 336,873 rows — these rows as CSV

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