PREVIEW / stock_5min / 2017-01-12

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-12.parquet
  size:    5.4 MB
  rows:    354,302
  symbols: 3,106

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-01-12 04:00:00	AAPL	Stock	29.9	29.9	29.875	29.875	10556.0
2017-01-12 04:20:00	AAPL	Stock	29.855	29.855	29.855	29.855	400.0
2017-01-12 04:25:00	AAPL	Stock	29.8375	29.8375	29.8375	29.8375	1712.0
2017-01-12 04:30:00	AAPL	Stock	29.825	29.825	29.825	29.825	1200.0
2017-01-12 04:40:00	AAPL	Stock	29.835	29.8375	29.835	29.8375	3248.0
2017-01-12 04:45:00	AAPL	Stock	29.8375	29.8375	29.8375	29.8375	1552.0
2017-01-12 05:20:00	AAPL	Stock	29.815	29.8175	29.8125	29.8175	12000.0
2017-01-12 05:25:00	AAPL	Stock	29.8175	29.8175	29.8175	29.8175	1200.0
2017-01-12 05:30:00	AAPL	Stock	29.82	29.82	29.805	29.805	16392.0
2017-01-12 05:35:00	AAPL	Stock	29.8	29.8	29.79	29.79	3880.0
2017-01-12 05:45:00	AAPL	Stock	29.7825	29.7825	29.775	29.775	3880.0
2017-01-12 05:50:00	AAPL	Stock	29.7775	29.7775	29.7775	29.7775	400.0
2017-01-12 05:55:00	AAPL	Stock	29.7725	29.785	29.7725	29.785	4408.0
2017-01-12 06:00:00	AAPL	Stock	29.77	29.77	29.7675	29.7675	12616.0
2017-01-12 06:05:00	AAPL	Stock	29.7675	29.7775	29.7675	29.775	7200.0
2017-01-12 06:10:00	AAPL	Stock	29.7875	29.79	29.7675	29.7675	3288.0
2017-01-12 06:15:00	AAPL	Stock	29.8125	29.8125	29.8125	29.8125	800.0
2017-01-12 06:20:00	AAPL	Stock	29.8125	29.815	29.775	29.775	60744.0
2017-01-12 06:25:00	AAPL	Stock	29.775	29.7975	29.775	29.7775	18412.0
2017-01-12 06:30:00	AAPL	Stock	29.7825	29.7825	29.775	29.775	16020.0
2017-01-12 06:35:00	AAPL	Stock	29.7575	29.7575	29.7375	29.7475	6800.0
2017-01-12 06:40:00	AAPL	Stock	29.725	29.725	29.7125	29.7125	3680.0
2017-01-12 06:45:00	AAPL	Stock	29.7425	29.745	29.7425	29.745	1200.0
2017-01-12 06:50:00	AAPL	Stock	29.7175	29.7175	29.7175	29.7175	2000.0
2017-01-12 06:55:00	AAPL	Stock	29.745	29.745	29.7275	29.7275	2400.0
2017-01-12 07:00:00	AAPL	Stock	29.7475	29.785	29.7475	29.77	57004.0
2017-01-12 07:05:00	AAPL	Stock	29.77	29.775	29.755	29.7625	16240.0
2017-01-12 07:10:00	AAPL	Stock	29.75	29.775	29.75	29.76	9400.0
2017-01-12 07:15:00	AAPL	Stock	29.755	29.77	29.755	29.77	2000.0
2017-01-12 07:20:00	AAPL	Stock	29.7725	29.7725	29.7175	29.7175	8680.0
2017-01-12 07:25:00	AAPL	Stock	29.7175	29.75	29.7175	29.75	4344.0
2017-01-12 07:30:00	AAPL	Stock	29.75	29.75	29.725	29.725	21400.0
2017-01-12 07:35:00	AAPL	Stock	29.7325	29.7325	29.705	29.705	63200.0
2017-01-12 07:40:00	AAPL	Stock	29.705	29.7425	29.6925	29.7425	28320.0
2017-01-12 07:45:00	AAPL	Stock	29.735	29.745	29.6975	29.6975	28452.0
2017-01-12 07:50:00	AAPL	Stock	29.73	29.73	29.6925	29.7225	12424.0
2017-01-12 07:55:00	AAPL	Stock	29.7125	29.75	29.7	29.7	25176.0
2017-01-12 08:00:00	AAPL	Stock	29.7125	29.875	29.6925	29.74	143340.0
2017-01-12 08:05:00	AAPL	Stock	29.75	29.7575	29.7425	29.7575	32896.0
2017-01-12 08:10:00	AAPL	Stock	29.75	29.76	29.7475	29.7475	87200.0
2017-01-12 08:15:00	AAPL	Stock	29.7475	29.7875	29.7475	29.775	56800.0
2017-01-12 08:20:00	AAPL	Stock	29.7775	29.7775	29.7675	29.7675	26760.0
2017-01-12 08:25:00	AAPL	Stock	29.77	29.775	29.7625	29.7625	10400.0
2017-01-12 08:30:00	AAPL	Stock	29.7625	29.7725	29.7525	29.7525	24696.0
2017-01-12 08:35:00	AAPL	Stock	29.7525	29.765	29.75	29.765	35600.0
2017-01-12 08:40:00	AAPL	Stock	29.7725	29.775	29.7625	29.765	22712.0
2017-01-12 08:45:00	AAPL	Stock	29.77	29.7875	29.765	29.775	51180.0
2017-01-12 08:50:00	AAPL	Stock	29.7775	29.7875	29.765	29.775	30800.0
2017-01-12 08:55:00	AAPL	Stock	29.78	29.78	29.7625	29.77	25160.0
2017-01-12 09:00:00	AAPL	Stock	29.765	29.7725	29.75	29.7625	31772.0

> showing 50 of 354,302 rows — these rows as CSV

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