PREVIEW / stock_5min / 2018-08-14

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-14.parquet
  size:    5.6 MB
  rows:    353,187
  symbols: 2,816

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-14 04:10:00	AAPL	Stock	52.5025	52.5875	52.5025	52.5825	2408.0
2018-08-14 04:30:00	AAPL	Stock	52.5075	52.5075	52.5075	52.5075	1372.0
2018-08-14 04:45:00	AAPL	Stock	52.5	52.5	52.5	52.5	2996.0
2018-08-14 05:25:00	AAPL	Stock	52.5375	52.5375	52.5375	52.5375	476.0
2018-08-14 05:50:00	AAPL	Stock	52.5	52.5	52.5	52.5	400.0
2018-08-14 06:10:00	AAPL	Stock	52.55	52.55	52.55	52.55	568.0
2018-08-14 06:15:00	AAPL	Stock	52.5	52.5	52.5	52.5	400.0
2018-08-14 06:25:00	AAPL	Stock	52.5625	52.5625	52.5625	52.5625	768.0
2018-08-14 06:30:00	AAPL	Stock	52.585	52.6075	52.585	52.6075	12524.0
2018-08-14 06:35:00	AAPL	Stock	52.585	52.5875	52.55	52.55	11600.0
2018-08-14 06:40:00	AAPL	Stock	52.585	52.6	52.585	52.6	7200.0
2018-08-14 06:50:00	AAPL	Stock	52.585	52.585	52.585	52.585	400.0
2018-08-14 06:55:00	AAPL	Stock	52.5775	52.58	52.575	52.575	12808.0
2018-08-14 07:00:00	AAPL	Stock	52.555	52.56	52.535	52.5425	18416.0
2018-08-14 07:05:00	AAPL	Stock	52.5525	52.5525	52.53	52.53	12540.0
2018-08-14 07:10:00	AAPL	Stock	52.525	52.5475	52.525	52.525	7408.0
2018-08-14 07:15:00	AAPL	Stock	52.5275	52.56	52.525	52.56	10516.0
2018-08-14 07:20:00	AAPL	Stock	52.535	52.535	52.535	52.535	800.0
2018-08-14 07:25:00	AAPL	Stock	52.5475	52.56	52.5475	52.56	8316.0
2018-08-14 07:30:00	AAPL	Stock	52.5275	52.5275	52.5075	52.5075	5080.0
2018-08-14 07:35:00	AAPL	Stock	52.5275	52.5275	52.475	52.475	5436.0
2018-08-14 07:40:00	AAPL	Stock	52.475	52.475	52.465	52.465	2604.0
2018-08-14 07:45:00	AAPL	Stock	52.4825	52.485	52.4825	52.485	2000.0
2018-08-14 07:50:00	AAPL	Stock	52.475	52.4875	52.475	52.4875	4812.0
2018-08-14 07:55:00	AAPL	Stock	52.4875	52.5025	52.4875	52.5025	12540.0
2018-08-14 08:00:00	AAPL	Stock	52.55	52.5625	52.4625	52.4825	69492.0
2018-08-14 08:05:00	AAPL	Stock	52.49	52.5125	52.4675	52.5125	23264.0
2018-08-14 08:10:00	AAPL	Stock	52.4975	52.525	52.4975	52.4975	11036.0
2018-08-14 08:15:00	AAPL	Stock	52.4975	52.51	52.475	52.5	30504.0
2018-08-14 08:20:00	AAPL	Stock	52.4675	52.475	52.4425	52.475	27800.0
2018-08-14 08:25:00	AAPL	Stock	52.475	52.482	52.4575	52.4575	2000.0
2018-08-14 08:30:00	AAPL	Stock	52.475	52.4825	52.4625	52.47	8116.0
2018-08-14 08:35:00	AAPL	Stock	52.485	52.4925	52.485	52.485	11000.0
2018-08-14 08:40:00	AAPL	Stock	52.495	52.5125	52.495	52.5125	11900.0
2018-08-14 08:45:00	AAPL	Stock	52.5125	52.5125	52.4875	52.4875	21512.0
2018-08-14 08:50:00	AAPL	Stock	52.4875	52.5	52.485	52.5	22596.0
2018-08-14 08:55:00	AAPL	Stock	52.4925	52.4925	52.485	52.485	1556.0
2018-08-14 09:00:00	AAPL	Stock	52.4725	52.4875	52.45	52.45	96540.0
2018-08-14 09:05:00	AAPL	Stock	52.4525	52.465	52.45	52.45	14084.0
2018-08-14 09:10:00	AAPL	Stock	52.46	52.475	52.4575	52.4625	16280.0
2018-08-14 09:15:00	AAPL	Stock	52.465	52.475	52.4625	52.465	12320.0
2018-08-14 09:20:00	AAPL	Stock	52.4675	52.4975	52.465	52.4825	17852.0
2018-08-14 09:25:00	AAPL	Stock	52.4875	52.55	52.4875	52.545	37136.0
2018-08-14 09:30:00	AAPL	Stock	52.5388	52.64	52.3575	52.42	4473380.0
2018-08-14 09:35:00	AAPL	Stock	52.419	52.4775	52.315	52.3525	1993488.0
2018-08-14 09:40:00	AAPL	Stock	52.355	52.425	52.2775	52.38	2123176.0
2018-08-14 09:45:00	AAPL	Stock	52.3775	52.3852	52.25	52.265	1681172.0
2018-08-14 09:50:00	AAPL	Stock	52.265	52.32	52.2125	52.304	1671796.0
2018-08-14 09:55:00	AAPL	Stock	52.2975	52.341	52.2725	52.3025	1190516.0
2018-08-14 10:00:00	AAPL	Stock	52.3075	52.32	52.09	52.0955	2151192.0

> showing 50 of 353,187 rows — these rows as CSV

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