PREVIEW / stock_5min / 2012-03-16

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-03-16.parquet
  size:    5.0 MB
  rows:    338,571
  symbols: 3,535

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-03-16 04:05:00	AAPL	Stock	20.9854	20.9854	20.9821	20.9821	12600.0
2012-03-16 04:30:00	AAPL	Stock	20.985	20.985	20.985	20.985	2800.0
2012-03-16 04:35:00	AAPL	Stock	20.9768	20.9768	20.9768	20.9768	16800.0
2012-03-16 04:40:00	AAPL	Stock	20.9768	20.9768	20.9768	20.9768	5600.0
2012-03-16 04:45:00	AAPL	Stock	20.9857	20.9857	20.9857	20.9857	2800.0
2012-03-16 04:50:00	AAPL	Stock	20.9857	20.9857	20.9857	20.9857	19320.0
2012-03-16 04:55:00	AAPL	Stock	20.9964	20.9964	20.9964	20.9964	14476.0
2012-03-16 05:00:00	AAPL	Stock	21.0079	21.0125	21.0079	21.0125	28000.0
2012-03-16 05:05:00	AAPL	Stock	21.0075	21.0075	21.0	21.0	25200.0
2012-03-16 05:10:00	AAPL	Stock	21.0104	21.0104	21.0104	21.0104	2800.0
2012-03-16 05:15:00	AAPL	Stock	21.0	21.0	21.0	21.0	5600.0
2012-03-16 05:20:00	AAPL	Stock	21.0	21.0	21.0	21.0	7840.0
2012-03-16 05:25:00	AAPL	Stock	21.0	21.0	21.0	21.0	5600.0
2012-03-16 05:30:00	AAPL	Stock	21.0	21.0	20.9964	20.9964	10360.0
2012-03-16 05:35:00	AAPL	Stock	21.0	21.0	21.0	21.0	29400.0
2012-03-16 05:40:00	AAPL	Stock	21.0089	21.0089	21.0089	21.0089	2800.0
2012-03-16 05:50:00	AAPL	Stock	20.9911	20.9911	20.99	20.99	9268.0
2012-03-16 06:25:00	AAPL	Stock	21.0	21.0	21.0	21.0	2800.0
2012-03-16 06:30:00	AAPL	Stock	21.0039	21.0039	21.0039	21.0039	2800.0
2012-03-16 06:40:00	AAPL	Stock	20.9946	20.9946	20.9893	20.99	34132.0
2012-03-16 06:45:00	AAPL	Stock	20.9893	20.9893	20.9893	20.9893	5600.0
2012-03-16 06:50:00	AAPL	Stock	20.9893	20.9893	20.9893	20.9893	11200.0
2012-03-16 06:55:00	AAPL	Stock	21.0	21.0179	21.0	21.0179	15008.0
2012-03-16 07:00:00	AAPL	Stock	21.0314	21.1071	21.0	21.1071	222796.0
2012-03-16 07:05:00	AAPL	Stock	21.0964	21.1304	21.0804	21.1161	191268.0
2012-03-16 07:10:00	AAPL	Stock	21.1164	21.1179	21.1018	21.1018	169260.0
2012-03-16 07:15:00	AAPL	Stock	21.09	21.0982	21.0625	21.0714	182000.0
2012-03-16 07:20:00	AAPL	Stock	21.0536	21.0643	21.0182	21.0182	96880.0
2012-03-16 07:25:00	AAPL	Stock	21.0196	21.0196	21.0021	21.0025	25200.0
2012-03-16 07:30:00	AAPL	Stock	21.025	21.0607	21.025	21.0414	125832.0
2012-03-16 07:35:00	AAPL	Stock	21.0539	21.0739	21.0464	21.0629	88620.0
2012-03-16 07:40:00	AAPL	Stock	21.0679	21.0854	21.0618	21.0804	388108.0
2012-03-16 07:45:00	AAPL	Stock	21.0786	21.0871	21.0768	21.0854	212240.0
2012-03-16 07:50:00	AAPL	Stock	21.085	21.0854	21.0429	21.0429	719348.0
2012-03-16 07:55:00	AAPL	Stock	21.0571	21.0596	21.0325	21.0482	416920.0
2012-03-16 08:00:00	AAPL	Stock	21.0357	21.1071	21.0357	21.075	1377684.0
2012-03-16 08:05:00	AAPL	Stock	21.0746	21.1018	21.0504	21.0643	1295560.0
2012-03-16 08:10:00	AAPL	Stock	21.0611	21.0689	21.0186	21.0211	824908.0
2012-03-16 08:15:00	AAPL	Stock	21.0243	21.0257	21.0046	21.0089	501676.0
2012-03-16 08:20:00	AAPL	Stock	21.0132	21.0161	20.9589	20.9818	724668.0
2012-03-16 08:25:00	AAPL	Stock	20.9854	20.9946	20.9589	20.9686	600600.0
2012-03-16 08:30:00	AAPL	Stock	20.97	21.01	20.97	20.9825	432628.0
2012-03-16 08:35:00	AAPL	Stock	20.9825	20.9975	20.9743	20.9846	552608.0
2012-03-16 08:40:00	AAPL	Stock	20.9893	20.9893	20.9421	20.9421	696500.0
2012-03-16 08:45:00	AAPL	Stock	20.95	20.9589	20.9179	20.9536	613704.0
2012-03-16 08:50:00	AAPL	Stock	20.9464	20.9629	20.9361	20.96	321328.0
2012-03-16 08:55:00	AAPL	Stock	20.9593	20.9821	20.9179	20.9196	812644.0
2012-03-16 09:00:00	AAPL	Stock	20.9146	20.9179	20.8982	20.9011	587720.0
2012-03-16 09:05:00	AAPL	Stock	20.8975	20.9161	20.875	20.9089	1105216.0
2012-03-16 09:10:00	AAPL	Stock	20.9064	20.9179	20.8968	20.9161	415716.0

> showing 50 of 338,571 rows — these rows as CSV

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