PREVIEW / stock_1min / 2018-07-05

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-05.parquet
  size:    14.6 MB
  rows:    1,063,132
  symbols: 2,349

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-07-05 04:00:00	AAPL	Stock	46.1125	46.2	46.1125	46.2	3600.0
2018-07-05 04:08:00	AAPL	Stock	46.2	46.2	46.2	46.2	400.0
2018-07-05 04:09:00	AAPL	Stock	46.2	46.225	46.2	46.225	840.0
2018-07-05 04:23:00	AAPL	Stock	46.25	46.25	46.235	46.235	2400.0
2018-07-05 04:27:00	AAPL	Stock	46.235	46.235	46.235	46.235	3200.0
2018-07-05 04:56:00	AAPL	Stock	46.25	46.25	46.25	46.25	400.0
2018-07-05 05:15:00	AAPL	Stock	46.2375	46.2375	46.2375	46.2375	416.0
2018-07-05 05:16:00	AAPL	Stock	46.2375	46.2375	46.2375	46.2375	800.0
2018-07-05 05:57:00	AAPL	Stock	46.3	46.3	46.3	46.3	2000.0
2018-07-05 06:04:00	AAPL	Stock	46.295	46.295	46.295	46.295	1200.0
2018-07-05 06:05:00	AAPL	Stock	46.25	46.25	46.25	46.25	1180.0
2018-07-05 06:12:00	AAPL	Stock	46.25	46.25	46.25	46.25	480.0
2018-07-05 06:51:00	AAPL	Stock	46.24	46.24	46.24	46.24	1816.0
2018-07-05 06:53:00	AAPL	Stock	46.24	46.24	46.24	46.24	2000.0
2018-07-05 07:01:00	AAPL	Stock	46.2425	46.2675	46.24	46.2675	5240.0
2018-07-05 07:02:00	AAPL	Stock	46.26	46.2625	46.26	46.26	6904.0
2018-07-05 07:03:00	AAPL	Stock	46.26	46.26	46.25	46.25	13836.0
2018-07-05 07:04:00	AAPL	Stock	46.24	46.2475	46.24	46.2475	1988.0
2018-07-05 07:05:00	AAPL	Stock	46.26	46.26	46.26	46.26	2684.0
2018-07-05 07:07:00	AAPL	Stock	46.275	46.275	46.275	46.275	2400.0
2018-07-05 07:12:00	AAPL	Stock	46.2575	46.2575	46.2575	46.2575	2000.0
2018-07-05 07:13:00	AAPL	Stock	46.2875	46.2875	46.2875	46.2875	2000.0
2018-07-05 07:14:00	AAPL	Stock	46.2875	46.2875	46.2875	46.2875	4000.0
2018-07-05 07:15:00	AAPL	Stock	46.2975	46.3	46.2975	46.3	3040.0
2018-07-05 07:18:00	AAPL	Stock	46.3075	46.3075	46.3075	46.3075	11152.0
2018-07-05 07:20:00	AAPL	Stock	46.3025	46.325	46.3025	46.325	11208.0
2018-07-05 07:24:00	AAPL	Stock	46.3	46.3	46.3	46.3	400.0
2018-07-05 07:27:00	AAPL	Stock	46.3	46.3	46.3	46.3	1780.0
2018-07-05 07:28:00	AAPL	Stock	46.3	46.3	46.3	46.3	400.0
2018-07-05 07:30:00	AAPL	Stock	46.3025	46.3025	46.3025	46.3025	800.0
2018-07-05 07:31:00	AAPL	Stock	46.3025	46.3025	46.3025	46.3025	3332.0
2018-07-05 07:32:00	AAPL	Stock	46.3025	46.3025	46.3025	46.3025	1200.0
2018-07-05 07:33:00	AAPL	Stock	46.3025	46.3025	46.3025	46.3025	800.0
2018-07-05 07:34:00	AAPL	Stock	46.3	46.3	46.3	46.3	1000.0
2018-07-05 07:39:00	AAPL	Stock	46.3025	46.3025	46.3025	46.3025	800.0
2018-07-05 07:40:00	AAPL	Stock	46.3	46.3	46.3	46.3	400.0
2018-07-05 07:41:00	AAPL	Stock	46.3	46.3	46.3	46.3	712.0
2018-07-05 07:42:00	AAPL	Stock	46.3025	46.3025	46.3025	46.3025	1188.0
2018-07-05 07:43:00	AAPL	Stock	46.315	46.315	46.315	46.315	400.0
2018-07-05 07:45:00	AAPL	Stock	46.3025	46.3125	46.3025	46.3125	2560.0
2018-07-05 07:46:00	AAPL	Stock	46.31	46.31	46.31	46.31	1200.0
2018-07-05 07:47:00	AAPL	Stock	46.3125	46.3125	46.3125	46.3125	800.0
2018-07-05 07:48:00	AAPL	Stock	46.3125	46.3125	46.3125	46.3125	12812.0
2018-07-05 07:52:00	AAPL	Stock	46.325	46.3375	46.325	46.3375	32480.0
2018-07-05 07:53:00	AAPL	Stock	46.3475	46.35	46.3475	46.35	7576.0
2018-07-05 07:54:00	AAPL	Stock	46.35	46.35	46.35	46.35	1200.0
2018-07-05 07:55:00	AAPL	Stock	46.35	46.35	46.35	46.35	7200.0
2018-07-05 07:56:00	AAPL	Stock	46.35	46.35	46.35	46.35	10020.0
2018-07-05 07:58:00	AAPL	Stock	46.35	46.355	46.35	46.355	800.0
2018-07-05 07:59:00	AAPL	Stock	46.3525	46.3525	46.35	46.35	1992.0

> showing 50 of 1,063,132 rows — these rows as CSV

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