PREVIEW / stock_5min / 2017-06-28

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-28.parquet
  size:    5.4 MB
  rows:    357,052
  symbols: 3,012

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-06-28 04:00:00	AAPL	Stock	35.6875	35.7125	35.625	35.7075	5600.0
2017-06-28 04:05:00	AAPL	Stock	35.625	35.625	35.6125	35.6175	7368.0
2017-06-28 04:10:00	AAPL	Stock	35.5625	35.5625	35.5625	35.5625	400.0
2017-06-28 04:20:00	AAPL	Stock	35.5625	35.5625	35.5625	35.5625	400.0
2017-06-28 04:25:00	AAPL	Stock	35.505	35.5125	35.425	35.5025	14000.0
2017-06-28 04:35:00	AAPL	Stock	35.5025	35.5025	35.44	35.44	5600.0
2017-06-28 04:40:00	AAPL	Stock	35.5	35.5025	35.5	35.5	3600.0
2017-06-28 04:45:00	AAPL	Stock	35.5425	35.5425	35.5025	35.5025	1608.0
2017-06-28 04:50:00	AAPL	Stock	35.5625	35.6	35.5625	35.6	2628.0
2017-06-28 04:55:00	AAPL	Stock	35.6	35.6	35.525	35.525	2000.0
2017-06-28 05:00:00	AAPL	Stock	35.6	35.6	35.525	35.525	2600.0
2017-06-28 05:10:00	AAPL	Stock	35.5875	35.5975	35.5875	35.5975	2000.0
2017-06-28 05:15:00	AAPL	Stock	35.585	35.5975	35.585	35.5975	7420.0
2017-06-28 05:20:00	AAPL	Stock	35.5875	35.5875	35.5875	35.5875	680.0
2017-06-28 05:25:00	AAPL	Stock	35.6225	35.6625	35.6225	35.6625	6848.0
2017-06-28 05:30:00	AAPL	Stock	35.695	35.7025	35.695	35.7	6768.0
2017-06-28 05:35:00	AAPL	Stock	35.75	35.75	35.75	35.75	400.0
2017-06-28 05:40:00	AAPL	Stock	35.7	35.7375	35.7	35.7375	10248.0
2017-06-28 05:45:00	AAPL	Stock	35.7625	35.7625	35.7625	35.7625	1200.0
2017-06-28 05:50:00	AAPL	Stock	35.7625	35.7625	35.7375	35.7375	6800.0
2017-06-28 05:55:00	AAPL	Stock	35.7125	35.75	35.7125	35.75	4000.0
2017-06-28 06:10:00	AAPL	Stock	35.75	35.7725	35.75	35.7725	17304.0
2017-06-28 06:15:00	AAPL	Stock	35.7575	35.7575	35.7125	35.7125	4264.0
2017-06-28 06:20:00	AAPL	Stock	35.715	35.715	35.7125	35.7125	11624.0
2017-06-28 06:25:00	AAPL	Stock	35.7025	35.7025	35.7025	35.7025	3432.0
2017-06-28 06:35:00	AAPL	Stock	35.75	35.75	35.75	35.75	932.0
2017-06-28 06:40:00	AAPL	Stock	35.715	35.715	35.7	35.7	3444.0
2017-06-28 06:50:00	AAPL	Stock	35.7	35.7	35.7	35.7	800.0
2017-06-28 06:55:00	AAPL	Stock	35.7225	35.7625	35.7125	35.75	80424.0
2017-06-28 07:00:00	AAPL	Stock	35.7475	35.775	35.7475	35.775	105616.0
2017-06-28 07:05:00	AAPL	Stock	35.7575	35.775	35.675	35.7525	57336.0
2017-06-28 07:10:00	AAPL	Stock	35.8	35.8	35.75	35.755	48840.0
2017-06-28 07:15:00	AAPL	Stock	35.755	35.755	35.75	35.75	10456.0
2017-06-28 07:20:00	AAPL	Stock	35.76	35.76	35.75	35.755	2000.0
2017-06-28 07:25:00	AAPL	Stock	35.755	35.775	35.75	35.765	7856.0
2017-06-28 07:30:00	AAPL	Stock	35.765	35.7975	35.765	35.7975	31296.0
2017-06-28 07:35:00	AAPL	Stock	35.7875	35.805	35.7875	35.805	1200.0
2017-06-28 07:40:00	AAPL	Stock	35.7775	35.79	35.775	35.775	2992.0
2017-06-28 07:45:00	AAPL	Stock	35.7975	35.8125	35.7975	35.805	7948.0
2017-06-28 07:50:00	AAPL	Stock	35.805	35.8375	35.805	35.8375	10488.0
2017-06-28 07:55:00	AAPL	Stock	35.85	35.89	35.83	35.88	52120.0
2017-06-28 08:00:00	AAPL	Stock	35.7125	35.925	35.7025	35.925	33520.0
2017-06-28 08:05:00	AAPL	Stock	35.925	35.985	35.925	35.985	51488.0
2017-06-28 08:10:00	AAPL	Stock	35.985	36.025	35.985	36.01	83484.0
2017-06-28 08:15:00	AAPL	Stock	36.015	36.185	36.0	36.1275	166864.0
2017-06-28 08:20:00	AAPL	Stock	36.125	36.125	36.0925	36.0925	35836.0
2017-06-28 08:25:00	AAPL	Stock	36.0925	36.1	36.0475	36.0475	36752.0
2017-06-28 08:30:00	AAPL	Stock	36.05	36.0875	36.05	36.065	32084.0
2017-06-28 08:35:00	AAPL	Stock	36.0625	36.09	36.0575	36.07	37736.0
2017-06-28 08:40:00	AAPL	Stock	36.07	36.13	36.0625	36.125	27712.0

> showing 50 of 357,052 rows — these rows as CSV

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