PREVIEW / stock_1min / 2014-06-24

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-06-24.parquet
  size:    15.0 MB
  rows:    1,078,806
  symbols: 2,904

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-06-24 04:00:00	AAPL	Stock	22.67	22.67	22.67	22.67	400.0
2014-06-24 05:03:00	AAPL	Stock	22.6925	22.6925	22.6925	22.6925	1024.0
2014-06-24 05:16:00	AAPL	Stock	22.695	22.695	22.6925	22.6925	6288.0
2014-06-24 05:25:00	AAPL	Stock	22.67	22.67	22.67	22.67	1564.0
2014-06-24 05:32:00	AAPL	Stock	22.665	22.665	22.665	22.665	3200.0
2014-06-24 05:37:00	AAPL	Stock	22.665	22.665	22.665	22.665	800.0
2014-06-24 05:38:00	AAPL	Stock	22.675	22.675	22.675	22.675	800.0
2014-06-24 05:41:00	AAPL	Stock	22.685	22.685	22.685	22.685	400.0
2014-06-24 05:47:00	AAPL	Stock	22.68	22.68	22.68	22.68	400.0
2014-06-24 05:58:00	AAPL	Stock	22.675	22.675	22.675	22.675	3200.0
2014-06-24 06:00:00	AAPL	Stock	22.685	22.685	22.685	22.685	800.0
2014-06-24 06:01:00	AAPL	Stock	22.69	22.69	22.69	22.69	800.0
2014-06-24 06:02:00	AAPL	Stock	22.69	22.69	22.69	22.69	400.0
2014-06-24 06:17:00	AAPL	Stock	22.6825	22.6825	22.6825	22.6825	420.0
2014-06-24 06:57:00	AAPL	Stock	22.6925	22.6925	22.6925	22.6925	1624.0
2014-06-24 06:59:00	AAPL	Stock	22.695	22.695	22.695	22.695	596.0
2014-06-24 07:00:00	AAPL	Stock	22.7	22.7	22.7	22.7	596.0
2014-06-24 07:01:00	AAPL	Stock	22.705	22.705	22.705	22.705	400.0
2014-06-24 07:07:00	AAPL	Stock	22.71	22.71	22.71	22.71	640.0
2014-06-24 07:11:00	AAPL	Stock	22.7125	22.7125	22.7125	22.7125	400.0
2014-06-24 07:12:00	AAPL	Stock	22.7125	22.7125	22.7125	22.7125	400.0
2014-06-24 07:19:00	AAPL	Stock	22.7125	22.7125	22.7125	22.7125	800.0
2014-06-24 07:20:00	AAPL	Stock	22.72	22.72	22.7175	22.72	3200.0
2014-06-24 07:33:00	AAPL	Stock	22.715	22.715	22.715	22.715	2000.0
2014-06-24 07:34:00	AAPL	Stock	22.715	22.715	22.7125	22.7125	13600.0
2014-06-24 07:36:00	AAPL	Stock	22.715	22.7175	22.715	22.7175	2800.0
2014-06-24 07:38:00	AAPL	Stock	22.72	22.72	22.72	22.72	2840.0
2014-06-24 07:39:00	AAPL	Stock	22.7175	22.7175	22.7175	22.7175	9200.0
2014-06-24 07:43:00	AAPL	Stock	22.7225	22.725	22.7225	22.725	7200.0
2014-06-24 07:44:00	AAPL	Stock	22.7275	22.7275	22.7225	22.7225	2000.0
2014-06-24 07:45:00	AAPL	Stock	22.725	22.725	22.725	22.725	800.0
2014-06-24 07:46:00	AAPL	Stock	22.725	22.725	22.725	22.725	800.0
2014-06-24 07:47:00	AAPL	Stock	22.7225	22.7225	22.7225	22.7225	400.0
2014-06-24 07:50:00	AAPL	Stock	22.7275	22.73	22.7275	22.73	27420.0
2014-06-24 07:52:00	AAPL	Stock	22.735	22.7375	22.735	22.7375	1600.0
2014-06-24 07:55:00	AAPL	Stock	22.735	22.735	22.735	22.735	2000.0
2014-06-24 07:58:00	AAPL	Stock	22.7375	22.7425	22.7375	22.74	24324.0
2014-06-24 08:00:00	AAPL	Stock	22.7375	22.7425	22.6975	22.74	69732.0
2014-06-24 08:01:00	AAPL	Stock	22.7325	22.735	22.725	22.7275	10400.0
2014-06-24 08:02:00	AAPL	Stock	22.735	22.735	22.725	22.725	18524.0
2014-06-24 08:03:00	AAPL	Stock	22.7275	22.7275	22.7225	22.7225	9324.0
2014-06-24 08:04:00	AAPL	Stock	22.725	22.725	22.725	22.725	400.0
2014-06-24 08:05:00	AAPL	Stock	22.725	22.725	22.725	22.725	11032.0
2014-06-24 08:06:00	AAPL	Stock	22.7275	22.73	22.725	22.725	11592.0
2014-06-24 08:07:00	AAPL	Stock	22.725	22.725	22.725	22.725	5600.0
2014-06-24 08:08:00	AAPL	Stock	22.73	22.73	22.73	22.73	2208.0
2014-06-24 08:12:00	AAPL	Stock	22.7325	22.7325	22.7325	22.7325	2000.0
2014-06-24 08:13:00	AAPL	Stock	22.7325	22.7325	22.7325	22.7325	2800.0
2014-06-24 08:14:00	AAPL	Stock	22.7325	22.7325	22.7325	22.7325	1600.0
2014-06-24 08:18:00	AAPL	Stock	22.7325	22.7325	22.7325	22.7325	9120.0

> showing 50 of 1,078,806 rows — these rows as CSV

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