PREVIEW / stock_5min / 2017-10-19

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-19.parquet
  size:    5.3 MB
  rows:    346,342
  symbols: 2,924

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-10-19 04:00:00	AAPL	Stock	39.625	39.625	39.325	39.35	16648.0
2017-10-19 04:05:00	AAPL	Stock	39.325	39.325	39.3	39.3	1852.0
2017-10-19 04:15:00	AAPL	Stock	39.25	39.3125	39.2125	39.3125	3740.0
2017-10-19 04:20:00	AAPL	Stock	39.4	39.4	39.4	39.4	400.0
2017-10-19 04:25:00	AAPL	Stock	39.375	39.375	39.375	39.375	4000.0
2017-10-19 04:30:00	AAPL	Stock	39.425	39.425	39.42	39.42	1200.0
2017-10-19 04:35:00	AAPL	Stock	39.4175	39.4175	39.275	39.275	23092.0
2017-10-19 04:40:00	AAPL	Stock	39.36	39.3625	39.36	39.3625	1492.0
2017-10-19 04:55:00	AAPL	Stock	39.3625	39.42	39.3625	39.42	800.0
2017-10-19 05:00:00	AAPL	Stock	39.3625	39.3625	39.3625	39.3625	3500.0
2017-10-19 05:05:00	AAPL	Stock	39.3625	39.3625	39.3625	39.3625	600.0
2017-10-19 05:10:00	AAPL	Stock	39.3625	39.3725	39.3625	39.3725	800.0
2017-10-19 05:15:00	AAPL	Stock	39.3625	39.3625	39.36	39.36	1200.0
2017-10-19 05:20:00	AAPL	Stock	39.36	39.36	39.36	39.36	800.0
2017-10-19 05:25:00	AAPL	Stock	39.3575	39.3575	39.3575	39.3575	800.0
2017-10-19 05:30:00	AAPL	Stock	39.3575	39.3575	39.3575	39.3575	1600.0
2017-10-19 05:40:00	AAPL	Stock	39.3125	39.36	39.3125	39.36	3576.0
2017-10-19 05:45:00	AAPL	Stock	39.36	39.36	39.36	39.36	400.0
2017-10-19 05:50:00	AAPL	Stock	39.36	39.36	39.35	39.35	8800.0
2017-10-19 05:55:00	AAPL	Stock	39.3425	39.3425	39.3375	39.3375	11944.0
2017-10-19 06:00:00	AAPL	Stock	39.335	39.335	39.3	39.315	17600.0
2017-10-19 06:05:00	AAPL	Stock	39.315	39.3375	39.315	39.3375	10000.0
2017-10-19 06:10:00	AAPL	Stock	39.325	39.325	39.325	39.325	400.0
2017-10-19 06:15:00	AAPL	Stock	39.3025	39.3025	39.3025	39.3025	1240.0
2017-10-19 06:20:00	AAPL	Stock	39.32	39.32	39.29	39.2975	13900.0
2017-10-19 06:25:00	AAPL	Stock	39.2775	39.2775	39.255	39.2575	1400.0
2017-10-19 06:30:00	AAPL	Stock	39.3025	39.3175	39.295	39.3	4820.0
2017-10-19 06:35:00	AAPL	Stock	39.3	39.3175	39.3	39.3175	3008.0
2017-10-19 06:40:00	AAPL	Stock	39.3	39.3	39.2925	39.2925	6800.0
2017-10-19 06:45:00	AAPL	Stock	39.2925	39.2925	39.25	39.265	50052.0
2017-10-19 06:50:00	AAPL	Stock	39.2725	39.2725	39.25	39.25	28360.0
2017-10-19 06:55:00	AAPL	Stock	39.29	39.29	39.26	39.2875	1600.0
2017-10-19 07:00:00	AAPL	Stock	39.3175	39.325	39.2775	39.2825	74828.0
2017-10-19 07:05:00	AAPL	Stock	39.285	39.3375	39.285	39.3025	29548.0
2017-10-19 07:10:00	AAPL	Stock	39.3	39.3125	39.265	39.2925	39336.0
2017-10-19 07:15:00	AAPL	Stock	39.2925	39.325	39.27	39.27	22760.0
2017-10-19 07:20:00	AAPL	Stock	39.2875	39.4	39.2875	39.3525	56496.0
2017-10-19 07:25:00	AAPL	Stock	39.345	39.3975	39.345	39.3725	46988.0
2017-10-19 07:30:00	AAPL	Stock	39.3725	39.425	39.3725	39.375	58640.0
2017-10-19 07:35:00	AAPL	Stock	39.4	39.4425	39.375	39.4425	54656.0
2017-10-19 07:40:00	AAPL	Stock	39.42	39.425	39.3875	39.4125	42652.0
2017-10-19 07:45:00	AAPL	Stock	39.4	39.41	39.365	39.375	149900.0
2017-10-19 07:50:00	AAPL	Stock	39.3625	39.375	39.3	39.3025	70616.0
2017-10-19 07:55:00	AAPL	Stock	39.3375	39.37	39.3375	39.37	17848.0
2017-10-19 08:00:00	AAPL	Stock	39.37	39.425	39.27	39.3525	149460.0
2017-10-19 08:05:00	AAPL	Stock	39.3625	39.3625	39.3275	39.3375	28956.0
2017-10-19 08:10:00	AAPL	Stock	39.345	39.35	39.2675	39.2675	132900.0
2017-10-19 08:15:00	AAPL	Stock	39.2675	39.275	39.2125	39.25	160832.0
2017-10-19 08:20:00	AAPL	Stock	39.25	39.285	39.25	39.26	40536.0
2017-10-19 08:25:00	AAPL	Stock	39.2625	39.305	39.23	39.25	95832.0

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

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