PREVIEW / stock_1min / 2019-08-20

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-08-20.parquet
  size:    14.5 MB
  rows:    1,036,747
  symbols: 2,174

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
2019-08-20 04:00:00	AAPL	Stock	52.65	52.65	52.65	52.65	984.0
2019-08-20 04:04:00	AAPL	Stock	52.775	52.775	52.775	52.775	1800.0
2019-08-20 04:08:00	AAPL	Stock	52.77	52.7725	52.77	52.77	2400.0
2019-08-20 04:10:00	AAPL	Stock	52.745	52.745	52.745	52.745	400.0
2019-08-20 04:13:00	AAPL	Stock	52.735	52.7475	52.735	52.7475	2312.0
2019-08-20 04:15:00	AAPL	Stock	52.745	52.745	52.745	52.745	800.0
2019-08-20 04:19:00	AAPL	Stock	52.75	52.75	52.75	52.75	1200.0
2019-08-20 04:22:00	AAPL	Stock	52.785	52.785	52.785	52.785	400.0
2019-08-20 04:33:00	AAPL	Stock	52.7725	52.7725	52.7725	52.7725	800.0
2019-08-20 04:34:00	AAPL	Stock	52.7225	52.7225	52.71	52.71	2800.0
2019-08-20 04:52:00	AAPL	Stock	52.7525	52.7525	52.7525	52.7525	400.0
2019-08-20 05:00:00	AAPL	Stock	52.755	52.755	52.755	52.755	1200.0
2019-08-20 05:14:00	AAPL	Stock	52.7	52.7	52.7	52.7	400.0
2019-08-20 05:16:00	AAPL	Stock	52.6575	52.6575	52.6575	52.6575	400.0
2019-08-20 05:17:00	AAPL	Stock	52.625	52.65	52.625	52.65	800.0
2019-08-20 05:21:00	AAPL	Stock	52.65	52.65	52.65	52.65	596.0
2019-08-20 05:24:00	AAPL	Stock	52.5925	52.6525	52.5925	52.635	2800.0
2019-08-20 05:35:00	AAPL	Stock	52.6275	52.6275	52.6275	52.6275	768.0
2019-08-20 05:58:00	AAPL	Stock	52.65	52.65	52.65	52.65	616.0
2019-08-20 06:05:00	AAPL	Stock	52.6825	52.6825	52.6775	52.6775	1176.0
2019-08-20 06:07:00	AAPL	Stock	52.7475	52.7475	52.7475	52.7475	800.0
2019-08-20 06:08:00	AAPL	Stock	52.75	52.75	52.75	52.75	800.0
2019-08-20 06:09:00	AAPL	Stock	52.6875	52.6875	52.6875	52.6875	1308.0
2019-08-20 06:33:00	AAPL	Stock	52.7275	52.7275	52.725	52.725	1664.0
2019-08-20 06:35:00	AAPL	Stock	52.7125	52.7125	52.7125	52.7125	1324.0
2019-08-20 06:48:00	AAPL	Stock	52.695	52.695	52.695	52.695	2800.0
2019-08-20 06:58:00	AAPL	Stock	52.6675	52.6675	52.65	52.65	3108.0
2019-08-20 06:59:00	AAPL	Stock	52.65	52.65	52.65	52.65	1600.0
2019-08-20 07:00:00	AAPL	Stock	52.675	52.6875	52.6075	52.675	5220.0
2019-08-20 07:02:00	AAPL	Stock	52.6975	52.6975	52.6975	52.6975	400.0
2019-08-20 07:06:00	AAPL	Stock	52.645	52.645	52.5575	52.5575	10068.0
2019-08-20 07:07:00	AAPL	Stock	52.555	52.555	52.555	52.555	400.0
2019-08-20 07:08:00	AAPL	Stock	52.5625	52.5625	52.5625	52.5625	2800.0
2019-08-20 07:09:00	AAPL	Stock	52.5675	52.5675	52.5675	52.5675	400.0
2019-08-20 07:10:00	AAPL	Stock	52.595	52.595	52.5	52.5	20120.0
2019-08-20 07:11:00	AAPL	Stock	52.505	52.505	52.5	52.5	1984.0
2019-08-20 07:12:00	AAPL	Stock	52.5425	52.5425	52.5375	52.5375	1200.0
2019-08-20 07:13:00	AAPL	Stock	52.54	52.54	52.54	52.54	2000.0
2019-08-20 07:16:00	AAPL	Stock	52.58	52.5875	52.5775	52.5875	3056.0
2019-08-20 07:17:00	AAPL	Stock	52.575	52.575	52.575	52.575	400.0
2019-08-20 07:18:00	AAPL	Stock	52.575	52.575	52.5625	52.5625	1400.0
2019-08-20 07:20:00	AAPL	Stock	52.635	52.635	52.5625	52.5625	2568.0
2019-08-20 07:23:00	AAPL	Stock	52.57	52.57	52.57	52.57	400.0
2019-08-20 07:27:00	AAPL	Stock	52.575	52.575	52.575	52.575	1072.0
2019-08-20 07:28:00	AAPL	Stock	52.575	52.575	52.575	52.575	400.0
2019-08-20 07:30:00	AAPL	Stock	52.575	52.575	52.55	52.55	4000.0
2019-08-20 07:32:00	AAPL	Stock	52.605	52.6125	52.5875	52.5875	6100.0
2019-08-20 07:34:00	AAPL	Stock	52.585	52.5875	52.585	52.5875	2824.0
2019-08-20 07:36:00	AAPL	Stock	52.6	52.6	52.6	52.6	656.0
2019-08-20 07:37:00	AAPL	Stock	52.65	52.6625	52.65	52.6625	1200.0

> showing 50 of 1,036,747 rows — these rows as CSV

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