PREVIEW / stock_1min / 2014-10-31

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-10-31.parquet
  size:    16.0 MB
  rows:    1,149,265
  symbols: 2,922

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-10-31 04:00:00	AAPL	Stock	26.75	27.5	26.75	27.125	35020.0
2014-10-31 04:04:00	AAPL	Stock	27.0525	27.0525	27.0525	27.0525	400.0
2014-10-31 04:05:00	AAPL	Stock	27.0525	27.0525	27.0525	27.0525	1600.0
2014-10-31 04:08:00	AAPL	Stock	27.0	27.0	27.0	27.0	3160.0
2014-10-31 04:12:00	AAPL	Stock	26.9625	26.9625	26.9625	26.9625	400.0
2014-10-31 04:13:00	AAPL	Stock	26.9625	26.9625	26.9625	26.9625	1600.0
2014-10-31 04:16:00	AAPL	Stock	26.94	26.94	26.94	26.94	4000.0
2014-10-31 04:17:00	AAPL	Stock	26.94	26.94	26.94	26.94	10400.0
2014-10-31 04:18:00	AAPL	Stock	26.94	26.945	26.94	26.945	5328.0
2014-10-31 04:24:00	AAPL	Stock	26.945	26.945	26.9425	26.9425	7832.0
2014-10-31 04:30:00	AAPL	Stock	26.9675	26.9675	26.9675	26.9675	480.0
2014-10-31 04:31:00	AAPL	Stock	26.9675	26.9675	26.9675	26.9675	5200.0
2014-10-31 04:35:00	AAPL	Stock	26.975	26.975	26.975	26.975	4800.0
2014-10-31 04:39:00	AAPL	Stock	26.9975	27.0	26.9975	27.0	5804.0
2014-10-31 04:55:00	AAPL	Stock	27.0	27.0	27.0	27.0	1600.0
2014-10-31 04:56:00	AAPL	Stock	27.0	27.0	27.0	27.0	800.0
2014-10-31 04:59:00	AAPL	Stock	27.0025	27.0025	27.0025	27.0025	800.0
2014-10-31 05:00:00	AAPL	Stock	27.0025	27.0025	27.0	27.0	800.0
2014-10-31 05:01:00	AAPL	Stock	27.0025	27.0025	27.0025	27.0025	8632.0
2014-10-31 05:05:00	AAPL	Stock	27.0025	27.0025	27.0025	27.0025	10732.0
2014-10-31 05:09:00	AAPL	Stock	27.035	27.035	27.035	27.035	1200.0
2014-10-31 05:18:00	AAPL	Stock	27.04	27.04	27.04	27.04	664.0
2014-10-31 05:21:00	AAPL	Stock	27.0425	27.0425	27.0425	27.0425	4000.0
2014-10-31 05:24:00	AAPL	Stock	27.0625	27.0625	27.0625	27.0625	400.0
2014-10-31 05:25:00	AAPL	Stock	27.1	27.1	27.0625	27.0625	3000.0
2014-10-31 05:30:00	AAPL	Stock	27.0875	27.0875	27.0875	27.0875	400.0
2014-10-31 05:34:00	AAPL	Stock	27.0925	27.1025	27.0925	27.1025	4400.0
2014-10-31 05:35:00	AAPL	Stock	27.11	27.11	27.0875	27.0875	2000.0
2014-10-31 05:41:00	AAPL	Stock	27.0825	27.0825	27.0825	27.0825	800.0
2014-10-31 05:46:00	AAPL	Stock	27.085	27.085	27.08	27.08	4960.0
2014-10-31 05:49:00	AAPL	Stock	27.08	27.08	27.08	27.08	4112.0
2014-10-31 05:59:00	AAPL	Stock	27.075	27.075	27.075	27.075	23600.0
2014-10-31 06:00:00	AAPL	Stock	27.085	27.085	27.085	27.085	1040.0
2014-10-31 06:01:00	AAPL	Stock	27.0925	27.0925	27.0925	27.0925	700.0
2014-10-31 06:05:00	AAPL	Stock	27.075	27.075	27.075	27.075	4000.0
2014-10-31 06:07:00	AAPL	Stock	27.0825	27.0825	27.0825	27.0825	800.0
2014-10-31 06:16:00	AAPL	Stock	27.075	27.075	27.075	27.075	5360.0
2014-10-31 06:19:00	AAPL	Stock	27.085	27.085	27.085	27.085	400.0
2014-10-31 06:30:00	AAPL	Stock	27.0775	27.0775	27.0775	27.0775	800.0
2014-10-31 06:32:00	AAPL	Stock	27.09	27.09	27.09	27.09	400.0
2014-10-31 06:43:00	AAPL	Stock	27.0625	27.0625	27.0625	27.0625	1040.0
2014-10-31 06:50:00	AAPL	Stock	27.0875	27.0875	27.0875	27.0875	5832.0
2014-10-31 06:51:00	AAPL	Stock	27.0625	27.0775	27.0625	27.0775	5680.0
2014-10-31 06:52:00	AAPL	Stock	27.0775	27.0875	27.0775	27.0875	5000.0
2014-10-31 07:00:00	AAPL	Stock	27.0775	27.0775	27.075	27.075	10000.0
2014-10-31 07:01:00	AAPL	Stock	27.075	27.075	27.0625	27.0625	5360.0
2014-10-31 07:02:00	AAPL	Stock	27.0525	27.0525	27.0525	27.0525	6400.0
2014-10-31 07:05:00	AAPL	Stock	27.0375	27.0375	27.0375	27.0375	3600.0
2014-10-31 07:07:00	AAPL	Stock	27.0375	27.0375	27.0375	27.0375	6448.0
2014-10-31 07:08:00	AAPL	Stock	27.0275	27.035	27.0275	27.035	4400.0

> showing 50 of 1,149,265 rows — these rows as CSV

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