PREVIEW / stock_1min / 2019-08-01

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-08-01.parquet
  size:    17.7 MB
  rows:    1,186,404
  symbols: 2,179

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-01 04:02:00	AAPL	Stock	53.5	53.5	53.5	53.5	400.0
2019-08-01 04:18:00	AAPL	Stock	53.4875	53.4875	53.4875	53.4875	3680.0
2019-08-01 04:19:00	AAPL	Stock	53.485	53.4925	53.485	53.4925	4000.0
2019-08-01 04:21:00	AAPL	Stock	53.4875	53.5	53.4875	53.4925	4192.0
2019-08-01 04:29:00	AAPL	Stock	53.4875	53.4875	53.4875	53.4875	552.0
2019-08-01 04:35:00	AAPL	Stock	53.45	53.45	53.45	53.45	2400.0
2019-08-01 04:43:00	AAPL	Stock	53.445	53.445	53.445	53.445	980.0
2019-08-01 04:45:00	AAPL	Stock	53.45	53.45	53.45	53.45	800.0
2019-08-01 05:05:00	AAPL	Stock	53.52	53.55	53.52	53.55	2400.0
2019-08-01 05:17:00	AAPL	Stock	53.53	53.53	53.53	53.53	2000.0
2019-08-01 05:27:00	AAPL	Stock	53.5475	53.55	53.5475	53.55	7640.0
2019-08-01 05:38:00	AAPL	Stock	53.5675	53.5675	53.5675	53.5675	400.0
2019-08-01 05:39:00	AAPL	Stock	53.5675	53.57	53.5675	53.57	3200.0
2019-08-01 05:41:00	AAPL	Stock	53.57	53.57	53.57	53.57	800.0
2019-08-01 05:43:00	AAPL	Stock	53.595	53.6125	53.595	53.6125	3604.0
2019-08-01 05:51:00	AAPL	Stock	53.6175	53.6175	53.6175	53.6175	400.0
2019-08-01 05:52:00	AAPL	Stock	53.6125	53.6125	53.6125	53.6125	800.0
2019-08-01 05:56:00	AAPL	Stock	53.625	53.625	53.625	53.625	708.0
2019-08-01 06:12:00	AAPL	Stock	53.625	53.625	53.625	53.625	2600.0
2019-08-01 06:20:00	AAPL	Stock	53.625	53.625	53.625	53.625	3632.0
2019-08-01 06:21:00	AAPL	Stock	53.6625	53.6625	53.6625	53.6625	3736.0
2019-08-01 06:22:00	AAPL	Stock	53.67	53.67	53.67	53.67	4000.0
2019-08-01 06:26:00	AAPL	Stock	53.6725	53.675	53.6725	53.675	1600.0
2019-08-01 06:31:00	AAPL	Stock	53.675	53.675	53.675	53.675	600.0
2019-08-01 06:40:00	AAPL	Stock	53.7075	53.7075	53.6775	53.6775	1200.0
2019-08-01 06:45:00	AAPL	Stock	53.645	53.645	53.645	53.645	800.0
2019-08-01 06:47:00	AAPL	Stock	53.6275	53.6275	53.6275	53.6275	1800.0
2019-08-01 06:49:00	AAPL	Stock	53.6	53.6	53.6	53.6	3920.0
2019-08-01 06:51:00	AAPL	Stock	53.5775	53.5775	53.5775	53.5775	400.0
2019-08-01 06:55:00	AAPL	Stock	53.575	53.575	53.575	53.575	1200.0
2019-08-01 06:59:00	AAPL	Stock	53.6225	53.625	53.6225	53.625	3744.0
2019-08-01 07:00:00	AAPL	Stock	53.62	53.625	53.5625	53.575	6628.0
2019-08-01 07:01:00	AAPL	Stock	53.6175	53.625	53.6175	53.625	6352.0
2019-08-01 07:02:00	AAPL	Stock	53.625	53.625	53.625	53.625	400.0
2019-08-01 07:03:00	AAPL	Stock	53.625	53.625	53.625	53.625	1200.0
2019-08-01 07:04:00	AAPL	Stock	53.6375	53.6375	53.6375	53.6375	4000.0
2019-08-01 07:05:00	AAPL	Stock	53.6275	53.6275	53.6275	53.6275	1600.0
2019-08-01 07:06:00	AAPL	Stock	53.6275	53.6275	53.625	53.625	2800.0
2019-08-01 07:07:00	AAPL	Stock	53.625	53.625	53.625	53.625	2400.0
2019-08-01 07:09:00	AAPL	Stock	53.595	53.595	53.5875	53.5875	28272.0
2019-08-01 07:10:00	AAPL	Stock	53.5575	53.5575	53.5575	53.5575	400.0
2019-08-01 07:11:00	AAPL	Stock	53.55	53.55	53.55	53.55	1600.0
2019-08-01 07:12:00	AAPL	Stock	53.5625	53.5625	53.5625	53.5625	400.0
2019-08-01 07:14:00	AAPL	Stock	53.5725	53.5725	53.55	53.55	12380.0
2019-08-01 07:15:00	AAPL	Stock	53.55	53.55	53.5425	53.5425	1200.0
2019-08-01 07:16:00	AAPL	Stock	53.5375	53.585	53.5375	53.5375	6196.0
2019-08-01 07:17:00	AAPL	Stock	53.54	53.54	53.5375	53.54	3004.0
2019-08-01 07:19:00	AAPL	Stock	53.585	53.59	53.585	53.59	1040.0
2019-08-01 07:20:00	AAPL	Stock	53.595	53.595	53.595	53.595	1984.0
2019-08-01 07:21:00	AAPL	Stock	53.6	53.6	53.6	53.6	400.0

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

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