PREVIEW / stock_1min / 2018-04-24

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-24.parquet
  size:    15.4 MB
  rows:    1,092,129
  symbols: 2,378

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-04-24 04:00:00	AAPL	Stock	41.4975	41.4975	41.375	41.375	17996.0
2018-04-24 04:01:00	AAPL	Stock	41.3725	41.3725	41.3725	41.3725	400.0
2018-04-24 04:05:00	AAPL	Stock	41.375	41.4375	41.375	41.4375	5260.0
2018-04-24 04:18:00	AAPL	Stock	41.425	41.425	41.425	41.425	640.0
2018-04-24 04:20:00	AAPL	Stock	41.4225	41.4225	41.4225	41.4225	400.0
2018-04-24 04:30:00	AAPL	Stock	41.45	41.45	41.45	41.45	400.0
2018-04-24 04:46:00	AAPL	Stock	41.46	41.46	41.46	41.46	4884.0
2018-04-24 04:47:00	AAPL	Stock	41.4875	41.4875	41.465	41.465	800.0
2018-04-24 04:48:00	AAPL	Stock	41.4875	41.4875	41.4875	41.4875	2000.0
2018-04-24 04:50:00	AAPL	Stock	41.4875	41.5425	41.4875	41.5425	2460.0
2018-04-24 04:51:00	AAPL	Stock	41.5425	41.5425	41.5425	41.5425	400.0
2018-04-24 04:53:00	AAPL	Stock	41.5425	41.5425	41.5425	41.5425	400.0
2018-04-24 05:16:00	AAPL	Stock	41.5425	41.5425	41.5425	41.5425	1108.0
2018-04-24 05:26:00	AAPL	Stock	41.525	41.525	41.525	41.525	800.0
2018-04-24 05:53:00	AAPL	Stock	41.525	41.525	41.525	41.525	400.0
2018-04-24 06:03:00	AAPL	Stock	41.55	41.55	41.55	41.55	400.0
2018-04-24 06:05:00	AAPL	Stock	41.55	41.55	41.55	41.55	1600.0
2018-04-24 06:06:00	AAPL	Stock	41.55	41.55	41.55	41.55	400.0
2018-04-24 06:08:00	AAPL	Stock	41.5	41.5	41.5	41.5	800.0
2018-04-24 06:10:00	AAPL	Stock	41.505	41.505	41.5025	41.5025	4176.0
2018-04-24 06:11:00	AAPL	Stock	41.5	41.5	41.5	41.5	11060.0
2018-04-24 06:13:00	AAPL	Stock	41.5475	41.5475	41.5475	41.5475	400.0
2018-04-24 06:21:00	AAPL	Stock	41.56	41.56	41.56	41.56	2000.0
2018-04-24 06:38:00	AAPL	Stock	41.575	41.575	41.575	41.575	800.0
2018-04-24 06:51:00	AAPL	Stock	41.54	41.54	41.54	41.54	1984.0
2018-04-24 06:53:00	AAPL	Stock	41.5625	41.5625	41.5625	41.5625	400.0
2018-04-24 07:00:00	AAPL	Stock	41.54	41.5625	41.54	41.5625	2000.0
2018-04-24 07:01:00	AAPL	Stock	41.5725	41.5725	41.54	41.54	7384.0
2018-04-24 07:02:00	AAPL	Stock	41.54	41.54	41.54	41.54	1200.0
2018-04-24 07:03:00	AAPL	Stock	41.555	41.555	41.555	41.555	2000.0
2018-04-24 07:04:00	AAPL	Stock	41.55	41.55	41.55	41.55	800.0
2018-04-24 07:06:00	AAPL	Stock	41.545	41.545	41.5375	41.5375	2400.0
2018-04-24 07:07:00	AAPL	Stock	41.55	41.55	41.5375	41.5375	14196.0
2018-04-24 07:08:00	AAPL	Stock	41.5025	41.5025	41.5	41.5	904.0
2018-04-24 07:09:00	AAPL	Stock	41.5125	41.5125	41.5125	41.5125	1900.0
2018-04-24 07:13:00	AAPL	Stock	41.5125	41.5125	41.5125	41.5125	8208.0
2018-04-24 07:14:00	AAPL	Stock	41.475	41.475	41.475	41.475	2000.0
2018-04-24 07:15:00	AAPL	Stock	41.5	41.5	41.475	41.475	10924.0
2018-04-24 07:16:00	AAPL	Stock	41.475	41.475	41.475	41.475	3200.0
2018-04-24 07:17:00	AAPL	Stock	41.4625	41.4625	41.4375	41.44	2852.0
2018-04-24 07:18:00	AAPL	Stock	41.4375	41.4375	41.4375	41.4375	944.0
2018-04-24 07:19:00	AAPL	Stock	41.44	41.4575	41.44	41.4575	2200.0
2018-04-24 07:20:00	AAPL	Stock	41.44	41.4425	41.44	41.4425	1200.0
2018-04-24 07:23:00	AAPL	Stock	41.44	41.44	41.44	41.44	2992.0
2018-04-24 07:25:00	AAPL	Stock	41.44	41.44	41.4375	41.4375	7416.0
2018-04-24 07:28:00	AAPL	Stock	41.45	41.45	41.45	41.45	400.0
2018-04-24 07:29:00	AAPL	Stock	41.4375	41.4375	41.4375	41.4375	5840.0
2018-04-24 07:30:00	AAPL	Stock	41.4375	41.4625	41.4375	41.4625	26504.0
2018-04-24 07:31:00	AAPL	Stock	41.4625	41.4625	41.4625	41.4625	4256.0
2018-04-24 07:32:00	AAPL	Stock	41.4575	41.4575	41.4575	41.4575	1200.0

> showing 50 of 1,092,129 rows — these rows as CSV

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