PREVIEW / stock_5min / 2012-07-24

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-24.parquet
  size:    4.8 MB
  rows:    319,327
  symbols: 3,472

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-07-24 04:10:00	AAPL	Stock	21.5536	21.5536	21.5536	21.5536	2800.0
2012-07-24 04:20:00	AAPL	Stock	21.5711	21.5711	21.5711	21.5711	2800.0
2012-07-24 04:40:00	AAPL	Stock	21.6	21.6	21.6	21.6	9240.0
2012-07-24 04:55:00	AAPL	Stock	21.5986	21.6	21.5986	21.6	16800.0
2012-07-24 05:25:00	AAPL	Stock	21.5821	21.5821	21.5821	21.5821	2800.0
2012-07-24 05:55:00	AAPL	Stock	21.5961	21.5964	21.5961	21.5964	30800.0
2012-07-24 06:05:00	AAPL	Stock	21.5982	21.5982	21.5911	21.5911	8400.0
2012-07-24 06:10:00	AAPL	Stock	21.5911	21.5911	21.5911	21.5911	5600.0
2012-07-24 06:15:00	AAPL	Stock	21.5804	21.5804	21.5786	21.5786	19320.0
2012-07-24 06:25:00	AAPL	Stock	21.5714	21.5714	21.5714	21.5714	22400.0
2012-07-24 06:30:00	AAPL	Stock	21.5821	21.5821	21.5821	21.5821	2800.0
2012-07-24 07:00:00	AAPL	Stock	21.5714	21.5804	21.5625	21.5714	31500.0
2012-07-24 07:05:00	AAPL	Stock	21.5821	21.5964	21.5789	21.5964	56000.0
2012-07-24 07:10:00	AAPL	Stock	21.5946	21.5982	21.5893	21.5964	91000.0
2012-07-24 07:15:00	AAPL	Stock	21.5893	21.5893	21.5893	21.5893	16828.0
2012-07-24 07:20:00	AAPL	Stock	21.5889	21.5889	21.5536	21.5596	230328.0
2012-07-24 07:25:00	AAPL	Stock	21.5554	21.5711	21.5554	21.5561	22400.0
2012-07-24 07:30:00	AAPL	Stock	21.5704	21.5796	21.5693	21.5786	63140.0
2012-07-24 07:35:00	AAPL	Stock	21.5786	21.5786	21.5161	21.5536	200508.0
2012-07-24 07:40:00	AAPL	Stock	21.5511	21.5511	21.5182	21.5354	147140.0
2012-07-24 07:45:00	AAPL	Stock	21.5361	21.5536	21.4971	21.5343	117432.0
2012-07-24 07:50:00	AAPL	Stock	21.525	21.525	21.5179	21.5239	25200.0
2012-07-24 07:55:00	AAPL	Stock	21.5286	21.5304	21.525	21.5304	14000.0
2012-07-24 08:00:00	AAPL	Stock	21.545	21.6043	21.4879	21.6043	514556.0
2012-07-24 08:05:00	AAPL	Stock	21.5943	21.6304	21.5943	21.6068	274764.0
2012-07-24 08:10:00	AAPL	Stock	21.6064	21.6107	21.5982	21.6089	102424.0
2012-07-24 08:15:00	AAPL	Stock	21.6193	21.6354	21.6179	21.6321	226212.0
2012-07-24 08:20:00	AAPL	Stock	21.6321	21.6746	21.6321	21.6607	237496.0
2012-07-24 08:25:00	AAPL	Stock	21.6686	21.6854	21.6536	21.6732	421568.0
2012-07-24 08:30:00	AAPL	Stock	21.6736	21.6954	21.6732	21.6789	400344.0
2012-07-24 08:35:00	AAPL	Stock	21.6821	21.6964	21.6821	21.6843	196784.0
2012-07-24 08:40:00	AAPL	Stock	21.6843	21.6946	21.6768	21.6793	345660.0
2012-07-24 08:45:00	AAPL	Stock	21.6807	21.6946	21.6786	21.6921	226324.0
2012-07-24 08:50:00	AAPL	Stock	21.6929	21.7314	21.6921	21.7179	634816.0
2012-07-24 08:55:00	AAPL	Stock	21.7175	21.7221	21.7064	21.7079	161700.0
2012-07-24 09:00:00	AAPL	Stock	21.7086	21.7179	21.6971	21.7007	329336.0
2012-07-24 09:05:00	AAPL	Stock	21.6989	21.7293	21.6989	21.7293	395108.0
2012-07-24 09:10:00	AAPL	Stock	21.7275	21.7589	21.7218	21.7464	604856.0
2012-07-24 09:15:00	AAPL	Stock	21.7464	21.75	21.7161	21.72	425628.0
2012-07-24 09:20:00	AAPL	Stock	21.7182	21.7321	21.7129	21.7318	294672.0
2012-07-24 09:25:00	AAPL	Stock	21.7286	21.7321	21.6921	21.6921	599872.0
2012-07-24 09:30:00	AAPL	Stock	21.6904	21.7743	21.6839	21.6861	44120552.0
2012-07-24 09:35:00	AAPL	Stock	21.6904	21.7229	21.6521	21.6543	11419828.0
2012-07-24 09:40:00	AAPL	Stock	21.6521	21.6821	21.6107	21.6324	9784824.0
2012-07-24 09:45:00	AAPL	Stock	21.6336	21.6579	21.6	21.6329	9679404.0
2012-07-24 09:50:00	AAPL	Stock	21.6375	21.6618	21.6307	21.6542	6350120.0
2012-07-24 09:55:00	AAPL	Stock	21.6554	21.6843	21.6368	21.6368	8958712.0
2012-07-24 10:00:00	AAPL	Stock	21.6479	21.6711	21.6296	21.6479	4903444.0
2012-07-24 10:05:00	AAPL	Stock	21.6504	21.6557	21.625	21.6461	4191740.0
2012-07-24 10:10:00	AAPL	Stock	21.6425	21.6639	21.6161	21.6293	4911788.0

> showing 50 of 319,327 rows — these rows as CSV

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