PREVIEW / stock_1min / 2018-11-09

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-11-09.parquet
  size:    15.6 MB
  rows:    1,096,344
  symbols: 2,289

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-11-09 04:00:00	AAPL	Stock	51.72	51.72	51.72	51.72	3016.0
2018-11-09 04:03:00	AAPL	Stock	51.69	51.69	51.69	51.69	1200.0
2018-11-09 04:05:00	AAPL	Stock	51.6	51.6	51.6	51.6	6792.0
2018-11-09 04:06:00	AAPL	Stock	51.6025	51.625	51.6025	51.625	2000.0
2018-11-09 04:53:00	AAPL	Stock	51.6075	51.6075	51.6075	51.6075	400.0
2018-11-09 05:02:00	AAPL	Stock	51.6175	51.6175	51.6175	51.6175	800.0
2018-11-09 05:09:00	AAPL	Stock	51.7175	51.725	51.7175	51.725	8128.0
2018-11-09 05:20:00	AAPL	Stock	51.7	51.7	51.7	51.7	832.0
2018-11-09 05:26:00	AAPL	Stock	51.675	51.675	51.675	51.675	2000.0
2018-11-09 05:42:00	AAPL	Stock	51.65	51.65	51.6375	51.6375	2464.0
2018-11-09 05:43:00	AAPL	Stock	51.625	51.625	51.625	51.625	832.0
2018-11-09 05:49:00	AAPL	Stock	51.625	51.625	51.625	51.625	400.0
2018-11-09 05:56:00	AAPL	Stock	51.6	51.6	51.6	51.6	1600.0
2018-11-09 05:58:00	AAPL	Stock	51.625	51.625	51.625	51.625	800.0
2018-11-09 06:00:00	AAPL	Stock	51.585	51.585	51.585	51.585	600.0
2018-11-09 06:04:00	AAPL	Stock	51.5875	51.5875	51.5825	51.5825	2392.0
2018-11-09 06:16:00	AAPL	Stock	51.535	51.535	51.5175	51.5175	1652.0
2018-11-09 06:18:00	AAPL	Stock	51.55	51.55	51.5375	51.545	4940.0
2018-11-09 06:23:00	AAPL	Stock	51.5625	51.5625	51.5625	51.5625	400.0
2018-11-09 06:24:00	AAPL	Stock	51.5625	51.5625	51.5625	51.5625	800.0
2018-11-09 06:33:00	AAPL	Stock	51.5375	51.5375	51.5175	51.5175	2140.0
2018-11-09 06:34:00	AAPL	Stock	51.52	51.52	51.5175	51.5175	3684.0
2018-11-09 06:41:00	AAPL	Stock	51.5	51.5	51.48	51.48	2600.0
2018-11-09 06:42:00	AAPL	Stock	51.4825	51.4825	51.4825	51.4825	600.0
2018-11-09 06:46:00	AAPL	Stock	51.525	51.555	51.525	51.555	1500.0
2018-11-09 06:53:00	AAPL	Stock	51.5775	51.6225	51.5775	51.6225	1280.0
2018-11-09 06:54:00	AAPL	Stock	51.515	51.515	51.5125	51.5125	3920.0
2018-11-09 06:56:00	AAPL	Stock	51.52	51.52	51.505	51.505	6800.0
2018-11-09 06:57:00	AAPL	Stock	51.5125	51.5125	51.5125	51.5125	400.0
2018-11-09 07:00:00	AAPL	Stock	51.565	51.575	51.525	51.5625	15316.0
2018-11-09 07:01:00	AAPL	Stock	51.595	51.6	51.5875	51.5875	9672.0
2018-11-09 07:02:00	AAPL	Stock	51.6	51.6	51.6	51.6	1200.0
2018-11-09 07:03:00	AAPL	Stock	51.6	51.625	51.6	51.615	5436.0
2018-11-09 07:05:00	AAPL	Stock	51.64	51.64	51.64	51.64	400.0
2018-11-09 07:06:00	AAPL	Stock	51.625	51.625	51.625	51.625	4320.0
2018-11-09 07:08:00	AAPL	Stock	51.6275	51.6275	51.6275	51.6275	7320.0
2018-11-09 07:09:00	AAPL	Stock	51.6225	51.6225	51.6225	51.6225	800.0
2018-11-09 07:11:00	AAPL	Stock	51.6125	51.6125	51.6125	51.6125	1200.0
2018-11-09 07:12:00	AAPL	Stock	51.61	51.625	51.61	51.625	3600.0
2018-11-09 07:13:00	AAPL	Stock	51.6	51.605	51.575	51.575	21116.0
2018-11-09 07:14:00	AAPL	Stock	51.5875	51.615	51.5875	51.615	8916.0
2018-11-09 07:15:00	AAPL	Stock	51.615	51.6275	51.615	51.6275	9680.0
2018-11-09 07:17:00	AAPL	Stock	51.5975	51.6	51.585	51.585	2672.0
2018-11-09 07:18:00	AAPL	Stock	51.595	51.6	51.56	51.56	15940.0
2018-11-09 07:19:00	AAPL	Stock	51.55	51.55	51.55	51.55	400.0
2018-11-09 07:20:00	AAPL	Stock	51.5375	51.57	51.5375	51.565	2000.0
2018-11-09 07:21:00	AAPL	Stock	51.545	51.545	51.5	51.505	27736.0
2018-11-09 07:22:00	AAPL	Stock	51.5	51.5	51.4825	51.49	18380.0
2018-11-09 07:23:00	AAPL	Stock	51.5	51.5	51.5	51.5	3064.0
2018-11-09 07:24:00	AAPL	Stock	51.5125	51.5125	51.4925	51.5	20296.0

> showing 50 of 1,096,344 rows — these rows as CSV

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