PREVIEW / stock_5min / 2011-10-18

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-10-18.parquet
  size:    4.8 MB
  rows:    326,956
  symbols: 3,527

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-10-18 04:15:00	AAPL	Stock	14.945	14.945	14.945	14.945	2800.0
2011-10-18 05:30:00	AAPL	Stock	14.9821	14.9821	14.9821	14.9821	2800.0
2011-10-18 05:35:00	AAPL	Stock	14.9907	14.9907	14.9882	14.9882	8400.0
2011-10-18 05:40:00	AAPL	Stock	14.9821	14.9821	14.9821	14.9821	4200.0
2011-10-18 05:50:00	AAPL	Stock	14.9414	14.9414	14.9414	14.9414	2800.0
2011-10-18 06:30:00	AAPL	Stock	14.9464	14.9464	14.9464	14.9464	2800.0
2011-10-18 07:00:00	AAPL	Stock	14.9886	14.9925	14.9661	14.9889	36624.0
2011-10-18 07:05:00	AAPL	Stock	14.9929	15.0089	14.9893	15.0029	39200.0
2011-10-18 07:10:00	AAPL	Stock	15.0011	15.0011	14.9929	14.9929	11200.0
2011-10-18 07:15:00	AAPL	Stock	14.9804	14.9818	14.9804	14.9811	14000.0
2011-10-18 07:20:00	AAPL	Stock	14.9714	14.9714	14.9286	14.9646	47600.0
2011-10-18 07:25:00	AAPL	Stock	14.9646	14.9732	14.9643	14.9732	14000.0
2011-10-18 07:30:00	AAPL	Stock	14.975	14.9821	14.975	14.9814	115360.0
2011-10-18 07:35:00	AAPL	Stock	14.9768	14.9768	14.9629	14.9629	117600.0
2011-10-18 07:40:00	AAPL	Stock	14.96	14.9811	14.96	14.9811	69496.0
2011-10-18 07:45:00	AAPL	Stock	14.9739	14.975	14.9632	14.9636	51800.0
2011-10-18 07:50:00	AAPL	Stock	14.9632	14.9632	14.9561	14.9561	15400.0
2011-10-18 07:55:00	AAPL	Stock	14.9518	14.9518	14.9375	14.9375	69300.0
2011-10-18 08:00:00	AAPL	Stock	14.9561	14.9896	14.9307	14.9407	161840.0
2011-10-18 08:05:00	AAPL	Stock	14.9411	14.9443	14.9311	14.9325	100940.0
2011-10-18 08:10:00	AAPL	Stock	14.9321	14.9714	14.9286	14.9714	321972.0
2011-10-18 08:15:00	AAPL	Stock	14.97	15.0196	14.97	15.0179	264404.0
2011-10-18 08:20:00	AAPL	Stock	15.025	15.0593	15.025	15.0593	671300.0
2011-10-18 08:25:00	AAPL	Stock	15.0593	15.06	15.0464	15.0536	321384.0
2011-10-18 08:30:00	AAPL	Stock	15.0536	15.0593	15.0357	15.0364	487452.0
2011-10-18 08:35:00	AAPL	Stock	15.0357	15.0364	15.0121	15.0314	470876.0
2011-10-18 08:40:00	AAPL	Stock	15.0286	15.0589	15.0286	15.0529	411712.0
2011-10-18 08:45:00	AAPL	Stock	15.055	15.0593	15.0464	15.0536	156016.0
2011-10-18 08:50:00	AAPL	Stock	15.0554	15.0643	15.05	15.0586	243180.0
2011-10-18 08:55:00	AAPL	Stock	15.0604	15.0714	15.0536	15.0618	309848.0
2011-10-18 09:00:00	AAPL	Stock	15.0625	15.0696	15.0582	15.0696	339472.0
2011-10-18 09:05:00	AAPL	Stock	15.0707	15.0843	15.05	15.0714	712432.0
2011-10-18 09:10:00	AAPL	Stock	15.0714	15.1029	15.0714	15.1029	844956.0
2011-10-18 09:15:00	AAPL	Stock	15.1011	15.1011	15.0796	15.0929	285796.0
2011-10-18 09:20:00	AAPL	Stock	15.0929	15.0964	15.0832	15.0918	170324.0
2011-10-18 09:25:00	AAPL	Stock	15.0914	15.0964	15.0561	15.0561	407064.0
2011-10-18 09:30:00	AAPL	Stock	15.0629	15.0821	15.0111	15.0221	14336728.0
2011-10-18 09:35:00	AAPL	Stock	15.0214	15.0436	14.9954	15.0	17270652.0
2011-10-18 09:40:00	AAPL	Stock	15.0004	15.0175	14.9286	14.9457	16308208.0
2011-10-18 09:45:00	AAPL	Stock	14.94	14.9461	14.905	14.9407	12460868.0
2011-10-18 09:50:00	AAPL	Stock	14.9399	14.9817	14.9339	14.975	11356772.0
2011-10-18 09:55:00	AAPL	Stock	14.9714	14.9818	14.9504	14.9732	8564444.0
2011-10-18 10:00:00	AAPL	Stock	14.9736	14.9779	14.8857	14.8929	12196324.0
2011-10-18 10:05:00	AAPL	Stock	14.8918	14.9425	14.8907	14.9114	8790516.0
2011-10-18 10:10:00	AAPL	Stock	14.9111	14.9339	14.8936	14.8968	7858984.0
2011-10-18 10:15:00	AAPL	Stock	14.8979	14.9036	14.8568	14.8825	17100356.0
2011-10-18 10:20:00	AAPL	Stock	14.8775	14.9121	14.8625	14.9014	9139648.0
2011-10-18 10:25:00	AAPL	Stock	14.8954	14.9368	14.8929	14.9325	8403808.0
2011-10-18 10:30:00	AAPL	Stock	14.9357	14.9643	14.9321	14.9596	8021692.0
2011-10-18 10:35:00	AAPL	Stock	14.9618	14.9714	14.9318	14.9375	9730532.0

> showing 50 of 326,956 rows — these rows as CSV

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