PREVIEW / stock_5min / 2020-05-27

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-05-27.parquet
  size:    6.7 MB
  rows:    423,509
  symbols: 2,375

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
2020-05-27 04:00:00	AAPL	Stock	79.8	79.88	79.8	79.85	4860.0
2020-05-27 04:05:00	AAPL	Stock	79.89	79.89	79.89	79.89	400.0
2020-05-27 04:10:00	AAPL	Stock	79.8675	79.8675	79.8675	79.8675	400.0
2020-05-27 04:25:00	AAPL	Stock	79.9125	79.9125	79.825	79.825	2288.0
2020-05-27 04:40:00	AAPL	Stock	79.9625	79.9625	79.9625	79.9625	544.0
2020-05-27 04:45:00	AAPL	Stock	79.885	79.885	79.885	79.885	800.0
2020-05-27 04:50:00	AAPL	Stock	79.8825	79.8825	79.8825	79.8825	592.0
2020-05-27 05:00:00	AAPL	Stock	79.9725	80.05	79.9725	80.05	1960.0
2020-05-27 05:05:00	AAPL	Stock	80.07	80.1675	80.07	80.0875	7920.0
2020-05-27 05:10:00	AAPL	Stock	80.0875	80.1225	80.0875	80.1225	4800.0
2020-05-27 05:15:00	AAPL	Stock	80.1225	80.1225	80.1	80.1225	4828.0
2020-05-27 05:20:00	AAPL	Stock	80.1375	80.1375	80.1375	80.1375	400.0
2020-05-27 05:25:00	AAPL	Stock	80.23	80.25	80.23	80.25	3768.0
2020-05-27 05:30:00	AAPL	Stock	80.1675	80.1675	80.1675	80.1675	3164.0
2020-05-27 05:35:00	AAPL	Stock	80.2	80.2	80.055	80.125	8920.0
2020-05-27 05:45:00	AAPL	Stock	80.195	80.195	80.195	80.195	2132.0
2020-05-27 05:50:00	AAPL	Stock	80.1575	80.25	80.1575	80.25	6572.0
2020-05-27 05:55:00	AAPL	Stock	80.24	80.255	80.24	80.25	4600.0
2020-05-27 06:00:00	AAPL	Stock	80.3025	80.3025	80.2525	80.2525	1000.0
2020-05-27 06:05:00	AAPL	Stock	80.1925	80.1925	80.1375	80.1375	1596.0
2020-05-27 06:10:00	AAPL	Stock	80.1275	80.17	80.1	80.1675	9368.0
2020-05-27 06:15:00	AAPL	Stock	80.125	80.125	80.1225	80.125	2196.0
2020-05-27 06:20:00	AAPL	Stock	80.125	80.125	80.1225	80.1225	1796.0
2020-05-27 06:30:00	AAPL	Stock	80.12	80.12	80.1075	80.1075	1520.0
2020-05-27 06:35:00	AAPL	Stock	80.0525	80.0525	80.0025	80.0025	1040.0
2020-05-27 06:40:00	AAPL	Stock	80.0025	80.0175	79.995	80.0	11932.0
2020-05-27 06:45:00	AAPL	Stock	80.0	80.0625	79.9675	80.0625	1704.0
2020-05-27 06:50:00	AAPL	Stock	80.0625	80.1	80.0625	80.1	4796.0
2020-05-27 06:55:00	AAPL	Stock	80.03	80.03	79.955	80.025	3600.0
2020-05-27 07:00:00	AAPL	Stock	80.0125	80.0125	79.8	79.8025	65544.0
2020-05-27 07:05:00	AAPL	Stock	79.8425	79.875	79.8175	79.85	11120.0
2020-05-27 07:10:00	AAPL	Stock	79.8275	79.88	79.7525	79.76	30948.0
2020-05-27 07:15:00	AAPL	Stock	79.7575	79.775	79.695	79.695	8408.0
2020-05-27 07:20:00	AAPL	Stock	79.65	79.7575	79.65	79.7025	4428.0
2020-05-27 07:25:00	AAPL	Stock	79.7325	79.7325	79.6875	79.7125	1604.0
2020-05-27 07:30:00	AAPL	Stock	79.6625	79.685	79.5925	79.5925	10920.0
2020-05-27 07:35:00	AAPL	Stock	79.625	79.65	79.5925	79.5925	6636.0
2020-05-27 07:40:00	AAPL	Stock	79.5925	79.625	79.49	79.49	30812.0
2020-05-27 07:45:00	AAPL	Stock	79.5	79.5	79.445	79.475	5844.0
2020-05-27 07:50:00	AAPL	Stock	79.4825	79.6125	79.475	79.5875	7348.0
2020-05-27 07:55:00	AAPL	Stock	79.5075	79.5975	79.475	79.475	18468.0
2020-05-27 08:00:00	AAPL	Stock	79.4975	79.95	79.38	79.515	88504.0
2020-05-27 08:05:00	AAPL	Stock	79.5	79.515	79.4025	79.4725	21964.0
2020-05-27 08:10:00	AAPL	Stock	79.46	79.6	79.4275	79.5875	11932.0
2020-05-27 08:15:00	AAPL	Stock	79.56	79.635	79.56	79.6125	13808.0
2020-05-27 08:20:00	AAPL	Stock	79.615	79.6225	79.5525	79.575	19892.0
2020-05-27 08:25:00	AAPL	Stock	79.57	79.6	79.5125	79.55	26792.0
2020-05-27 08:30:00	AAPL	Stock	79.5908	79.62	79.4975	79.4975	14820.0
2020-05-27 08:35:00	AAPL	Stock	79.5	79.5	79.4	79.425	50388.0
2020-05-27 08:40:00	AAPL	Stock	79.4425	79.457	79.375	79.375	33412.0

> showing 50 of 423,509 rows — these rows as CSV

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