PREVIEW / stock_5min / 2017-08-01

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-01.parquet
  size:    5.4 MB
  rows:    349,249
  symbols: 2,995

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-08-01 04:00:00	AAPL	Stock	37.2625	37.2625	37.1875	37.1875	13876.0
2017-08-01 04:05:00	AAPL	Stock	37.255	37.26	37.2525	37.26	3200.0
2017-08-01 04:10:00	AAPL	Stock	37.2875	37.2875	37.2875	37.2875	3744.0
2017-08-01 04:15:00	AAPL	Stock	37.32	37.3225	37.32	37.3225	1524.0
2017-08-01 05:05:00	AAPL	Stock	37.325	37.325	37.325	37.325	15184.0
2017-08-01 05:20:00	AAPL	Stock	37.3425	37.3425	37.3275	37.3275	800.0
2017-08-01 05:35:00	AAPL	Stock	37.3525	37.3525	37.3525	37.3525	604.0
2017-08-01 05:50:00	AAPL	Stock	37.33	37.33	37.33	37.33	400.0
2017-08-01 06:00:00	AAPL	Stock	37.3275	37.3275	37.3275	37.3275	400.0
2017-08-01 06:30:00	AAPL	Stock	37.2925	37.2925	37.2925	37.2925	1664.0
2017-08-01 06:40:00	AAPL	Stock	37.2925	37.315	37.2925	37.315	6000.0
2017-08-01 06:45:00	AAPL	Stock	37.2925	37.2925	37.2875	37.2875	13904.0
2017-08-01 06:50:00	AAPL	Stock	37.2925	37.3125	37.2925	37.3125	12000.0
2017-08-01 06:55:00	AAPL	Stock	37.3125	37.3175	37.3025	37.3025	18092.0
2017-08-01 07:00:00	AAPL	Stock	37.3125	37.3125	37.25	37.25	22364.0
2017-08-01 07:05:00	AAPL	Stock	37.2525	37.275	37.225	37.225	11032.0
2017-08-01 07:10:00	AAPL	Stock	37.2125	37.2675	37.2125	37.2675	2448.0
2017-08-01 07:20:00	AAPL	Stock	37.2225	37.2225	37.215	37.215	4800.0
2017-08-01 07:25:00	AAPL	Stock	37.215	37.2375	37.215	37.2375	9092.0
2017-08-01 07:30:00	AAPL	Stock	37.25	37.255	37.2475	37.255	11220.0
2017-08-01 07:45:00	AAPL	Stock	37.255	37.255	37.255	37.255	800.0
2017-08-01 07:50:00	AAPL	Stock	37.2525	37.27	37.25	37.25	19544.0
2017-08-01 07:55:00	AAPL	Stock	37.25	37.275	37.25	37.275	13784.0
2017-08-01 08:00:00	AAPL	Stock	37.3225	37.3225	37.2175	37.25	85264.0
2017-08-01 08:05:00	AAPL	Stock	37.24	37.25	37.1825	37.24	10156.0
2017-08-01 08:10:00	AAPL	Stock	37.245	37.25	37.225	37.23	36472.0
2017-08-01 08:15:00	AAPL	Stock	37.2375	37.2475	37.2375	37.24	12196.0
2017-08-01 08:20:00	AAPL	Stock	37.245	37.2575	37.2275	37.2475	58144.0
2017-08-01 08:25:00	AAPL	Stock	37.2425	37.245	37.235	37.245	29408.0
2017-08-01 08:30:00	AAPL	Stock	37.2425	37.25	37.2375	37.25	11724.0
2017-08-01 08:35:00	AAPL	Stock	37.25	37.25	37.2375	37.2425	3512.0
2017-08-01 08:40:00	AAPL	Stock	37.2425	37.25	37.2425	37.25	17596.0
2017-08-01 08:45:00	AAPL	Stock	37.25	37.2825	37.25	37.2825	74216.0
2017-08-01 08:50:00	AAPL	Stock	37.275	37.2925	37.275	37.2925	10776.0
2017-08-01 08:55:00	AAPL	Stock	37.2925	37.2925	37.27	37.27	17372.0
2017-08-01 09:00:00	AAPL	Stock	37.275	37.2975	37.27	37.2875	17924.0
2017-08-01 09:05:00	AAPL	Stock	37.2775	37.295	37.2775	37.2875	18648.0
2017-08-01 09:10:00	AAPL	Stock	37.2875	37.29	37.2875	37.2875	7180.0
2017-08-01 09:15:00	AAPL	Stock	37.29	37.29	37.28	37.2875	3928.0
2017-08-01 09:20:00	AAPL	Stock	37.2875	37.2875	37.275	37.275	5444.0
2017-08-01 09:25:00	AAPL	Stock	37.275	37.335	37.25	37.2875	93004.0
2017-08-01 09:30:00	AAPL	Stock	37.275	37.3425	37.1675	37.222	4331056.0
2017-08-01 09:35:00	AAPL	Stock	37.2275	37.355	37.1675	37.3075	1960384.0
2017-08-01 09:40:00	AAPL	Stock	37.3108	37.3375	37.25	37.3175	1466928.0
2017-08-01 09:45:00	AAPL	Stock	37.315	37.3312	37.2925	37.3125	965120.0
2017-08-01 09:50:00	AAPL	Stock	37.3175	37.32	37.245	37.2475	1146520.0
2017-08-01 09:55:00	AAPL	Stock	37.2475	37.2825	37.1775	37.2025	1172720.0
2017-08-01 10:00:00	AAPL	Stock	37.1975	37.2445	37.15	37.2275	1339212.0
2017-08-01 10:05:00	AAPL	Stock	37.2325	37.265	37.205	37.2275	881980.0
2017-08-01 10:10:00	AAPL	Stock	37.2288	37.2375	37.225	37.235	794072.0

> showing 50 of 349,249 rows — these rows as CSV

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