PREVIEW / stock_1min / 2014-03-21

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-03-21.parquet
  size:    15.4 MB
  rows:    1,103,839
  symbols: 2,873

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
2014-03-21 05:01:00	AAPL	Stock	18.9286	18.9286	18.8821	18.8821	13160.0
2014-03-21 05:06:00	AAPL	Stock	18.9182	18.9182	18.9182	18.9182	14000.0
2014-03-21 05:13:00	AAPL	Stock	18.8843	18.8843	18.8339	18.8339	30800.0
2014-03-21 06:34:00	AAPL	Stock	18.9171	18.9171	18.9171	18.9171	2800.0
2014-03-21 06:58:00	AAPL	Stock	18.9271	18.9271	18.9271	18.9271	2800.0
2014-03-21 07:05:00	AAPL	Stock	18.9246	18.9246	18.9246	18.9246	2800.0
2014-03-21 07:06:00	AAPL	Stock	18.9246	18.9246	18.9246	18.9246	2800.0
2014-03-21 07:07:00	AAPL	Stock	18.9264	18.9264	18.9264	18.9264	2800.0
2014-03-21 07:14:00	AAPL	Stock	18.9264	18.9411	18.9264	18.9411	47600.0
2014-03-21 07:18:00	AAPL	Stock	18.9507	18.9571	18.9507	18.9571	16800.0
2014-03-21 07:20:00	AAPL	Stock	18.9582	18.9582	18.9582	18.9582	5600.0
2014-03-21 07:28:00	AAPL	Stock	18.9571	18.9643	18.9571	18.9643	15400.0
2014-03-21 07:30:00	AAPL	Stock	18.9571	18.9571	18.9571	18.9571	2800.0
2014-03-21 07:32:00	AAPL	Stock	18.9571	18.9571	18.9554	18.9554	47600.0
2014-03-21 07:38:00	AAPL	Stock	18.9604	18.9604	18.9604	18.9604	2800.0
2014-03-21 07:41:00	AAPL	Stock	18.9464	18.9464	18.9464	18.9464	5600.0
2014-03-21 07:42:00	AAPL	Stock	18.9429	18.9429	18.9429	18.9429	28000.0
2014-03-21 07:50:00	AAPL	Stock	18.9375	18.9375	18.9257	18.9257	22288.0
2014-03-21 07:53:00	AAPL	Stock	18.9282	18.9282	18.9282	18.9282	2800.0
2014-03-21 07:54:00	AAPL	Stock	18.9279	18.9279	18.9279	18.9279	2800.0
2014-03-21 07:55:00	AAPL	Stock	18.9089	18.9089	18.9089	18.9089	2800.0
2014-03-21 07:59:00	AAPL	Stock	18.9268	18.9268	18.9268	18.9268	4900.0
2014-03-21 08:00:00	AAPL	Stock	18.9279	18.9286	18.9268	18.9285	14560.0
2014-03-21 08:01:00	AAPL	Stock	18.9271	18.9286	18.9246	18.9286	21700.0
2014-03-21 08:07:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	2800.0
2014-03-21 08:08:00	AAPL	Stock	18.9282	18.9282	18.9282	18.9282	2800.0
2014-03-21 08:11:00	AAPL	Stock	18.9171	18.9171	18.9171	18.9171	4480.0
2014-03-21 08:20:00	AAPL	Stock	18.9264	18.9268	18.9264	18.9268	28000.0
2014-03-21 08:21:00	AAPL	Stock	18.9286	18.9289	18.9286	18.9286	63280.0
2014-03-21 08:25:00	AAPL	Stock	18.9196	18.9196	18.9179	18.9196	50400.0
2014-03-21 08:27:00	AAPL	Stock	18.9321	18.9321	18.9321	18.9321	14000.0
2014-03-21 08:32:00	AAPL	Stock	18.9318	18.9357	18.9318	18.9357	16800.0
2014-03-21 08:34:00	AAPL	Stock	18.9293	18.9357	18.9293	18.9293	8400.0
2014-03-21 08:35:00	AAPL	Stock	18.9286	18.9375	18.9286	18.9375	62580.0
2014-03-21 08:36:00	AAPL	Stock	18.9371	18.9371	18.9321	18.9321	10500.0
2014-03-21 08:39:00	AAPL	Stock	18.9286	18.9318	18.9286	18.9286	14224.0
2014-03-21 08:40:00	AAPL	Stock	18.9321	18.9339	18.9321	18.9339	22400.0
2014-03-21 08:41:00	AAPL	Stock	18.9339	18.9339	18.9321	18.9321	21868.0
2014-03-21 08:42:00	AAPL	Stock	18.9318	18.9318	18.9204	18.9204	5600.0
2014-03-21 08:43:00	AAPL	Stock	18.9257	18.9257	18.9257	18.9257	4508.0
2014-03-21 08:44:00	AAPL	Stock	18.9118	18.9179	18.9118	18.9125	19628.0
2014-03-21 08:50:00	AAPL	Stock	18.925	18.9257	18.925	18.9257	5600.0
2014-03-21 08:51:00	AAPL	Stock	18.9286	18.9296	18.9286	18.9296	16800.0
2014-03-21 08:52:00	AAPL	Stock	18.9375	18.9375	18.9375	18.9375	27580.0
2014-03-21 08:53:00	AAPL	Stock	18.9393	18.9393	18.9332	18.9375	33040.0
2014-03-21 08:56:00	AAPL	Stock	18.9207	18.9221	18.9207	18.9211	28000.0
2014-03-21 09:02:00	AAPL	Stock	18.9282	18.9282	18.9282	18.9282	2800.0
2014-03-21 09:06:00	AAPL	Stock	18.9286	18.9286	18.9282	18.9282	29400.0
2014-03-21 09:07:00	AAPL	Stock	18.9304	18.9304	18.9304	18.9304	8400.0
2014-03-21 09:09:00	AAPL	Stock	18.9339	18.9339	18.9339	18.9339	2800.0

> showing 50 of 1,103,839 rows — these rows as CSV

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