PREVIEW / stock_5min / 2019-08-14

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-08-14.parquet
  size:    5.9 MB
  rows:    369,800
  symbols: 2,570

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-08-14 04:00:00	AAPL	Stock	52.2375	52.2375	52.05	52.05	1284.0
2019-08-14 04:05:00	AAPL	Stock	52.19	52.19	52.19	52.19	800.0
2019-08-14 04:10:00	AAPL	Stock	52.1275	52.1275	52.06	52.06	1600.0
2019-08-14 04:15:00	AAPL	Stock	52.09	52.09	52.09	52.09	800.0
2019-08-14 04:20:00	AAPL	Stock	52.1275	52.1275	52.1275	52.1275	400.0
2019-08-14 04:30:00	AAPL	Stock	52.205	52.2075	52.205	52.2075	1520.0
2019-08-14 04:45:00	AAPL	Stock	52.0875	52.0875	52.0875	52.0875	400.0
2019-08-14 05:05:00	AAPL	Stock	52.045	52.045	52.045	52.045	400.0
2019-08-14 05:10:00	AAPL	Stock	52.0275	52.0275	52.025	52.025	2588.0
2019-08-14 05:15:00	AAPL	Stock	52.0	52.0	51.975	52.0	4000.0
2019-08-14 05:20:00	AAPL	Stock	52.0	52.0	51.975	51.975	800.0
2019-08-14 05:25:00	AAPL	Stock	51.925	51.975	51.9	51.975	1200.0
2019-08-14 05:30:00	AAPL	Stock	51.9325	51.975	51.9275	51.975	1632.0
2019-08-14 05:40:00	AAPL	Stock	51.8875	51.91	51.85	51.91	2812.0
2019-08-14 05:45:00	AAPL	Stock	51.835	51.835	51.835	51.835	1212.0
2019-08-14 05:50:00	AAPL	Stock	51.8525	51.8525	51.8525	51.8525	400.0
2019-08-14 06:00:00	AAPL	Stock	51.8075	51.8075	51.7525	51.7525	2000.0
2019-08-14 06:05:00	AAPL	Stock	51.7475	51.7475	51.7475	51.7475	1920.0
2019-08-14 06:10:00	AAPL	Stock	51.565	51.6	51.565	51.5775	4524.0
2019-08-14 06:15:00	AAPL	Stock	51.6	51.6	51.54	51.54	19132.0
2019-08-14 06:20:00	AAPL	Stock	51.5	51.5	51.5	51.5	400.0
2019-08-14 06:25:00	AAPL	Stock	51.465	51.475	51.465	51.475	2788.0
2019-08-14 06:30:00	AAPL	Stock	51.575	51.6	51.575	51.5875	4880.0
2019-08-14 06:35:00	AAPL	Stock	51.595	51.595	51.5025	51.5025	6220.0
2019-08-14 06:40:00	AAPL	Stock	51.56	51.5625	51.56	51.5625	1600.0
2019-08-14 06:45:00	AAPL	Stock	51.6325	51.6375	51.6325	51.6375	4000.0
2019-08-14 06:50:00	AAPL	Stock	51.5775	51.63	51.5625	51.5625	3300.0
2019-08-14 07:00:00	AAPL	Stock	51.54	51.7375	51.54	51.7375	55320.0
2019-08-14 07:05:00	AAPL	Stock	51.7375	51.7525	51.6275	51.65	37928.0
2019-08-14 07:10:00	AAPL	Stock	51.64	51.65	51.5775	51.65	51688.0
2019-08-14 07:15:00	AAPL	Stock	51.65	51.65	51.6225	51.635	9360.0
2019-08-14 07:20:00	AAPL	Stock	51.6425	51.6425	51.5875	51.6375	23372.0
2019-08-14 07:25:00	AAPL	Stock	51.66	51.66	51.6025	51.6025	30988.0
2019-08-14 07:30:00	AAPL	Stock	51.6	51.6325	51.5625	51.5625	41624.0
2019-08-14 07:35:00	AAPL	Stock	51.5375	51.575	51.5275	51.5275	12824.0
2019-08-14 07:40:00	AAPL	Stock	51.535	51.535	51.4	51.4625	48620.0
2019-08-14 07:45:00	AAPL	Stock	51.4125	51.4125	51.3175	51.3625	63208.0
2019-08-14 07:50:00	AAPL	Stock	51.375	51.375	51.25	51.2825	85184.0
2019-08-14 07:55:00	AAPL	Stock	51.31	51.3725	51.2875	51.3325	14092.0
2019-08-14 08:00:00	AAPL	Stock	51.7028	51.75	51.175	51.23	233456.0
2019-08-14 08:05:00	AAPL	Stock	51.235	52.1125	51.1275	51.1375	159288.0
2019-08-14 08:10:00	AAPL	Stock	51.1375	51.1625	50.96	51.005	171544.0
2019-08-14 08:15:00	AAPL	Stock	51.0498	51.1	51.0	51.0225	99216.0
2019-08-14 08:20:00	AAPL	Stock	51.025	51.0725	51.0	51.0	61308.0
2019-08-14 08:25:00	AAPL	Stock	51.0	51.085	50.975	51.0475	147408.0
2019-08-14 08:30:00	AAPL	Stock	51.075	51.075	50.93	50.95	56972.0
2019-08-14 08:35:00	AAPL	Stock	50.98	51.0	50.955	50.9575	51848.0
2019-08-14 08:40:00	AAPL	Stock	50.995	51.0625	50.98	51.01	183168.0
2019-08-14 08:45:00	AAPL	Stock	51.0	51.065	51.0	51.015	84432.0
2019-08-14 08:50:00	AAPL	Stock	51.015	51.05	50.975	51.0	101144.0

> showing 50 of 369,800 rows — these rows as CSV

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