PREVIEW / stock_1min / 2018-08-06

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-08-06.parquet
  size:    14.3 MB
  rows:    1,027,186
  symbols: 2,334

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
2018-08-06 04:00:00	AAPL	Stock	52.0175	52.05	52.0175	52.05	1576.0
2018-08-06 04:20:00	AAPL	Stock	52.06	52.06	52.06	52.06	720.0
2018-08-06 04:29:00	AAPL	Stock	52.0475	52.0475	52.0475	52.0475	1200.0
2018-08-06 04:51:00	AAPL	Stock	52.0	52.0	51.9975	51.9975	2536.0
2018-08-06 04:58:00	AAPL	Stock	51.925	51.925	51.925	51.925	2000.0
2018-08-06 05:00:00	AAPL	Stock	51.92	51.92	51.92	51.92	400.0
2018-08-06 05:16:00	AAPL	Stock	51.9475	51.95	51.9475	51.95	2000.0
2018-08-06 05:20:00	AAPL	Stock	51.9	51.9	51.8875	51.8875	9236.0
2018-08-06 05:23:00	AAPL	Stock	51.9375	51.9375	51.9375	51.9375	456.0
2018-08-06 05:49:00	AAPL	Stock	51.99	51.99	51.99	51.99	2608.0
2018-08-06 05:50:00	AAPL	Stock	51.99	51.99	51.99	51.99	1276.0
2018-08-06 05:51:00	AAPL	Stock	52.0	52.0	52.0	52.0	888.0
2018-08-06 06:14:00	AAPL	Stock	52.0	52.0	52.0	52.0	400.0
2018-08-06 06:30:00	AAPL	Stock	52.025	52.05	52.025	52.05	8800.0
2018-08-06 06:34:00	AAPL	Stock	52.015	52.015	52.0	52.0	11508.0
2018-08-06 07:00:00	AAPL	Stock	52.03	52.0775	52.0225	52.0725	6940.0
2018-08-06 07:01:00	AAPL	Stock	52.0725	52.0725	52.0225	52.0225	23052.0
2018-08-06 07:02:00	AAPL	Stock	52.0575	52.07	52.0575	52.06	13600.0
2018-08-06 07:03:00	AAPL	Stock	52.075	52.075	52.07	52.07	800.0
2018-08-06 07:04:00	AAPL	Stock	52.0675	52.0675	52.0625	52.0625	2204.0
2018-08-06 07:05:00	AAPL	Stock	52.05	52.05	52.05	52.05	800.0
2018-08-06 07:06:00	AAPL	Stock	52.05	52.05	52.05	52.05	3108.0
2018-08-06 07:07:00	AAPL	Stock	52.0575	52.0575	52.0575	52.0575	10000.0
2018-08-06 07:08:00	AAPL	Stock	52.0575	52.0575	52.0575	52.0575	4000.0
2018-08-06 07:09:00	AAPL	Stock	52.05	52.05	52.05	52.05	2000.0
2018-08-06 07:14:00	AAPL	Stock	52.0575	52.0625	52.0275	52.0275	15136.0
2018-08-06 07:16:00	AAPL	Stock	52.0475	52.0475	52.0475	52.0475	5160.0
2018-08-06 07:17:00	AAPL	Stock	52.0475	52.0475	52.0475	52.0475	1200.0
2018-08-06 07:20:00	AAPL	Stock	52.03	52.03	52.03	52.03	1960.0
2018-08-06 07:22:00	AAPL	Stock	52.0475	52.0475	52.0475	52.0475	488.0
2018-08-06 07:23:00	AAPL	Stock	52.0625	52.0675	52.0625	52.0675	5696.0
2018-08-06 07:24:00	AAPL	Stock	52.0675	52.0675	52.0675	52.0675	1996.0
2018-08-06 07:29:00	AAPL	Stock	52.05	52.05	52.05	52.05	488.0
2018-08-06 07:30:00	AAPL	Stock	52.05	52.05	52.05	52.05	588.0
2018-08-06 07:31:00	AAPL	Stock	52.0625	52.0625	52.0625	52.0625	800.0
2018-08-06 07:32:00	AAPL	Stock	52.0625	52.0625	52.0625	52.0625	3600.0
2018-08-06 07:33:00	AAPL	Stock	52.07	52.075	52.07	52.075	2280.0
2018-08-06 07:34:00	AAPL	Stock	52.0625	52.0775	52.0625	52.0625	2644.0
2018-08-06 07:35:00	AAPL	Stock	52.0625	52.0625	52.0625	52.0625	13200.0
2018-08-06 07:37:00	AAPL	Stock	52.05	52.05	52.05	52.05	400.0
2018-08-06 07:41:00	AAPL	Stock	52.05	52.05	52.0375	52.0375	4300.0
2018-08-06 07:42:00	AAPL	Stock	52.0375	52.05	52.0375	52.0375	5292.0
2018-08-06 07:43:00	AAPL	Stock	52.0375	52.0375	52.0325	52.0325	4400.0
2018-08-06 07:50:00	AAPL	Stock	52.0325	52.0325	52.0325	52.0325	400.0
2018-08-06 07:52:00	AAPL	Stock	52.045	52.05	52.045	52.05	4732.0
2018-08-06 07:54:00	AAPL	Stock	52.055	52.055	52.05	52.05	7200.0
2018-08-06 07:58:00	AAPL	Stock	52.0375	52.0475	52.02	52.0475	10276.0
2018-08-06 07:59:00	AAPL	Stock	52.0425	52.0425	52.0425	52.0425	400.0
2018-08-06 08:00:00	AAPL	Stock	52.075	52.0775	51.9975	51.9975	92436.0
2018-08-06 08:01:00	AAPL	Stock	52.04	52.04	52.04	52.04	1476.0

> showing 50 of 1,027,186 rows — these rows as CSV

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