PREVIEW / stock_1min / 2018-08-01

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-08-01.parquet
  size:    15.3 MB
  rows:    1,097,890
  symbols: 2,335

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-08-01 04:00:00	AAPL	Stock	49.3225	49.4725	49.3225	49.4725	16880.0
2018-08-01 04:01:00	AAPL	Stock	49.415	49.4625	49.415	49.4625	12304.0
2018-08-01 04:02:00	AAPL	Stock	49.435	49.46	49.4325	49.46	2000.0
2018-08-01 04:03:00	AAPL	Stock	49.4375	49.4375	49.42	49.42	8800.0
2018-08-01 04:04:00	AAPL	Stock	49.3825	49.42	49.3825	49.42	1352.0
2018-08-01 04:07:00	AAPL	Stock	49.3775	49.3775	49.375	49.375	2248.0
2018-08-01 04:10:00	AAPL	Stock	49.355	49.3575	49.355	49.3575	2480.0
2018-08-01 04:16:00	AAPL	Stock	49.375	49.375	49.375	49.375	2000.0
2018-08-01 04:17:00	AAPL	Stock	49.375	49.375	49.375	49.375	3684.0
2018-08-01 04:18:00	AAPL	Stock	49.375	49.375	49.3025	49.3025	8544.0
2018-08-01 04:19:00	AAPL	Stock	49.3625	49.3625	49.305	49.32	3984.0
2018-08-01 04:21:00	AAPL	Stock	49.37	49.37	49.37	49.37	400.0
2018-08-01 04:24:00	AAPL	Stock	49.3025	49.3025	49.3025	49.3025	3608.0
2018-08-01 04:27:00	AAPL	Stock	49.38	49.38	49.3025	49.325	7640.0
2018-08-01 04:28:00	AAPL	Stock	49.3025	49.325	49.3025	49.325	4400.0
2018-08-01 04:30:00	AAPL	Stock	49.325	49.325	49.3025	49.325	4604.0
2018-08-01 04:31:00	AAPL	Stock	49.305	49.305	49.305	49.305	3592.0
2018-08-01 04:34:00	AAPL	Stock	49.2975	49.2975	49.25	49.25	19924.0
2018-08-01 04:35:00	AAPL	Stock	49.24	49.24	49.225	49.225	11600.0
2018-08-01 04:37:00	AAPL	Stock	49.25	49.25	49.25	49.25	2000.0
2018-08-01 04:38:00	AAPL	Stock	49.25	49.25	49.225	49.225	10684.0
2018-08-01 04:43:00	AAPL	Stock	49.225	49.225	49.225	49.225	600.0
2018-08-01 04:44:00	AAPL	Stock	49.25	49.25	49.25	49.25	400.0
2018-08-01 04:50:00	AAPL	Stock	49.225	49.225	49.225	49.225	1180.0
2018-08-01 04:52:00	AAPL	Stock	49.2	49.2	49.1775	49.1775	7160.0
2018-08-01 04:53:00	AAPL	Stock	49.1775	49.1775	49.1775	49.1775	400.0
2018-08-01 04:54:00	AAPL	Stock	49.18	49.18	49.18	49.18	3268.0
2018-08-01 04:55:00	AAPL	Stock	49.1775	49.1775	49.1775	49.1775	2156.0
2018-08-01 04:56:00	AAPL	Stock	49.2025	49.225	49.2025	49.225	16928.0
2018-08-01 04:57:00	AAPL	Stock	49.225	49.225	49.225	49.225	400.0
2018-08-01 04:58:00	AAPL	Stock	49.225	49.225	49.225	49.225	800.0
2018-08-01 04:59:00	AAPL	Stock	49.25	49.25	49.25	49.25	2616.0
2018-08-01 05:05:00	AAPL	Stock	49.19	49.19	49.19	49.19	600.0
2018-08-01 05:06:00	AAPL	Stock	49.2375	49.245	49.235	49.235	1636.0
2018-08-01 05:08:00	AAPL	Stock	49.25	49.26	49.25	49.26	7916.0
2018-08-01 05:10:00	AAPL	Stock	49.3	49.3	49.3	49.3	5648.0
2018-08-01 05:14:00	AAPL	Stock	49.27	49.27	49.27	49.27	872.0
2018-08-01 05:16:00	AAPL	Stock	49.27	49.27	49.27	49.27	416.0
2018-08-01 05:24:00	AAPL	Stock	49.24	49.24	49.24	49.24	1536.0
2018-08-01 05:27:00	AAPL	Stock	49.2525	49.27	49.2525	49.27	2060.0
2018-08-01 05:42:00	AAPL	Stock	49.275	49.275	49.275	49.275	732.0
2018-08-01 05:45:00	AAPL	Stock	49.29	49.29	49.29	49.29	1468.0
2018-08-01 05:46:00	AAPL	Stock	49.2925	49.3	49.2925	49.3	9652.0
2018-08-01 05:47:00	AAPL	Stock	49.2875	49.2875	49.275	49.275	2304.0
2018-08-01 05:49:00	AAPL	Stock	49.275	49.275	49.26	49.26	3200.0
2018-08-01 05:52:00	AAPL	Stock	49.275	49.29	49.275	49.29	5200.0
2018-08-01 05:53:00	AAPL	Stock	49.2775	49.2775	49.25	49.255	13936.0
2018-08-01 05:54:00	AAPL	Stock	49.25	49.25	49.25	49.25	2152.0
2018-08-01 05:55:00	AAPL	Stock	49.245	49.25	49.245	49.25	1060.0
2018-08-01 05:56:00	AAPL	Stock	49.215	49.215	49.215	49.215	3920.0

> showing 50 of 1,097,890 rows — these rows as CSV

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