PREVIEW / stock_5min / 2019-11-25

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-11-25.parquet
  size:    5.9 MB
  rows:    368,244
  symbols: 2,516

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
2019-11-25 04:00:00	AAPL	Stock	65.6675	65.7625	65.6675	65.7375	6780.0
2019-11-25 04:05:00	AAPL	Stock	65.755	65.7975	65.755	65.7975	2300.0
2019-11-25 04:10:00	AAPL	Stock	65.7925	65.7925	65.7925	65.7925	892.0
2019-11-25 04:45:00	AAPL	Stock	65.7	65.7	65.7	65.7	2764.0
2019-11-25 05:00:00	AAPL	Stock	65.7475	65.7475	65.7475	65.7475	400.0
2019-11-25 05:10:00	AAPL	Stock	65.7475	65.7475	65.7475	65.7475	1996.0
2019-11-25 05:40:00	AAPL	Stock	65.7475	65.75	65.7475	65.75	3512.0
2019-11-25 06:25:00	AAPL	Stock	65.7625	65.7625	65.7625	65.7625	2800.0
2019-11-25 06:55:00	AAPL	Stock	65.745	65.745	65.7375	65.7375	2348.0
2019-11-25 07:00:00	AAPL	Stock	65.7375	65.7375	65.7	65.7	23936.0
2019-11-25 07:05:00	AAPL	Stock	65.7075	65.725	65.675	65.675	13576.0
2019-11-25 07:10:00	AAPL	Stock	65.675	65.675	65.675	65.675	2000.0
2019-11-25 07:15:00	AAPL	Stock	65.6775	65.6775	65.6675	65.675	9644.0
2019-11-25 07:25:00	AAPL	Stock	65.6575	65.6575	65.6575	65.6575	400.0
2019-11-25 07:30:00	AAPL	Stock	65.685	65.695	65.6675	65.695	2368.0
2019-11-25 07:35:00	AAPL	Stock	65.685	65.685	65.685	65.685	400.0
2019-11-25 07:40:00	AAPL	Stock	65.6825	65.6875	65.67	65.6875	3200.0
2019-11-25 07:45:00	AAPL	Stock	65.685	65.6875	65.685	65.6875	800.0
2019-11-25 07:50:00	AAPL	Stock	65.6875	65.7	65.6875	65.7	1280.0
2019-11-25 07:55:00	AAPL	Stock	65.6875	65.6875	65.6875	65.6875	1600.0
2019-11-25 08:00:00	AAPL	Stock	65.6625	65.7212	65.65	65.6875	103096.0
2019-11-25 08:05:00	AAPL	Stock	65.6825	65.695	65.4	65.6675	60632.0
2019-11-25 08:10:00	AAPL	Stock	65.6675	65.6725	65.4	65.455	97380.0
2019-11-25 08:15:00	AAPL	Stock	65.4475	65.4925	65.4	65.4925	11900.0
2019-11-25 08:20:00	AAPL	Stock	65.4925	65.525	65.475	65.5	8800.0
2019-11-25 08:25:00	AAPL	Stock	65.5	65.525	65.4975	65.525	30084.0
2019-11-25 08:30:00	AAPL	Stock	65.5475	65.624	65.5475	65.62	16584.0
2019-11-25 08:35:00	AAPL	Stock	65.605	65.6125	65.575	65.575	7788.0
2019-11-25 08:40:00	AAPL	Stock	65.5925	65.6	65.5925	65.6	5364.0
2019-11-25 08:45:00	AAPL	Stock	65.595	65.595	65.5875	65.5925	3912.0
2019-11-25 08:50:00	AAPL	Stock	65.6075	65.6075	65.5885	65.5885	6400.0
2019-11-25 08:55:00	AAPL	Stock	65.61	65.6375	65.61	65.6375	10976.0
2019-11-25 09:00:00	AAPL	Stock	65.6275	65.6275	65.585	65.5875	4660.0
2019-11-25 09:05:00	AAPL	Stock	65.6125	65.6125	65.585	65.6125	4184.0
2019-11-25 09:10:00	AAPL	Stock	65.6125	65.6425	65.6	65.62	8300.0
2019-11-25 09:15:00	AAPL	Stock	65.625	65.67	65.625	65.6625	9412.0
2019-11-25 09:20:00	AAPL	Stock	65.6575	65.6775	65.625	65.64	19632.0
2019-11-25 09:25:00	AAPL	Stock	65.63	65.6575	65.625	65.6575	18724.0
2019-11-25 09:30:00	AAPL	Stock	65.66	66.0475	65.63	66.03	3322736.0
2019-11-25 09:35:00	AAPL	Stock	66.0425	66.12	65.9575	66.1075	1570232.0
2019-11-25 09:40:00	AAPL	Stock	66.105	66.16	66.095	66.1268	1237544.0
2019-11-25 09:45:00	AAPL	Stock	66.125	66.1375	66.05	66.06	979028.0
2019-11-25 09:50:00	AAPL	Stock	66.061	66.21	66.061	66.1642	1161256.0
2019-11-25 09:55:00	AAPL	Stock	66.17	66.1875	66.105	66.1425	751772.0
2019-11-25 10:00:00	AAPL	Stock	66.1475	66.155	66.105	66.1195	607580.0
2019-11-25 10:05:00	AAPL	Stock	66.12	66.18	66.12	66.18	614268.0
2019-11-25 10:10:00	AAPL	Stock	66.18	66.216	66.1505	66.1538	900116.0
2019-11-25 10:15:00	AAPL	Stock	66.155	66.185	66.135	66.1625	468712.0
2019-11-25 10:20:00	AAPL	Stock	66.1625	66.25	66.16	66.235	780868.0
2019-11-25 10:25:00	AAPL	Stock	66.2325	66.298	66.2135	66.2938	1369532.0

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

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