PREVIEW / stock_5min / 2018-08-24

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-24.parquet
  size:    5.4 MB
  rows:    347,483
  symbols: 2,786

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-08-24 04:05:00	AAPL	Stock	54.075	54.075	54.075	54.075	400.0
2018-08-24 04:10:00	AAPL	Stock	54.1125	54.1125	54.1125	54.1125	2212.0
2018-08-24 04:25:00	AAPL	Stock	54.095	54.095	54.095	54.095	1336.0
2018-08-24 04:30:00	AAPL	Stock	54.05	54.05	54.05	54.05	1600.0
2018-08-24 04:40:00	AAPL	Stock	54.025	54.025	54.025	54.025	1200.0
2018-08-24 04:50:00	AAPL	Stock	54.0525	54.0525	54.0525	54.0525	1044.0
2018-08-24 05:40:00	AAPL	Stock	54.0875	54.09	54.0875	54.09	4000.0
2018-08-24 06:15:00	AAPL	Stock	54.0925	54.0925	54.09	54.09	1824.0
2018-08-24 06:20:00	AAPL	Stock	54.0925	54.0925	54.0925	54.0925	6004.0
2018-08-24 06:25:00	AAPL	Stock	54.0925	54.0925	54.06	54.0925	3660.0
2018-08-24 06:30:00	AAPL	Stock	54.1125	54.1125	54.1125	54.1125	1200.0
2018-08-24 07:00:00	AAPL	Stock	54.1	54.1	54.0775	54.1	18076.0
2018-08-24 07:05:00	AAPL	Stock	54.08	54.08	54.07	54.07	800.0
2018-08-24 07:10:00	AAPL	Stock	54.075	54.0875	54.0675	54.075	4000.0
2018-08-24 07:15:00	AAPL	Stock	54.0775	54.08	54.0775	54.08	2200.0
2018-08-24 07:20:00	AAPL	Stock	54.0675	54.0875	54.0625	54.065	30744.0
2018-08-24 07:25:00	AAPL	Stock	54.0825	54.0825	54.0825	54.0825	800.0
2018-08-24 07:30:00	AAPL	Stock	54.08	54.0875	54.0625	54.0625	3800.0
2018-08-24 07:35:00	AAPL	Stock	54.0825	54.0825	54.0825	54.0825	400.0
2018-08-24 07:40:00	AAPL	Stock	54.1025	54.1025	54.1	54.1	4592.0
2018-08-24 07:45:00	AAPL	Stock	54.1	54.1	54.09	54.09	4040.0
2018-08-24 07:55:00	AAPL	Stock	54.105	54.105	54.105	54.105	1036.0
2018-08-24 08:00:00	AAPL	Stock	54.0875	54.1125	54.065	54.0875	100240.0
2018-08-24 08:05:00	AAPL	Stock	54.055	54.055	54.055	54.055	1600.0
2018-08-24 08:10:00	AAPL	Stock	54.055	54.055	54.055	54.055	25200.0
2018-08-24 08:15:00	AAPL	Stock	54.075	54.075	54.075	54.075	800.0
2018-08-24 08:20:00	AAPL	Stock	54.075	54.0925	54.075	54.0925	10488.0
2018-08-24 08:25:00	AAPL	Stock	54.1	54.105	54.095	54.095	16380.0
2018-08-24 08:30:00	AAPL	Stock	54.075	54.075	54.075	54.075	5400.0
2018-08-24 08:35:00	AAPL	Stock	54.1025	54.1125	54.1025	54.1125	5120.0
2018-08-24 08:40:00	AAPL	Stock	54.1125	54.1625	54.1125	54.1575	27480.0
2018-08-24 08:45:00	AAPL	Stock	54.14	54.14	54.1275	54.1275	10332.0
2018-08-24 08:50:00	AAPL	Stock	54.1275	54.1275	54.1075	54.11	22640.0
2018-08-24 08:55:00	AAPL	Stock	54.115	54.135	54.105	54.125	12256.0
2018-08-24 09:00:00	AAPL	Stock	54.1125	54.1125	54.1025	54.1025	1108.0
2018-08-24 09:05:00	AAPL	Stock	54.1375	54.1375	54.1	54.135	4104.0
2018-08-24 09:10:00	AAPL	Stock	54.12	54.15	54.12	54.125	8108.0
2018-08-24 09:15:00	AAPL	Stock	54.1375	54.14	54.125	54.13	3248.0
2018-08-24 09:20:00	AAPL	Stock	54.1225	54.1225	54.105	54.105	10712.0
2018-08-24 09:25:00	AAPL	Stock	54.1225	54.125	54.0775	54.0875	31892.0
2018-08-24 09:30:00	AAPL	Stock	54.15	54.225	54.0625	54.105	3107304.0
2018-08-24 09:35:00	AAPL	Stock	54.106	54.2035	54.0775	54.2035	1195376.0
2018-08-24 09:40:00	AAPL	Stock	54.2025	54.2125	54.111	54.1125	896676.0
2018-08-24 09:45:00	AAPL	Stock	54.11	54.125	53.9685	54.0125	1712712.0
2018-08-24 09:50:00	AAPL	Stock	54.0125	54.0525	53.9725	54.025	1010892.0
2018-08-24 09:55:00	AAPL	Stock	54.0275	54.0275	53.95	53.9725	903604.0
2018-08-24 10:00:00	AAPL	Stock	53.975	54.08	53.96	53.9625	1430308.0
2018-08-24 10:05:00	AAPL	Stock	53.9625	53.985	53.8625	53.8625	1806984.0
2018-08-24 10:10:00	AAPL	Stock	53.8638	53.89	53.7775	53.81	1805676.0
2018-08-24 10:15:00	AAPL	Stock	53.813	53.9275	53.8075	53.9025	1618468.0

> showing 50 of 347,483 rows — these rows as CSV

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