PREVIEW / etf_1hour / 2017-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-19.parquet
  size:    294 KB
  rows:    9,734

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-12-19 04:00:00	SPY	ETF	268.51	268.57	268.41	268.46	24718.0
2017-12-19 05:00:00	SPY	ETF	268.46	268.49	268.4	268.49	29302.0
2017-12-19 06:00:00	SPY	ETF	268.48	268.48	268.35	268.39	16800.0
2017-12-19 07:00:00	SPY	ETF	268.44	268.52	268.35	268.5	268937.0
2017-12-19 08:00:00	SPY	ETF	268.48	268.58	268.38	268.47	237890.0
2017-12-19 09:00:00	SPY	ETF	268.45	268.53	267.75	267.8885	6121297.0
2017-12-19 10:00:00	SPY	ETF	267.87	268.51	267.57	267.74	12729985.0
2017-12-19 11:00:00	SPY	ETF	267.73	267.88	267.44	267.44	6860192.0
2017-12-19 12:00:00	SPY	ETF	267.445	267.635	267.33	267.625	5168636.0
2017-12-19 13:00:00	SPY	ETF	267.62	267.765	267.53	267.6337	5143870.0
2017-12-19 14:00:00	SPY	ETF	267.64	267.81	267.28	267.39	6781803.0
2017-12-19 15:00:00	SPY	ETF	267.39	267.55	267.09	267.22	19256777.0
2017-12-19 16:00:00	SPY	ETF	267.19	268.0705	267.06	267.25	11651047.0
2017-12-19 17:00:00	SPY	ETF	267.25	267.4707	267.14	267.27	3658296.0
2017-12-19 18:00:00	SPY	ETF	267.29	267.57	267.17	267.57	907220.0
2017-12-19 19:00:00	SPY	ETF	267.57	267.69	267.53	267.67	63447.0
2017-12-19 04:00:00	QQQ	ETF	158.79	158.79	158.75	158.78	680.0
2017-12-19 06:00:00	QQQ	ETF	158.68	158.69	158.66	158.66	4000.0
2017-12-19 07:00:00	QQQ	ETF	158.65	158.67	158.61	158.64	19599.0
2017-12-19 08:00:00	QQQ	ETF	158.63	158.65	158.42	158.42	31886.0
2017-12-19 09:00:00	QQQ	ETF	158.43	158.5	157.822	157.925	3923601.0
2017-12-19 10:00:00	QQQ	ETF	157.91	158.155	157.56	157.65	4437530.0
2017-12-19 11:00:00	QQQ	ETF	157.64	157.9363	157.4	157.45	2506022.0
2017-12-19 12:00:00	QQQ	ETF	157.45	157.59	157.26	157.587	2009962.0
2017-12-19 13:00:00	QQQ	ETF	157.589	157.829	157.53	157.75	1473713.0
2017-12-19 14:00:00	QQQ	ETF	157.745	157.85	157.47	157.549	2600678.0
2017-12-19 15:00:00	QQQ	ETF	157.541	157.81	157.335	157.72	5796672.0
2017-12-19 16:00:00	QQQ	ETF	157.73	157.83	157.66	157.83	2005678.0
2017-12-19 17:00:00	QQQ	ETF	157.84	157.84	157.77	157.78	5655.0
2017-12-19 18:00:00	QQQ	ETF	157.82	157.96	157.82	157.96	10922.0
2017-12-19 19:00:00	QQQ	ETF	157.98	158.04	157.96	158.0	9850.0
2017-12-19 07:00:00	IWM	ETF	154.26	154.34	154.24	154.34	14021.0
2017-12-19 08:00:00	IWM	ETF	154.3	154.54	154.26	154.46	126581.0
2017-12-19 09:00:00	IWM	ETF	154.52	154.77	154.17	154.3	3282560.0
2017-12-19 10:00:00	IWM	ETF	154.29	154.37	154.02	154.235	2584030.0
2017-12-19 11:00:00	IWM	ETF	154.235	154.26	153.78	153.8	2087358.0
2017-12-19 12:00:00	IWM	ETF	153.79	153.84	153.19	153.55	2381763.0
2017-12-19 13:00:00	IWM	ETF	153.56	153.775	153.42	153.4801	1970507.0
2017-12-19 14:00:00	IWM	ETF	153.48	153.62	153.08	153.22	2025806.0
2017-12-19 15:00:00	IWM	ETF	153.22	153.26	152.82	153.09	3614092.0
2017-12-19 16:00:00	IWM	ETF	153.08	153.27	152.7	153.0	1155293.0
2017-12-19 17:00:00	IWM	ETF	153.0	153.2978	153.0	153.0	17400.0
2017-12-19 18:00:00	IWM	ETF	152.91	153.27	152.88	153.27	265395.0
2017-12-19 19:00:00	IWM	ETF	153.3	153.4	153.3	153.4	6126.0
2017-12-19 04:00:00	DIA	ETF	248.23	248.23	248.23	248.23	200.0
2017-12-19 07:00:00	DIA	ETF	248.1	248.17	248.1	248.17	1400.0
2017-12-19 08:00:00	DIA	ETF	248.15	248.5	248.12	248.5	11199.0
2017-12-19 09:00:00	DIA	ETF	248.38	248.38	247.03	247.4361	428417.0
2017-12-19 10:00:00	DIA	ETF	247.44	247.62	246.94	247.17	433684.0
2017-12-19 11:00:00	DIA	ETF	247.18	247.45	247.0001	247.2399	354184.0

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

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