PREVIEW / stock_1min / 2014-06-27

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-06-27.parquet
  size:    14.9 MB
  rows:    1,083,232
  symbols: 2,909

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-27 04:00:00	AAPL	Stock	22.7375	22.7375	22.7375	22.7375	3600.0
2014-06-27 04:30:00	AAPL	Stock	22.735	22.735	22.735	22.735	400.0
2014-06-27 04:39:00	AAPL	Stock	22.74	22.74	22.74	22.74	400.0
2014-06-27 05:25:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	5160.0
2014-06-27 05:28:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	2000.0
2014-06-27 05:44:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	3920.0
2014-06-27 05:55:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	1200.0
2014-06-27 06:03:00	AAPL	Stock	22.75	22.75	22.75	22.75	800.0
2014-06-27 06:04:00	AAPL	Stock	22.75	22.75	22.75	22.75	3200.0
2014-06-27 06:05:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	860.0
2014-06-27 06:11:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	3212.0
2014-06-27 06:23:00	AAPL	Stock	22.75	22.75	22.75	22.75	1200.0
2014-06-27 06:24:00	AAPL	Stock	22.75	22.75	22.75	22.75	400.0
2014-06-27 06:28:00	AAPL	Stock	22.7575	22.7575	22.75	22.75	1200.0
2014-06-27 06:30:00	AAPL	Stock	22.78	22.78	22.78	22.78	4000.0
2014-06-27 06:36:00	AAPL	Stock	22.775	22.775	22.775	22.775	400.0
2014-06-27 06:37:00	AAPL	Stock	22.77	22.77	22.77	22.77	800.0
2014-06-27 06:38:00	AAPL	Stock	22.775	22.775	22.775	22.775	3120.0
2014-06-27 06:41:00	AAPL	Stock	22.775	22.775	22.775	22.775	1200.0
2014-06-27 06:43:00	AAPL	Stock	22.775	22.775	22.775	22.775	400.0
2014-06-27 06:47:00	AAPL	Stock	22.775	22.775	22.7725	22.7725	800.0
2014-06-27 06:51:00	AAPL	Stock	22.775	22.775	22.775	22.775	400.0
2014-06-27 06:59:00	AAPL	Stock	22.7625	22.7625	22.7625	22.7625	800.0
2014-06-27 07:04:00	AAPL	Stock	22.7575	22.7575	22.75	22.75	6800.0
2014-06-27 07:07:00	AAPL	Stock	22.7275	22.75	22.7275	22.75	4400.0
2014-06-27 07:11:00	AAPL	Stock	22.74	22.74	22.74	22.74	1600.0
2014-06-27 07:12:00	AAPL	Stock	22.74	22.74	22.74	22.74	1600.0
2014-06-27 07:17:00	AAPL	Stock	22.75	22.7575	22.75	22.75	2400.0
2014-06-27 07:18:00	AAPL	Stock	22.75	22.75	22.75	22.75	400.0
2014-06-27 07:19:00	AAPL	Stock	22.75	22.75	22.75	22.75	400.0
2014-06-27 07:23:00	AAPL	Stock	22.75	22.75	22.75	22.75	800.0
2014-06-27 07:28:00	AAPL	Stock	22.75	22.75	22.75	22.75	2516.0
2014-06-27 07:30:00	AAPL	Stock	22.73	22.73	22.73	22.73	400.0
2014-06-27 07:40:00	AAPL	Stock	22.7325	22.7325	22.7325	22.7325	1200.0
2014-06-27 07:45:00	AAPL	Stock	22.7325	22.735	22.7325	22.735	800.0
2014-06-27 07:48:00	AAPL	Stock	22.735	22.735	22.735	22.735	400.0
2014-06-27 07:51:00	AAPL	Stock	22.75	22.75	22.7425	22.7425	1200.0
2014-06-27 07:53:00	AAPL	Stock	22.75	22.75	22.75	22.75	800.0
2014-06-27 07:54:00	AAPL	Stock	22.75	22.75	22.7425	22.7425	5880.0
2014-06-27 07:55:00	AAPL	Stock	22.7425	22.75	22.7425	22.745	27848.0
2014-06-27 07:56:00	AAPL	Stock	22.745	22.75	22.745	22.75	2324.0
2014-06-27 07:57:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	400.0
2014-06-27 07:58:00	AAPL	Stock	22.7475	22.755	22.7475	22.755	7600.0
2014-06-27 07:59:00	AAPL	Stock	22.755	22.7575	22.7475	22.7575	13444.0
2014-06-27 08:00:00	AAPL	Stock	22.76	22.7725	22.665	22.7225	105412.0
2014-06-27 08:01:00	AAPL	Stock	22.6925	22.71	22.6925	22.71	5500.0
2014-06-27 08:02:00	AAPL	Stock	22.725	22.725	22.725	22.725	1048.0
2014-06-27 08:07:00	AAPL	Stock	22.7175	22.7275	22.7175	22.7275	12648.0
2014-06-27 08:08:00	AAPL	Stock	22.725	22.725	22.725	22.725	2000.0
2014-06-27 08:09:00	AAPL	Stock	22.725	22.725	22.7175	22.7175	1600.0

> showing 50 of 1,083,232 rows — these rows as CSV

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