PREVIEW / stock_5min / 2018-07-05

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-05.parquet
  size:    5.5 MB
  rows:    358,137
  symbols: 2,820

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-07-05 04:00:00	AAPL	Stock	46.1125	46.2	46.1125	46.2	3600.0
2018-07-05 04:05:00	AAPL	Stock	46.2	46.225	46.2	46.225	1240.0
2018-07-05 04:20:00	AAPL	Stock	46.25	46.25	46.235	46.235	2400.0
2018-07-05 04:25:00	AAPL	Stock	46.235	46.235	46.235	46.235	3200.0
2018-07-05 04:55:00	AAPL	Stock	46.25	46.25	46.25	46.25	400.0
2018-07-05 05:15:00	AAPL	Stock	46.2375	46.2375	46.2375	46.2375	1216.0
2018-07-05 05:55:00	AAPL	Stock	46.3	46.3	46.3	46.3	2000.0
2018-07-05 06:00:00	AAPL	Stock	46.295	46.295	46.295	46.295	1200.0
2018-07-05 06:05:00	AAPL	Stock	46.25	46.25	46.25	46.25	1180.0
2018-07-05 06:10:00	AAPL	Stock	46.25	46.25	46.25	46.25	480.0
2018-07-05 06:50:00	AAPL	Stock	46.24	46.24	46.24	46.24	3816.0
2018-07-05 07:00:00	AAPL	Stock	46.2425	46.2675	46.24	46.2475	27968.0
2018-07-05 07:05:00	AAPL	Stock	46.26	46.275	46.26	46.275	5084.0
2018-07-05 07:10:00	AAPL	Stock	46.2575	46.2875	46.2575	46.2875	8000.0
2018-07-05 07:15:00	AAPL	Stock	46.2975	46.3075	46.2975	46.3075	14192.0
2018-07-05 07:20:00	AAPL	Stock	46.3025	46.325	46.3	46.3	11608.0
2018-07-05 07:25:00	AAPL	Stock	46.3	46.3	46.3	46.3	2180.0
2018-07-05 07:30:00	AAPL	Stock	46.3025	46.3025	46.3	46.3	7132.0
2018-07-05 07:35:00	AAPL	Stock	46.3025	46.3025	46.3025	46.3025	800.0
2018-07-05 07:40:00	AAPL	Stock	46.3	46.315	46.3	46.315	2700.0
2018-07-05 07:45:00	AAPL	Stock	46.3025	46.3125	46.3025	46.3125	17372.0
2018-07-05 07:50:00	AAPL	Stock	46.325	46.35	46.325	46.35	41256.0
2018-07-05 07:55:00	AAPL	Stock	46.35	46.355	46.35	46.35	20012.0
2018-07-05 08:00:00	AAPL	Stock	46.3562	46.365	46.2675	46.35	61156.0
2018-07-05 08:05:00	AAPL	Stock	46.3625	46.3625	46.325	46.34	13484.0
2018-07-05 08:10:00	AAPL	Stock	46.3475	46.3675	46.3475	46.3625	25736.0
2018-07-05 08:15:00	AAPL	Stock	46.3625	46.38	46.3625	46.38	13116.0
2018-07-05 08:20:00	AAPL	Stock	46.3825	46.41	46.3725	46.3775	11896.0
2018-07-05 08:25:00	AAPL	Stock	46.3775	46.3775	46.3325	46.3725	5172.0
2018-07-05 08:30:00	AAPL	Stock	46.3575	46.38	46.3575	46.38	9032.0
2018-07-05 08:35:00	AAPL	Stock	46.3875	46.395	46.35	46.35	65632.0
2018-07-05 08:40:00	AAPL	Stock	46.365	46.365	46.35	46.35	24800.0
2018-07-05 08:45:00	AAPL	Stock	46.35	46.355	46.325	46.35	13264.0
2018-07-05 08:50:00	AAPL	Stock	46.3375	46.35	46.325	46.325	7040.0
2018-07-05 08:55:00	AAPL	Stock	46.325	46.3275	46.315	46.3275	7692.0
2018-07-05 09:00:00	AAPL	Stock	46.33	46.34	46.3225	46.3225	17828.0
2018-07-05 09:05:00	AAPL	Stock	46.3175	46.3225	46.3025	46.3025	6960.0
2018-07-05 09:10:00	AAPL	Stock	46.3	46.305	46.2975	46.2975	10960.0
2018-07-05 09:15:00	AAPL	Stock	46.31	46.325	46.2875	46.3025	18692.0
2018-07-05 09:20:00	AAPL	Stock	46.2975	46.33	46.275	46.3	79184.0
2018-07-05 09:25:00	AAPL	Stock	46.3025	46.345	46.3	46.3075	60300.0
2018-07-05 09:30:00	AAPL	Stock	46.2975	46.565	46.285	46.5175	3563892.0
2018-07-05 09:35:00	AAPL	Stock	46.5242	46.5975	46.4925	46.585	1735212.0
2018-07-05 09:40:00	AAPL	Stock	46.585	46.6025	46.54	46.57	1552012.0
2018-07-05 09:45:00	AAPL	Stock	46.57	46.59	46.475	46.53	1671500.0
2018-07-05 09:50:00	AAPL	Stock	46.5325	46.5418	46.4825	46.49	1021200.0
2018-07-05 09:55:00	AAPL	Stock	46.49	46.505	46.3825	46.39	898624.0
2018-07-05 10:00:00	AAPL	Stock	46.41	46.4642	46.3275	46.3425	1010024.0
2018-07-05 10:05:00	AAPL	Stock	46.345	46.3875	46.33	46.38	1170244.0
2018-07-05 10:10:00	AAPL	Stock	46.38	46.38	46.2825	46.308	973652.0

> showing 50 of 358,137 rows — these rows as CSV

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