PREVIEW / stock_5min / 2017-07-21

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-21.parquet
  size:    5.2 MB
  rows:    342,300
  symbols: 2,992

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
2017-07-21 04:35:00	AAPL	Stock	37.58	37.58	37.58	37.58	1292.0
2017-07-21 06:20:00	AAPL	Stock	37.6	37.6	37.6	37.6	400.0
2017-07-21 06:25:00	AAPL	Stock	37.5825	37.5825	37.58	37.58	4892.0
2017-07-21 06:35:00	AAPL	Stock	37.5625	37.5625	37.4625	37.525	9724.0
2017-07-21 06:45:00	AAPL	Stock	37.525	37.525	37.525	37.525	1600.0
2017-07-21 07:00:00	AAPL	Stock	37.55	37.55	37.55	37.55	400.0
2017-07-21 07:05:00	AAPL	Stock	37.525	37.525	37.525	37.525	400.0
2017-07-21 07:20:00	AAPL	Stock	37.5425	37.5425	37.5425	37.5425	488.0
2017-07-21 07:25:00	AAPL	Stock	37.5425	37.5425	37.5425	37.5425	400.0
2017-07-21 07:30:00	AAPL	Stock	37.5425	37.5425	37.5275	37.5275	1540.0
2017-07-21 07:40:00	AAPL	Stock	37.54	37.5575	37.54	37.5575	1200.0
2017-07-21 07:55:00	AAPL	Stock	37.5425	37.5425	37.5275	37.5275	3200.0
2017-07-21 08:00:00	AAPL	Stock	37.55	37.55	37.5375	37.5375	9332.0
2017-07-21 08:05:00	AAPL	Stock	37.5275	37.5375	37.525	37.525	15356.0
2017-07-21 08:10:00	AAPL	Stock	37.5375	37.5375	37.5125	37.5125	7952.0
2017-07-21 08:15:00	AAPL	Stock	37.5375	37.545	37.505	37.545	6752.0
2017-07-21 08:20:00	AAPL	Stock	37.5175	37.5275	37.5175	37.5275	800.0
2017-07-21 08:25:00	AAPL	Stock	37.5325	37.55	37.5325	37.54	1600.0
2017-07-21 08:30:00	AAPL	Stock	37.5425	37.56	37.5375	37.56	7200.0
2017-07-21 08:35:00	AAPL	Stock	37.54	37.5425	37.5375	37.5425	6572.0
2017-07-21 08:40:00	AAPL	Stock	37.5425	37.5425	37.535	37.54	4640.0
2017-07-21 08:45:00	AAPL	Stock	37.5425	37.5425	37.525	37.525	16768.0
2017-07-21 08:50:00	AAPL	Stock	37.525	37.525	37.525	37.525	2400.0
2017-07-21 08:55:00	AAPL	Stock	37.53	37.5425	37.53	37.5425	3600.0
2017-07-21 09:00:00	AAPL	Stock	37.52	37.535	37.52	37.535	3740.0
2017-07-21 09:05:00	AAPL	Stock	37.535	37.535	37.5125	37.5125	920.0
2017-07-21 09:10:00	AAPL	Stock	37.515	37.5175	37.5025	37.5025	4396.0
2017-07-21 09:15:00	AAPL	Stock	37.52	37.52	37.5025	37.505	8816.0
2017-07-21 09:20:00	AAPL	Stock	37.51	37.52	37.505	37.5125	19236.0
2017-07-21 09:25:00	AAPL	Stock	37.515	37.5675	37.375	37.56	817928.0
2017-07-21 09:30:00	AAPL	Stock	37.56	37.56	37.4	37.4925	10081104.0
2017-07-21 09:35:00	AAPL	Stock	37.5	37.535	37.465	37.4825	1748140.0
2017-07-21 09:40:00	AAPL	Stock	37.4825	37.51	37.4642	37.4675	1076536.0
2017-07-21 09:45:00	AAPL	Stock	37.465	37.47	37.3825	37.43	2228444.0
2017-07-21 09:50:00	AAPL	Stock	37.4275	37.43	37.22	37.307	4017604.0
2017-07-21 09:55:00	AAPL	Stock	37.305	37.3925	37.24	37.385	3032312.0
2017-07-21 10:00:00	AAPL	Stock	37.3875	37.42	37.3575	37.375	1474476.0
2017-07-21 10:05:00	AAPL	Stock	37.3725	37.385	37.3475	37.3825	998676.0
2017-07-21 10:10:00	AAPL	Stock	37.3838	37.4175	37.3772	37.4112	1080776.0
2017-07-21 10:15:00	AAPL	Stock	37.4112	37.435	37.3775	37.42	901796.0
2017-07-21 10:20:00	AAPL	Stock	37.42	37.44	37.405	37.4288	722644.0
2017-07-21 10:25:00	AAPL	Stock	37.4275	37.4275	37.3975	37.4	488768.0
2017-07-21 10:30:00	AAPL	Stock	37.405	37.45	37.4	37.4362	682344.0
2017-07-21 10:35:00	AAPL	Stock	37.4375	37.4925	37.435	37.465	903980.0
2017-07-21 10:40:00	AAPL	Stock	37.465	37.475	37.4225	37.4675	850856.0
2017-07-21 10:45:00	AAPL	Stock	37.47	37.5125	37.47	37.5037	637224.0
2017-07-21 10:50:00	AAPL	Stock	37.5037	37.505	37.4225	37.4462	941512.0
2017-07-21 10:55:00	AAPL	Stock	37.445	37.445	37.405	37.419	471328.0
2017-07-21 11:00:00	AAPL	Stock	37.42	37.4325	37.3625	37.3675	657916.0
2017-07-21 11:05:00	AAPL	Stock	37.37	37.4125	37.34	37.41	1032504.0

> showing 50 of 342,300 rows — these rows as CSV

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