PREVIEW / stock_5min / 2017-03-24

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-24.parquet
  size:    5.2 MB
  rows:    343,419
  symbols: 3,052

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-03-24 04:35:00	AAPL	Stock	35.2675	35.285	35.2675	35.285	1600.0
2017-03-24 06:05:00	AAPL	Stock	35.3075	35.3375	35.3075	35.3375	1528.0
2017-03-24 06:25:00	AAPL	Stock	35.2875	35.2875	35.2875	35.2875	4400.0
2017-03-24 06:45:00	AAPL	Stock	35.2875	35.2875	35.2875	35.2875	400.0
2017-03-24 07:15:00	AAPL	Stock	35.315	35.325	35.31	35.3175	11616.0
2017-03-24 07:20:00	AAPL	Stock	35.33	35.3375	35.19	35.2375	79260.0
2017-03-24 07:25:00	AAPL	Stock	35.2475	35.2625	35.2375	35.2375	9548.0
2017-03-24 07:30:00	AAPL	Stock	35.2375	35.2375	35.235	35.2375	7200.0
2017-03-24 07:35:00	AAPL	Stock	35.24	35.275	35.24	35.275	9820.0
2017-03-24 07:40:00	AAPL	Stock	35.285	35.3	35.285	35.3	7200.0
2017-03-24 07:45:00	AAPL	Stock	35.305	35.3075	35.305	35.3075	3760.0
2017-03-24 07:55:00	AAPL	Stock	35.3	35.325	35.3	35.3175	8836.0
2017-03-24 08:00:00	AAPL	Stock	35.2625	35.3225	35.225	35.3225	75080.0
2017-03-24 08:05:00	AAPL	Stock	35.3075	35.32	35.3075	35.3125	7112.0
2017-03-24 08:10:00	AAPL	Stock	35.3075	35.3075	35.3	35.305	2020.0
2017-03-24 08:15:00	AAPL	Stock	35.3	35.3075	35.295	35.3075	12648.0
2017-03-24 08:20:00	AAPL	Stock	35.31	35.3125	35.3	35.3	6628.0
2017-03-24 08:25:00	AAPL	Stock	35.3125	35.3125	35.305	35.3125	3984.0
2017-03-24 08:30:00	AAPL	Stock	35.3225	35.35	35.3225	35.35	9852.0
2017-03-24 08:35:00	AAPL	Stock	35.33	35.3475	35.325	35.3325	7200.0
2017-03-24 08:40:00	AAPL	Stock	35.3175	35.3275	35.3025	35.31	9020.0
2017-03-24 08:45:00	AAPL	Stock	35.3125	35.3125	35.3125	35.3125	400.0
2017-03-24 08:50:00	AAPL	Stock	35.315	35.315	35.315	35.315	400.0
2017-03-24 08:55:00	AAPL	Stock	35.3125	35.325	35.3125	35.325	4320.0
2017-03-24 09:00:00	AAPL	Stock	35.325	35.3325	35.325	35.33	10348.0
2017-03-24 09:05:00	AAPL	Stock	35.3275	35.3325	35.3125	35.3125	13844.0
2017-03-24 09:10:00	AAPL	Stock	35.3125	35.3125	35.305	35.305	6800.0
2017-03-24 09:15:00	AAPL	Stock	35.31	35.3125	35.3025	35.3125	12152.0
2017-03-24 09:20:00	AAPL	Stock	35.3125	35.3325	35.3125	35.33	15620.0
2017-03-24 09:25:00	AAPL	Stock	35.3325	35.375	35.3175	35.3675	70840.0
2017-03-24 09:30:00	AAPL	Stock	35.3475	35.4	35.3	35.35	5020632.0
2017-03-24 09:35:00	AAPL	Stock	35.35	35.3975	35.3475	35.3575	1939028.0
2017-03-24 09:40:00	AAPL	Stock	35.3625	35.4025	35.355	35.4025	1396280.0
2017-03-24 09:45:00	AAPL	Stock	35.4012	35.4225	35.3775	35.4085	2089356.0
2017-03-24 09:50:00	AAPL	Stock	35.41	35.435	35.3975	35.43	1116376.0
2017-03-24 09:55:00	AAPL	Stock	35.4288	35.435	35.38	35.3825	1167908.0
2017-03-24 10:00:00	AAPL	Stock	35.3847	35.385	35.3375	35.35	1249100.0
2017-03-24 10:05:00	AAPL	Stock	35.3525	35.3725	35.34	35.36	600220.0
2017-03-24 10:10:00	AAPL	Stock	35.36	35.36	35.33	35.3425	1070596.0
2017-03-24 10:15:00	AAPL	Stock	35.3425	35.3625	35.3362	35.355	598396.0
2017-03-24 10:20:00	AAPL	Stock	35.3525	35.355	35.32	35.3488	879672.0
2017-03-24 10:25:00	AAPL	Stock	35.3475	35.3475	35.315	35.3325	978576.0
2017-03-24 10:30:00	AAPL	Stock	35.335	35.35	35.315	35.34	803120.0
2017-03-24 10:35:00	AAPL	Stock	35.3375	35.355	35.325	35.3525	581752.0
2017-03-24 10:40:00	AAPL	Stock	35.35	35.3625	35.3325	35.3425	610064.0
2017-03-24 10:45:00	AAPL	Stock	35.3425	35.3725	35.34	35.3675	687224.0
2017-03-24 10:50:00	AAPL	Stock	35.3675	35.4	35.365	35.38	797720.0
2017-03-24 10:55:00	AAPL	Stock	35.3798	35.4075	35.37	35.3775	909256.0
2017-03-24 11:00:00	AAPL	Stock	35.38	35.3975	35.37	35.3925	585472.0
2017-03-24 11:05:00	AAPL	Stock	35.3925	35.4125	35.3925	35.3975	768492.0

> showing 50 of 343,419 rows — these rows as CSV

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