PREVIEW / stock_1min / 2014-11-20

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-11-20.parquet
  size:    14.0 MB
  rows:    1,029,350
  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-11-20 04:00:00	AAPL	Stock	27.5	27.5	27.5	27.5	400.0
2014-11-20 04:10:00	AAPL	Stock	28.595	28.595	28.595	28.595	1200.0
2014-11-20 04:31:00	AAPL	Stock	28.595	28.595	28.595	28.595	400.0
2014-11-20 04:46:00	AAPL	Stock	28.5925	28.5925	28.5925	28.5925	400.0
2014-11-20 04:50:00	AAPL	Stock	28.5875	28.5875	28.5875	28.5875	10400.0
2014-11-20 05:01:00	AAPL	Stock	28.5675	28.5675	28.5675	28.5675	4352.0
2014-11-20 05:23:00	AAPL	Stock	28.5675	28.5675	28.5675	28.5675	800.0
2014-11-20 05:40:00	AAPL	Stock	28.57	28.57	28.57	28.57	2000.0
2014-11-20 05:46:00	AAPL	Stock	28.6025	28.6025	28.6025	28.6025	400.0
2014-11-20 05:58:00	AAPL	Stock	28.57	28.57	28.57	28.57	2000.0
2014-11-20 06:07:00	AAPL	Stock	28.585	28.585	28.585	28.585	400.0
2014-11-20 06:10:00	AAPL	Stock	28.575	28.575	28.575	28.575	3056.0
2014-11-20 06:16:00	AAPL	Stock	28.575	28.575	28.575	28.575	2056.0
2014-11-20 06:22:00	AAPL	Stock	28.5675	28.5675	28.5675	28.5675	752.0
2014-11-20 06:33:00	AAPL	Stock	28.57	28.57	28.57	28.57	400.0
2014-11-20 06:35:00	AAPL	Stock	28.5675	28.59	28.5625	28.59	2800.0
2014-11-20 06:47:00	AAPL	Stock	28.5875	28.5875	28.5875	28.5875	500.0
2014-11-20 07:01:00	AAPL	Stock	28.605	28.605	28.58	28.58	800.0
2014-11-20 07:06:00	AAPL	Stock	28.605	28.6125	28.605	28.6125	6296.0
2014-11-20 07:07:00	AAPL	Stock	28.6125	28.6375	28.6125	28.6375	10000.0
2014-11-20 07:08:00	AAPL	Stock	28.6375	28.6375	28.6375	28.6375	4504.0
2014-11-20 07:11:00	AAPL	Stock	28.6025	28.6025	28.6025	28.6025	2000.0
2014-11-20 07:12:00	AAPL	Stock	28.6125	28.635	28.6125	28.635	5200.0
2014-11-20 07:14:00	AAPL	Stock	28.6125	28.6125	28.6125	28.6125	4000.0
2014-11-20 07:15:00	AAPL	Stock	28.6175	28.6175	28.6175	28.6175	1200.0
2014-11-20 07:17:00	AAPL	Stock	28.6125	28.625	28.6125	28.625	4932.0
2014-11-20 07:22:00	AAPL	Stock	28.605	28.605	28.605	28.605	5340.0
2014-11-20 07:23:00	AAPL	Stock	28.605	28.605	28.605	28.605	3600.0
2014-11-20 07:24:00	AAPL	Stock	28.6	28.6	28.6	28.6	1200.0
2014-11-20 07:25:00	AAPL	Stock	28.605	28.605	28.605	28.605	400.0
2014-11-20 07:27:00	AAPL	Stock	28.605	28.62	28.605	28.62	1600.0
2014-11-20 07:28:00	AAPL	Stock	28.6225	28.6225	28.62	28.62	2400.0
2014-11-20 07:30:00	AAPL	Stock	28.62	28.62	28.62	28.62	400.0
2014-11-20 07:31:00	AAPL	Stock	28.625	28.625	28.625	28.625	7500.0
2014-11-20 07:32:00	AAPL	Stock	28.625	28.6375	28.625	28.6275	5200.0
2014-11-20 07:33:00	AAPL	Stock	28.635	28.6375	28.63	28.6375	3648.0
2014-11-20 07:34:00	AAPL	Stock	28.6475	28.6475	28.6275	28.6275	6384.0
2014-11-20 07:35:00	AAPL	Stock	28.6375	28.645	28.6375	28.64	8816.0
2014-11-20 07:39:00	AAPL	Stock	28.625	28.625	28.625	28.625	400.0
2014-11-20 07:41:00	AAPL	Stock	28.6275	28.6275	28.6275	28.6275	600.0
2014-11-20 07:42:00	AAPL	Stock	28.6375	28.6375	28.6375	28.6375	800.0
2014-11-20 07:44:00	AAPL	Stock	28.6275	28.6375	28.6275	28.6375	1040.0
2014-11-20 07:50:00	AAPL	Stock	28.63	28.63	28.63	28.63	400.0
2014-11-20 07:53:00	AAPL	Stock	28.63	28.6375	28.63	28.6375	4000.0
2014-11-20 07:57:00	AAPL	Stock	28.6325	28.6325	28.6325	28.6325	400.0
2014-11-20 07:59:00	AAPL	Stock	28.6325	28.6375	28.625	28.625	7200.0
2014-11-20 08:00:00	AAPL	Stock	28.63	28.6675	28.58	28.6375	28460.0
2014-11-20 08:01:00	AAPL	Stock	28.6275	28.6625	28.6275	28.6625	8188.0
2014-11-20 08:02:00	AAPL	Stock	28.635	28.6375	28.635	28.6375	800.0
2014-11-20 08:03:00	AAPL	Stock	28.6375	28.6375	28.6375	28.6375	600.0

> showing 50 of 1,029,350 rows — these rows as CSV

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