PREVIEW / stock_1min / 2017-11-01

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-11-01.parquet
  size:    15.2 MB
  rows:    1,086,091
  symbols: 2,431

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-11-01 04:00:00	AAPL	Stock	42.375	42.375	42.375	42.375	1100.0
2017-11-01 04:09:00	AAPL	Stock	42.4025	42.4025	42.4025	42.4025	1080.0
2017-11-01 04:12:00	AAPL	Stock	42.455	42.455	42.455	42.455	400.0
2017-11-01 04:17:00	AAPL	Stock	42.455	42.455	42.455	42.455	1348.0
2017-11-01 04:21:00	AAPL	Stock	42.4625	42.4625	42.4625	42.4625	528.0
2017-11-01 04:22:00	AAPL	Stock	42.4625	42.4625	42.4625	42.4625	17876.0
2017-11-01 04:23:00	AAPL	Stock	42.435	42.435	42.435	42.435	400.0
2017-11-01 04:27:00	AAPL	Stock	42.44	42.44	42.435	42.435	4484.0
2017-11-01 04:39:00	AAPL	Stock	42.4375	42.4375	42.4375	42.4375	1200.0
2017-11-01 04:41:00	AAPL	Stock	42.4375	42.4375	42.4375	42.4375	700.0
2017-11-01 04:51:00	AAPL	Stock	42.425	42.425	42.425	42.425	796.0
2017-11-01 04:59:00	AAPL	Stock	42.3975	42.3975	42.39	42.39	1368.0
2017-11-01 05:28:00	AAPL	Stock	42.405	42.405	42.405	42.405	800.0
2017-11-01 05:40:00	AAPL	Stock	42.38	42.38	42.38	42.38	400.0
2017-11-01 05:49:00	AAPL	Stock	42.43	42.5	42.43	42.5	19788.0
2017-11-01 05:57:00	AAPL	Stock	42.4925	42.4925	42.4925	42.4925	4000.0
2017-11-01 05:59:00	AAPL	Stock	42.4375	42.4375	42.405	42.405	1960.0
2017-11-01 06:02:00	AAPL	Stock	42.485	42.4925	42.485	42.4925	3600.0
2017-11-01 06:04:00	AAPL	Stock	42.5	42.5075	42.5	42.5075	35820.0
2017-11-01 06:05:00	AAPL	Stock	42.525	42.525	42.525	42.525	516.0
2017-11-01 06:11:00	AAPL	Stock	42.525	42.525	42.525	42.525	560.0
2017-11-01 06:12:00	AAPL	Stock	42.5125	42.5125	42.5125	42.5125	1724.0
2017-11-01 06:14:00	AAPL	Stock	42.525	42.525	42.525	42.525	400.0
2017-11-01 06:15:00	AAPL	Stock	42.5475	42.5475	42.5475	42.5475	400.0
2017-11-01 06:16:00	AAPL	Stock	42.5475	42.5475	42.5375	42.5375	3408.0
2017-11-01 06:17:00	AAPL	Stock	42.525	42.525	42.5	42.5	1400.0
2017-11-01 06:18:00	AAPL	Stock	42.5225	42.5225	42.5225	42.5225	400.0
2017-11-01 06:19:00	AAPL	Stock	42.5225	42.5225	42.5225	42.5225	800.0
2017-11-01 06:20:00	AAPL	Stock	42.5225	42.5225	42.5225	42.5225	800.0
2017-11-01 06:25:00	AAPL	Stock	42.52	42.52	42.52	42.52	400.0
2017-11-01 06:31:00	AAPL	Stock	42.52	42.52	42.52	42.52	556.0
2017-11-01 06:32:00	AAPL	Stock	42.4975	42.4975	42.4875	42.4875	3200.0
2017-11-01 06:33:00	AAPL	Stock	42.4525	42.4525	42.4525	42.4525	1200.0
2017-11-01 06:36:00	AAPL	Stock	42.485	42.485	42.485	42.485	4000.0
2017-11-01 06:38:00	AAPL	Stock	42.485	42.485	42.485	42.485	800.0
2017-11-01 06:39:00	AAPL	Stock	42.485	42.485	42.485	42.485	2000.0
2017-11-01 06:41:00	AAPL	Stock	42.47	42.47	42.4675	42.4675	800.0
2017-11-01 06:46:00	AAPL	Stock	42.455	42.455	42.455	42.455	2800.0
2017-11-01 06:49:00	AAPL	Stock	42.44	42.44	42.44	42.44	400.0
2017-11-01 06:51:00	AAPL	Stock	42.46	42.46	42.46	42.46	400.0
2017-11-01 06:53:00	AAPL	Stock	42.4425	42.4425	42.44	42.44	2416.0
2017-11-01 06:54:00	AAPL	Stock	42.44	42.44	42.44	42.44	5200.0
2017-11-01 06:55:00	AAPL	Stock	42.4375	42.4375	42.425	42.425	9744.0
2017-11-01 06:58:00	AAPL	Stock	42.4325	42.4325	42.4325	42.4325	712.0
2017-11-01 07:00:00	AAPL	Stock	42.4375	42.4425	42.4175	42.4425	26180.0
2017-11-01 07:01:00	AAPL	Stock	42.4375	42.46	42.4375	42.4425	28228.0
2017-11-01 07:02:00	AAPL	Stock	42.44	42.45	42.44	42.4425	5164.0
2017-11-01 07:03:00	AAPL	Stock	42.4425	42.4425	42.425	42.4425	5432.0
2017-11-01 07:04:00	AAPL	Stock	42.4425	42.4425	42.4425	42.4425	1584.0
2017-11-01 07:06:00	AAPL	Stock	42.4575	42.4575	42.4575	42.4575	1984.0

> showing 50 of 1,086,091 rows — these rows as CSV

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