PREVIEW / stock_5min / 2019-04-24

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-04-24.parquet
  size:    5.7 MB
  rows:    358,584
  symbols: 2,613

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-04-24 04:00:00	AAPL	Stock	51.905	51.975	51.8825	51.905	3668.0
2019-04-24 04:05:00	AAPL	Stock	51.975	51.975	51.97	51.975	17160.0
2019-04-24 04:10:00	AAPL	Stock	51.975	51.975	51.975	51.975	4536.0
2019-04-24 04:15:00	AAPL	Stock	51.975	52.04	51.975	52.0	4832.0
2019-04-24 04:20:00	AAPL	Stock	51.995	52.0	51.995	52.0	4252.0
2019-04-24 04:25:00	AAPL	Stock	52.0075	52.0075	52.0075	52.0075	400.0
2019-04-24 04:30:00	AAPL	Stock	51.9625	51.9625	51.9625	51.9625	5600.0
2019-04-24 06:00:00	AAPL	Stock	51.9975	51.9975	51.9975	51.9975	1600.0
2019-04-24 06:05:00	AAPL	Stock	51.9975	52.025	51.9975	52.025	1388.0
2019-04-24 06:25:00	AAPL	Stock	52.025	52.025	52.025	52.025	400.0
2019-04-24 06:30:00	AAPL	Stock	52.025	52.025	52.025	52.025	968.0
2019-04-24 06:45:00	AAPL	Stock	51.9975	51.9975	51.9975	51.9975	1524.0
2019-04-24 07:00:00	AAPL	Stock	52.0075	52.03	52.0	52.0	14776.0
2019-04-24 07:05:00	AAPL	Stock	52.02	52.02	51.975	51.9775	4052.0
2019-04-24 07:10:00	AAPL	Stock	51.9625	51.975	51.95	51.95	32468.0
2019-04-24 07:15:00	AAPL	Stock	51.9375	51.9575	51.9125	51.95	9744.0
2019-04-24 07:20:00	AAPL	Stock	51.95	51.9575	51.94	51.9475	9596.0
2019-04-24 07:25:00	AAPL	Stock	51.95	51.9625	51.945	51.9625	10160.0
2019-04-24 07:30:00	AAPL	Stock	51.945	51.9875	51.9425	51.9875	15228.0
2019-04-24 07:35:00	AAPL	Stock	51.985	52.0	51.9775	51.9775	30032.0
2019-04-24 07:40:00	AAPL	Stock	52.0075	52.0075	51.9375	51.9375	19356.0
2019-04-24 07:45:00	AAPL	Stock	51.9675	51.9675	51.9675	51.9675	2000.0
2019-04-24 07:55:00	AAPL	Stock	51.9625	51.9725	51.9625	51.9725	8680.0
2019-04-24 08:00:00	AAPL	Stock	52.0275	52.036	51.9225	51.98	71868.0
2019-04-24 08:05:00	AAPL	Stock	51.9775	51.9775	51.9775	51.9775	1496.0
2019-04-24 08:10:00	AAPL	Stock	51.9775	52.0	51.9775	52.0	12528.0
2019-04-24 08:15:00	AAPL	Stock	52.0075	52.03	52.0	52.025	16624.0
2019-04-24 08:20:00	AAPL	Stock	52.0125	52.025	51.98	51.98	30400.0
2019-04-24 08:25:00	AAPL	Stock	51.9825	52.0	51.945	51.9625	30200.0
2019-04-24 08:30:00	AAPL	Stock	51.95	51.9575	51.915	51.9225	19500.0
2019-04-24 08:35:00	AAPL	Stock	51.915	51.93	51.9125	51.9175	7872.0
2019-04-24 08:40:00	AAPL	Stock	51.9175	51.9275	51.8875	51.9	16296.0
2019-04-24 08:45:00	AAPL	Stock	51.91	51.93	51.9	51.93	15380.0
2019-04-24 08:50:00	AAPL	Stock	51.9275	51.94	51.9175	51.94	11212.0
2019-04-24 08:55:00	AAPL	Stock	51.9472	51.9475	51.9225	51.9225	9232.0
2019-04-24 09:00:00	AAPL	Stock	51.9375	51.94	51.8775	51.885	28996.0
2019-04-24 09:05:00	AAPL	Stock	51.8775	51.8775	51.84	51.85	40008.0
2019-04-24 09:10:00	AAPL	Stock	51.8625	51.875	51.8345	51.855	24236.0
2019-04-24 09:15:00	AAPL	Stock	51.8625	51.905	51.84	51.8625	23612.0
2019-04-24 09:20:00	AAPL	Stock	51.8625	51.865	51.8375	51.8375	34964.0
2019-04-24 09:25:00	AAPL	Stock	51.85	51.995	51.81	51.8375	82612.0
2019-04-24 09:30:00	AAPL	Stock	51.835	52.1	51.805	52.0075	5373196.0
2019-04-24 09:35:00	AAPL	Stock	52.0067	52.075	51.9025	52.045	2506764.0
2019-04-24 09:40:00	AAPL	Stock	52.045	52.05	51.9075	51.9875	1674196.0
2019-04-24 09:45:00	AAPL	Stock	51.9875	52.0225	51.915	51.98	1496128.0
2019-04-24 09:50:00	AAPL	Stock	51.98	51.9825	51.8147	51.8588	2149280.0
2019-04-24 09:55:00	AAPL	Stock	51.86	51.91	51.815	51.86	1468972.0
2019-04-24 10:00:00	AAPL	Stock	51.8575	51.875	51.7625	51.862	1360556.0
2019-04-24 10:05:00	AAPL	Stock	51.8625	51.9125	51.85	51.9025	1061636.0
2019-04-24 10:10:00	AAPL	Stock	51.9	51.9625	51.88	51.9512	766972.0

> showing 50 of 358,584 rows — these rows as CSV

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