PREVIEW / stock_5min / 2019-09-23

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-09-23.parquet
  size:    5.6 MB
  rows:    360,090
  symbols: 2,561

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-23 04:00:00	AAPL	Stock	54.5625	54.7225	54.545	54.545	1716.0
2019-09-23 04:05:00	AAPL	Stock	54.5	54.53	54.5	54.53	1280.0
2019-09-23 04:15:00	AAPL	Stock	54.5	54.5	54.4325	54.445	17292.0
2019-09-23 04:35:00	AAPL	Stock	54.435	54.435	54.375	54.375	6240.0
2019-09-23 04:55:00	AAPL	Stock	54.355	54.355	54.35	54.35	2132.0
2019-09-23 05:00:00	AAPL	Stock	54.35	54.3625	54.35	54.35	8396.0
2019-09-23 05:55:00	AAPL	Stock	54.5275	54.5275	54.5275	54.5275	400.0
2019-09-23 06:20:00	AAPL	Stock	54.5625	54.5625	54.5625	54.5625	400.0
2019-09-23 06:30:00	AAPL	Stock	54.5625	54.5625	54.5625	54.5625	3996.0
2019-09-23 06:40:00	AAPL	Stock	54.61	54.61	54.61	54.61	920.0
2019-09-23 06:45:00	AAPL	Stock	54.61	54.6175	54.515	54.515	9232.0
2019-09-23 07:00:00	AAPL	Stock	54.65	54.7175	54.65	54.7175	11580.0
2019-09-23 07:05:00	AAPL	Stock	54.7125	54.7125	54.5975	54.5975	38468.0
2019-09-23 07:10:00	AAPL	Stock	54.6175	54.625	54.5875	54.6	5624.0
2019-09-23 07:15:00	AAPL	Stock	54.5875	54.5875	54.5175	54.555	29400.0
2019-09-23 07:20:00	AAPL	Stock	54.525	54.5925	54.525	54.5925	1412.0
2019-09-23 07:25:00	AAPL	Stock	54.5625	54.5925	54.5625	54.5925	1200.0
2019-09-23 07:30:00	AAPL	Stock	54.6	54.6125	54.6	54.6125	5428.0
2019-09-23 07:35:00	AAPL	Stock	54.595	54.6	54.5625	54.5625	16756.0
2019-09-23 07:40:00	AAPL	Stock	54.575	54.575	54.575	54.575	5808.0
2019-09-23 07:45:00	AAPL	Stock	54.575	54.575	54.5375	54.5375	8400.0
2019-09-23 07:50:00	AAPL	Stock	54.5375	54.5375	54.53	54.53	13720.0
2019-09-23 07:55:00	AAPL	Stock	54.52	54.5375	54.515	54.515	22876.0
2019-09-23 08:00:00	AAPL	Stock	54.625	54.7175	54.515	54.6	53068.0
2019-09-23 08:05:00	AAPL	Stock	54.6	54.62	54.5875	54.6	14300.0
2019-09-23 08:10:00	AAPL	Stock	54.575	54.575	54.56	54.56	13800.0
2019-09-23 08:15:00	AAPL	Stock	54.56	54.5625	54.5275	54.5275	15924.0
2019-09-23 08:20:00	AAPL	Stock	54.5225	54.5375	54.5125	54.515	16400.0
2019-09-23 08:25:00	AAPL	Stock	54.5175	54.5375	54.5125	54.525	5540.0
2019-09-23 08:30:00	AAPL	Stock	54.52	54.52	54.45	54.47	40560.0
2019-09-23 08:35:00	AAPL	Stock	54.47	54.5	54.4675	54.5	26192.0
2019-09-23 08:40:00	AAPL	Stock	54.5	54.5975	54.5	54.5525	28580.0
2019-09-23 08:45:00	AAPL	Stock	54.4325	54.61	54.4325	54.5625	41140.0
2019-09-23 08:50:00	AAPL	Stock	54.525	54.55	54.525	54.5425	2400.0
2019-09-23 08:55:00	AAPL	Stock	54.55	54.6275	54.55	54.6275	12472.0
2019-09-23 09:00:00	AAPL	Stock	54.62	54.675	54.6025	54.63	10940.0
2019-09-23 09:05:00	AAPL	Stock	54.63	54.6625	54.625	54.645	15108.0
2019-09-23 09:10:00	AAPL	Stock	54.625	54.625	54.6025	54.625	23612.0
2019-09-23 09:15:00	AAPL	Stock	54.605	54.6125	54.5125	54.5475	43368.0
2019-09-23 09:20:00	AAPL	Stock	54.565	54.5975	54.5475	54.58	21348.0
2019-09-23 09:25:00	AAPL	Stock	54.58	54.8025	54.58	54.7475	79980.0
2019-09-23 09:30:00	AAPL	Stock	54.7275	54.8725	54.6775	54.775	3676516.0
2019-09-23 09:35:00	AAPL	Stock	54.7725	54.8275	54.555	54.56	2043804.0
2019-09-23 09:40:00	AAPL	Stock	54.56	54.8	54.53	54.795	1386996.0
2019-09-23 09:45:00	AAPL	Stock	54.8	54.862	54.715	54.7328	1886936.0
2019-09-23 09:50:00	AAPL	Stock	54.735	54.855	54.5925	54.7125	1303392.0
2019-09-23 09:55:00	AAPL	Stock	54.715	54.755	54.6325	54.6338	975080.0
2019-09-23 10:00:00	AAPL	Stock	54.64	54.6612	54.5025	54.5225	1424596.0
2019-09-23 10:05:00	AAPL	Stock	54.525	54.59	54.5012	54.5375	870908.0
2019-09-23 10:10:00	AAPL	Stock	54.5325	54.536	54.4225	54.4638	1594768.0

> showing 50 of 360,090 rows — these rows as CSV

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