PREVIEW / stock_1min / 2011-06-17

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-06-17.parquet
  size:    13.7 MB
  rows:    1,040,165
  symbols: 2,899

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-17 06:03:00	AAPL	Stock	11.65	11.65	11.65	11.65	2800.0
2011-06-17 06:30:00	AAPL	Stock	11.6982	11.7039	11.6982	11.7039	8400.0
2011-06-17 06:35:00	AAPL	Stock	11.6964	11.6964	11.6964	11.6964	5600.0
2011-06-17 06:44:00	AAPL	Stock	11.6914	11.6964	11.6914	11.6964	5600.0
2011-06-17 06:55:00	AAPL	Stock	11.6964	11.6964	11.6964	11.6964	2800.0
2011-06-17 06:56:00	AAPL	Stock	11.685	11.685	11.685	11.685	14000.0
2011-06-17 06:58:00	AAPL	Stock	11.6929	11.6929	11.6929	11.6929	44800.0
2011-06-17 06:59:00	AAPL	Stock	11.7021	11.7057	11.695	11.695	19600.0
2011-06-17 07:00:00	AAPL	Stock	11.6946	11.6946	11.6946	11.6946	2800.0
2011-06-17 07:03:00	AAPL	Stock	11.7054	11.7061	11.7054	11.7061	36400.0
2011-06-17 07:04:00	AAPL	Stock	11.7121	11.7143	11.7121	11.7125	103600.0
2011-06-17 07:05:00	AAPL	Stock	11.7139	11.7139	11.7139	11.7139	2800.0
2011-06-17 07:07:00	AAPL	Stock	11.7139	11.7139	11.7139	11.7139	2800.0
2011-06-17 07:08:00	AAPL	Stock	11.7143	11.7143	11.7143	11.7143	5600.0
2011-06-17 07:09:00	AAPL	Stock	11.7086	11.7086	11.7071	11.7071	5600.0
2011-06-17 07:11:00	AAPL	Stock	11.7089	11.7089	11.7089	11.7089	5600.0
2011-06-17 07:15:00	AAPL	Stock	11.7136	11.7136	11.7136	11.7136	8400.0
2011-06-17 07:17:00	AAPL	Stock	11.7071	11.7071	11.7	11.7	11088.0
2011-06-17 07:19:00	AAPL	Stock	11.7018	11.7018	11.7018	11.7018	4200.0
2011-06-17 07:21:00	AAPL	Stock	11.7032	11.7032	11.7032	11.7032	5600.0
2011-06-17 07:22:00	AAPL	Stock	11.7029	11.7032	11.7029	11.7032	5600.0
2011-06-17 07:23:00	AAPL	Stock	11.7032	11.7032	11.7032	11.7032	5600.0
2011-06-17 07:26:00	AAPL	Stock	11.7104	11.7121	11.7025	11.7121	36400.0
2011-06-17 07:28:00	AAPL	Stock	11.7089	11.7089	11.7089	11.7089	2800.0
2011-06-17 07:30:00	AAPL	Stock	11.7121	11.7143	11.7121	11.7129	30800.0
2011-06-17 07:31:00	AAPL	Stock	11.7139	11.7182	11.7139	11.7182	16800.0
2011-06-17 07:32:00	AAPL	Stock	11.7254	11.7254	11.7254	11.7254	2800.0
2011-06-17 07:33:00	AAPL	Stock	11.7143	11.7143	11.7143	11.7143	4200.0
2011-06-17 07:34:00	AAPL	Stock	11.7146	11.7146	11.7146	11.7146	5600.0
2011-06-17 07:36:00	AAPL	Stock	11.7179	11.7232	11.7143	11.7207	22400.0
2011-06-17 07:37:00	AAPL	Stock	11.7161	11.7161	11.7154	11.7154	14980.0
2011-06-17 07:38:00	AAPL	Stock	11.7154	11.7154	11.7129	11.7129	9380.0
2011-06-17 07:40:00	AAPL	Stock	11.7107	11.7107	11.7107	11.7107	5600.0
2011-06-17 07:41:00	AAPL	Stock	11.7143	11.7143	11.7143	11.7143	5600.0
2011-06-17 07:45:00	AAPL	Stock	11.715	11.7154	11.715	11.7154	7420.0
2011-06-17 07:48:00	AAPL	Stock	11.7146	11.7146	11.7143	11.7143	33600.0
2011-06-17 07:50:00	AAPL	Stock	11.7107	11.7143	11.7107	11.7143	16940.0
2011-06-17 07:52:00	AAPL	Stock	11.725	11.725	11.725	11.725	35196.0
2011-06-17 07:53:00	AAPL	Stock	11.725	11.725	11.725	11.725	8456.0
2011-06-17 07:55:00	AAPL	Stock	11.7354	11.7379	11.7354	11.7375	30800.0
2011-06-17 07:56:00	AAPL	Stock	11.7321	11.7321	11.7318	11.7318	11200.0
2011-06-17 07:57:00	AAPL	Stock	11.7321	11.7321	11.7321	11.7321	2800.0
2011-06-17 08:00:00	AAPL	Stock	11.73	11.73	11.7171	11.7171	55160.0
2011-06-17 08:01:00	AAPL	Stock	11.72	11.7232	11.7196	11.7232	16800.0
2011-06-17 08:02:00	AAPL	Stock	11.7232	11.73	11.7232	11.7268	35112.0
2011-06-17 08:03:00	AAPL	Stock	11.7286	11.73	11.7268	11.73	38304.0
2011-06-17 08:04:00	AAPL	Stock	11.7264	11.7264	11.7261	11.7261	8400.0
2011-06-17 08:05:00	AAPL	Stock	11.7057	11.7286	11.7057	11.7286	57036.0
2011-06-17 08:07:00	AAPL	Stock	11.7286	11.7286	11.725	11.725	46200.0
2011-06-17 08:08:00	AAPL	Stock	11.725	11.725	11.7196	11.7196	77000.0

> showing 50 of 1,040,165 rows — these rows as CSV

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