PREVIEW / stock_5min / 2017-08-22

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-22.parquet
  size:    5.2 MB
  rows:    340,847
  symbols: 2,985

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
2017-08-22 04:10:00	AAPL	Stock	39.45	39.45	39.45	39.45	920.0
2017-08-22 04:15:00	AAPL	Stock	39.4525	39.4525	39.4525	39.4525	400.0
2017-08-22 06:00:00	AAPL	Stock	39.4	39.4	39.4	39.4	480.0
2017-08-22 06:20:00	AAPL	Stock	39.4225	39.445	39.4225	39.445	2404.0
2017-08-22 06:35:00	AAPL	Stock	39.42	39.4425	39.42	39.4425	4000.0
2017-08-22 06:40:00	AAPL	Stock	39.4375	39.4375	39.4375	39.4375	3508.0
2017-08-22 07:00:00	AAPL	Stock	39.425	39.425	39.425	39.425	6172.0
2017-08-22 07:05:00	AAPL	Stock	39.425	39.425	39.415	39.415	4720.0
2017-08-22 07:10:00	AAPL	Stock	39.4275	39.45	39.4275	39.45	7000.0
2017-08-22 07:20:00	AAPL	Stock	39.4425	39.4425	39.4275	39.4325	11268.0
2017-08-22 07:25:00	AAPL	Stock	39.4325	39.4325	39.425	39.425	4796.0
2017-08-22 07:30:00	AAPL	Stock	39.425	39.425	39.425	39.425	1872.0
2017-08-22 07:35:00	AAPL	Stock	39.43	39.43	39.43	39.43	716.0
2017-08-22 07:40:00	AAPL	Stock	39.4375	39.4375	39.4375	39.4375	792.0
2017-08-22 07:45:00	AAPL	Stock	39.4425	39.4475	39.4375	39.4475	2800.0
2017-08-22 07:50:00	AAPL	Stock	39.445	39.45	39.445	39.45	10400.0
2017-08-22 07:55:00	AAPL	Stock	39.4375	39.4425	39.4375	39.4425	2080.0
2017-08-22 08:00:00	AAPL	Stock	39.4475	39.455	39.425	39.4425	47032.0
2017-08-22 08:05:00	AAPL	Stock	39.45	39.4625	39.44	39.4625	29436.0
2017-08-22 08:10:00	AAPL	Stock	39.4625	39.485	39.4625	39.4825	20448.0
2017-08-22 08:15:00	AAPL	Stock	39.4825	39.5075	39.4825	39.5	63504.0
2017-08-22 08:20:00	AAPL	Stock	39.5	39.505	39.475	39.475	15200.0
2017-08-22 08:25:00	AAPL	Stock	39.5	39.5375	39.5	39.525	28920.0
2017-08-22 08:30:00	AAPL	Stock	39.525	39.525	39.525	39.525	2400.0
2017-08-22 08:35:00	AAPL	Stock	39.5025	39.5175	39.5025	39.505	9600.0
2017-08-22 08:40:00	AAPL	Stock	39.5175	39.5225	39.5175	39.5225	2356.0
2017-08-22 08:45:00	AAPL	Stock	39.5225	39.5225	39.4525	39.4525	23848.0
2017-08-22 08:50:00	AAPL	Stock	39.4625	39.475	39.4625	39.475	9436.0
2017-08-22 08:55:00	AAPL	Stock	39.48	39.485	39.475	39.485	2400.0
2017-08-22 09:00:00	AAPL	Stock	39.4775	39.4775	39.45	39.4775	28052.0
2017-08-22 09:05:00	AAPL	Stock	39.4775	39.5	39.4775	39.485	22552.0
2017-08-22 09:10:00	AAPL	Stock	39.4875	39.5	39.4875	39.5	5852.0
2017-08-22 09:15:00	AAPL	Stock	39.505	39.5125	39.4925	39.5125	23328.0
2017-08-22 09:20:00	AAPL	Stock	39.5125	39.525	39.4925	39.5175	22332.0
2017-08-22 09:25:00	AAPL	Stock	39.535	39.5625	39.525	39.55	32588.0
2017-08-22 09:30:00	AAPL	Stock	39.5575	39.6725	39.505	39.667	3316976.0
2017-08-22 09:35:00	AAPL	Stock	39.665	39.81	39.64	39.765	2931156.0
2017-08-22 09:40:00	AAPL	Stock	39.7625	39.7975	39.7075	39.775	2249244.0
2017-08-22 09:45:00	AAPL	Stock	39.7775	39.79	39.675	39.7495	1628068.0
2017-08-22 09:50:00	AAPL	Stock	39.75	39.79	39.725	39.7668	1477532.0
2017-08-22 09:55:00	AAPL	Stock	39.7625	39.7775	39.69	39.7285	1191068.0
2017-08-22 10:00:00	AAPL	Stock	39.7288	39.845	39.7228	39.7675	1821996.0
2017-08-22 10:05:00	AAPL	Stock	39.7725	39.8065	39.7525	39.7802	792588.0
2017-08-22 10:10:00	AAPL	Stock	39.781	39.8725	39.781	39.87	1381280.0
2017-08-22 10:15:00	AAPL	Stock	39.8725	39.9125	39.8425	39.8725	1427600.0
2017-08-22 10:20:00	AAPL	Stock	39.8725	39.9125	39.83	39.85	1383660.0
2017-08-22 10:25:00	AAPL	Stock	39.85	39.865	39.8075	39.8375	1026236.0
2017-08-22 10:30:00	AAPL	Stock	39.841	39.8625	39.8145	39.848	644696.0
2017-08-22 10:35:00	AAPL	Stock	39.8475	39.856	39.815	39.83	585192.0
2017-08-22 10:40:00	AAPL	Stock	39.8348	39.835	39.7825	39.8025	1162152.0

> showing 50 of 340,847 rows — these rows as CSV

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