PREVIEW / stock_5min / 2017-04-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-27.parquet
  size:    5.4 MB
  rows:    352,429
  symbols: 3,029

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-04-27 04:05:00	AAPL	Stock	35.9375	35.9975	35.9375	35.9975	4708.0
2017-04-27 04:10:00	AAPL	Stock	35.9375	35.9375	35.9375	35.9375	7800.0
2017-04-27 04:15:00	AAPL	Stock	35.9375	35.9375	35.9375	35.9375	2320.0
2017-04-27 04:35:00	AAPL	Stock	35.9375	35.9375	35.9375	35.9375	476.0
2017-04-27 05:00:00	AAPL	Stock	35.9125	35.9125	35.9075	35.9075	2560.0
2017-04-27 05:05:00	AAPL	Stock	35.9375	35.9375	35.9375	35.9375	980.0
2017-04-27 05:15:00	AAPL	Stock	35.8875	35.8875	35.8875	35.8875	800.0
2017-04-27 05:25:00	AAPL	Stock	35.8825	35.8825	35.8825	35.8825	492.0
2017-04-27 05:35:00	AAPL	Stock	35.8875	35.8875	35.8875	35.8875	420.0
2017-04-27 05:55:00	AAPL	Stock	35.9125	35.9125	35.9125	35.9125	3244.0
2017-04-27 06:20:00	AAPL	Stock	35.93	35.9375	35.93	35.93	4928.0
2017-04-27 06:25:00	AAPL	Stock	35.925	35.925	35.915	35.915	1228.0
2017-04-27 06:30:00	AAPL	Stock	35.915	35.915	35.915	35.915	1736.0
2017-04-27 06:35:00	AAPL	Stock	35.925	35.925	35.925	35.925	420.0
2017-04-27 06:45:00	AAPL	Stock	35.925	35.925	35.925	35.925	5868.0
2017-04-27 06:55:00	AAPL	Stock	35.95	35.9875	35.95	35.9875	3280.0
2017-04-27 07:10:00	AAPL	Stock	35.9675	35.9675	35.9675	35.9675	2400.0
2017-04-27 07:20:00	AAPL	Stock	35.9675	35.9675	35.9675	35.9675	1200.0
2017-04-27 07:30:00	AAPL	Stock	35.97	35.97	35.9675	35.9675	2940.0
2017-04-27 07:35:00	AAPL	Stock	35.9675	35.9675	35.95	35.95	2200.0
2017-04-27 07:40:00	AAPL	Stock	35.95	35.95	35.9375	35.9375	7760.0
2017-04-27 07:45:00	AAPL	Stock	35.9375	35.9375	35.9375	35.9375	13600.0
2017-04-27 07:50:00	AAPL	Stock	35.9375	35.94	35.9375	35.94	2044.0
2017-04-27 07:55:00	AAPL	Stock	35.945	35.945	35.945	35.945	1520.0
2017-04-27 08:00:00	AAPL	Stock	35.96	35.97	35.96	35.97	4472.0
2017-04-27 08:05:00	AAPL	Stock	35.95	35.97	35.95	35.95	5800.0
2017-04-27 08:10:00	AAPL	Stock	35.965	35.965	35.965	35.965	1600.0
2017-04-27 08:15:00	AAPL	Stock	35.9675	35.9675	35.9675	35.9675	3200.0
2017-04-27 08:20:00	AAPL	Stock	35.9675	35.9725	35.95	35.95	24968.0
2017-04-27 08:25:00	AAPL	Stock	35.945	35.95	35.945	35.95	6880.0
2017-04-27 08:30:00	AAPL	Stock	35.95	35.95	35.9375	35.9375	4228.0
2017-04-27 08:35:00	AAPL	Stock	35.9475	35.95	35.9475	35.95	7600.0
2017-04-27 08:40:00	AAPL	Stock	35.965	35.965	35.965	35.965	400.0
2017-04-27 08:45:00	AAPL	Stock	35.975	35.9875	35.9725	35.985	32760.0
2017-04-27 08:50:00	AAPL	Stock	35.9575	35.9575	35.9375	35.94	10980.0
2017-04-27 08:55:00	AAPL	Stock	35.9375	35.955	35.9375	35.9425	12156.0
2017-04-27 09:10:00	AAPL	Stock	35.96	35.96	35.96	35.96	3600.0
2017-04-27 09:15:00	AAPL	Stock	35.9625	35.9675	35.9625	35.9675	2400.0
2017-04-27 09:20:00	AAPL	Stock	35.9725	35.975	35.9725	35.975	6800.0
2017-04-27 09:25:00	AAPL	Stock	35.975	35.9825	35.9725	35.9725	25912.0
2017-04-27 09:30:00	AAPL	Stock	35.9775	36.04	35.97	35.995	2461984.0
2017-04-27 09:35:00	AAPL	Stock	35.995	36.025	35.9225	35.9225	1444084.0
2017-04-27 09:40:00	AAPL	Stock	35.9225	35.97	35.905	35.9625	1252144.0
2017-04-27 09:45:00	AAPL	Stock	35.9625	35.9775	35.8925	35.9275	1277176.0
2017-04-27 09:50:00	AAPL	Stock	35.9272	35.9325	35.8578	35.86	1222780.0
2017-04-27 09:55:00	AAPL	Stock	35.86	35.91	35.86	35.8975	981460.0
2017-04-27 10:00:00	AAPL	Stock	35.8965	35.925	35.8875	35.9125	754312.0
2017-04-27 10:05:00	AAPL	Stock	35.9125	35.9375	35.8825	35.8988	814248.0
2017-04-27 10:10:00	AAPL	Stock	35.8975	35.92	35.89	35.9	788492.0
2017-04-27 10:15:00	AAPL	Stock	35.9	35.915	35.8965	35.904	556664.0

> showing 50 of 352,429 rows — these rows as CSV

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