PREVIEW / stock_1min / 2014-11-05

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-11-05.parquet
  size:    15.0 MB
  rows:    1,087,399
  symbols: 2,892

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-11-05 04:00:00	AAPL	Stock	27.225	27.225	27.225	27.225	400.0
2014-11-05 04:13:00	AAPL	Stock	27.2375	27.2375	27.2125	27.2125	4000.0
2014-11-05 04:16:00	AAPL	Stock	27.2375	27.2375	27.2375	27.2375	1200.0
2014-11-05 04:24:00	AAPL	Stock	27.225	27.225	27.225	27.225	2000.0
2014-11-05 04:32:00	AAPL	Stock	27.225	27.225	27.225	27.225	400.0
2014-11-05 04:36:00	AAPL	Stock	27.245	27.245	27.245	27.245	600.0
2014-11-05 04:37:00	AAPL	Stock	27.2375	27.2375	27.2375	27.2375	3656.0
2014-11-05 04:43:00	AAPL	Stock	27.2375	27.25	27.2375	27.25	3800.0
2014-11-05 04:47:00	AAPL	Stock	27.2625	27.2625	27.2625	27.2625	400.0
2014-11-05 04:50:00	AAPL	Stock	27.2575	27.2625	27.2575	27.2625	3200.0
2014-11-05 04:55:00	AAPL	Stock	27.2575	27.2575	27.2575	27.2575	400.0
2014-11-05 04:57:00	AAPL	Stock	27.2575	27.2625	27.2575	27.2625	8000.0
2014-11-05 05:06:00	AAPL	Stock	27.2625	27.2625	27.2625	27.2625	1184.0
2014-11-05 05:19:00	AAPL	Stock	27.2875	27.2875	27.2875	27.2875	1820.0
2014-11-05 05:21:00	AAPL	Stock	27.2875	27.2875	27.2875	27.2875	400.0
2014-11-05 05:24:00	AAPL	Stock	27.32	27.3375	27.32	27.325	12320.0
2014-11-05 05:25:00	AAPL	Stock	27.32	27.32	27.32	27.32	400.0
2014-11-05 05:57:00	AAPL	Stock	27.29	27.29	27.29	27.29	400.0
2014-11-05 06:00:00	AAPL	Stock	27.295	27.295	27.295	27.295	800.0
2014-11-05 06:03:00	AAPL	Stock	27.32	27.32	27.32	27.32	3108.0
2014-11-05 06:04:00	AAPL	Stock	27.32	27.32	27.32	27.32	400.0
2014-11-05 06:05:00	AAPL	Stock	27.3175	27.3175	27.3175	27.3175	1600.0
2014-11-05 06:08:00	AAPL	Stock	27.29	27.29	27.29	27.29	1600.0
2014-11-05 06:20:00	AAPL	Stock	27.275	27.275	27.275	27.275	400.0
2014-11-05 06:21:00	AAPL	Stock	27.275	27.275	27.275	27.275	1200.0
2014-11-05 06:23:00	AAPL	Stock	27.265	27.265	27.265	27.265	400.0
2014-11-05 06:26:00	AAPL	Stock	27.265	27.265	27.265	27.265	1600.0
2014-11-05 06:30:00	AAPL	Stock	27.265	27.265	27.265	27.265	408.0
2014-11-05 06:32:00	AAPL	Stock	27.265	27.275	27.265	27.275	6296.0
2014-11-05 06:33:00	AAPL	Stock	27.275	27.275	27.275	27.275	400.0
2014-11-05 06:36:00	AAPL	Stock	27.275	27.275	27.275	27.275	1600.0
2014-11-05 06:44:00	AAPL	Stock	27.2725	27.2725	27.2725	27.2725	5300.0
2014-11-05 06:45:00	AAPL	Stock	27.275	27.275	27.275	27.275	800.0
2014-11-05 06:51:00	AAPL	Stock	27.275	27.275	27.275	27.275	2000.0
2014-11-05 06:52:00	AAPL	Stock	27.2725	27.2725	27.2725	27.2725	4400.0
2014-11-05 06:53:00	AAPL	Stock	27.275	27.275	27.2725	27.2725	2400.0
2014-11-05 07:00:00	AAPL	Stock	27.265	27.27	27.265	27.27	2000.0
2014-11-05 07:01:00	AAPL	Stock	27.2725	27.2725	27.2725	27.2725	3600.0
2014-11-05 07:02:00	AAPL	Stock	27.27	27.27	27.2675	27.2675	1200.0
2014-11-05 07:03:00	AAPL	Stock	27.2675	27.2675	27.265	27.265	1900.0
2014-11-05 07:04:00	AAPL	Stock	27.265	27.265	27.25	27.2525	4000.0
2014-11-05 07:05:00	AAPL	Stock	27.2675	27.2675	27.2675	27.2675	2000.0
2014-11-05 07:06:00	AAPL	Stock	27.2525	27.2625	27.2525	27.2625	2400.0
2014-11-05 07:07:00	AAPL	Stock	27.2675	27.2675	27.2675	27.2675	5300.0
2014-11-05 07:09:00	AAPL	Stock	27.2725	27.2725	27.2725	27.2725	800.0
2014-11-05 07:10:00	AAPL	Stock	27.2725	27.275	27.2725	27.275	2712.0
2014-11-05 07:11:00	AAPL	Stock	27.27	27.27	27.27	27.27	400.0
2014-11-05 07:12:00	AAPL	Stock	27.27	27.27	27.2675	27.2675	6960.0
2014-11-05 07:14:00	AAPL	Stock	27.2525	27.255	27.25	27.255	4400.0
2014-11-05 07:15:00	AAPL	Stock	27.2575	27.2575	27.2575	27.2575	800.0

> showing 50 of 1,087,399 rows — these rows as CSV

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