PREVIEW / stock_5min / 2018-06-22

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-06-22.parquet
  size:    5.7 MB
  rows:    368,140
  symbols: 2,818

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-06-22 04:20:00	AAPL	Stock	46.45	46.45	46.45	46.45	800.0
2018-06-22 04:35:00	AAPL	Stock	46.45	46.4725	46.45	46.4725	1600.0
2018-06-22 05:10:00	AAPL	Stock	46.5125	46.5125	46.5125	46.5125	1200.0
2018-06-22 06:00:00	AAPL	Stock	46.5175	46.5175	46.5175	46.5175	516.0
2018-06-22 06:30:00	AAPL	Stock	46.55	46.55	46.55	46.55	2000.0
2018-06-22 07:00:00	AAPL	Stock	46.625	46.625	46.5325	46.5325	4044.0
2018-06-22 07:05:00	AAPL	Stock	46.55	46.5725	46.55	46.5725	2908.0
2018-06-22 07:10:00	AAPL	Stock	46.5925	46.5925	46.5175	46.5575	15204.0
2018-06-22 07:20:00	AAPL	Stock	46.525	46.5575	46.5	46.515	23668.0
2018-06-22 07:30:00	AAPL	Stock	46.525	46.525	46.525	46.525	400.0
2018-06-22 07:35:00	AAPL	Stock	46.5175	46.525	46.5075	46.5075	3828.0
2018-06-22 07:40:00	AAPL	Stock	46.53	46.53	46.5075	46.5075	3364.0
2018-06-22 07:45:00	AAPL	Stock	46.5	46.515	46.5	46.515	2520.0
2018-06-22 07:50:00	AAPL	Stock	46.515	46.5425	46.515	46.5425	11440.0
2018-06-22 08:00:00	AAPL	Stock	46.55	46.655	46.4825	46.555	55792.0
2018-06-22 08:05:00	AAPL	Stock	46.5375	46.5375	46.525	46.525	1180.0
2018-06-22 08:10:00	AAPL	Stock	46.5275	46.5275	46.515	46.5175	11984.0
2018-06-22 08:15:00	AAPL	Stock	46.525	46.55	46.525	46.55	28428.0
2018-06-22 08:20:00	AAPL	Stock	46.55	46.6	46.55	46.6	7256.0
2018-06-22 08:25:00	AAPL	Stock	46.585	46.5875	46.575	46.575	7348.0
2018-06-22 08:30:00	AAPL	Stock	46.5625	46.58	46.555	46.5575	5812.0
2018-06-22 08:35:00	AAPL	Stock	46.57	46.57	46.5625	46.5625	2196.0
2018-06-22 08:40:00	AAPL	Stock	46.575	46.575	46.565	46.565	1228.0
2018-06-22 08:45:00	AAPL	Stock	46.575	46.585	46.57	46.57	4992.0
2018-06-22 08:50:00	AAPL	Stock	46.5625	46.5725	46.5625	46.565	1600.0
2018-06-22 08:55:00	AAPL	Stock	46.5742	46.5742	46.55	46.55	28976.0
2018-06-22 09:00:00	AAPL	Stock	46.5625	46.57	46.5525	46.57	2800.0
2018-06-22 09:05:00	AAPL	Stock	46.5625	46.575	46.5625	46.565	16172.0
2018-06-22 09:10:00	AAPL	Stock	46.5675	46.5675	46.5675	46.5675	800.0
2018-06-22 09:15:00	AAPL	Stock	46.56	46.5675	46.56	46.5675	1600.0
2018-06-22 09:20:00	AAPL	Stock	46.565	46.5775	46.5575	46.5675	26072.0
2018-06-22 09:25:00	AAPL	Stock	46.57	46.61	46.4525	46.4775	86744.0
2018-06-22 09:30:00	AAPL	Stock	46.4775	46.5375	46.415	46.4775	2090460.0
2018-06-22 09:35:00	AAPL	Stock	46.4775	46.505	46.3825	46.424	1176732.0
2018-06-22 09:40:00	AAPL	Stock	46.425	46.455	46.3398	46.3502	959972.0
2018-06-22 09:45:00	AAPL	Stock	46.35	46.3725	46.2775	46.325	1312504.0
2018-06-22 09:50:00	AAPL	Stock	46.3225	46.4175	46.3175	46.4025	912808.0
2018-06-22 09:55:00	AAPL	Stock	46.41	46.435	46.34	46.3875	857640.0
2018-06-22 10:00:00	AAPL	Stock	46.385	46.4325	46.3475	46.4	772840.0
2018-06-22 10:05:00	AAPL	Stock	46.4038	46.4675	46.4	46.4425	899664.0
2018-06-22 10:10:00	AAPL	Stock	46.4375	46.4525	46.395	46.4	675976.0
2018-06-22 10:15:00	AAPL	Stock	46.3975	46.415	46.36	46.3835	665220.0
2018-06-22 10:20:00	AAPL	Stock	46.385	46.385	46.3075	46.3125	857056.0
2018-06-22 10:25:00	AAPL	Stock	46.3138	46.325	46.2425	46.2725	1561516.0
2018-06-22 10:30:00	AAPL	Stock	46.2738	46.29	46.2075	46.2825	1050376.0
2018-06-22 10:35:00	AAPL	Stock	46.2825	46.3125	46.205	46.21	738244.0
2018-06-22 10:40:00	AAPL	Stock	46.21	46.275	46.2075	46.265	717964.0
2018-06-22 10:45:00	AAPL	Stock	46.2675	46.32	46.2525	46.3175	747792.0
2018-06-22 10:50:00	AAPL	Stock	46.315	46.3835	46.302	46.3462	730508.0
2018-06-22 10:55:00	AAPL	Stock	46.345	46.4188	46.335	46.415	720568.0

> showing 50 of 368,140 rows — these rows as CSV

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