PREVIEW / stock_1min / 2018-07-19

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-19.parquet
  size:    14.5 MB
  rows:    1,052,130
  symbols: 2,338

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-19 06:03:00	AAPL	Stock	47.55	47.55	47.55	47.55	400.0
2018-07-19 06:07:00	AAPL	Stock	47.5525	47.5525	47.55	47.55	8148.0
2018-07-19 06:08:00	AAPL	Stock	47.55	47.55	47.55	47.55	2616.0
2018-07-19 06:16:00	AAPL	Stock	47.545	47.55	47.545	47.545	1492.0
2018-07-19 06:17:00	AAPL	Stock	47.54	47.5425	47.54	47.5425	2172.0
2018-07-19 06:18:00	AAPL	Stock	47.5375	47.5375	47.5375	47.5375	400.0
2018-07-19 06:23:00	AAPL	Stock	47.5325	47.5325	47.5	47.5	5528.0
2018-07-19 06:24:00	AAPL	Stock	47.5	47.5	47.475	47.475	2800.0
2018-07-19 06:27:00	AAPL	Stock	47.5	47.5	47.5	47.5	400.0
2018-07-19 06:28:00	AAPL	Stock	47.5	47.5	47.5	47.5	2000.0
2018-07-19 06:52:00	AAPL	Stock	47.4875	47.4875	47.4875	47.4875	3400.0
2018-07-19 07:00:00	AAPL	Stock	47.5375	47.5575	47.5375	47.55	3304.0
2018-07-19 07:01:00	AAPL	Stock	47.55	47.55	47.55	47.55	400.0
2018-07-19 07:07:00	AAPL	Stock	47.575	47.6	47.575	47.6	23072.0
2018-07-19 07:08:00	AAPL	Stock	47.6	47.6	47.6	47.6	2000.0
2018-07-19 07:10:00	AAPL	Stock	47.6225	47.625	47.6225	47.625	3552.0
2018-07-19 07:12:00	AAPL	Stock	47.6075	47.6075	47.6	47.6	12008.0
2018-07-19 07:13:00	AAPL	Stock	47.5975	47.5975	47.5975	47.5975	4000.0
2018-07-19 07:19:00	AAPL	Stock	47.5775	47.5775	47.575	47.575	57864.0
2018-07-19 07:20:00	AAPL	Stock	47.55	47.5525	47.55	47.5525	1200.0
2018-07-19 07:25:00	AAPL	Stock	47.5525	47.5525	47.5525	47.5525	1376.0
2018-07-19 07:27:00	AAPL	Stock	47.5525	47.5625	47.55	47.5625	9900.0
2018-07-19 07:30:00	AAPL	Stock	47.55	47.55	47.55	47.55	3724.0
2018-07-19 07:31:00	AAPL	Stock	47.575	47.5875	47.575	47.5875	800.0
2018-07-19 07:32:00	AAPL	Stock	47.5875	47.5975	47.5875	47.5975	8124.0
2018-07-19 07:44:00	AAPL	Stock	47.5775	47.5775	47.5775	47.5775	400.0
2018-07-19 07:45:00	AAPL	Stock	47.575	47.575	47.575	47.575	656.0
2018-07-19 07:46:00	AAPL	Stock	47.575	47.575	47.575	47.575	4944.0
2018-07-19 07:49:00	AAPL	Stock	47.5625	47.5625	47.5425	47.5425	1600.0
2018-07-19 07:51:00	AAPL	Stock	47.545	47.545	47.5425	47.5425	800.0
2018-07-19 07:52:00	AAPL	Stock	47.5575	47.5625	47.5575	47.5625	4768.0
2018-07-19 07:54:00	AAPL	Stock	47.545	47.545	47.5375	47.5375	2000.0
2018-07-19 07:55:00	AAPL	Stock	47.54	47.54	47.5375	47.5375	1200.0
2018-07-19 07:56:00	AAPL	Stock	47.525	47.525	47.5	47.5025	87192.0
2018-07-19 07:57:00	AAPL	Stock	47.5075	47.5075	47.5	47.5	38364.0
2018-07-19 07:58:00	AAPL	Stock	47.5	47.5	47.5	47.5	1600.0
2018-07-19 07:59:00	AAPL	Stock	47.5	47.5	47.5	47.5	400.0
2018-07-19 08:00:00	AAPL	Stock	47.5188	47.5975	47.5188	47.5425	18456.0
2018-07-19 08:01:00	AAPL	Stock	47.5	47.5	47.4875	47.4875	1600.0
2018-07-19 08:02:00	AAPL	Stock	47.4875	47.4875	47.4775	47.4775	2256.0
2018-07-19 08:03:00	AAPL	Stock	47.4775	47.4775	47.475	47.475	3956.0
2018-07-19 08:05:00	AAPL	Stock	47.4925	47.4925	47.4925	47.4925	1600.0
2018-07-19 08:12:00	AAPL	Stock	47.495	47.495	47.495	47.495	580.0
2018-07-19 08:13:00	AAPL	Stock	47.495	47.5	47.495	47.5	2000.0
2018-07-19 08:16:00	AAPL	Stock	47.5	47.5	47.5	47.5	4400.0
2018-07-19 08:17:00	AAPL	Stock	47.5	47.5	47.5	47.5	400.0
2018-07-19 08:18:00	AAPL	Stock	47.5025	47.5025	47.5	47.5	5600.0
2018-07-19 08:20:00	AAPL	Stock	47.5025	47.5025	47.5025	47.5025	1200.0
2018-07-19 08:21:00	AAPL	Stock	47.4925	47.4925	47.4825	47.4825	3920.0
2018-07-19 08:23:00	AAPL	Stock	47.4775	47.4775	47.475	47.475	1100.0

> showing 50 of 1,052,130 rows — these rows as CSV

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