PREVIEW / stock_1min / 2018-03-27

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-03-27.parquet
  size:    15.7 MB
  rows:    1,111,186
  symbols: 2,393

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-03-27 04:00:00	AAPL	Stock	43.325	43.5025	43.325	43.5025	1600.0
2018-03-27 04:07:00	AAPL	Stock	43.4975	43.5	43.4975	43.5	2800.0
2018-03-27 04:09:00	AAPL	Stock	43.4375	43.4375	43.4375	43.4375	1200.0
2018-03-27 04:10:00	AAPL	Stock	43.4975	43.5	43.4975	43.5	1600.0
2018-03-27 04:18:00	AAPL	Stock	43.5125	43.5125	43.5125	43.5125	1800.0
2018-03-27 04:28:00	AAPL	Stock	43.475	43.475	43.475	43.475	800.0
2018-03-27 04:29:00	AAPL	Stock	43.475	43.475	43.475	43.475	10400.0
2018-03-27 04:31:00	AAPL	Stock	43.5	43.5	43.5	43.5	3200.0
2018-03-27 04:35:00	AAPL	Stock	43.5	43.5	43.5	43.5	400.0
2018-03-27 04:38:00	AAPL	Stock	43.5	43.5	43.5	43.5	3996.0
2018-03-27 04:40:00	AAPL	Stock	43.5025	43.5025	43.5025	43.5025	600.0
2018-03-27 04:50:00	AAPL	Stock	43.55	43.55	43.55	43.55	2388.0
2018-03-27 05:07:00	AAPL	Stock	43.55	43.55	43.55	43.55	400.0
2018-03-27 05:08:00	AAPL	Stock	43.5675	43.5675	43.5675	43.5675	1200.0
2018-03-27 05:14:00	AAPL	Stock	43.5675	43.5675	43.5675	43.5675	880.0
2018-03-27 05:15:00	AAPL	Stock	43.5675	43.5675	43.5675	43.5675	696.0
2018-03-27 05:19:00	AAPL	Stock	43.55	43.55	43.55	43.55	2324.0
2018-03-27 05:36:00	AAPL	Stock	43.5275	43.5275	43.5275	43.5275	1488.0
2018-03-27 05:37:00	AAPL	Stock	43.5175	43.5175	43.5175	43.5175	2000.0
2018-03-27 05:39:00	AAPL	Stock	43.5625	43.57	43.5625	43.57	4696.0
2018-03-27 06:05:00	AAPL	Stock	43.565	43.62	43.56	43.62	1200.0
2018-03-27 06:09:00	AAPL	Stock	43.5575	43.5575	43.55	43.55	1600.0
2018-03-27 06:10:00	AAPL	Stock	43.55	43.55	43.545	43.545	9680.0
2018-03-27 06:11:00	AAPL	Stock	43.525	43.525	43.525	43.525	400.0
2018-03-27 06:14:00	AAPL	Stock	43.515	43.515	43.515	43.515	1440.0
2018-03-27 06:15:00	AAPL	Stock	43.515	43.515	43.515	43.515	6400.0
2018-03-27 06:25:00	AAPL	Stock	43.525	43.525	43.505	43.505	5600.0
2018-03-27 06:30:00	AAPL	Stock	43.51	43.51	43.51	43.51	2400.0
2018-03-27 06:31:00	AAPL	Stock	43.51	43.51	43.51	43.51	4000.0
2018-03-27 06:33:00	AAPL	Stock	43.525	43.525	43.525	43.525	800.0
2018-03-27 06:34:00	AAPL	Stock	43.51	43.51	43.51	43.51	1500.0
2018-03-27 06:42:00	AAPL	Stock	43.5	43.5	43.5	43.5	400.0
2018-03-27 06:44:00	AAPL	Stock	43.49	43.49	43.49	43.49	2000.0
2018-03-27 06:47:00	AAPL	Stock	43.49	43.49	43.49	43.49	800.0
2018-03-27 07:00:00	AAPL	Stock	43.465	43.525	43.465	43.5	12380.0
2018-03-27 07:01:00	AAPL	Stock	43.525	43.525	43.525	43.525	1156.0
2018-03-27 07:02:00	AAPL	Stock	43.525	43.545	43.525	43.545	11012.0
2018-03-27 07:03:00	AAPL	Stock	43.545	43.55	43.545	43.55	3348.0
2018-03-27 07:04:00	AAPL	Stock	43.55	43.5625	43.55	43.5625	13904.0
2018-03-27 07:05:00	AAPL	Stock	43.5825	43.5875	43.5625	43.5825	21600.0
2018-03-27 07:06:00	AAPL	Stock	43.555	43.555	43.555	43.555	400.0
2018-03-27 07:07:00	AAPL	Stock	43.555	43.5825	43.555	43.5825	3220.0
2018-03-27 07:08:00	AAPL	Stock	43.5575	43.5625	43.555	43.5625	6000.0
2018-03-27 07:09:00	AAPL	Stock	43.57	43.585	43.57	43.585	4304.0
2018-03-27 07:10:00	AAPL	Stock	43.585	43.585	43.585	43.585	1336.0
2018-03-27 07:12:00	AAPL	Stock	43.58	43.5825	43.58	43.5825	1572.0
2018-03-27 07:13:00	AAPL	Stock	43.575	43.575	43.575	43.575	10692.0
2018-03-27 07:14:00	AAPL	Stock	43.575	43.58	43.575	43.58	2264.0
2018-03-27 07:15:00	AAPL	Stock	43.58	43.58	43.58	43.58	2168.0
2018-03-27 07:16:00	AAPL	Stock	43.5875	43.5875	43.575	43.575	12016.0

> showing 50 of 1,111,186 rows — these rows as CSV

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