PREVIEW / stock_1min / 2017-12-26

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-12-26.parquet
  size:    13.6 MB
  rows:    969,182
  symbols: 2,394

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-12-26 04:00:00	AAPL	Stock	43.625	43.625	43.315	43.315	6416.0
2017-12-26 04:01:00	AAPL	Stock	43.3075	43.3075	43.2475	43.2475	2584.0
2017-12-26 04:02:00	AAPL	Stock	43.155	43.155	43.155	43.155	800.0
2017-12-26 04:11:00	AAPL	Stock	43.1	43.125	43.1	43.125	7196.0
2017-12-26 04:12:00	AAPL	Stock	43.125	43.125	43.125	43.125	768.0
2017-12-26 04:18:00	AAPL	Stock	43.125	43.125	43.125	43.125	560.0
2017-12-26 04:32:00	AAPL	Stock	43.185	43.185	43.175	43.175	800.0
2017-12-26 04:35:00	AAPL	Stock	43.175	43.175	43.175	43.175	400.0
2017-12-26 04:36:00	AAPL	Stock	43.15	43.15	43.15	43.15	400.0
2017-12-26 04:37:00	AAPL	Stock	43.15	43.15	43.125	43.125	800.0
2017-12-26 04:49:00	AAPL	Stock	43.05	43.05	43.0	43.0	3732.0
2017-12-26 04:51:00	AAPL	Stock	43.0	43.0	43.0	43.0	400.0
2017-12-26 04:52:00	AAPL	Stock	43.0	43.0	43.0	43.0	400.0
2017-12-26 04:58:00	AAPL	Stock	43.0	43.0	43.0	43.0	3200.0
2017-12-26 04:59:00	AAPL	Stock	42.9375	42.9375	42.9375	42.9375	400.0
2017-12-26 05:01:00	AAPL	Stock	42.9375	42.9375	42.9375	42.9375	988.0
2017-12-26 05:22:00	AAPL	Stock	42.9375	42.9375	42.9375	42.9375	400.0
2017-12-26 05:27:00	AAPL	Stock	42.9425	42.9425	42.9375	42.9375	1200.0
2017-12-26 05:50:00	AAPL	Stock	43.0275	43.0275	43.0275	43.0275	1800.0
2017-12-26 06:01:00	AAPL	Stock	43.005	43.005	43.005	43.005	400.0
2017-12-26 06:05:00	AAPL	Stock	43.025	43.025	43.025	43.025	800.0
2017-12-26 06:08:00	AAPL	Stock	43.0425	43.05	43.0425	43.05	1600.0
2017-12-26 06:09:00	AAPL	Stock	43.0575	43.0575	43.0575	43.0575	400.0
2017-12-26 06:12:00	AAPL	Stock	43.025	43.025	43.0175	43.0175	1600.0
2017-12-26 06:13:00	AAPL	Stock	43.025	43.025	43.025	43.025	400.0
2017-12-26 06:14:00	AAPL	Stock	43.025	43.025	43.015	43.015	1200.0
2017-12-26 06:15:00	AAPL	Stock	43.025	43.05	43.025	43.05	1600.0
2017-12-26 06:16:00	AAPL	Stock	43.05	43.05	43.0375	43.0375	2400.0
2017-12-26 06:17:00	AAPL	Stock	43.0025	43.0025	43.0	43.0	3080.0
2017-12-26 06:22:00	AAPL	Stock	43.04	43.04	43.0	43.0	5884.0
2017-12-26 06:25:00	AAPL	Stock	43.0025	43.0025	43.0025	43.0025	400.0
2017-12-26 06:27:00	AAPL	Stock	43.0	43.0	42.9925	42.9925	1200.0
2017-12-26 06:31:00	AAPL	Stock	42.9975	43.0	42.9625	42.9625	4808.0
2017-12-26 06:34:00	AAPL	Stock	42.94	42.94	42.94	42.94	400.0
2017-12-26 06:36:00	AAPL	Stock	42.94	42.94	42.94	42.94	2800.0
2017-12-26 06:44:00	AAPL	Stock	42.92	42.925	42.92	42.925	2600.0
2017-12-26 06:48:00	AAPL	Stock	42.9025	42.9025	42.8725	42.8725	23880.0
2017-12-26 06:50:00	AAPL	Stock	42.84	42.84	42.75	42.76	16820.0
2017-12-26 06:51:00	AAPL	Stock	42.75	42.775	42.75	42.775	5200.0
2017-12-26 06:52:00	AAPL	Stock	42.7625	42.7625	42.7625	42.7625	800.0
2017-12-26 06:54:00	AAPL	Stock	42.775	42.775	42.6875	42.6875	12800.0
2017-12-26 06:57:00	AAPL	Stock	42.7675	42.77	42.7675	42.77	2400.0
2017-12-26 06:58:00	AAPL	Stock	42.77	42.775	42.75	42.77	22836.0
2017-12-26 06:59:00	AAPL	Stock	42.7975	42.7975	42.7975	42.7975	14400.0
2017-12-26 07:00:00	AAPL	Stock	42.895	42.9	42.835	42.875	43516.0
2017-12-26 07:01:00	AAPL	Stock	42.88	42.925	42.875	42.925	15800.0
2017-12-26 07:02:00	AAPL	Stock	42.9	42.9	42.9	42.9	1200.0
2017-12-26 07:03:00	AAPL	Stock	42.89	42.905	42.89	42.905	4200.0
2017-12-26 07:04:00	AAPL	Stock	42.9025	42.9075	42.9025	42.9075	800.0
2017-12-26 07:06:00	AAPL	Stock	42.9	42.905	42.875	42.9	39784.0

> showing 50 of 969,182 rows — these rows as CSV

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