PREVIEW / stock_1min / 2018-08-14

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-08-14.parquet
  size:    14.7 MB
  rows:    1,048,740
  symbols: 2,347

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-08-14 04:11:00	AAPL	Stock	52.5025	52.5025	52.5025	52.5025	1208.0
2018-08-14 04:12:00	AAPL	Stock	52.5875	52.5875	52.5825	52.5825	1200.0
2018-08-14 04:33:00	AAPL	Stock	52.5075	52.5075	52.5075	52.5075	1372.0
2018-08-14 04:46:00	AAPL	Stock	52.5	52.5	52.5	52.5	996.0
2018-08-14 04:47:00	AAPL	Stock	52.5	52.5	52.5	52.5	1200.0
2018-08-14 04:49:00	AAPL	Stock	52.5	52.5	52.5	52.5	800.0
2018-08-14 05:29:00	AAPL	Stock	52.5375	52.5375	52.5375	52.5375	476.0
2018-08-14 05:50:00	AAPL	Stock	52.5	52.5	52.5	52.5	400.0
2018-08-14 06:14:00	AAPL	Stock	52.55	52.55	52.55	52.55	568.0
2018-08-14 06:16:00	AAPL	Stock	52.5	52.5	52.5	52.5	400.0
2018-08-14 06:26:00	AAPL	Stock	52.5625	52.5625	52.5625	52.5625	768.0
2018-08-14 06:31:00	AAPL	Stock	52.585	52.5875	52.585	52.5875	10344.0
2018-08-14 06:33:00	AAPL	Stock	52.605	52.6075	52.605	52.6075	2180.0
2018-08-14 06:35:00	AAPL	Stock	52.585	52.5875	52.585	52.585	8800.0
2018-08-14 06:36:00	AAPL	Stock	52.5875	52.5875	52.5875	52.5875	2000.0
2018-08-14 06:38:00	AAPL	Stock	52.55	52.55	52.55	52.55	400.0
2018-08-14 06:39:00	AAPL	Stock	52.55	52.55	52.55	52.55	400.0
2018-08-14 06:40:00	AAPL	Stock	52.585	52.6	52.585	52.6	7200.0
2018-08-14 06:50:00	AAPL	Stock	52.585	52.585	52.585	52.585	400.0
2018-08-14 06:57:00	AAPL	Stock	52.5775	52.58	52.575	52.575	12808.0
2018-08-14 07:00:00	AAPL	Stock	52.555	52.555	52.5375	52.5375	3608.0
2018-08-14 07:01:00	AAPL	Stock	52.535	52.535	52.535	52.535	1200.0
2018-08-14 07:02:00	AAPL	Stock	52.54	52.56	52.54	52.56	6608.0
2018-08-14 07:03:00	AAPL	Stock	52.55	52.55	52.55	52.55	800.0
2018-08-14 07:04:00	AAPL	Stock	52.5575	52.5575	52.5425	52.5425	6200.0
2018-08-14 07:05:00	AAPL	Stock	52.5525	52.5525	52.55	52.55	1200.0
2018-08-14 07:07:00	AAPL	Stock	52.55	52.55	52.5475	52.5475	6540.0
2018-08-14 07:09:00	AAPL	Stock	52.5425	52.5425	52.53	52.53	4800.0
2018-08-14 07:10:00	AAPL	Stock	52.525	52.5475	52.525	52.5475	6608.0
2018-08-14 07:11:00	AAPL	Stock	52.525	52.525	52.525	52.525	800.0
2018-08-14 07:15:00	AAPL	Stock	52.5275	52.5275	52.525	52.525	4944.0
2018-08-14 07:17:00	AAPL	Stock	52.5475	52.55	52.5475	52.55	2772.0
2018-08-14 07:18:00	AAPL	Stock	52.56	52.56	52.56	52.56	2800.0
2018-08-14 07:24:00	AAPL	Stock	52.535	52.535	52.535	52.535	800.0
2018-08-14 07:25:00	AAPL	Stock	52.5475	52.56	52.5475	52.56	8316.0
2018-08-14 07:30:00	AAPL	Stock	52.5275	52.5275	52.5275	52.5275	400.0
2018-08-14 07:31:00	AAPL	Stock	52.5275	52.5275	52.51	52.51	1480.0
2018-08-14 07:32:00	AAPL	Stock	52.5125	52.5125	52.5125	52.5125	400.0
2018-08-14 07:33:00	AAPL	Stock	52.5075	52.5075	52.5075	52.5075	2800.0
2018-08-14 07:36:00	AAPL	Stock	52.5275	52.5275	52.5275	52.5275	1700.0
2018-08-14 07:37:00	AAPL	Stock	52.5075	52.5075	52.5	52.5	2536.0
2018-08-14 07:38:00	AAPL	Stock	52.485	52.485	52.485	52.485	800.0
2018-08-14 07:39:00	AAPL	Stock	52.475	52.475	52.475	52.475	400.0
2018-08-14 07:40:00	AAPL	Stock	52.475	52.475	52.475	52.475	800.0
2018-08-14 07:41:00	AAPL	Stock	52.475	52.475	52.475	52.475	800.0
2018-08-14 07:42:00	AAPL	Stock	52.475	52.475	52.465	52.465	1004.0
2018-08-14 07:47:00	AAPL	Stock	52.4825	52.485	52.4825	52.485	2000.0
2018-08-14 07:50:00	AAPL	Stock	52.475	52.475	52.475	52.475	400.0
2018-08-14 07:52:00	AAPL	Stock	52.48	52.48	52.48	52.48	412.0
2018-08-14 07:53:00	AAPL	Stock	52.4875	52.4875	52.4875	52.4875	800.0

> showing 50 of 1,048,740 rows — these rows as CSV

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