PREVIEW / stock_5min / 2019-03-27

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-03-27.parquet
  size:    5.8 MB
  rows:    367,075
  symbols: 2,642

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-03-27 04:00:00	AAPL	Stock	46.9625	47.22	46.9625	47.14	2300.0
2019-03-27 04:10:00	AAPL	Stock	47.1775	47.1925	47.1775	47.1925	800.0
2019-03-27 04:20:00	AAPL	Stock	47.215	47.215	47.215	47.215	400.0
2019-03-27 04:25:00	AAPL	Stock	47.1575	47.19	47.1475	47.19	8020.0
2019-03-27 04:45:00	AAPL	Stock	47.1275	47.1275	47.1275	47.1275	400.0
2019-03-27 04:55:00	AAPL	Stock	47.065	47.065	47.065	47.065	400.0
2019-03-27 05:30:00	AAPL	Stock	47.1	47.1	47.1	47.1	5776.0
2019-03-27 05:45:00	AAPL	Stock	47.005	47.005	47.0025	47.0025	888.0
2019-03-27 05:50:00	AAPL	Stock	47.0	47.0	46.995	46.9975	1600.0
2019-03-27 05:55:00	AAPL	Stock	46.9625	46.9625	46.9625	46.9625	2076.0
2019-03-27 06:00:00	AAPL	Stock	46.915	46.915	46.915	46.915	400.0
2019-03-27 06:05:00	AAPL	Stock	46.8625	46.8625	46.8625	46.8625	400.0
2019-03-27 06:10:00	AAPL	Stock	46.8375	46.875	46.8375	46.875	2400.0
2019-03-27 06:15:00	AAPL	Stock	46.875	46.875	46.875	46.875	400.0
2019-03-27 06:30:00	AAPL	Stock	46.95	46.95	46.95	46.95	400.0
2019-03-27 06:35:00	AAPL	Stock	46.95	46.95	46.9075	46.9075	1524.0
2019-03-27 06:40:00	AAPL	Stock	46.93	46.95	46.93	46.95	1400.0
2019-03-27 06:50:00	AAPL	Stock	46.9375	46.9375	46.9225	46.9375	6944.0
2019-03-27 07:00:00	AAPL	Stock	46.9425	47.0	46.9025	46.975	20248.0
2019-03-27 07:05:00	AAPL	Stock	46.9825	46.995	46.9225	46.9425	16388.0
2019-03-27 07:10:00	AAPL	Stock	46.885	46.915	46.875	46.8825	7560.0
2019-03-27 07:15:00	AAPL	Stock	46.9125	46.9575	46.9125	46.9575	11100.0
2019-03-27 07:25:00	AAPL	Stock	46.99	47.0	46.9575	46.96	27196.0
2019-03-27 07:30:00	AAPL	Stock	46.9925	47.0675	46.975	47.015	14692.0
2019-03-27 07:35:00	AAPL	Stock	47.0325	47.0925	47.03	47.05	32356.0
2019-03-27 07:40:00	AAPL	Stock	47.0725	47.0725	47.07	47.07	1284.0
2019-03-27 07:45:00	AAPL	Stock	47.07	47.095	46.9975	47.095	29724.0
2019-03-27 07:50:00	AAPL	Stock	47.0925	47.095	47.065	47.0875	17364.0
2019-03-27 07:55:00	AAPL	Stock	47.085	47.0975	47.085	47.09	15668.0
2019-03-27 08:00:00	AAPL	Stock	46.95	47.1475	46.8125	47.05	152184.0
2019-03-27 08:05:00	AAPL	Stock	47.055	47.1075	47.055	47.06	21024.0
2019-03-27 08:10:00	AAPL	Stock	47.055	47.0825	46.975	47.0225	37680.0
2019-03-27 08:15:00	AAPL	Stock	47.0025	47.0275	46.98	47.025	15212.0
2019-03-27 08:20:00	AAPL	Stock	47.01	47.05	47.005	47.0425	11084.0
2019-03-27 08:25:00	AAPL	Stock	47.0575	47.1075	47.0575	47.1075	33700.0
2019-03-27 08:30:00	AAPL	Stock	47.0875	47.1875	47.075	47.1525	22556.0
2019-03-27 08:35:00	AAPL	Stock	47.1625	47.1875	47.15	47.17	49844.0
2019-03-27 08:40:00	AAPL	Stock	47.1825	47.2	47.1	47.1	65984.0
2019-03-27 08:45:00	AAPL	Stock	47.1475	47.1675	47.1075	47.1075	28480.0
2019-03-27 08:50:00	AAPL	Stock	47.125	47.125	47.0925	47.0925	5492.0
2019-03-27 08:55:00	AAPL	Stock	47.1125	47.1125	47.0925	47.0925	14924.0
2019-03-27 09:00:00	AAPL	Stock	47.1125	47.17	47.1125	47.155	30040.0
2019-03-27 09:05:00	AAPL	Stock	47.125	47.1575	47.1	47.1025	21128.0
2019-03-27 09:10:00	AAPL	Stock	47.105	47.105	47.0675	47.07	41172.0
2019-03-27 09:15:00	AAPL	Stock	47.075	47.1125	47.065	47.0825	17356.0
2019-03-27 09:20:00	AAPL	Stock	47.1025	47.1875	47.1025	47.1875	36668.0
2019-03-27 09:25:00	AAPL	Stock	47.155	47.225	47.15	47.2	70908.0
2019-03-27 09:30:00	AAPL	Stock	47.1875	47.3425	47.0725	47.175	5523664.0
2019-03-27 09:35:00	AAPL	Stock	47.18	47.315	47.0825	47.2025	2776372.0
2019-03-27 09:40:00	AAPL	Stock	47.205	47.301	47.115	47.145	2450944.0

> showing 50 of 367,075 rows — these rows as CSV

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