PREVIEW / stock_1min / 2012-07-20

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-20.parquet
  size:    11.9 MB
  rows:    883,057
  symbols: 2,800

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-20 05:32:00	AAPL	Stock	21.9646	21.9646	21.9643	21.9643	5600.0
2012-07-20 05:50:00	AAPL	Stock	21.9643	21.9643	21.9643	21.9643	2800.0
2012-07-20 06:01:00	AAPL	Stock	21.9643	21.9643	21.9643	21.9643	2800.0
2012-07-20 06:10:00	AAPL	Stock	21.9818	21.9818	21.9818	21.9818	2800.0
2012-07-20 06:29:00	AAPL	Stock	21.9871	21.9871	21.9871	21.9871	2800.0
2012-07-20 06:55:00	AAPL	Stock	21.9821	21.9821	21.9821	21.9821	5600.0
2012-07-20 06:59:00	AAPL	Stock	21.9646	21.9646	21.9646	21.9646	11200.0
2012-07-20 07:00:00	AAPL	Stock	21.9646	21.9782	21.9646	21.9782	5600.0
2012-07-20 07:01:00	AAPL	Stock	21.965	21.965	21.9589	21.9643	30828.0
2012-07-20 07:02:00	AAPL	Stock	21.9643	21.9643	21.9643	21.9643	2800.0
2012-07-20 07:09:00	AAPL	Stock	21.9554	21.9554	21.9554	21.9554	2800.0
2012-07-20 07:14:00	AAPL	Stock	21.9414	21.9414	21.9414	21.9414	5600.0
2012-07-20 07:15:00	AAPL	Stock	21.9411	21.9411	21.9393	21.9393	15400.0
2012-07-20 07:17:00	AAPL	Stock	21.9411	21.9411	21.9411	21.9411	2800.0
2012-07-20 07:18:00	AAPL	Stock	21.9446	21.9446	21.9307	21.9446	11200.0
2012-07-20 07:19:00	AAPL	Stock	21.9318	21.9318	21.9318	21.9318	2800.0
2012-07-20 07:23:00	AAPL	Stock	21.9357	21.9357	21.9321	21.9321	8008.0
2012-07-20 07:26:00	AAPL	Stock	21.9361	21.9361	21.9321	21.9321	6048.0
2012-07-20 07:30:00	AAPL	Stock	21.9482	21.9482	21.9482	21.9482	14000.0
2012-07-20 07:31:00	AAPL	Stock	21.9357	21.9357	21.9357	21.9357	11200.0
2012-07-20 07:34:00	AAPL	Stock	21.9429	21.9429	21.9429	21.9429	10780.0
2012-07-20 07:36:00	AAPL	Stock	21.9464	21.9464	21.9325	21.9325	14420.0
2012-07-20 07:37:00	AAPL	Stock	21.9321	21.9321	21.9232	21.9232	48664.0
2012-07-20 07:38:00	AAPL	Stock	21.9107	21.9107	21.9107	21.9107	8400.0
2012-07-20 07:40:00	AAPL	Stock	21.9107	21.9125	21.9107	21.9107	29148.0
2012-07-20 07:41:00	AAPL	Stock	21.9107	21.9107	21.9107	21.9107	11340.0
2012-07-20 07:42:00	AAPL	Stock	21.9107	21.9107	21.9018	21.9107	30800.0
2012-07-20 07:43:00	AAPL	Stock	21.9018	21.9071	21.875	21.9071	72576.0
2012-07-20 07:44:00	AAPL	Stock	21.8839	21.8839	21.8571	21.8679	19600.0
2012-07-20 07:46:00	AAPL	Stock	21.8839	21.8875	21.8789	21.8875	23800.0
2012-07-20 07:47:00	AAPL	Stock	21.8661	21.8661	21.8646	21.8646	7000.0
2012-07-20 07:49:00	AAPL	Stock	21.8636	21.8636	21.8625	21.8625	5600.0
2012-07-20 07:51:00	AAPL	Stock	21.8643	21.8643	21.8571	21.8571	33740.0
2012-07-20 07:52:00	AAPL	Stock	21.8464	21.8464	21.8214	21.8214	22400.0
2012-07-20 07:53:00	AAPL	Stock	21.8275	21.8275	21.8214	21.8214	8400.0
2012-07-20 07:54:00	AAPL	Stock	21.8232	21.8232	21.8232	21.8232	2800.0
2012-07-20 07:56:00	AAPL	Stock	21.8604	21.8604	21.8571	21.8571	8400.0
2012-07-20 07:57:00	AAPL	Stock	21.8554	21.8571	21.8554	21.8571	11200.0
2012-07-20 07:58:00	AAPL	Stock	21.8571	21.8571	21.8571	21.8571	14000.0
2012-07-20 08:00:00	AAPL	Stock	21.8739	21.9643	21.8507	21.8646	133560.0
2012-07-20 08:01:00	AAPL	Stock	21.8732	21.8732	21.8729	21.8729	8400.0
2012-07-20 08:02:00	AAPL	Stock	21.8821	21.8886	21.8821	21.8886	36400.0
2012-07-20 08:03:00	AAPL	Stock	21.8925	21.9082	21.8925	21.9082	12320.0
2012-07-20 08:04:00	AAPL	Stock	21.9036	21.91	21.8932	21.9029	57456.0
2012-07-20 08:05:00	AAPL	Stock	21.9036	21.9089	21.8968	21.8968	65520.0
2012-07-20 08:06:00	AAPL	Stock	21.8932	21.8936	21.8886	21.8893	131068.0
2012-07-20 08:07:00	AAPL	Stock	21.8814	21.8929	21.8814	21.8929	35504.0
2012-07-20 08:08:00	AAPL	Stock	21.8929	21.8929	21.8886	21.8886	64120.0
2012-07-20 08:09:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	2800.0
2012-07-20 08:12:00	AAPL	Stock	21.9025	21.9107	21.9025	21.9107	39200.0

> showing 50 of 883,057 rows — these rows as CSV

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