PREVIEW / stock_5min / 2016-07-18

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-07-18.parquet
  size:    5.3 MB
  rows:    350,425
  symbols: 3,276

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-07-18 04:00:00	AAPL	Stock	24.6925	24.75	24.6925	24.75	1960.0
2016-07-18 04:40:00	AAPL	Stock	24.75	24.75	24.75	24.75	400.0
2016-07-18 04:55:00	AAPL	Stock	24.745	24.745	24.745	24.745	420.0
2016-07-18 05:20:00	AAPL	Stock	24.7375	24.7375	24.7375	24.7375	400.0
2016-07-18 06:15:00	AAPL	Stock	24.7375	24.7375	24.7075	24.7075	800.0
2016-07-18 06:25:00	AAPL	Stock	24.7225	24.7225	24.7225	24.7225	1268.0
2016-07-18 06:30:00	AAPL	Stock	24.7175	24.7175	24.7175	24.7175	656.0
2016-07-18 06:35:00	AAPL	Stock	24.7125	24.7225	24.7125	24.7225	3600.0
2016-07-18 06:40:00	AAPL	Stock	24.7125	24.7125	24.7125	24.7125	2348.0
2016-07-18 06:45:00	AAPL	Stock	24.7125	24.7125	24.7125	24.7125	800.0
2016-07-18 06:50:00	AAPL	Stock	24.7125	24.7125	24.7125	24.7125	520.0
2016-07-18 06:55:00	AAPL	Stock	24.7075	24.7125	24.7075	24.7125	1976.0
2016-07-18 07:00:00	AAPL	Stock	24.7225	24.7225	24.7225	24.7225	680.0
2016-07-18 07:05:00	AAPL	Stock	24.725	24.725	24.725	24.725	2164.0
2016-07-18 07:10:00	AAPL	Stock	24.725	24.725	24.725	24.725	2000.0
2016-07-18 07:20:00	AAPL	Stock	24.7325	24.7325	24.7325	24.7325	1200.0
2016-07-18 07:25:00	AAPL	Stock	24.73	24.73	24.73	24.73	1048.0
2016-07-18 07:45:00	AAPL	Stock	24.7325	24.735	24.7325	24.735	1400.0
2016-07-18 07:50:00	AAPL	Stock	24.7325	24.7425	24.7325	24.7425	8000.0
2016-07-18 07:55:00	AAPL	Stock	24.75	24.755	24.75	24.755	9924.0
2016-07-18 08:00:00	AAPL	Stock	24.7425	24.7625	24.7125	24.755	71192.0
2016-07-18 08:05:00	AAPL	Stock	24.7475	24.7475	24.7375	24.7375	11600.0
2016-07-18 08:10:00	AAPL	Stock	24.74	24.75	24.74	24.75	13800.0
2016-07-18 08:15:00	AAPL	Stock	24.7625	24.765	24.745	24.765	6400.0
2016-07-18 08:20:00	AAPL	Stock	24.7625	24.77	24.75	24.75	35076.0
2016-07-18 08:25:00	AAPL	Stock	24.75	24.75	24.745	24.75	24452.0
2016-07-18 08:30:00	AAPL	Stock	24.7525	24.7575	24.7525	24.7525	4400.0
2016-07-18 08:35:00	AAPL	Stock	24.76	24.765	24.76	24.76	18576.0
2016-07-18 08:40:00	AAPL	Stock	24.765	24.765	24.7575	24.7575	8840.0
2016-07-18 08:45:00	AAPL	Stock	24.755	24.755	24.75	24.75	7800.0
2016-07-18 08:50:00	AAPL	Stock	24.7525	24.7525	24.745	24.75	19940.0
2016-07-18 08:55:00	AAPL	Stock	24.755	24.765	24.745	24.745	55912.0
2016-07-18 09:00:00	AAPL	Stock	24.735	24.74	24.7325	24.74	65788.0
2016-07-18 09:05:00	AAPL	Stock	24.74	24.7625	24.7375	24.7625	32956.0
2016-07-18 09:10:00	AAPL	Stock	24.7625	24.7675	24.7625	24.7625	21796.0
2016-07-18 09:15:00	AAPL	Stock	24.7525	24.7625	24.7525	24.7625	11368.0
2016-07-18 09:20:00	AAPL	Stock	24.7525	24.77	24.7525	24.77	3200.0
2016-07-18 09:25:00	AAPL	Stock	24.765	24.765	24.6775	24.6775	181308.0
2016-07-18 09:30:00	AAPL	Stock	24.675	24.8	24.65	24.7862	5593884.0
2016-07-18 09:35:00	AAPL	Stock	24.7875	24.82	24.7625	24.7975	2953136.0
2016-07-18 09:40:00	AAPL	Stock	24.7975	24.8225	24.7825	24.82	2247976.0
2016-07-18 09:45:00	AAPL	Stock	24.82	24.8225	24.79	24.8125	2478104.0
2016-07-18 09:50:00	AAPL	Stock	24.8125	24.8275	24.8025	24.8112	2184112.0
2016-07-18 09:55:00	AAPL	Stock	24.81	24.8725	24.81	24.8725	3377760.0
2016-07-18 10:00:00	AAPL	Stock	24.8725	24.9275	24.87	24.89	3567736.0
2016-07-18 10:05:00	AAPL	Stock	24.8925	24.9175	24.8675	24.91	2388244.0
2016-07-18 10:10:00	AAPL	Stock	24.9125	24.945	24.9122	24.9425	2142028.0
2016-07-18 10:15:00	AAPL	Stock	24.9425	24.9625	24.94	24.96	1981644.0
2016-07-18 10:20:00	AAPL	Stock	24.9598	24.965	24.935	24.9475	2088476.0
2016-07-18 10:25:00	AAPL	Stock	24.9475	24.99	24.945	24.989	2090000.0

> showing 50 of 350,425 rows — these rows as CSV

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