PREVIEW / stock_1min / 2012-06-22

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-06-22.parquet
  size:    13.8 MB
  rows:    1,033,818
  symbols: 2,850

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-06-22 05:30:00	AAPL	Stock	20.7	20.7	20.7	20.7	12600.0
2012-06-22 05:58:00	AAPL	Stock	20.6964	20.6964	20.6964	20.6964	2800.0
2012-06-22 06:17:00	AAPL	Stock	20.6961	20.6961	20.6961	20.6961	2800.0
2012-06-22 06:26:00	AAPL	Stock	20.6982	20.6982	20.6982	20.6982	2800.0
2012-06-22 06:27:00	AAPL	Stock	20.7	20.7	20.7	20.7	30800.0
2012-06-22 07:00:00	AAPL	Stock	20.7036	20.7043	20.6964	20.6964	22680.0
2012-06-22 07:01:00	AAPL	Stock	20.6964	20.6964	20.6964	20.6964	2800.0
2012-06-22 07:07:00	AAPL	Stock	20.6961	20.6961	20.6961	20.6961	2800.0
2012-06-22 07:24:00	AAPL	Stock	20.6786	20.6786	20.6786	20.6786	8400.0
2012-06-22 07:26:00	AAPL	Stock	20.6789	20.6789	20.6786	20.6786	14000.0
2012-06-22 07:27:00	AAPL	Stock	20.6786	20.6786	20.6786	20.6786	2800.0
2012-06-22 07:28:00	AAPL	Stock	20.6636	20.6636	20.6607	20.6607	32200.0
2012-06-22 07:30:00	AAPL	Stock	20.6614	20.6614	20.6518	20.6518	33600.0
2012-06-22 07:35:00	AAPL	Stock	20.6696	20.6696	20.6696	20.6696	4004.0
2012-06-22 07:36:00	AAPL	Stock	20.6768	20.6786	20.6768	20.6786	8400.0
2012-06-22 07:42:00	AAPL	Stock	20.6932	20.6932	20.6932	20.6932	9660.0
2012-06-22 07:44:00	AAPL	Stock	20.6814	20.6814	20.6814	20.6814	2800.0
2012-06-22 07:47:00	AAPL	Stock	20.6875	20.6875	20.6875	20.6875	5600.0
2012-06-22 07:48:00	AAPL	Stock	20.6814	20.6814	20.6814	20.6814	2800.0
2012-06-22 07:51:00	AAPL	Stock	20.6943	20.6943	20.6943	20.6943	2800.0
2012-06-22 07:54:00	AAPL	Stock	20.6946	20.6982	20.6946	20.6982	61544.0
2012-06-22 07:55:00	AAPL	Stock	20.6929	20.6929	20.6929	20.6929	5600.0
2012-06-22 07:56:00	AAPL	Stock	20.6946	20.6946	20.6946	20.6946	2800.0
2012-06-22 07:57:00	AAPL	Stock	20.6946	20.695	20.6929	20.695	16800.0
2012-06-22 08:00:00	AAPL	Stock	20.6893	20.6975	20.6839	20.6839	65520.0
2012-06-22 08:01:00	AAPL	Stock	20.6904	20.6939	20.6904	20.6939	11200.0
2012-06-22 08:02:00	AAPL	Stock	20.6929	20.6964	20.6929	20.6964	16800.0
2012-06-22 08:03:00	AAPL	Stock	20.6889	20.6889	20.6857	20.6857	14000.0
2012-06-22 08:04:00	AAPL	Stock	20.6821	20.6936	20.6821	20.6936	25200.0
2012-06-22 08:05:00	AAPL	Stock	20.6832	20.6832	20.6789	20.6789	22316.0
2012-06-22 08:06:00	AAPL	Stock	20.6721	20.6721	20.6718	20.6718	14000.0
2012-06-22 08:07:00	AAPL	Stock	20.6782	20.6782	20.6782	20.6782	2800.0
2012-06-22 08:08:00	AAPL	Stock	20.6893	20.6911	20.6893	20.6911	5600.0
2012-06-22 08:09:00	AAPL	Stock	20.6889	20.695	20.6889	20.695	22764.0
2012-06-22 08:10:00	AAPL	Stock	20.6857	20.6857	20.6857	20.6857	4060.0
2012-06-22 08:14:00	AAPL	Stock	20.6721	20.6721	20.6696	20.6696	30184.0
2012-06-22 08:15:00	AAPL	Stock	20.6786	20.6786	20.6786	20.6786	12488.0
2012-06-22 08:18:00	AAPL	Stock	20.6782	20.6782	20.6782	20.6782	2800.0
2012-06-22 08:19:00	AAPL	Stock	20.6643	20.6643	20.6643	20.6643	2800.0
2012-06-22 08:23:00	AAPL	Stock	20.6661	20.6661	20.6661	20.6661	8400.0
2012-06-22 08:24:00	AAPL	Stock	20.6779	20.6786	20.6779	20.6786	23548.0
2012-06-22 08:26:00	AAPL	Stock	20.6861	20.6861	20.6861	20.6861	2800.0
2012-06-22 08:27:00	AAPL	Stock	20.6864	20.6864	20.6864	20.6864	5600.0
2012-06-22 08:30:00	AAPL	Stock	20.6829	20.6857	20.6829	20.6829	13300.0
2012-06-22 08:31:00	AAPL	Stock	20.6889	20.69	20.6889	20.69	25060.0
2012-06-22 08:32:00	AAPL	Stock	20.6904	20.6904	20.6821	20.6821	6804.0
2012-06-22 08:33:00	AAPL	Stock	20.6821	20.6954	20.6821	20.6954	16716.0
2012-06-22 08:34:00	AAPL	Stock	20.6939	20.7	20.6939	20.6986	16800.0
2012-06-22 08:35:00	AAPL	Stock	20.6971	20.6971	20.6961	20.6961	25788.0
2012-06-22 08:36:00	AAPL	Stock	20.6957	20.6957	20.6843	20.6843	11200.0

> showing 50 of 1,033,818 rows — these rows as CSV

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