PREVIEW / stock_1min / 2012-06-28

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-06-28.parquet
  size:    12.5 MB
  rows:    938,290
  symbols: 2,836

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-28 04:00:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	28000.0
2012-06-28 04:16:00	AAPL	Stock	20.4021	20.4021	20.4021	20.4021	4200.0
2012-06-28 07:01:00	AAPL	Stock	20.4443	20.4521	20.4443	20.4443	42000.0
2012-06-28 07:05:00	AAPL	Stock	20.4518	20.4518	20.45	20.45	5600.0
2012-06-28 07:13:00	AAPL	Stock	20.4464	20.4464	20.4464	20.4464	3080.0
2012-06-28 07:22:00	AAPL	Stock	20.4939	20.5	20.4939	20.5	56000.0
2012-06-28 07:26:00	AAPL	Stock	20.4839	20.4839	20.4839	20.4839	2800.0
2012-06-28 07:27:00	AAPL	Stock	20.4843	20.4843	20.4821	20.4821	5600.0
2012-06-28 07:38:00	AAPL	Stock	20.4654	20.4654	20.4654	20.4654	2800.0
2012-06-28 07:46:00	AAPL	Stock	20.465	20.465	20.4589	20.4589	8400.0
2012-06-28 07:49:00	AAPL	Stock	20.4557	20.4618	20.4557	20.4618	5600.0
2012-06-28 07:50:00	AAPL	Stock	20.455	20.455	20.455	20.455	2800.0
2012-06-28 07:51:00	AAPL	Stock	20.455	20.455	20.45	20.45	56000.0
2012-06-28 07:55:00	AAPL	Stock	20.4339	20.4339	20.4286	20.4286	11200.0
2012-06-28 08:00:00	AAPL	Stock	20.4596	20.4643	20.4393	20.4429	84476.0
2012-06-28 08:01:00	AAPL	Stock	20.4396	20.4396	20.4286	20.4286	55636.0
2012-06-28 08:02:00	AAPL	Stock	20.4418	20.4418	20.4418	20.4418	2800.0
2012-06-28 08:04:00	AAPL	Stock	20.4357	20.4357	20.4279	20.4279	5600.0
2012-06-28 08:05:00	AAPL	Stock	20.4321	20.4321	20.4321	20.4321	5600.0
2012-06-28 08:06:00	AAPL	Stock	20.4354	20.4354	20.4286	20.4286	8400.0
2012-06-28 08:07:00	AAPL	Stock	20.4286	20.4339	20.4286	20.4339	28000.0
2012-06-28 08:09:00	AAPL	Stock	20.4336	20.4339	20.4336	20.4339	8120.0
2012-06-28 08:11:00	AAPL	Stock	20.4464	20.4471	20.4464	20.4471	8400.0
2012-06-28 08:14:00	AAPL	Stock	20.4293	20.4293	20.4107	20.4107	88620.0
2012-06-28 08:17:00	AAPL	Stock	20.415	20.415	20.415	20.415	14000.0
2012-06-28 08:18:00	AAPL	Stock	20.4164	20.4164	20.4164	20.4164	2800.0
2012-06-28 08:20:00	AAPL	Stock	20.4268	20.4268	20.4268	20.4268	2800.0
2012-06-28 08:22:00	AAPL	Stock	20.4229	20.4229	20.4229	20.4229	2800.0
2012-06-28 08:28:00	AAPL	Stock	20.4279	20.4279	20.4279	20.4279	2800.0
2012-06-28 08:29:00	AAPL	Stock	20.4293	20.4293	20.4293	20.4293	2800.0
2012-06-28 08:30:00	AAPL	Stock	20.4286	20.4429	20.4286	20.4429	8540.0
2012-06-28 08:31:00	AAPL	Stock	20.4425	20.4425	20.4425	20.4425	2800.0
2012-06-28 08:32:00	AAPL	Stock	20.4414	20.4421	20.4414	20.4421	5600.0
2012-06-28 08:33:00	AAPL	Stock	20.4471	20.45	20.4471	20.45	26600.0
2012-06-28 08:34:00	AAPL	Stock	20.4464	20.4464	20.4464	20.4464	2800.0
2012-06-28 08:35:00	AAPL	Stock	20.4461	20.4464	20.4414	20.4414	33600.0
2012-06-28 08:38:00	AAPL	Stock	20.4307	20.4393	20.4307	20.4357	11200.0
2012-06-28 08:39:00	AAPL	Stock	20.4293	20.4304	20.4286	20.4286	50400.0
2012-06-28 08:45:00	AAPL	Stock	20.4257	20.4257	20.4257	20.4257	5600.0
2012-06-28 08:47:00	AAPL	Stock	20.4275	20.4275	20.4275	20.4275	2800.0
2012-06-28 08:48:00	AAPL	Stock	20.4318	20.4321	20.4318	20.4321	16800.0
2012-06-28 08:52:00	AAPL	Stock	20.4304	20.4307	20.4286	20.4307	16800.0
2012-06-28 08:54:00	AAPL	Stock	20.4236	20.425	20.4218	20.4218	26040.0
2012-06-28 08:55:00	AAPL	Stock	20.42	20.42	20.42	20.42	6944.0
2012-06-28 08:58:00	AAPL	Stock	20.4214	20.4229	20.4207	20.4207	17220.0
2012-06-28 09:01:00	AAPL	Stock	20.4239	20.4239	20.4239	20.4239	5600.0
2012-06-28 09:02:00	AAPL	Stock	20.4232	20.4232	20.4179	20.4179	83468.0
2012-06-28 09:03:00	AAPL	Stock	20.4179	20.4179	20.4179	20.4179	31360.0
2012-06-28 09:04:00	AAPL	Stock	20.4179	20.4232	20.4179	20.4232	11200.0
2012-06-28 09:05:00	AAPL	Stock	20.4196	20.42	20.4196	20.4196	36428.0

> showing 50 of 938,290 rows — these rows as CSV

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