PREVIEW / stock_5min / 2018-01-02

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-01-02.parquet
  size:    5.9 MB
  rows:    376,269
  symbols: 2,929

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-01-02 04:00:00	AAPL	Stock	42.275	42.275	42.275	42.275	3600.0
2018-01-02 04:05:00	AAPL	Stock	42.2775	42.2775	42.2775	42.2775	3748.0
2018-01-02 04:40:00	AAPL	Stock	42.3	42.3	42.3	42.3	4000.0
2018-01-02 04:50:00	AAPL	Stock	42.29	42.29	42.29	42.29	672.0
2018-01-02 04:55:00	AAPL	Stock	42.285	42.295	42.275	42.295	20420.0
2018-01-02 05:00:00	AAPL	Stock	42.3125	42.3125	42.3125	42.3125	800.0
2018-01-02 05:05:00	AAPL	Stock	42.2875	42.3225	42.25	42.25	12920.0
2018-01-02 05:15:00	AAPL	Stock	42.2575	42.2975	42.2575	42.2975	2796.0
2018-01-02 05:20:00	AAPL	Stock	42.295	42.295	42.295	42.295	1200.0
2018-01-02 05:25:00	AAPL	Stock	42.295	42.2975	42.295	42.2975	1392.0
2018-01-02 05:45:00	AAPL	Stock	42.3375	42.3375	42.3375	42.3375	400.0
2018-01-02 06:05:00	AAPL	Stock	42.335	42.335	42.335	42.335	19456.0
2018-01-02 06:40:00	AAPL	Stock	42.37	42.3725	42.37	42.3725	2464.0
2018-01-02 06:45:00	AAPL	Stock	42.3725	42.3725	42.3725	42.3725	1200.0
2018-01-02 06:50:00	AAPL	Stock	42.3725	42.385	42.3725	42.385	2984.0
2018-01-02 06:55:00	AAPL	Stock	42.395	42.4175	42.395	42.4175	19456.0
2018-01-02 07:00:00	AAPL	Stock	42.38	42.4075	42.3775	42.4075	16868.0
2018-01-02 07:05:00	AAPL	Stock	42.4125	42.42	42.4125	42.42	9600.0
2018-01-02 07:10:00	AAPL	Stock	42.425	42.4525	42.425	42.4525	9760.0
2018-01-02 07:15:00	AAPL	Stock	42.455	42.4625	42.4525	42.4625	3416.0
2018-01-02 07:20:00	AAPL	Stock	42.4625	42.4625	42.455	42.4625	2240.0
2018-01-02 07:25:00	AAPL	Stock	42.4525	42.4625	42.4525	42.4625	10036.0
2018-01-02 07:30:00	AAPL	Stock	42.4875	42.5175	42.4875	42.5075	19284.0
2018-01-02 07:35:00	AAPL	Stock	42.505	42.55	42.5025	42.5225	36528.0
2018-01-02 07:40:00	AAPL	Stock	42.515	42.5325	42.515	42.525	8260.0
2018-01-02 07:45:00	AAPL	Stock	42.5125	42.5125	42.49	42.49	15160.0
2018-01-02 07:50:00	AAPL	Stock	42.51	42.51	42.51	42.51	460.0
2018-01-02 07:55:00	AAPL	Stock	42.505	42.5125	42.505	42.5125	4020.0
2018-01-02 08:00:00	AAPL	Stock	42.5025	42.53	42.3825	42.475	34700.0
2018-01-02 08:05:00	AAPL	Stock	42.475	42.5	42.4525	42.5	5368.0
2018-01-02 08:10:00	AAPL	Stock	42.4625	42.5	42.4625	42.4875	18992.0
2018-01-02 08:15:00	AAPL	Stock	42.4625	42.4875	42.4625	42.4875	14600.0
2018-01-02 08:20:00	AAPL	Stock	42.495	42.5225	42.495	42.5225	57388.0
2018-01-02 08:25:00	AAPL	Stock	42.5225	42.53	42.5	42.5125	91136.0
2018-01-02 08:30:00	AAPL	Stock	42.5225	42.5425	42.5	42.5375	67804.0
2018-01-02 08:35:00	AAPL	Stock	42.5275	42.53	42.52	42.525	5200.0
2018-01-02 08:40:00	AAPL	Stock	42.5225	42.5325	42.5225	42.5325	8000.0
2018-01-02 08:45:00	AAPL	Stock	42.535	42.535	42.5125	42.53	15636.0
2018-01-02 08:50:00	AAPL	Stock	42.53	42.5475	42.53	42.5375	66700.0
2018-01-02 08:55:00	AAPL	Stock	42.53	42.54	42.53	42.53	41904.0
2018-01-02 09:00:00	AAPL	Stock	42.5375	42.5475	42.53	42.5375	23656.0
2018-01-02 09:05:00	AAPL	Stock	42.5375	42.555	42.5375	42.555	31704.0
2018-01-02 09:10:00	AAPL	Stock	42.56	42.57	42.5475	42.5625	31572.0
2018-01-02 09:15:00	AAPL	Stock	42.56	42.56	42.545	42.555	6400.0
2018-01-02 09:20:00	AAPL	Stock	42.55	42.55	42.535	42.535	26196.0
2018-01-02 09:25:00	AAPL	Stock	42.535	42.5825	42.5125	42.555	132572.0
2018-01-02 09:30:00	AAPL	Stock	42.54	42.555	42.315	42.4125	5812540.0
2018-01-02 09:35:00	AAPL	Stock	42.41	42.55	42.375	42.5125	3206360.0
2018-01-02 09:40:00	AAPL	Stock	42.5125	42.5875	42.4875	42.5875	3266184.0
2018-01-02 09:45:00	AAPL	Stock	42.5838	42.73	42.5838	42.68	3992236.0

> showing 50 of 376,269 rows — these rows as CSV

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