PREVIEW / stock_5min / 2017-07-26

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-26.parquet
  size:    5.4 MB
  rows:    347,290
  symbols: 2,991

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-26 04:10:00	AAPL	Stock	38.26	38.3225	38.26	38.3225	2400.0
2017-07-26 06:25:00	AAPL	Stock	38.2875	38.2875	38.2875	38.2875	400.0
2017-07-26 07:15:00	AAPL	Stock	38.3025	38.3025	38.3025	38.3025	728.0
2017-07-26 07:20:00	AAPL	Stock	38.34	38.34	38.34	38.34	800.0
2017-07-26 07:25:00	AAPL	Stock	38.325	38.325	38.325	38.325	2600.0
2017-07-26 07:30:00	AAPL	Stock	38.3125	38.325	38.3125	38.3125	2600.0
2017-07-26 07:35:00	AAPL	Stock	38.3075	38.3075	38.3	38.3	5552.0
2017-07-26 07:40:00	AAPL	Stock	38.3025	38.3025	38.3025	38.3025	400.0
2017-07-26 07:45:00	AAPL	Stock	38.2875	38.2875	38.2875	38.2875	800.0
2017-07-26 07:55:00	AAPL	Stock	38.3125	38.3125	38.31	38.31	1384.0
2017-07-26 08:00:00	AAPL	Stock	38.325	38.335	38.3	38.3175	60508.0
2017-07-26 08:05:00	AAPL	Stock	38.3175	38.325	38.315	38.325	3500.0
2017-07-26 08:10:00	AAPL	Stock	38.325	38.325	38.3	38.3	11396.0
2017-07-26 08:20:00	AAPL	Stock	38.305	38.305	38.305	38.305	800.0
2017-07-26 08:25:00	AAPL	Stock	38.3075	38.33	38.3075	38.33	29696.0
2017-07-26 08:30:00	AAPL	Stock	38.3425	38.35	38.3425	38.35	2800.0
2017-07-26 08:35:00	AAPL	Stock	38.35	38.355	38.35	38.355	3168.0
2017-07-26 08:40:00	AAPL	Stock	38.3275	38.3375	38.3	38.3375	12648.0
2017-07-26 08:45:00	AAPL	Stock	38.3375	38.3375	38.325	38.325	3200.0
2017-07-26 08:50:00	AAPL	Stock	38.325	38.325	38.325	38.325	13748.0
2017-07-26 08:55:00	AAPL	Stock	38.3225	38.335	38.3225	38.335	4400.0
2017-07-26 09:00:00	AAPL	Stock	38.335	38.335	38.32	38.33	9500.0
2017-07-26 09:05:00	AAPL	Stock	38.3375	38.345	38.3375	38.345	3196.0
2017-07-26 09:10:00	AAPL	Stock	38.355	38.37	38.35	38.37	8504.0
2017-07-26 09:15:00	AAPL	Stock	38.3525	38.355	38.3375	38.355	16108.0
2017-07-26 09:20:00	AAPL	Stock	38.3425	38.35	38.3425	38.345	8500.0
2017-07-26 09:25:00	AAPL	Stock	38.34	38.365	38.3125	38.3375	106540.0
2017-07-26 09:30:00	AAPL	Stock	38.3375	38.4825	38.3375	38.4042	3056200.0
2017-07-26 09:35:00	AAPL	Stock	38.4	38.4258	38.355	38.365	1022004.0
2017-07-26 09:40:00	AAPL	Stock	38.3678	38.3725	38.2875	38.3025	1497888.0
2017-07-26 09:45:00	AAPL	Stock	38.31	38.3425	38.2925	38.32	897840.0
2017-07-26 09:50:00	AAPL	Stock	38.325	38.325	38.265	38.295	1083372.0
2017-07-26 09:55:00	AAPL	Stock	38.2975	38.3725	38.2875	38.3575	912188.0
2017-07-26 10:00:00	AAPL	Stock	38.3572	38.4275	38.3475	38.3975	1702688.0
2017-07-26 10:05:00	AAPL	Stock	38.4025	38.44	38.3575	38.4125	906404.0
2017-07-26 10:10:00	AAPL	Stock	38.4125	38.4375	38.4025	38.4312	886072.0
2017-07-26 10:15:00	AAPL	Stock	38.43	38.4598	38.4168	38.445	709744.0
2017-07-26 10:20:00	AAPL	Stock	38.445	38.4825	38.4375	38.4375	1229724.0
2017-07-26 10:25:00	AAPL	Stock	38.44	38.4625	38.405	38.405	1038760.0
2017-07-26 10:30:00	AAPL	Stock	38.405	38.425	38.3875	38.395	668368.0
2017-07-26 10:35:00	AAPL	Stock	38.3975	38.44	38.38	38.3825	619300.0
2017-07-26 10:40:00	AAPL	Stock	38.38	38.385	38.33	38.3325	657660.0
2017-07-26 10:45:00	AAPL	Stock	38.3325	38.3575	38.3025	38.345	770244.0
2017-07-26 10:50:00	AAPL	Stock	38.345	38.3562	38.2925	38.2938	755296.0
2017-07-26 10:55:00	AAPL	Stock	38.2938	38.3325	38.2875	38.2968	738468.0
2017-07-26 11:00:00	AAPL	Stock	38.2972	38.3422	38.295	38.335	441144.0
2017-07-26 11:05:00	AAPL	Stock	38.3375	38.3825	38.33	38.3725	810084.0
2017-07-26 11:10:00	AAPL	Stock	38.3738	38.41	38.3738	38.3825	758820.0
2017-07-26 11:15:00	AAPL	Stock	38.385	38.3988	38.3725	38.3925	589920.0
2017-07-26 11:20:00	AAPL	Stock	38.395	38.395	38.3175	38.325	572364.0

> showing 50 of 347,290 rows — these rows as CSV

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