PREVIEW / stock_1min / 2019-09-20

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-09-20.parquet
  size:    15.8 MB
  rows:    1,114,558
  symbols: 2,151

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-09-20 04:05:00	AAPL	Stock	55.3225	55.365	55.3225	55.365	800.0
2019-09-20 04:10:00	AAPL	Stock	55.325	55.325	55.325	55.325	1600.0
2019-09-20 04:16:00	AAPL	Stock	55.3375	55.3375	55.3275	55.3275	800.0
2019-09-20 04:18:00	AAPL	Stock	55.3975	55.3975	55.3975	55.3975	1200.0
2019-09-20 04:29:00	AAPL	Stock	55.3725	55.3725	55.3725	55.3725	400.0
2019-09-20 04:42:00	AAPL	Stock	55.41	55.41	55.41	55.41	548.0
2019-09-20 04:51:00	AAPL	Stock	55.355	55.355	55.3375	55.3375	1060.0
2019-09-20 05:11:00	AAPL	Stock	55.35	55.3625	55.35	55.3625	2400.0
2019-09-20 05:36:00	AAPL	Stock	55.3925	55.4	55.3925	55.4	800.0
2019-09-20 05:49:00	AAPL	Stock	55.395	55.395	55.395	55.395	432.0
2019-09-20 05:50:00	AAPL	Stock	55.395	55.395	55.395	55.395	1600.0
2019-09-20 05:51:00	AAPL	Stock	55.37	55.37	55.35	55.35	2792.0
2019-09-20 05:52:00	AAPL	Stock	55.3375	55.3375	55.3375	55.3375	3980.0
2019-09-20 05:55:00	AAPL	Stock	55.4025	55.4025	55.4025	55.4025	640.0
2019-09-20 06:09:00	AAPL	Stock	55.3875	55.3875	55.3875	55.3875	400.0
2019-09-20 06:10:00	AAPL	Stock	55.3625	55.3625	55.315	55.315	800.0
2019-09-20 06:16:00	AAPL	Stock	55.34	55.34	55.34	55.34	400.0
2019-09-20 06:48:00	AAPL	Stock	55.34	55.34	55.335	55.335	6800.0
2019-09-20 07:00:00	AAPL	Stock	55.3625	55.3625	55.2875	55.335	10348.0
2019-09-20 07:01:00	AAPL	Stock	55.3325	55.35	55.3325	55.335	12000.0
2019-09-20 07:04:00	AAPL	Stock	55.3375	55.345	55.3375	55.345	2952.0
2019-09-20 07:05:00	AAPL	Stock	55.325	55.325	55.325	55.325	4584.0
2019-09-20 07:07:00	AAPL	Stock	55.3375	55.3375	55.3375	55.3375	400.0
2019-09-20 07:08:00	AAPL	Stock	55.35	55.35	55.35	55.35	26800.0
2019-09-20 07:11:00	AAPL	Stock	55.3525	55.3525	55.3425	55.3425	1948.0
2019-09-20 07:19:00	AAPL	Stock	55.36	55.36	55.36	55.36	400.0
2019-09-20 07:20:00	AAPL	Stock	55.375	55.375	55.375	55.375	1200.0
2019-09-20 07:21:00	AAPL	Stock	55.3875	55.3875	55.3875	55.3875	1220.0
2019-09-20 07:23:00	AAPL	Stock	55.3975	55.3975	55.3975	55.3975	628.0
2019-09-20 07:25:00	AAPL	Stock	55.3875	55.3875	55.3875	55.3875	8004.0
2019-09-20 07:26:00	AAPL	Stock	55.39	55.4125	55.39	55.4125	4000.0
2019-09-20 07:27:00	AAPL	Stock	55.4125	55.4225	55.4125	55.42	20084.0
2019-09-20 07:28:00	AAPL	Stock	55.4225	55.4225	55.4125	55.4125	4124.0
2019-09-20 07:29:00	AAPL	Stock	55.4225	55.425	55.4125	55.425	7304.0
2019-09-20 07:31:00	AAPL	Stock	55.4375	55.4375	55.4375	55.4375	1188.0
2019-09-20 07:32:00	AAPL	Stock	55.43	55.445	55.43	55.445	2800.0
2019-09-20 07:33:00	AAPL	Stock	55.425	55.425	55.425	55.425	2400.0
2019-09-20 07:35:00	AAPL	Stock	55.425	55.425	55.375	55.38	16772.0
2019-09-20 07:36:00	AAPL	Stock	55.3825	55.3825	55.375	55.375	7152.0
2019-09-20 07:38:00	AAPL	Stock	55.3825	55.3825	55.375	55.375	6000.0
2019-09-20 07:39:00	AAPL	Stock	55.3575	55.3575	55.3375	55.35	12260.0
2019-09-20 07:41:00	AAPL	Stock	55.3425	55.35	55.34	55.35	4208.0
2019-09-20 07:43:00	AAPL	Stock	55.35	55.35	55.35	55.35	400.0
2019-09-20 07:46:00	AAPL	Stock	55.3725	55.375	55.3725	55.375	6000.0
2019-09-20 07:49:00	AAPL	Stock	55.3825	55.385	55.375	55.375	1772.0
2019-09-20 07:51:00	AAPL	Stock	55.3875	55.3875	55.3875	55.3875	1600.0
2019-09-20 07:52:00	AAPL	Stock	55.375	55.375	55.375	55.375	400.0
2019-09-20 07:57:00	AAPL	Stock	55.4075	55.4075	55.4075	55.4075	1080.0
2019-09-20 07:59:00	AAPL	Stock	55.425	55.4375	55.425	55.4375	7988.0
2019-09-20 08:00:00	AAPL	Stock	55.3275	55.445	55.325	55.415	81976.0

> showing 50 of 1,114,558 rows — these rows as CSV

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