PREVIEW / stock_1min / 2018-07-17

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-17.parquet
  size:    14.3 MB
  rows:    1,030,516
  symbols: 2,358

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-17 04:00:00	AAPL	Stock	47.475	47.475	47.475	47.475	400.0
2018-07-17 04:55:00	AAPL	Stock	47.5	47.5	47.5	47.5	416.0
2018-07-17 06:03:00	AAPL	Stock	47.5	47.5	47.5	47.5	400.0
2018-07-17 06:09:00	AAPL	Stock	47.5	47.5	47.5	47.5	400.0
2018-07-17 06:10:00	AAPL	Stock	47.5	47.5	47.5	47.5	2552.0
2018-07-17 06:20:00	AAPL	Stock	47.4725	47.4725	47.4725	47.4725	800.0
2018-07-17 06:27:00	AAPL	Stock	47.45	47.455	47.45	47.45	16128.0
2018-07-17 06:29:00	AAPL	Stock	47.45	47.45	47.45	47.45	4000.0
2018-07-17 06:32:00	AAPL	Stock	47.45	47.45	47.45	47.45	800.0
2018-07-17 06:33:00	AAPL	Stock	47.45	47.45	47.45	47.45	400.0
2018-07-17 06:42:00	AAPL	Stock	47.44	47.44	47.44	47.44	400.0
2018-07-17 06:43:00	AAPL	Stock	47.4375	47.4375	47.4375	47.4375	400.0
2018-07-17 06:51:00	AAPL	Stock	47.43	47.43	47.4	47.4	18828.0
2018-07-17 06:52:00	AAPL	Stock	47.4	47.4	47.4	47.4	400.0
2018-07-17 07:00:00	AAPL	Stock	47.425	47.45	47.425	47.4475	7204.0
2018-07-17 07:01:00	AAPL	Stock	47.4475	47.4475	47.4475	47.4475	1600.0
2018-07-17 07:02:00	AAPL	Stock	47.4475	47.4475	47.4475	47.4475	980.0
2018-07-17 07:05:00	AAPL	Stock	47.4375	47.4375	47.4325	47.4325	2000.0
2018-07-17 07:15:00	AAPL	Stock	47.435	47.435	47.4325	47.4325	1200.0
2018-07-17 07:18:00	AAPL	Stock	47.4475	47.4475	47.44	47.44	6472.0
2018-07-17 07:25:00	AAPL	Stock	47.44	47.44	47.44	47.44	400.0
2018-07-17 07:29:00	AAPL	Stock	47.4475	47.45	47.4475	47.45	20052.0
2018-07-17 07:30:00	AAPL	Stock	47.475	47.4775	47.475	47.4775	1600.0
2018-07-17 07:31:00	AAPL	Stock	47.475	47.475	47.475	47.475	3600.0
2018-07-17 07:33:00	AAPL	Stock	47.48	47.48	47.48	47.48	400.0
2018-07-17 07:34:00	AAPL	Stock	47.475	47.475	47.475	47.475	3600.0
2018-07-17 07:40:00	AAPL	Stock	47.4625	47.4625	47.4625	47.4625	400.0
2018-07-17 07:41:00	AAPL	Stock	47.48	47.48	47.48	47.48	7940.0
2018-07-17 07:42:00	AAPL	Stock	47.5	47.5	47.5	47.5	400.0
2018-07-17 07:43:00	AAPL	Stock	47.5	47.5	47.5	47.5	1356.0
2018-07-17 07:44:00	AAPL	Stock	47.4875	47.4875	47.4875	47.4875	656.0
2018-07-17 07:45:00	AAPL	Stock	47.4875	47.4875	47.4875	47.4875	544.0
2018-07-17 07:47:00	AAPL	Stock	47.505	47.5425	47.505	47.5425	6948.0
2018-07-17 07:49:00	AAPL	Stock	47.5425	47.5425	47.53	47.53	1000.0
2018-07-17 07:55:00	AAPL	Stock	47.5425	47.595	47.5425	47.5875	21540.0
2018-07-17 07:56:00	AAPL	Stock	47.5875	47.5875	47.5875	47.5875	2800.0
2018-07-17 07:58:00	AAPL	Stock	47.5875	47.5875	47.5875	47.5875	1424.0
2018-07-17 07:59:00	AAPL	Stock	47.5875	47.5875	47.5875	47.5875	448.0
2018-07-17 08:00:00	AAPL	Stock	47.595	47.595	47.425	47.5625	35312.0
2018-07-17 08:01:00	AAPL	Stock	47.575	47.575	47.5625	47.5625	1600.0
2018-07-17 08:02:00	AAPL	Stock	47.5675	47.5675	47.5675	47.5675	400.0
2018-07-17 08:07:00	AAPL	Stock	47.5925	47.5925	47.5925	47.5925	400.0
2018-07-17 08:09:00	AAPL	Stock	47.575	47.575	47.575	47.575	11016.0
2018-07-17 08:10:00	AAPL	Stock	47.575	47.575	47.575	47.575	640.0
2018-07-17 08:11:00	AAPL	Stock	47.59	47.59	47.575	47.575	2400.0
2018-07-17 08:12:00	AAPL	Stock	47.5675	47.5675	47.5675	47.5675	788.0
2018-07-17 08:14:00	AAPL	Stock	47.5625	47.5625	47.5625	47.5625	400.0
2018-07-17 08:15:00	AAPL	Stock	47.5675	47.5675	47.5675	47.5675	700.0
2018-07-17 08:16:00	AAPL	Stock	47.57	47.575	47.57	47.575	800.0
2018-07-17 08:17:00	AAPL	Stock	47.575	47.5875	47.5675	47.5875	2908.0

> showing 50 of 1,030,516 rows — these rows as CSV

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