PREVIEW / stock_5min / 2018-07-24

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-24.parquet
  size:    5.6 MB
  rows:    354,394
  symbols: 2,831

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
2018-07-24 04:00:00	AAPL	Stock	48.025	48.045	48.025	48.045	1600.0
2018-07-24 04:10:00	AAPL	Stock	48.055	48.055	48.045	48.045	6400.0
2018-07-24 04:35:00	AAPL	Stock	48.095	48.1	48.095	48.1	2800.0
2018-07-24 04:50:00	AAPL	Stock	48.09	48.09	48.09	48.09	600.0
2018-07-24 05:15:00	AAPL	Stock	48.0975	48.0975	48.075	48.075	1952.0
2018-07-24 05:30:00	AAPL	Stock	48.1125	48.1125	48.1125	48.1125	800.0
2018-07-24 06:05:00	AAPL	Stock	48.135	48.135	48.025	48.03	24496.0
2018-07-24 06:10:00	AAPL	Stock	48.0175	48.03	47.95	47.95	9940.0
2018-07-24 06:15:00	AAPL	Stock	47.9375	47.95	47.8775	47.8775	39320.0
2018-07-24 06:25:00	AAPL	Stock	47.8975	47.935	47.8975	47.935	1600.0
2018-07-24 06:35:00	AAPL	Stock	47.945	47.95	47.945	47.95	1000.0
2018-07-24 06:40:00	AAPL	Stock	48.06	48.06	48.06	48.06	400.0
2018-07-24 06:45:00	AAPL	Stock	47.9625	47.9625	47.925	47.925	16632.0
2018-07-24 06:50:00	AAPL	Stock	47.945	47.9625	47.945	47.9625	800.0
2018-07-24 07:00:00	AAPL	Stock	48.0	48.03	47.9975	47.9975	11344.0
2018-07-24 07:05:00	AAPL	Stock	47.975	47.98	47.9625	47.9625	4800.0
2018-07-24 07:10:00	AAPL	Stock	47.965	47.965	47.9625	47.9625	2816.0
2018-07-24 07:15:00	AAPL	Stock	47.9375	47.94	47.9375	47.9375	2060.0
2018-07-24 07:20:00	AAPL	Stock	47.97	48.005	47.97	48.0	33668.0
2018-07-24 07:25:00	AAPL	Stock	47.9975	47.9975	47.9975	47.9975	2000.0
2018-07-24 07:30:00	AAPL	Stock	47.9625	47.995	47.9625	47.9875	2800.0
2018-07-24 07:35:00	AAPL	Stock	48.0	48.025	47.9975	48.0125	14552.0
2018-07-24 07:40:00	AAPL	Stock	48.0	48.02	47.98	48.02	13228.0
2018-07-24 07:45:00	AAPL	Stock	48.015	48.0275	48.005	48.005	8800.0
2018-07-24 07:50:00	AAPL	Stock	48.015	48.035	48.015	48.035	5192.0
2018-07-24 07:55:00	AAPL	Stock	48.05	48.0625	48.0375	48.0625	10108.0
2018-07-24 08:00:00	AAPL	Stock	47.9625	48.0825	47.9375	48.0825	93228.0
2018-07-24 08:05:00	AAPL	Stock	48.0825	48.115	48.0825	48.0925	30244.0
2018-07-24 08:10:00	AAPL	Stock	48.105	48.105	48.075	48.0775	9200.0
2018-07-24 08:15:00	AAPL	Stock	48.095	48.1125	48.0775	48.11	17992.0
2018-07-24 08:20:00	AAPL	Stock	48.1075	48.125	48.105	48.125	31036.0
2018-07-24 08:25:00	AAPL	Stock	48.135	48.1525	48.135	48.1375	16404.0
2018-07-24 08:30:00	AAPL	Stock	48.1375	48.1525	48.0925	48.0975	14716.0
2018-07-24 08:35:00	AAPL	Stock	48.105	48.1075	48.0825	48.1075	47104.0
2018-07-24 08:40:00	AAPL	Stock	48.085	48.12	48.0825	48.0925	14932.0
2018-07-24 08:45:00	AAPL	Stock	48.1025	48.115	48.0875	48.115	9252.0
2018-07-24 08:50:00	AAPL	Stock	48.11	48.125	48.1025	48.1075	17660.0
2018-07-24 08:55:00	AAPL	Stock	48.1005	48.1005	48.0875	48.0875	1240.0
2018-07-24 09:00:00	AAPL	Stock	48.0875	48.1	48.08	48.0975	11936.0
2018-07-24 09:05:00	AAPL	Stock	48.0975	48.125	48.095	48.12	12612.0
2018-07-24 09:10:00	AAPL	Stock	48.125	48.1475	48.12	48.1475	11328.0
2018-07-24 09:15:00	AAPL	Stock	48.1475	48.15	48.13	48.135	15940.0
2018-07-24 09:20:00	AAPL	Stock	48.135	48.1375	48.1025	48.1125	9072.0
2018-07-24 09:25:00	AAPL	Stock	48.13	48.135	48.0225	48.0225	28228.0
2018-07-24 09:30:00	AAPL	Stock	48.1125	48.245	48.0475	48.24	3608584.0
2018-07-24 09:35:00	AAPL	Stock	48.2425	48.3525	48.2	48.3485	2445976.0
2018-07-24 09:40:00	AAPL	Stock	48.35	48.415	48.2325	48.2925	2991732.0
2018-07-24 09:45:00	AAPL	Stock	48.2912	48.325	48.2225	48.2875	1559220.0
2018-07-24 09:50:00	AAPL	Stock	48.285	48.345	48.28	48.3075	1019576.0
2018-07-24 09:55:00	AAPL	Stock	48.315	48.345	48.2325	48.295	1019080.0

> showing 50 of 354,394 rows — these rows as CSV

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