PREVIEW / stock_1min / 2017-10-04

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-04.parquet
  size:    14.4 MB
  rows:    1,039,260
  symbols: 2,451

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-10-04 05:30:00	AAPL	Stock	38.625	38.6325	38.625	38.6325	4520.0
2017-10-04 05:31:00	AAPL	Stock	38.65	38.65	38.65	38.65	4400.0
2017-10-04 05:37:00	AAPL	Stock	38.6625	38.6625	38.6625	38.6625	620.0
2017-10-04 06:23:00	AAPL	Stock	38.635	38.635	38.635	38.635	400.0
2017-10-04 06:28:00	AAPL	Stock	38.6325	38.6325	38.6325	38.6325	528.0
2017-10-04 06:48:00	AAPL	Stock	38.6275	38.6275	38.625	38.625	37200.0
2017-10-04 06:52:00	AAPL	Stock	38.6	38.6	38.6	38.6	1200.0
2017-10-04 06:53:00	AAPL	Stock	38.6	38.6	38.5775	38.5775	1820.0
2017-10-04 06:59:00	AAPL	Stock	38.585	38.585	38.585	38.585	800.0
2017-10-04 07:02:00	AAPL	Stock	38.6	38.62	38.5975	38.6125	35516.0
2017-10-04 07:07:00	AAPL	Stock	38.6025	38.6025	38.6025	38.6025	660.0
2017-10-04 07:09:00	AAPL	Stock	38.58	38.58	38.58	38.58	2000.0
2017-10-04 07:10:00	AAPL	Stock	38.58	38.58	38.575	38.575	800.0
2017-10-04 07:14:00	AAPL	Stock	38.5725	38.5875	38.5725	38.5875	6872.0
2017-10-04 07:15:00	AAPL	Stock	38.575	38.575	38.5475	38.5475	8728.0
2017-10-04 07:20:00	AAPL	Stock	38.5375	38.5375	38.5375	38.5375	1200.0
2017-10-04 07:21:00	AAPL	Stock	38.55	38.55	38.55	38.55	5600.0
2017-10-04 07:23:00	AAPL	Stock	38.5125	38.5125	38.4775	38.5	24012.0
2017-10-04 07:24:00	AAPL	Stock	38.4725	38.4875	38.4725	38.4875	5200.0
2017-10-04 07:25:00	AAPL	Stock	38.4825	38.4825	38.455	38.4625	2256.0
2017-10-04 07:26:00	AAPL	Stock	38.45	38.4525	38.45	38.45	9556.0
2017-10-04 07:27:00	AAPL	Stock	38.45	38.45	38.445	38.445	6160.0
2017-10-04 07:28:00	AAPL	Stock	38.43	38.43	38.38	38.38	10800.0
2017-10-04 07:29:00	AAPL	Stock	38.425	38.425	38.425	38.425	800.0
2017-10-04 07:30:00	AAPL	Stock	38.425	38.425	38.375	38.375	10944.0
2017-10-04 07:31:00	AAPL	Stock	38.365	38.365	38.36	38.36	11344.0
2017-10-04 07:34:00	AAPL	Stock	38.355	38.355	38.3275	38.3275	9160.0
2017-10-04 07:35:00	AAPL	Stock	38.375	38.375	38.375	38.375	400.0
2017-10-04 07:36:00	AAPL	Stock	38.35	38.3525	38.35	38.35	8060.0
2017-10-04 07:37:00	AAPL	Stock	38.35	38.35	38.35	38.35	6340.0
2017-10-04 07:42:00	AAPL	Stock	38.375	38.375	38.375	38.375	3200.0
2017-10-04 07:43:00	AAPL	Stock	38.375	38.375	38.375	38.375	2144.0
2017-10-04 07:44:00	AAPL	Stock	38.4	38.4	38.4	38.4	5600.0
2017-10-04 07:45:00	AAPL	Stock	38.4375	38.45	38.4375	38.45	9708.0
2017-10-04 07:46:00	AAPL	Stock	38.4075	38.4075	38.375	38.375	21200.0
2017-10-04 07:48:00	AAPL	Stock	38.375	38.4225	38.375	38.4225	4100.0
2017-10-04 07:49:00	AAPL	Stock	38.425	38.425	38.425	38.425	400.0
2017-10-04 07:50:00	AAPL	Stock	38.435	38.435	38.435	38.435	2656.0
2017-10-04 07:52:00	AAPL	Stock	38.4375	38.4625	38.4375	38.4625	4400.0
2017-10-04 07:53:00	AAPL	Stock	38.4375	38.4375	38.425	38.425	10052.0
2017-10-04 07:55:00	AAPL	Stock	38.45	38.4625	38.45	38.4625	4444.0
2017-10-04 07:56:00	AAPL	Stock	38.4625	38.475	38.4625	38.475	12400.0
2017-10-04 07:57:00	AAPL	Stock	38.475	38.475	38.4625	38.4625	25104.0
2017-10-04 07:58:00	AAPL	Stock	38.4925	38.5	38.4675	38.4675	16420.0
2017-10-04 07:59:00	AAPL	Stock	38.4775	38.4775	38.4675	38.4675	3140.0
2017-10-04 08:00:00	AAPL	Stock	38.575	38.5975	38.3275	38.5	26912.0
2017-10-04 08:01:00	AAPL	Stock	38.4675	38.47	38.465	38.465	4000.0
2017-10-04 08:02:00	AAPL	Stock	38.495	38.705	38.495	38.5	33400.0
2017-10-04 08:04:00	AAPL	Stock	38.4825	38.4825	38.475	38.475	5780.0
2017-10-04 08:12:00	AAPL	Stock	38.465	38.47	38.4625	38.465	22056.0

> showing 50 of 1,039,260 rows — these rows as CSV

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