PREVIEW / stock_5min / 2016-12-23

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-12-23.parquet
  size:    5.1 MB
  rows:    335,638
  symbols: 3,149

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
2016-12-23 05:45:00	AAPL	Stock	28.9775	28.9775	28.9775	28.9775	400.0
2016-12-23 06:35:00	AAPL	Stock	28.97	28.97	28.97	28.97	2000.0
2016-12-23 07:00:00	AAPL	Stock	28.99	29.0175	28.99	29.0175	4040.0
2016-12-23 07:05:00	AAPL	Stock	29.0125	29.0125	29.005	29.005	5256.0
2016-12-23 07:10:00	AAPL	Stock	29.0025	29.0025	29.0025	29.0025	400.0
2016-12-23 07:15:00	AAPL	Stock	29.0	29.0	29.0	29.0	5804.0
2016-12-23 07:25:00	AAPL	Stock	28.99	28.995	28.99	28.995	3332.0
2016-12-23 07:35:00	AAPL	Stock	28.9775	28.98	28.975	28.975	2800.0
2016-12-23 07:40:00	AAPL	Stock	28.9675	28.9675	28.9675	28.9675	400.0
2016-12-23 07:55:00	AAPL	Stock	28.9625	28.9625	28.9575	28.9575	2600.0
2016-12-23 08:00:00	AAPL	Stock	29.0	29.0025	28.96	28.975	9600.0
2016-12-23 08:05:00	AAPL	Stock	28.9575	28.9575	28.9575	28.9575	2760.0
2016-12-23 08:10:00	AAPL	Stock	28.95	28.95	28.9375	28.95	6700.0
2016-12-23 08:15:00	AAPL	Stock	28.9625	28.975	28.9625	28.97	2100.0
2016-12-23 08:25:00	AAPL	Stock	28.9662	28.9662	28.9575	28.9575	5596.0
2016-12-23 08:30:00	AAPL	Stock	28.9575	28.9625	28.945	28.9625	8640.0
2016-12-23 08:35:00	AAPL	Stock	28.9625	28.97	28.9625	28.97	4400.0
2016-12-23 08:45:00	AAPL	Stock	28.9675	28.975	28.955	28.96	25620.0
2016-12-23 08:50:00	AAPL	Stock	28.96	28.96	28.95	28.95	24784.0
2016-12-23 08:55:00	AAPL	Stock	28.9475	28.9475	28.9475	28.9475	1656.0
2016-12-23 09:00:00	AAPL	Stock	28.94	28.9725	28.9325	28.9725	8424.0
2016-12-23 09:05:00	AAPL	Stock	28.95	28.9525	28.95	28.95	5600.0
2016-12-23 09:10:00	AAPL	Stock	28.9475	28.9475	28.9425	28.9475	6000.0
2016-12-23 09:20:00	AAPL	Stock	28.9425	28.9475	28.9375	28.9475	6092.0
2016-12-23 09:25:00	AAPL	Stock	28.9375	28.9775	28.9075	28.95	45056.0
2016-12-23 09:30:00	AAPL	Stock	28.8975	29.0888	28.8975	29.0385	3646376.0
2016-12-23 09:35:00	AAPL	Stock	29.04	29.1125	29.0395	29.0875	2201760.0
2016-12-23 09:40:00	AAPL	Stock	29.0875	29.1075	29.0725	29.0975	1258732.0
2016-12-23 09:45:00	AAPL	Stock	29.0962	29.1125	29.06	29.0975	1419048.0
2016-12-23 09:50:00	AAPL	Stock	29.0962	29.1175	29.08	29.1168	1057824.0
2016-12-23 09:55:00	AAPL	Stock	29.1152	29.125	29.0975	29.1	1291032.0
2016-12-23 10:00:00	AAPL	Stock	29.1	29.115	29.1	29.1125	725908.0
2016-12-23 10:05:00	AAPL	Stock	29.1115	29.1125	29.075	29.0825	913736.0
2016-12-23 10:10:00	AAPL	Stock	29.0845	29.0875	29.0475	29.05	881476.0
2016-12-23 10:15:00	AAPL	Stock	29.05	29.08	29.05	29.075	889736.0
2016-12-23 10:20:00	AAPL	Stock	29.0728	29.095	29.0725	29.0875	708472.0
2016-12-23 10:25:00	AAPL	Stock	29.09	29.09	29.0628	29.0775	511908.0
2016-12-23 10:30:00	AAPL	Stock	29.0775	29.0875	29.05	29.0575	874364.0
2016-12-23 10:35:00	AAPL	Stock	29.0575	29.07	29.0325	29.0512	725360.0
2016-12-23 10:40:00	AAPL	Stock	29.05	29.055	29.0325	29.0375	610064.0
2016-12-23 10:45:00	AAPL	Stock	29.04	29.0645	29.0388	29.0625	451568.0
2016-12-23 10:50:00	AAPL	Stock	29.061	29.0675	29.0475	29.055	463364.0
2016-12-23 10:55:00	AAPL	Stock	29.05	29.0525	29.0175	29.025	672816.0
2016-12-23 11:00:00	AAPL	Stock	29.025	29.03	29.0125	29.02	475700.0
2016-12-23 11:05:00	AAPL	Stock	29.0225	29.03	29.0025	29.0275	719188.0
2016-12-23 11:10:00	AAPL	Stock	29.0275	29.0375	29.0175	29.0175	531528.0
2016-12-23 11:15:00	AAPL	Stock	29.02	29.025	29.0	29.001	549604.0
2016-12-23 11:20:00	AAPL	Stock	29.0	29.0238	28.9925	29.0175	651352.0
2016-12-23 11:25:00	AAPL	Stock	29.0175	29.039	29.0162	29.035	691520.0
2016-12-23 11:30:00	AAPL	Stock	29.0375	29.05	29.035	29.0435	398716.0

> showing 50 of 335,638 rows — these rows as CSV

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