PREVIEW / stock_1min / 2017-09-07

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-07.parquet
  size:    14.4 MB
  rows:    1,052,142
  symbols: 2,470

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
2017-09-07 04:44:00	AAPL	Stock	40.5	40.5	40.5	40.5	592.0
2017-09-07 05:03:00	AAPL	Stock	40.5	40.5	40.5	40.5	840.0
2017-09-07 05:08:00	AAPL	Stock	40.5	40.5	40.4875	40.4875	5752.0
2017-09-07 05:09:00	AAPL	Stock	40.5	40.5	40.5	40.5	8000.0
2017-09-07 05:12:00	AAPL	Stock	40.5	40.5	40.5	40.5	3600.0
2017-09-07 05:13:00	AAPL	Stock	40.5	40.5	40.5	40.5	3204.0
2017-09-07 05:24:00	AAPL	Stock	40.5	40.5	40.5	40.5	2000.0
2017-09-07 05:28:00	AAPL	Stock	40.4875	40.4875	40.4875	40.4875	400.0
2017-09-07 05:31:00	AAPL	Stock	40.4875	40.4875	40.4875	40.4875	1040.0
2017-09-07 05:38:00	AAPL	Stock	40.4875	40.4875	40.4875	40.4875	400.0
2017-09-07 05:39:00	AAPL	Stock	40.4875	40.4875	40.4875	40.4875	400.0
2017-09-07 05:40:00	AAPL	Stock	40.55	40.55	40.55	40.55	3600.0
2017-09-07 05:54:00	AAPL	Stock	40.5	40.5	40.5	40.5	3400.0
2017-09-07 05:58:00	AAPL	Stock	40.5	40.5	40.5	40.5	3200.0
2017-09-07 06:05:00	AAPL	Stock	40.515	40.515	40.515	40.515	1732.0
2017-09-07 06:23:00	AAPL	Stock	40.5325	40.535	40.5325	40.5325	2800.0
2017-09-07 06:24:00	AAPL	Stock	40.5375	40.5375	40.5375	40.5375	4400.0
2017-09-07 06:25:00	AAPL	Stock	40.5475	40.55	40.5475	40.55	800.0
2017-09-07 06:26:00	AAPL	Stock	40.55	40.55	40.55	40.55	948.0
2017-09-07 06:51:00	AAPL	Stock	40.55	40.55	40.55	40.55	1936.0
2017-09-07 06:54:00	AAPL	Stock	40.56	40.56	40.55	40.55	4388.0
2017-09-07 06:57:00	AAPL	Stock	40.56	40.56	40.56	40.56	1200.0
2017-09-07 07:08:00	AAPL	Stock	40.5325	40.535	40.5325	40.535	1200.0
2017-09-07 07:11:00	AAPL	Stock	40.535	40.5425	40.5325	40.5425	2000.0
2017-09-07 07:13:00	AAPL	Stock	40.5375	40.5375	40.535	40.535	8000.0
2017-09-07 07:14:00	AAPL	Stock	40.535	40.535	40.535	40.535	400.0
2017-09-07 07:15:00	AAPL	Stock	40.535	40.535	40.535	40.535	4420.0
2017-09-07 07:16:00	AAPL	Stock	40.5325	40.5325	40.5325	40.5325	736.0
2017-09-07 07:24:00	AAPL	Stock	40.52	40.5325	40.52	40.52	3940.0
2017-09-07 07:28:00	AAPL	Stock	40.515	40.515	40.5075	40.5075	5600.0
2017-09-07 07:29:00	AAPL	Stock	40.5125	40.5125	40.5125	40.5125	1800.0
2017-09-07 07:30:00	AAPL	Stock	40.5	40.5	40.5	40.5	400.0
2017-09-07 07:41:00	AAPL	Stock	40.5	40.5	40.5	40.5	3344.0
2017-09-07 07:47:00	AAPL	Stock	40.5	40.5	40.5	40.5	2000.0
2017-09-07 07:48:00	AAPL	Stock	40.5	40.5	40.5	40.5	2400.0
2017-09-07 07:49:00	AAPL	Stock	40.5	40.5	40.5	40.5	468.0
2017-09-07 07:50:00	AAPL	Stock	40.515	40.515	40.4975	40.5	4268.0
2017-09-07 07:53:00	AAPL	Stock	40.5125	40.5125	40.5125	40.5125	800.0
2017-09-07 07:56:00	AAPL	Stock	40.4875	40.4875	40.4875	40.4875	400.0
2017-09-07 08:00:00	AAPL	Stock	40.5125	40.535	40.5	40.5025	61864.0
2017-09-07 08:01:00	AAPL	Stock	40.5025	40.5025	40.5	40.5	5424.0
2017-09-07 08:02:00	AAPL	Stock	40.5	40.5	40.5	40.5	3600.0
2017-09-07 08:04:00	AAPL	Stock	40.4925	40.505	40.475	40.475	13096.0
2017-09-07 08:05:00	AAPL	Stock	40.48	40.48	40.475	40.475	3400.0
2017-09-07 08:06:00	AAPL	Stock	40.4875	40.4875	40.45	40.475	30152.0
2017-09-07 08:08:00	AAPL	Stock	40.45	40.45	40.45	40.45	648.0
2017-09-07 08:12:00	AAPL	Stock	40.45	40.45	40.45	40.45	800.0
2017-09-07 08:15:00	AAPL	Stock	40.4525	40.4525	40.4525	40.4525	400.0
2017-09-07 08:18:00	AAPL	Stock	40.4725	40.4725	40.4725	40.4725	3996.0
2017-09-07 08:19:00	AAPL	Stock	40.4525	40.4525	40.4525	40.4525	1600.0

> showing 50 of 1,052,142 rows — these rows as CSV

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