PREVIEW / stock_5min / 2017-05-24

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-24.parquet
  size:    5.3 MB
  rows:    346,244
  symbols: 3,023

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-05-24 04:35:00	AAPL	Stock	38.5125	38.5125	38.5125	38.5125	400.0
2017-05-24 06:10:00	AAPL	Stock	38.535	38.55	38.535	38.55	5400.0
2017-05-24 06:30:00	AAPL	Stock	38.5425	38.5425	38.5425	38.5425	800.0
2017-05-24 06:35:00	AAPL	Stock	38.545	38.545	38.545	38.545	1200.0
2017-05-24 06:40:00	AAPL	Stock	38.505	38.505	38.505	38.505	600.0
2017-05-24 06:50:00	AAPL	Stock	38.505	38.505	38.505	38.505	4000.0
2017-05-24 06:55:00	AAPL	Stock	38.5	38.5	38.5	38.5	3988.0
2017-05-24 07:05:00	AAPL	Stock	38.4775	38.4775	38.475	38.475	1972.0
2017-05-24 07:10:00	AAPL	Stock	38.475	38.475	38.475	38.475	800.0
2017-05-24 07:35:00	AAPL	Stock	38.4975	38.4975	38.4975	38.4975	3620.0
2017-05-24 07:40:00	AAPL	Stock	38.475	38.475	38.475	38.475	1024.0
2017-05-24 07:45:00	AAPL	Stock	38.4975	38.4975	38.475	38.4925	1200.0
2017-05-24 07:55:00	AAPL	Stock	38.4925	38.5	38.4925	38.5	2752.0
2017-05-24 08:00:00	AAPL	Stock	38.5	38.535	38.475	38.5	22100.0
2017-05-24 08:05:00	AAPL	Stock	38.5075	38.5125	38.5	38.5	3200.0
2017-05-24 08:10:00	AAPL	Stock	38.5	38.5	38.5	38.5	11524.0
2017-05-24 08:15:00	AAPL	Stock	38.5	38.5	38.46	38.46	9912.0
2017-05-24 08:20:00	AAPL	Stock	38.45	38.45	38.4275	38.4275	4216.0
2017-05-24 08:25:00	AAPL	Stock	38.4275	38.4725	38.4275	38.4725	18088.0
2017-05-24 08:30:00	AAPL	Stock	38.4675	38.48	38.4625	38.465	15380.0
2017-05-24 08:35:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	400.0
2017-05-24 08:40:00	AAPL	Stock	38.4625	38.475	38.4625	38.475	2400.0
2017-05-24 08:45:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	2000.0
2017-05-24 08:50:00	AAPL	Stock	38.4675	38.4875	38.4675	38.4875	10788.0
2017-05-24 08:55:00	AAPL	Stock	38.495	38.505	38.475	38.475	30364.0
2017-05-24 09:00:00	AAPL	Stock	38.4625	38.4625	38.455	38.4625	14652.0
2017-05-24 09:05:00	AAPL	Stock	38.475	38.475	38.4425	38.4425	16660.0
2017-05-24 09:10:00	AAPL	Stock	38.4375	38.45	38.425	38.425	23884.0
2017-05-24 09:15:00	AAPL	Stock	38.425	38.425	38.415	38.415	18608.0
2017-05-24 09:20:00	AAPL	Stock	38.43	38.43	38.43	38.43	800.0
2017-05-24 09:25:00	AAPL	Stock	38.425	38.4625	38.4125	38.4625	84900.0
2017-05-24 09:30:00	AAPL	Stock	38.46	38.5425	38.4025	38.4975	3006540.0
2017-05-24 09:35:00	AAPL	Stock	38.4875	38.505	38.4525	38.4525	1410652.0
2017-05-24 09:40:00	AAPL	Stock	38.4525	38.49	38.4525	38.4875	1160956.0
2017-05-24 09:45:00	AAPL	Stock	38.49	38.5025	38.4575	38.4698	817312.0
2017-05-24 09:50:00	AAPL	Stock	38.47	38.5	38.4625	38.4725	756344.0
2017-05-24 09:55:00	AAPL	Stock	38.468	38.4725	38.405	38.41	1325244.0
2017-05-24 10:00:00	AAPL	Stock	38.4112	38.4285	38.3325	38.3625	1617940.0
2017-05-24 10:05:00	AAPL	Stock	38.3598	38.36	38.3125	38.3175	1523152.0
2017-05-24 10:10:00	AAPL	Stock	38.3175	38.325	38.26	38.295	1645416.0
2017-05-24 10:15:00	AAPL	Stock	38.295	38.3575	38.2935	38.32	1383592.0
2017-05-24 10:20:00	AAPL	Stock	38.3212	38.375	38.3075	38.3725	1148256.0
2017-05-24 10:25:00	AAPL	Stock	38.3725	38.385	38.335	38.335	744424.0
2017-05-24 10:30:00	AAPL	Stock	38.335	38.3975	38.335	38.364	765160.0
2017-05-24 10:35:00	AAPL	Stock	38.3625	38.3925	38.35	38.3538	572844.0
2017-05-24 10:40:00	AAPL	Stock	38.3525	38.361	38.3325	38.3425	644420.0
2017-05-24 10:45:00	AAPL	Stock	38.34	38.345	38.325	38.343	678084.0
2017-05-24 10:50:00	AAPL	Stock	38.3425	38.3425	38.285	38.3118	975076.0
2017-05-24 10:55:00	AAPL	Stock	38.3112	38.325	38.285	38.2875	651228.0
2017-05-24 11:00:00	AAPL	Stock	38.2875	38.295	38.2375	38.245	1774808.0

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

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