PREVIEW / stock_1min / 2014-09-09

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-09-09.parquet
  size:    14.2 MB
  rows:    1,043,885
  symbols: 2,912

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-09-09 04:00:00	AAPL	Stock	24.75	24.75	24.65	24.65	1000.0
2014-09-09 04:05:00	AAPL	Stock	24.665	24.665	24.665	24.665	1012.0
2014-09-09 04:06:00	AAPL	Stock	24.6825	24.7	24.6825	24.7	1600.0
2014-09-09 04:08:00	AAPL	Stock	24.7175	24.725	24.7175	24.725	5200.0
2014-09-09 04:09:00	AAPL	Stock	24.725	24.725	24.725	24.725	1248.0
2014-09-09 04:12:00	AAPL	Stock	24.73	24.73	24.73	24.73	2000.0
2014-09-09 04:14:00	AAPL	Stock	24.735	24.735	24.735	24.735	3000.0
2014-09-09 04:15:00	AAPL	Stock	24.7375	24.74	24.7375	24.74	5000.0
2014-09-09 04:16:00	AAPL	Stock	24.7425	24.7425	24.7425	24.7425	3920.0
2014-09-09 04:17:00	AAPL	Stock	24.7425	24.7425	24.7425	24.7425	400.0
2014-09-09 04:18:00	AAPL	Stock	24.75	24.75	24.745	24.745	15500.0
2014-09-09 04:19:00	AAPL	Stock	24.75	24.75	24.75	24.75	5136.0
2014-09-09 04:21:00	AAPL	Stock	24.75	24.75	24.75	24.75	400.0
2014-09-09 04:22:00	AAPL	Stock	24.765	24.765	24.765	24.765	4000.0
2014-09-09 04:23:00	AAPL	Stock	24.75	24.75	24.75	24.75	800.0
2014-09-09 04:25:00	AAPL	Stock	24.7575	24.7575	24.7575	24.7575	800.0
2014-09-09 04:27:00	AAPL	Stock	24.7625	24.7625	24.7625	24.7625	400.0
2014-09-09 04:29:00	AAPL	Stock	24.75	24.75	24.75	24.75	400.0
2014-09-09 04:31:00	AAPL	Stock	24.735	24.735	24.7325	24.7325	10000.0
2014-09-09 04:32:00	AAPL	Stock	24.735	24.735	24.73	24.73	6804.0
2014-09-09 04:33:00	AAPL	Stock	24.725	24.725	24.725	24.725	752.0
2014-09-09 04:34:00	AAPL	Stock	24.735	24.735	24.735	24.735	400.0
2014-09-09 04:35:00	AAPL	Stock	24.735	24.735	24.735	24.735	400.0
2014-09-09 04:38:00	AAPL	Stock	24.7225	24.7225	24.7225	24.7225	1892.0
2014-09-09 04:43:00	AAPL	Stock	24.705	24.705	24.705	24.705	400.0
2014-09-09 04:44:00	AAPL	Stock	24.7175	24.7175	24.7175	24.7175	400.0
2014-09-09 04:48:00	AAPL	Stock	24.7175	24.7175	24.7175	24.7175	400.0
2014-09-09 04:50:00	AAPL	Stock	24.7175	24.7175	24.7175	24.7175	1272.0
2014-09-09 04:58:00	AAPL	Stock	24.7275	24.7275	24.7175	24.7175	920.0
2014-09-09 05:04:00	AAPL	Stock	24.7425	24.7425	24.7175	24.7175	13836.0
2014-09-09 05:07:00	AAPL	Stock	24.7175	24.7175	24.7175	24.7175	6800.0
2014-09-09 05:09:00	AAPL	Stock	24.7025	24.7025	24.7025	24.7025	400.0
2014-09-09 05:17:00	AAPL	Stock	24.7325	24.735	24.7325	24.735	11796.0
2014-09-09 05:18:00	AAPL	Stock	24.735	24.735	24.715	24.715	1600.0
2014-09-09 05:31:00	AAPL	Stock	24.725	24.725	24.715	24.715	8800.0
2014-09-09 05:40:00	AAPL	Stock	24.735	24.735	24.735	24.735	6024.0
2014-09-09 05:41:00	AAPL	Stock	24.735	24.735	24.735	24.735	2000.0
2014-09-09 05:42:00	AAPL	Stock	24.7375	24.7375	24.7275	24.7275	3600.0
2014-09-09 05:44:00	AAPL	Stock	24.7425	24.7425	24.7375	24.7375	3200.0
2014-09-09 05:45:00	AAPL	Stock	24.7275	24.7275	24.725	24.725	3184.0
2014-09-09 05:50:00	AAPL	Stock	24.725	24.725	24.725	24.725	8800.0
2014-09-09 05:51:00	AAPL	Stock	24.735	24.735	24.735	24.735	1200.0
2014-09-09 05:53:00	AAPL	Stock	24.7125	24.7125	24.7125	24.7125	8400.0
2014-09-09 05:56:00	AAPL	Stock	24.7325	24.735	24.7325	24.7325	2000.0
2014-09-09 05:57:00	AAPL	Stock	24.735	24.735	24.735	24.735	800.0
2014-09-09 05:59:00	AAPL	Stock	24.7125	24.7125	24.7125	24.7125	400.0
2014-09-09 06:00:00	AAPL	Stock	24.735	24.735	24.735	24.735	2400.0
2014-09-09 06:01:00	AAPL	Stock	24.7325	24.7325	24.7325	24.7325	4000.0
2014-09-09 06:02:00	AAPL	Stock	24.7325	24.7325	24.7325	24.7325	1940.0
2014-09-09 06:03:00	AAPL	Stock	24.73	24.73	24.705	24.73	2200.0

> showing 50 of 1,043,885 rows — these rows as CSV

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