PREVIEW / stock_1min / 2018-06-07

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-06-07.parquet
  size:    15.4 MB
  rows:    1,097,229
  symbols: 2,360

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-06-07 04:00:00	AAPL	Stock	48.5625	48.6125	48.5625	48.6125	3076.0
2018-06-07 04:11:00	AAPL	Stock	48.6125	48.6125	48.6125	48.6125	1600.0
2018-06-07 04:50:00	AAPL	Stock	48.595	48.595	48.5875	48.5875	2368.0
2018-06-07 04:51:00	AAPL	Stock	48.5875	48.5875	48.5875	48.5875	400.0
2018-06-07 04:52:00	AAPL	Stock	48.575	48.575	48.575	48.575	800.0
2018-06-07 04:55:00	AAPL	Stock	48.575	48.575	48.575	48.575	1552.0
2018-06-07 04:56:00	AAPL	Stock	48.575	48.575	48.575	48.575	400.0
2018-06-07 05:14:00	AAPL	Stock	48.575	48.575	48.575	48.575	3636.0
2018-06-07 05:17:00	AAPL	Stock	48.575	48.575	48.575	48.575	400.0
2018-06-07 06:04:00	AAPL	Stock	48.575	48.575	48.575	48.575	440.0
2018-06-07 06:07:00	AAPL	Stock	48.575	48.575	48.575	48.575	3304.0
2018-06-07 07:00:00	AAPL	Stock	48.53	48.54	48.495	48.5	9504.0
2018-06-07 07:01:00	AAPL	Stock	48.5	48.5	48.5	48.5	19960.0
2018-06-07 07:03:00	AAPL	Stock	48.5025	48.5025	48.495	48.495	11108.0
2018-06-07 07:04:00	AAPL	Stock	48.47	48.47	48.47	48.47	1072.0
2018-06-07 07:07:00	AAPL	Stock	48.4725	48.4725	48.47	48.47	3400.0
2018-06-07 07:09:00	AAPL	Stock	48.48	48.48	48.48	48.48	840.0
2018-06-07 07:10:00	AAPL	Stock	48.4925	48.5	48.4925	48.5	5276.0
2018-06-07 07:11:00	AAPL	Stock	48.5125	48.525	48.5125	48.525	6300.0
2018-06-07 07:12:00	AAPL	Stock	48.5225	48.55	48.5225	48.5475	47600.0
2018-06-07 07:18:00	AAPL	Stock	48.535	48.55	48.535	48.55	16296.0
2018-06-07 07:19:00	AAPL	Stock	48.5625	48.575	48.5625	48.575	4032.0
2018-06-07 07:22:00	AAPL	Stock	48.5575	48.5575	48.5575	48.5575	1200.0
2018-06-07 07:23:00	AAPL	Stock	48.56	48.5625	48.56	48.5625	2000.0
2018-06-07 07:24:00	AAPL	Stock	48.54	48.54	48.5375	48.5375	4000.0
2018-06-07 07:27:00	AAPL	Stock	48.5375	48.55	48.5375	48.55	5008.0
2018-06-07 07:28:00	AAPL	Stock	48.55	48.55	48.5375	48.5375	5328.0
2018-06-07 07:29:00	AAPL	Stock	48.5375	48.5375	48.5375	48.5375	400.0
2018-06-07 07:30:00	AAPL	Stock	48.5475	48.5475	48.5475	48.5475	7808.0
2018-06-07 07:32:00	AAPL	Stock	48.5225	48.5225	48.5225	48.5225	400.0
2018-06-07 07:33:00	AAPL	Stock	48.5225	48.5225	48.5225	48.5225	3120.0
2018-06-07 07:34:00	AAPL	Stock	48.515	48.515	48.515	48.515	1480.0
2018-06-07 07:37:00	AAPL	Stock	48.5175	48.5175	48.5175	48.5175	1200.0
2018-06-07 07:38:00	AAPL	Stock	48.5175	48.5175	48.5175	48.5175	400.0
2018-06-07 07:42:00	AAPL	Stock	48.5175	48.5175	48.5175	48.5175	1608.0
2018-06-07 07:43:00	AAPL	Stock	48.515	48.515	48.515	48.515	4284.0
2018-06-07 07:44:00	AAPL	Stock	48.5175	48.5175	48.5175	48.5175	2000.0
2018-06-07 07:47:00	AAPL	Stock	48.515	48.515	48.515	48.515	6000.0
2018-06-07 07:48:00	AAPL	Stock	48.5125	48.5125	48.505	48.5075	7460.0
2018-06-07 07:52:00	AAPL	Stock	48.5075	48.5075	48.5075	48.5075	400.0
2018-06-07 07:53:00	AAPL	Stock	48.5075	48.5075	48.5075	48.5075	3864.0
2018-06-07 07:56:00	AAPL	Stock	48.51	48.51	48.5025	48.5025	6924.0
2018-06-07 07:57:00	AAPL	Stock	48.515	48.515	48.515	48.515	400.0
2018-06-07 07:58:00	AAPL	Stock	48.515	48.515	48.515	48.515	1020.0
2018-06-07 08:00:00	AAPL	Stock	48.5	48.575	48.465	48.52	95996.0
2018-06-07 08:02:00	AAPL	Stock	48.525	48.525	48.525	48.525	800.0
2018-06-07 08:04:00	AAPL	Stock	48.525	48.525	48.485	48.485	8708.0
2018-06-07 08:05:00	AAPL	Stock	48.485	48.485	48.485	48.485	6600.0
2018-06-07 08:06:00	AAPL	Stock	48.4975	48.5	48.4975	48.4975	16580.0
2018-06-07 08:07:00	AAPL	Stock	48.4925	48.4925	48.4925	48.4925	800.0

> showing 50 of 1,097,229 rows — these rows as CSV

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