PREVIEW / stock_5min / 2018-03-27

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-03-27.parquet
  size:    5.6 MB
  rows:    363,795
  symbols: 2,877

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-03-27 04:00:00	AAPL	Stock	43.325	43.5025	43.325	43.5025	1600.0
2018-03-27 04:05:00	AAPL	Stock	43.4975	43.5	43.4375	43.4375	4000.0
2018-03-27 04:10:00	AAPL	Stock	43.4975	43.5	43.4975	43.5	1600.0
2018-03-27 04:15:00	AAPL	Stock	43.5125	43.5125	43.5125	43.5125	1800.0
2018-03-27 04:25:00	AAPL	Stock	43.475	43.475	43.475	43.475	11200.0
2018-03-27 04:30:00	AAPL	Stock	43.5	43.5	43.5	43.5	3200.0
2018-03-27 04:35:00	AAPL	Stock	43.5	43.5	43.5	43.5	4396.0
2018-03-27 04:40:00	AAPL	Stock	43.5025	43.5025	43.5025	43.5025	600.0
2018-03-27 04:50:00	AAPL	Stock	43.55	43.55	43.55	43.55	2388.0
2018-03-27 05:05:00	AAPL	Stock	43.55	43.5675	43.55	43.5675	1600.0
2018-03-27 05:10:00	AAPL	Stock	43.5675	43.5675	43.5675	43.5675	880.0
2018-03-27 05:15:00	AAPL	Stock	43.5675	43.5675	43.55	43.55	3020.0
2018-03-27 05:35:00	AAPL	Stock	43.5275	43.57	43.5175	43.57	8184.0
2018-03-27 06:05:00	AAPL	Stock	43.565	43.62	43.55	43.55	2800.0
2018-03-27 06:10:00	AAPL	Stock	43.55	43.55	43.515	43.515	11520.0
2018-03-27 06:15:00	AAPL	Stock	43.515	43.515	43.515	43.515	6400.0
2018-03-27 06:25:00	AAPL	Stock	43.525	43.525	43.505	43.505	5600.0
2018-03-27 06:30:00	AAPL	Stock	43.51	43.525	43.51	43.51	8700.0
2018-03-27 06:40:00	AAPL	Stock	43.5	43.5	43.49	43.49	2400.0
2018-03-27 06:45:00	AAPL	Stock	43.49	43.49	43.49	43.49	800.0
2018-03-27 07:00:00	AAPL	Stock	43.465	43.5625	43.465	43.5625	41800.0
2018-03-27 07:05:00	AAPL	Stock	43.5825	43.5875	43.555	43.585	35524.0
2018-03-27 07:10:00	AAPL	Stock	43.585	43.585	43.575	43.58	15864.0
2018-03-27 07:15:00	AAPL	Stock	43.58	43.625	43.575	43.6075	24724.0
2018-03-27 07:20:00	AAPL	Stock	43.6	43.675	43.6	43.665	31428.0
2018-03-27 07:25:00	AAPL	Stock	43.665	43.665	43.615	43.625	16636.0
2018-03-27 07:30:00	AAPL	Stock	43.6125	43.65	43.6125	43.65	20140.0
2018-03-27 07:35:00	AAPL	Stock	43.6325	43.6375	43.6125	43.6325	8260.0
2018-03-27 07:40:00	AAPL	Stock	43.625	43.625	43.5875	43.5875	9412.0
2018-03-27 07:45:00	AAPL	Stock	43.5875	43.5875	43.5375	43.5625	17792.0
2018-03-27 07:50:00	AAPL	Stock	43.5625	43.5625	43.55	43.55	12200.0
2018-03-27 07:55:00	AAPL	Stock	43.5425	43.5425	43.525	43.535	17536.0
2018-03-27 08:00:00	AAPL	Stock	43.627	43.68	43.4875	43.4875	77612.0
2018-03-27 08:05:00	AAPL	Stock	43.4925	43.5125	43.4825	43.5	17836.0
2018-03-27 08:10:00	AAPL	Stock	43.5	43.5	43.48	43.48	32168.0
2018-03-27 08:15:00	AAPL	Stock	43.5	43.5	43.4975	43.5	63520.0
2018-03-27 08:20:00	AAPL	Stock	43.495	43.5	43.4625	43.47	45928.0
2018-03-27 08:25:00	AAPL	Stock	43.4525	43.4875	43.4	43.4	27516.0
2018-03-27 08:30:00	AAPL	Stock	43.415	43.425	43.4075	43.425	49128.0
2018-03-27 08:35:00	AAPL	Stock	43.4125	43.425	43.41	43.425	30160.0
2018-03-27 08:40:00	AAPL	Stock	43.4175	43.425	43.4075	43.425	19756.0
2018-03-27 08:45:00	AAPL	Stock	43.425	43.45	43.4125	43.435	27864.0
2018-03-27 08:50:00	AAPL	Stock	43.425	43.435	43.3475	43.3475	114468.0
2018-03-27 08:55:00	AAPL	Stock	43.3525	43.405	43.3475	43.3875	14432.0
2018-03-27 09:00:00	AAPL	Stock	43.38	43.405	43.3475	43.3775	26332.0
2018-03-27 09:05:00	AAPL	Stock	43.4	43.4225	43.3875	43.3875	70844.0
2018-03-27 09:10:00	AAPL	Stock	43.3875	43.4575	43.3875	43.4475	47100.0
2018-03-27 09:15:00	AAPL	Stock	43.45	43.45	43.425	43.425	13116.0
2018-03-27 09:20:00	AAPL	Stock	43.425	43.425	43.3625	43.3775	45128.0
2018-03-27 09:25:00	AAPL	Stock	43.41	43.45	43.41	43.4475	53316.0

> showing 50 of 363,795 rows — these rows as CSV

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