PREVIEW / stock_5min / 2018-05-17

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-17.parquet
  size:    5.6 MB
  rows:    360,110
  symbols: 2,838

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-05-17 04:00:00	AAPL	Stock	46.9375	46.9375	46.9025	46.9025	1200.0
2018-05-17 05:55:00	AAPL	Stock	46.995	46.9975	46.995	46.9975	5528.0
2018-05-17 06:50:00	AAPL	Stock	46.875	46.875	46.85	46.85	5884.0
2018-05-17 07:00:00	AAPL	Stock	46.895	46.9	46.895	46.9	8180.0
2018-05-17 07:05:00	AAPL	Stock	46.9	46.9	46.8675	46.875	2764.0
2018-05-17 07:10:00	AAPL	Stock	46.9	46.93	46.9	46.9275	13704.0
2018-05-17 07:30:00	AAPL	Stock	46.925	46.925	46.925	46.925	2000.0
2018-05-17 07:45:00	AAPL	Stock	46.97	46.97	46.97	46.97	400.0
2018-05-17 07:50:00	AAPL	Stock	46.9425	46.95	46.9425	46.95	7576.0
2018-05-17 07:55:00	AAPL	Stock	46.925	46.925	46.925	46.925	2400.0
2018-05-17 08:00:00	AAPL	Stock	46.9	46.9825	46.885	46.9325	28948.0
2018-05-17 08:05:00	AAPL	Stock	46.925	46.925	46.925	46.925	1508.0
2018-05-17 08:10:00	AAPL	Stock	46.9125	46.9375	46.9125	46.925	22120.0
2018-05-17 08:15:00	AAPL	Stock	46.9275	46.9275	46.9125	46.9125	9316.0
2018-05-17 08:20:00	AAPL	Stock	46.915	46.915	46.9	46.9	12192.0
2018-05-17 08:25:00	AAPL	Stock	46.9025	46.9475	46.9025	46.9475	6020.0
2018-05-17 08:30:00	AAPL	Stock	46.8875	46.9375	46.8675	46.875	18896.0
2018-05-17 08:35:00	AAPL	Stock	46.8625	46.875	46.85	46.8625	9856.0
2018-05-17 08:40:00	AAPL	Stock	46.8675	46.89	46.8675	46.89	5596.0
2018-05-17 08:45:00	AAPL	Stock	46.87	46.8925	46.855	46.855	19956.0
2018-05-17 08:50:00	AAPL	Stock	46.8725	46.8925	46.8725	46.8825	9420.0
2018-05-17 08:55:00	AAPL	Stock	46.8925	46.9	46.8925	46.9	3360.0
2018-05-17 09:00:00	AAPL	Stock	46.9125	46.95	46.9125	46.9325	17276.0
2018-05-17 09:05:00	AAPL	Stock	46.945	46.96	46.9375	46.95	10600.0
2018-05-17 09:10:00	AAPL	Stock	46.9475	46.985	46.945	46.9775	15176.0
2018-05-17 09:15:00	AAPL	Stock	46.975	46.9825	46.9525	46.9625	21120.0
2018-05-17 09:20:00	AAPL	Stock	46.955	46.955	46.9175	46.9325	30004.0
2018-05-17 09:25:00	AAPL	Stock	46.925	47.015	46.925	46.9975	16896.0
2018-05-17 09:30:00	AAPL	Stock	47.0	47.055	46.9075	46.96	3196196.0
2018-05-17 09:35:00	AAPL	Stock	46.965	47.03	46.8675	46.92	1426264.0
2018-05-17 09:40:00	AAPL	Stock	46.9205	46.93	46.82	46.835	1220312.0
2018-05-17 09:45:00	AAPL	Stock	46.8325	46.9075	46.8202	46.905	1049132.0
2018-05-17 09:50:00	AAPL	Stock	46.903	46.9475	46.84	46.87	1064656.0
2018-05-17 09:55:00	AAPL	Stock	46.8725	46.885	46.835	46.84	573816.0
2018-05-17 10:00:00	AAPL	Stock	46.845	46.9675	46.83	46.9612	1059824.0
2018-05-17 10:05:00	AAPL	Stock	46.9575	47.015	46.9525	47.0075	861868.0
2018-05-17 10:10:00	AAPL	Stock	47.0075	47.03	46.902	46.9075	934952.0
2018-05-17 10:15:00	AAPL	Stock	46.905	46.9925	46.89	46.975	921964.0
2018-05-17 10:20:00	AAPL	Stock	46.9742	47.05	46.9675	47.0375	783236.0
2018-05-17 10:25:00	AAPL	Stock	47.04	47.075	47.0375	47.0575	787328.0
2018-05-17 10:30:00	AAPL	Stock	47.06	47.1025	47.0362	47.1025	686944.0
2018-05-17 10:35:00	AAPL	Stock	47.1062	47.16	47.09	47.1375	1376256.0
2018-05-17 10:40:00	AAPL	Stock	47.1425	47.185	47.1175	47.1175	1038204.0
2018-05-17 10:45:00	AAPL	Stock	47.12	47.1725	47.1175	47.1615	642380.0
2018-05-17 10:50:00	AAPL	Stock	47.167	47.2075	47.145	47.2	772404.0
2018-05-17 10:55:00	AAPL	Stock	47.1975	47.225	47.1925	47.215	926420.0
2018-05-17 11:00:00	AAPL	Stock	47.215	47.2275	47.15	47.1525	901088.0
2018-05-17 11:05:00	AAPL	Stock	47.155	47.1575	47.105	47.145	901600.0
2018-05-17 11:10:00	AAPL	Stock	47.142	47.1838	47.1375	47.1738	602832.0
2018-05-17 11:15:00	AAPL	Stock	47.1725	47.1725	47.1325	47.1525	438504.0

> showing 50 of 360,110 rows — these rows as CSV

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