PREVIEW / stock_1min / 2019-08-02

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-08-02.parquet
  size:    16.1 MB
  rows:    1,131,020
  symbols: 2,170

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-02 04:00:00	AAPL	Stock	51.55	51.55	51.4275	51.4275	9304.0
2019-08-02 04:01:00	AAPL	Stock	51.525	51.525	51.525	51.525	400.0
2019-08-02 04:11:00	AAPL	Stock	51.535	51.535	51.535	51.535	800.0
2019-08-02 04:16:00	AAPL	Stock	51.5375	51.5375	51.5375	51.5375	1120.0
2019-08-02 04:17:00	AAPL	Stock	51.525	51.525	51.5	51.5	5616.0
2019-08-02 04:20:00	AAPL	Stock	51.4525	51.4525	51.4525	51.4525	400.0
2019-08-02 04:21:00	AAPL	Stock	51.5	51.5	51.5	51.5	3200.0
2019-08-02 04:30:00	AAPL	Stock	51.405	51.405	51.3875	51.3875	1224.0
2019-08-02 04:31:00	AAPL	Stock	51.4425	51.45	51.4425	51.45	1300.0
2019-08-02 04:32:00	AAPL	Stock	51.3875	51.3875	51.3875	51.3875	3836.0
2019-08-02 04:33:00	AAPL	Stock	51.3775	51.3775	51.3775	51.3775	400.0
2019-08-02 04:35:00	AAPL	Stock	51.45	51.45	51.45	51.45	800.0
2019-08-02 04:38:00	AAPL	Stock	51.45	51.45	51.45	51.45	532.0
2019-08-02 04:43:00	AAPL	Stock	51.45	51.45	51.45	51.45	584.0
2019-08-02 04:44:00	AAPL	Stock	51.45	51.45	51.45	51.45	1008.0
2019-08-02 04:47:00	AAPL	Stock	51.4925	51.4925	51.4925	51.4925	400.0
2019-08-02 04:51:00	AAPL	Stock	51.4925	51.4925	51.4925	51.4925	3616.0
2019-08-02 04:54:00	AAPL	Stock	51.45	51.45	51.45	51.45	600.0
2019-08-02 04:57:00	AAPL	Stock	51.4425	51.4425	51.4425	51.4425	1200.0
2019-08-02 04:58:00	AAPL	Stock	51.4425	51.4425	51.4425	51.4425	1996.0
2019-08-02 05:08:00	AAPL	Stock	51.385	51.385	51.385	51.385	400.0
2019-08-02 05:16:00	AAPL	Stock	51.3925	51.3925	51.3725	51.3825	5028.0
2019-08-02 05:39:00	AAPL	Stock	51.4075	51.4075	51.3875	51.3875	4320.0
2019-08-02 05:42:00	AAPL	Stock	51.39	51.39	51.39	51.39	404.0
2019-08-02 05:46:00	AAPL	Stock	51.4125	51.4125	51.4	51.4	928.0
2019-08-02 05:58:00	AAPL	Stock	51.4	51.4	51.4	51.4	400.0
2019-08-02 06:02:00	AAPL	Stock	51.3875	51.3875	51.3875	51.3875	2088.0
2019-08-02 06:03:00	AAPL	Stock	51.425	51.425	51.425	51.425	1620.0
2019-08-02 06:06:00	AAPL	Stock	51.4725	51.485	51.415	51.415	4792.0
2019-08-02 06:17:00	AAPL	Stock	51.535	51.535	51.535	51.535	400.0
2019-08-02 06:18:00	AAPL	Stock	51.5475	51.5475	51.5475	51.5475	400.0
2019-08-02 06:19:00	AAPL	Stock	51.58	51.58	51.58	51.58	1200.0
2019-08-02 06:22:00	AAPL	Stock	51.5875	51.5875	51.5875	51.5875	944.0
2019-08-02 06:23:00	AAPL	Stock	51.5625	51.5625	51.55	51.55	1200.0
2019-08-02 06:25:00	AAPL	Stock	51.575	51.575	51.575	51.575	400.0
2019-08-02 06:26:00	AAPL	Stock	51.57	51.57	51.5625	51.5625	800.0
2019-08-02 06:28:00	AAPL	Stock	51.5625	51.5625	51.5625	51.5625	400.0
2019-08-02 06:29:00	AAPL	Stock	51.5625	51.5625	51.5	51.5	9296.0
2019-08-02 06:30:00	AAPL	Stock	51.5	51.5	51.5	51.5	3504.0
2019-08-02 06:31:00	AAPL	Stock	51.5475	51.5475	51.5475	51.5475	524.0
2019-08-02 06:32:00	AAPL	Stock	51.5025	51.5025	51.5025	51.5025	1672.0
2019-08-02 06:33:00	AAPL	Stock	51.5	51.5	51.5	51.5	800.0
2019-08-02 06:35:00	AAPL	Stock	51.575	51.575	51.5275	51.5275	2000.0
2019-08-02 06:36:00	AAPL	Stock	51.53	51.53	51.53	51.53	800.0
2019-08-02 06:39:00	AAPL	Stock	51.5	51.5	51.5	51.5	988.0
2019-08-02 06:41:00	AAPL	Stock	51.45	51.45	51.45	51.45	4552.0
2019-08-02 06:45:00	AAPL	Stock	51.5	51.5	51.5	51.5	400.0
2019-08-02 06:46:00	AAPL	Stock	51.5075	51.5075	51.5075	51.5075	800.0
2019-08-02 06:47:00	AAPL	Stock	51.5	51.5	51.5	51.5	400.0
2019-08-02 06:48:00	AAPL	Stock	51.515	51.515	51.515	51.515	400.0

> showing 50 of 1,131,020 rows — these rows as CSV

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