PREVIEW / etf_1hour / 2017-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-18.parquet
  size:    283 KB
  rows:    9,290

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-09-18 04:00:00	SPY	ETF	249.61	249.86	249.61	249.8	5963.0
2017-09-18 05:00:00	SPY	ETF	249.8	249.88	249.79	249.88	3530.0
2017-09-18 06:00:00	SPY	ETF	249.78	249.82	249.75	249.75	58951.0
2017-09-18 07:00:00	SPY	ETF	249.75	249.75	249.66	249.74	85714.0
2017-09-18 08:00:00	SPY	ETF	249.74	249.75	249.52	249.56	235246.0
2017-09-18 09:00:00	SPY	ETF	249.57	250.12	249.47	249.995	5928793.0
2017-09-18 10:00:00	SPY	ETF	249.99	250.05	249.3	249.885	6120048.0
2017-09-18 11:00:00	SPY	ETF	249.88	250.07	249.87	249.9	4877526.0
2017-09-18 12:00:00	SPY	ETF	249.9	249.96	249.71	249.86	4420479.0
2017-09-18 13:00:00	SPY	ETF	249.86	249.95	249.75	249.84	2272031.0
2017-09-18 14:00:00	SPY	ETF	249.84	249.845	249.28	249.48	5909762.0
2017-09-18 15:00:00	SPY	ETF	249.47	249.78	249.455	249.69	8663279.0
2017-09-18 16:00:00	SPY	ETF	249.7	249.78	249.63	249.77	6658406.0
2017-09-18 17:00:00	SPY	ETF	249.75	249.76	249.69	249.72	324897.0
2017-09-18 18:00:00	SPY	ETF	249.72	249.78	249.71	249.75	43634.0
2017-09-18 19:00:00	SPY	ETF	249.75	249.78	249.72	249.74	21458.0
2017-09-18 04:00:00	QQQ	ETF	146.04	146.3	145.95	145.95	46038.0
2017-09-18 05:00:00	QQQ	ETF	146.07	146.08	146.07	146.08	6700.0
2017-09-18 06:00:00	QQQ	ETF	146.0	146.25	146.0	146.1	58195.0
2017-09-18 07:00:00	QQQ	ETF	146.06	146.07	145.99	146.05	23302.0
2017-09-18 08:00:00	QQQ	ETF	146.0	146.06	145.82	145.85	98085.0
2017-09-18 09:00:00	QQQ	ETF	145.87	146.37	145.75	146.2	2853323.0
2017-09-18 10:00:00	QQQ	ETF	146.2	146.3399	145.98	146.05	2628647.0
2017-09-18 11:00:00	QQQ	ETF	146.05	146.29	146.045	146.17	2227372.0
2017-09-18 12:00:00	QQQ	ETF	146.18	146.28	146.06	146.1793	1336026.0
2017-09-18 13:00:00	QQQ	ETF	146.17	146.1701	146.015	146.09	861892.0
2017-09-18 14:00:00	QQQ	ETF	146.08	146.09	145.11	145.4	4718380.0
2017-09-18 15:00:00	QQQ	ETF	145.4	145.68	145.3359	145.55	3442351.0
2017-09-18 16:00:00	QQQ	ETF	145.56	145.65	145.49	145.64	812350.0
2017-09-18 17:00:00	QQQ	ETF	145.65	146.1391	145.2012	145.65	75365.0
2017-09-18 18:00:00	QQQ	ETF	145.65	145.68	145.64	145.68	3487.0
2017-09-18 19:00:00	QQQ	ETF	145.64	145.68	145.62	145.68	4000.0
2017-09-18 04:00:00	IWM	ETF	142.86	142.94	142.86	142.94	3467.0
2017-09-18 05:00:00	IWM	ETF	142.96	142.96	142.87	142.87	1641.0
2017-09-18 06:00:00	IWM	ETF	142.85	142.9	142.8	142.9	8963.0
2017-09-18 07:00:00	IWM	ETF	142.87	142.9	142.72	142.8	46337.0
2017-09-18 08:00:00	IWM	ETF	142.81	142.81	142.55	142.59	55420.0
2017-09-18 09:00:00	IWM	ETF	142.63	143.36	142.56	143.21	2965497.0
2017-09-18 10:00:00	IWM	ETF	143.19	143.505	143.14	143.29	2978660.0
2017-09-18 11:00:00	IWM	ETF	143.29	143.45	143.19	143.35	2387049.0
2017-09-18 12:00:00	IWM	ETF	143.36	143.57	143.29	143.54	2563305.0
2017-09-18 13:00:00	IWM	ETF	143.55	143.8075	143.51	143.77	2279947.0
2017-09-18 14:00:00	IWM	ETF	143.77	143.785	143.2801	143.48	3153388.0
2017-09-18 15:00:00	IWM	ETF	143.49	143.5	143.27	143.4	3750289.0
2017-09-18 16:00:00	IWM	ETF	143.39	143.53	143.3	143.52	716059.0
2017-09-18 17:00:00	IWM	ETF	143.51	143.6071	142.0507	143.45	328165.0
2017-09-18 18:00:00	IWM	ETF	143.5	143.5	143.5	143.5	4000.0
2017-09-18 19:00:00	IWM	ETF	143.45	143.54	143.45	143.54	12055.0
2017-09-18 04:00:00	DIA	ETF	222.65	222.9	222.65	222.9	747.0
2017-09-18 08:00:00	DIA	ETF	223.2	223.2	222.88	222.88	6627.0

> showing 50 of 9,290 rows — these rows as CSV

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