PREVIEW / stock_5min / 2017-11-09

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-09.parquet
  size:    5.7 MB
  rows:    366,073
  symbols: 2,929

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-11-09 04:00:00	AAPL	Stock	44.075	44.075	44.075	44.075	7116.0
2017-11-09 04:05:00	AAPL	Stock	44.075	44.075	44.075	44.075	736.0
2017-11-09 04:10:00	AAPL	Stock	44.1725	44.1725	44.1725	44.1725	800.0
2017-11-09 04:20:00	AAPL	Stock	44.145	44.145	44.145	44.145	400.0
2017-11-09 05:15:00	AAPL	Stock	44.1125	44.1375	44.1125	44.1375	3200.0
2017-11-09 05:25:00	AAPL	Stock	44.135	44.1375	44.135	44.1375	1724.0
2017-11-09 05:55:00	AAPL	Stock	44.1425	44.1425	44.1425	44.1425	652.0
2017-11-09 06:00:00	AAPL	Stock	44.08	44.08	44.075	44.08	4528.0
2017-11-09 06:05:00	AAPL	Stock	44.1225	44.15	44.1225	44.15	16316.0
2017-11-09 06:10:00	AAPL	Stock	44.1	44.1	44.1	44.1	800.0
2017-11-09 06:20:00	AAPL	Stock	44.095	44.095	44.0825	44.0825	2400.0
2017-11-09 06:25:00	AAPL	Stock	44.0875	44.0875	44.015	44.015	16588.0
2017-11-09 06:30:00	AAPL	Stock	44.025	44.0275	43.9825	43.995	24268.0
2017-11-09 06:35:00	AAPL	Stock	44.0025	44.0025	44.0025	44.0025	600.0
2017-11-09 06:40:00	AAPL	Stock	43.995	43.995	43.95	43.9625	23460.0
2017-11-09 06:45:00	AAPL	Stock	43.975	43.975	43.975	43.975	2508.0
2017-11-09 06:50:00	AAPL	Stock	43.9825	43.9825	43.9825	43.9825	4000.0
2017-11-09 06:55:00	AAPL	Stock	43.975	43.9875	43.975	43.9875	1292.0
2017-11-09 07:00:00	AAPL	Stock	44.0125	44.075	43.98	44.025	36108.0
2017-11-09 07:05:00	AAPL	Stock	44.02	44.0425	43.965	43.965	43952.0
2017-11-09 07:10:00	AAPL	Stock	43.9975	43.9975	43.975	43.9975	2800.0
2017-11-09 07:15:00	AAPL	Stock	43.9975	43.9975	43.975	43.975	7100.0
2017-11-09 07:20:00	AAPL	Stock	43.975	43.9875	43.9625	43.975	12508.0
2017-11-09 07:25:00	AAPL	Stock	43.965	43.9875	43.965	43.9875	17000.0
2017-11-09 07:30:00	AAPL	Stock	43.995	44.0	43.975	43.975	18392.0
2017-11-09 07:35:00	AAPL	Stock	43.9625	43.975	43.9625	43.975	3444.0
2017-11-09 07:40:00	AAPL	Stock	43.9625	43.975	43.9575	43.9575	16368.0
2017-11-09 07:45:00	AAPL	Stock	43.9625	43.9725	43.9475	43.9475	12000.0
2017-11-09 07:50:00	AAPL	Stock	43.95	43.9575	43.9375	43.9575	14828.0
2017-11-09 07:55:00	AAPL	Stock	43.9375	43.9375	43.875	43.875	73572.0
2017-11-09 08:00:00	AAPL	Stock	43.8925	44.05	43.875	43.8825	187372.0
2017-11-09 08:05:00	AAPL	Stock	43.8825	43.895	43.825	43.8475	75720.0
2017-11-09 08:10:00	AAPL	Stock	43.8425	43.8425	43.79	43.79	39148.0
2017-11-09 08:15:00	AAPL	Stock	43.78	43.8125	43.775	43.78	65552.0
2017-11-09 08:20:00	AAPL	Stock	43.7925	43.8125	43.7625	43.8025	73928.0
2017-11-09 08:25:00	AAPL	Stock	43.8	43.81	43.7375	43.7475	117252.0
2017-11-09 08:30:00	AAPL	Stock	43.75	43.8	43.7275	43.775	61264.0
2017-11-09 08:35:00	AAPL	Stock	43.775	43.855	43.775	43.85	67080.0
2017-11-09 08:40:00	AAPL	Stock	43.85	43.85	43.805	43.825	103028.0
2017-11-09 08:45:00	AAPL	Stock	43.83	43.85	43.8	43.8325	64932.0
2017-11-09 08:50:00	AAPL	Stock	43.8375	43.845	43.8	43.8125	47484.0
2017-11-09 08:55:00	AAPL	Stock	43.8125	43.8125	43.7675	43.7825	34116.0
2017-11-09 09:00:00	AAPL	Stock	43.8	43.81	43.7775	43.7875	71748.0
2017-11-09 09:05:00	AAPL	Stock	43.7775	43.815	43.775	43.8125	42668.0
2017-11-09 09:10:00	AAPL	Stock	43.825	43.825	43.8	43.8125	18200.0
2017-11-09 09:15:00	AAPL	Stock	43.8125	43.85	43.8125	43.85	51560.0
2017-11-09 09:20:00	AAPL	Stock	43.8475	43.8475	43.7775	43.7775	47260.0
2017-11-09 09:25:00	AAPL	Stock	43.7875	43.82	43.775	43.82	23380.0
2017-11-09 09:30:00	AAPL	Stock	43.82	43.9775	43.75	43.9075	5437692.0
2017-11-09 09:35:00	AAPL	Stock	43.905	43.98	43.875	43.92	2657992.0

> showing 50 of 366,073 rows — these rows as CSV

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