PREVIEW / stock_5min / 2018-10-09

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-10-09.parquet
  size:    5.7 MB
  rows:    362,229
  symbols: 2,800

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-10-09 04:00:00	AAPL	Stock	55.8675	55.8675	55.865	55.865	1536.0
2018-10-09 04:10:00	AAPL	Stock	55.7975	55.7975	55.7975	55.7975	400.0
2018-10-09 04:20:00	AAPL	Stock	55.7975	55.7975	55.7975	55.7975	540.0
2018-10-09 04:30:00	AAPL	Stock	55.75	55.75	55.75	55.75	416.0
2018-10-09 04:40:00	AAPL	Stock	55.86	55.86	55.86	55.86	400.0
2018-10-09 05:05:00	AAPL	Stock	55.8275	55.8275	55.825	55.825	4400.0
2018-10-09 05:15:00	AAPL	Stock	55.8325	55.8325	55.825	55.825	2112.0
2018-10-09 05:25:00	AAPL	Stock	55.8	55.8	55.8	55.8	400.0
2018-10-09 05:35:00	AAPL	Stock	55.775	55.775	55.775	55.775	400.0
2018-10-09 06:00:00	AAPL	Stock	55.695	55.715	55.695	55.715	800.0
2018-10-09 06:05:00	AAPL	Stock	55.725	55.725	55.725	55.725	1356.0
2018-10-09 06:10:00	AAPL	Stock	55.75	55.75	55.75	55.75	1200.0
2018-10-09 06:25:00	AAPL	Stock	55.675	55.675	55.675	55.675	400.0
2018-10-09 06:35:00	AAPL	Stock	55.725	55.7625	55.725	55.7625	2800.0
2018-10-09 06:40:00	AAPL	Stock	55.7625	55.7625	55.7625	55.7625	400.0
2018-10-09 06:50:00	AAPL	Stock	55.775	55.785	55.775	55.785	4864.0
2018-10-09 06:55:00	AAPL	Stock	55.79	55.79	55.79	55.79	1200.0
2018-10-09 07:00:00	AAPL	Stock	55.845	55.845	55.795	55.795	3512.0
2018-10-09 07:05:00	AAPL	Stock	55.8125	55.8125	55.7775	55.7775	4340.0
2018-10-09 07:10:00	AAPL	Stock	55.765	55.765	55.69	55.69	26524.0
2018-10-09 07:15:00	AAPL	Stock	55.69	55.69	55.625	55.625	18044.0
2018-10-09 07:20:00	AAPL	Stock	55.65	55.65	55.5525	55.625	29368.0
2018-10-09 07:25:00	AAPL	Stock	55.6575	55.6875	55.63	55.6325	39536.0
2018-10-09 07:30:00	AAPL	Stock	55.65	55.65	55.5125	55.515	36096.0
2018-10-09 07:35:00	AAPL	Stock	55.5675	55.585	55.5225	55.55	14756.0
2018-10-09 07:40:00	AAPL	Stock	55.55	55.5875	55.5325	55.57	4256.0
2018-10-09 07:45:00	AAPL	Stock	55.575	55.5925	55.5375	55.5925	29412.0
2018-10-09 07:50:00	AAPL	Stock	55.575	55.59	55.435	55.5	30988.0
2018-10-09 07:55:00	AAPL	Stock	55.5	55.5	55.475	55.475	9676.0
2018-10-09 08:00:00	AAPL	Stock	55.4975	55.85	55.47	55.5875	104608.0
2018-10-09 08:05:00	AAPL	Stock	55.5825	55.5975	55.55	55.55	17652.0
2018-10-09 08:10:00	AAPL	Stock	55.565	55.575	55.5	55.5	15676.0
2018-10-09 08:15:00	AAPL	Stock	55.53	55.535	55.5	55.5225	13952.0
2018-10-09 08:20:00	AAPL	Stock	55.5225	55.575	55.5	55.575	106632.0
2018-10-09 08:25:00	AAPL	Stock	55.5725	55.6025	55.5725	55.58	37180.0
2018-10-09 08:30:00	AAPL	Stock	55.5975	55.62	55.5975	55.62	39108.0
2018-10-09 08:35:00	AAPL	Stock	55.6425	55.65	55.6125	55.65	48272.0
2018-10-09 08:40:00	AAPL	Stock	55.665	55.6975	55.6575	55.675	35560.0
2018-10-09 08:45:00	AAPL	Stock	55.68	55.73	55.68	55.7125	44348.0
2018-10-09 08:50:00	AAPL	Stock	55.7125	55.7475	55.7	55.7475	12992.0
2018-10-09 08:55:00	AAPL	Stock	55.725	55.85	55.725	55.8425	72948.0
2018-10-09 09:00:00	AAPL	Stock	55.825	55.8375	55.6875	55.6875	78368.0
2018-10-09 09:05:00	AAPL	Stock	55.685	55.75	55.675	55.75	73796.0
2018-10-09 09:10:00	AAPL	Stock	55.7375	55.7725	55.705	55.705	30732.0
2018-10-09 09:15:00	AAPL	Stock	55.7025	55.71	55.6525	55.6525	25892.0
2018-10-09 09:20:00	AAPL	Stock	55.67	55.7	55.6625	55.665	26420.0
2018-10-09 09:25:00	AAPL	Stock	55.665	55.9075	55.665	55.9075	98648.0
2018-10-09 09:30:00	AAPL	Stock	55.9075	56.1288	55.7175	55.99	4511552.0
2018-10-09 09:35:00	AAPL	Stock	55.9775	56.2325	55.9175	55.9925	2797916.0
2018-10-09 09:40:00	AAPL	Stock	56.0038	56.0302	55.67	55.9912	2361556.0

> showing 50 of 362,229 rows — these rows as CSV

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