PREVIEW / stock_1min / 2012-06-21

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-06-21.parquet
  size:    13.5 MB
  rows:    1,007,652
  symbols: 2,817

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-21 04:00:00	AAPL	Stock	20.8571	20.8571	20.8571	20.8571	28000.0
2012-06-21 04:29:00	AAPL	Stock	20.8393	20.8393	20.8393	20.8393	2800.0
2012-06-21 07:13:00	AAPL	Stock	20.8929	20.8929	20.8925	20.8929	19068.0
2012-06-21 07:15:00	AAPL	Stock	20.8929	20.8929	20.8929	20.8929	3752.0
2012-06-21 07:19:00	AAPL	Stock	20.8929	20.8929	20.8929	20.8929	2800.0
2012-06-21 07:36:00	AAPL	Stock	20.9196	20.9264	20.9196	20.9264	5600.0
2012-06-21 07:43:00	AAPL	Stock	20.9125	20.9125	20.9111	20.9111	5600.0
2012-06-21 07:46:00	AAPL	Stock	20.9286	20.9286	20.9286	20.9286	14000.0
2012-06-21 07:47:00	AAPL	Stock	20.9375	20.9375	20.9286	20.9286	16800.0
2012-06-21 07:48:00	AAPL	Stock	20.9311	20.9311	20.9311	20.9311	2800.0
2012-06-21 07:51:00	AAPL	Stock	20.9286	20.9286	20.9161	20.9161	8400.0
2012-06-21 07:52:00	AAPL	Stock	20.9143	20.9143	20.9125	20.9125	5600.0
2012-06-21 08:00:00	AAPL	Stock	20.9125	20.9125	20.9043	20.9043	5600.0
2012-06-21 08:01:00	AAPL	Stock	20.9043	20.9043	20.9043	20.9043	5600.0
2012-06-21 08:02:00	AAPL	Stock	20.9121	20.9121	20.9064	20.9064	8400.0
2012-06-21 08:04:00	AAPL	Stock	20.9057	20.9064	20.9032	20.9064	37744.0
2012-06-21 08:08:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	2800.0
2012-06-21 08:10:00	AAPL	Stock	20.9089	20.9089	20.9064	20.9064	55076.0
2012-06-21 08:11:00	AAPL	Stock	20.9064	20.9089	20.9064	20.9089	5600.0
2012-06-21 08:12:00	AAPL	Stock	20.9232	20.9268	20.9107	20.9111	20636.0
2012-06-21 08:13:00	AAPL	Stock	20.9107	20.9114	20.9107	20.9114	5600.0
2012-06-21 08:14:00	AAPL	Stock	20.92	20.92	20.92	20.92	2800.0
2012-06-21 08:15:00	AAPL	Stock	20.9196	20.9196	20.9196	20.9196	2800.0
2012-06-21 08:16:00	AAPL	Stock	20.9179	20.9179	20.9179	20.9179	2800.0
2012-06-21 08:18:00	AAPL	Stock	20.9161	20.9161	20.9161	20.9161	5600.0
2012-06-21 08:21:00	AAPL	Stock	20.9161	20.9161	20.9054	20.9054	11200.0
2012-06-21 08:22:00	AAPL	Stock	20.9068	20.9068	20.9018	20.9018	5600.0
2012-06-21 08:24:00	AAPL	Stock	20.9064	20.9064	20.9064	20.9064	2800.0
2012-06-21 08:25:00	AAPL	Stock	20.9018	20.9018	20.9018	20.9018	15400.0
2012-06-21 08:27:00	AAPL	Stock	20.8975	20.8975	20.8946	20.8975	15400.0
2012-06-21 08:28:00	AAPL	Stock	20.8975	20.8975	20.8932	20.8932	19600.0
2012-06-21 08:30:00	AAPL	Stock	20.8968	20.8979	20.8857	20.8893	44800.0
2012-06-21 08:31:00	AAPL	Stock	20.9082	20.9082	20.905	20.905	5600.0
2012-06-21 08:32:00	AAPL	Stock	20.8904	20.8904	20.8904	20.8904	2800.0
2012-06-21 08:33:00	AAPL	Stock	20.8982	20.8982	20.8982	20.8982	2800.0
2012-06-21 08:36:00	AAPL	Stock	20.9118	20.9221	20.9118	20.9221	8400.0
2012-06-21 08:37:00	AAPL	Stock	20.9221	20.9221	20.9221	20.9221	2800.0
2012-06-21 08:38:00	AAPL	Stock	20.9218	20.9218	20.9214	20.9214	5600.0
2012-06-21 08:39:00	AAPL	Stock	20.9039	20.9039	20.9039	20.9039	2800.0
2012-06-21 08:41:00	AAPL	Stock	20.9207	20.9211	20.9193	20.9211	11200.0
2012-06-21 08:44:00	AAPL	Stock	20.9143	20.9143	20.9143	20.9143	2800.0
2012-06-21 08:53:00	AAPL	Stock	20.9107	20.9107	20.9018	20.9018	17528.0
2012-06-21 08:54:00	AAPL	Stock	20.9018	20.9018	20.8929	20.8929	68628.0
2012-06-21 09:00:00	AAPL	Stock	20.8929	20.8929	20.8929	20.8929	2800.0
2012-06-21 09:01:00	AAPL	Stock	20.8929	20.8929	20.8929	20.8929	14000.0
2012-06-21 09:04:00	AAPL	Stock	20.8929	20.8964	20.8911	20.8911	19600.0
2012-06-21 09:07:00	AAPL	Stock	20.8875	20.8875	20.8857	20.8857	8400.0
2012-06-21 09:08:00	AAPL	Stock	20.8836	20.885	20.8836	20.885	16800.0
2012-06-21 09:09:00	AAPL	Stock	20.8793	20.8893	20.8736	20.8893	42000.0
2012-06-21 09:12:00	AAPL	Stock	20.8921	20.8929	20.8921	20.8929	8148.0

> showing 50 of 1,007,652 rows — these rows as CSV

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