PREVIEW / etf_1hour / 2017-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-01.parquet
  size:    277 KB
  rows:    9,093

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-01 04:00:00	SPY	ETF	247.65	247.74	247.51	247.58	3006.0
2017-09-01 05:00:00	SPY	ETF	247.54	247.6	247.54	247.59	900.0
2017-09-01 06:00:00	SPY	ETF	247.6	247.85	247.6	247.84	21978.0
2017-09-01 07:00:00	SPY	ETF	247.82	248.05	247.81	247.98	110270.0
2017-09-01 08:00:00	SPY	ETF	247.85	248.18	247.45	247.92	939578.0
2017-09-01 09:00:00	SPY	ETF	247.96	248.12	247.69	247.85	6628289.0
2017-09-01 10:00:00	SPY	ETF	247.87	248.17	247.67	248.13	8395084.0
2017-09-01 11:00:00	SPY	ETF	248.12	248.2	247.85	248.09	7516483.0
2017-09-01 12:00:00	SPY	ETF	248.1	248.32	248.05	248.275	4194811.0
2017-09-01 13:00:00	SPY	ETF	248.28	248.33	248.13	248.17	2692701.0
2017-09-01 14:00:00	SPY	ETF	248.165	248.25	248.09	248.16	4539944.0
2017-09-01 15:00:00	SPY	ETF	248.155	248.23	247.87	247.88	11565402.0
2017-09-01 16:00:00	SPY	ETF	247.88	247.9516	247.74	247.77	12351379.0
2017-09-01 17:00:00	SPY	ETF	247.78	247.8	247.69	247.75	37184.0
2017-09-01 18:00:00	SPY	ETF	247.75	248.25	247.71	247.71	27401.0
2017-09-01 19:00:00	SPY	ETF	247.72	247.76	247.65	247.71	39398.0
2017-09-01 04:00:00	QQQ	ETF	146.15	146.18	146.15	146.17	4800.0
2017-09-01 05:00:00	QQQ	ETF	146.18	146.18	146.09	146.1	2000.0
2017-09-01 06:00:00	QQQ	ETF	146.17	146.33	146.17	146.3	8170.0
2017-09-01 07:00:00	QQQ	ETF	146.32	146.5	146.32	146.5	20521.0
2017-09-01 08:00:00	QQQ	ETF	146.29	146.74	146.2	146.44	281011.0
2017-09-01 09:00:00	QQQ	ETF	146.41	146.585	145.86	145.93	3013490.0
2017-09-01 10:00:00	QQQ	ETF	145.94	146.14	145.61	146.09	4217154.0
2017-09-01 11:00:00	QQQ	ETF	146.08	146.18	145.933	146.16	1543726.0
2017-09-01 12:00:00	QQQ	ETF	146.16	146.24	146.095	146.17	926309.0
2017-09-01 13:00:00	QQQ	ETF	146.18	146.22	145.91	146.0292	1724813.0
2017-09-01 14:00:00	QQQ	ETF	146.02	146.13	145.97	146.045	2021712.0
2017-09-01 15:00:00	QQQ	ETF	146.05	146.19	145.99	146.0	3545753.0
2017-09-01 16:00:00	QQQ	ETF	146.0	146.06	145.95	146.0	2262114.0
2017-09-01 17:00:00	QQQ	ETF	146.02	146.05	145.93	146.05	1326.0
2017-09-01 18:00:00	QQQ	ETF	146.05	146.05	145.98	145.98	1506.0
2017-09-01 19:00:00	QQQ	ETF	145.98	146.0	145.93	145.96	4743.0
2017-09-01 04:00:00	IWM	ETF	139.79	139.8	139.69	139.7	4953.0
2017-09-01 05:00:00	IWM	ETF	139.78	139.81	139.78	139.78	2976.0
2017-09-01 06:00:00	IWM	ETF	139.91	139.94	139.9	139.9	12678.0
2017-09-01 07:00:00	IWM	ETF	139.93	140.13	139.93	140.13	24150.0
2017-09-01 08:00:00	IWM	ETF	140.13	140.15	139.73	139.96	32142.0
2017-09-01 09:00:00	IWM	ETF	140.03	140.15	139.7256	139.89	1933805.0
2017-09-01 10:00:00	IWM	ETF	139.89	140.19	139.83	140.16	1879424.0
2017-09-01 11:00:00	IWM	ETF	140.16	140.265	140.0	140.15	1665912.0
2017-09-01 12:00:00	IWM	ETF	140.15	140.31	140.06	140.285	987878.0
2017-09-01 13:00:00	IWM	ETF	140.28	140.37	140.19	140.19	865926.0
2017-09-01 14:00:00	IWM	ETF	140.19	140.345	140.145	140.3	970002.0
2017-09-01 15:00:00	IWM	ETF	140.3	140.63	140.28	140.5	3923549.0
2017-09-01 16:00:00	IWM	ETF	140.5	140.68	140.32	140.45	2336778.0
2017-09-01 17:00:00	IWM	ETF	140.45	140.47	140.42	140.47	6967.0
2017-09-01 18:00:00	IWM	ETF	140.47	140.49	140.157	140.45	72648.0
2017-09-01 19:00:00	IWM	ETF	140.46	140.55	140.46	140.54	9859.0
2017-09-01 04:00:00	DIA	ETF	219.9	219.99	219.88	219.88	500.0
2017-09-01 05:00:00	DIA	ETF	219.94	219.94	219.94	219.94	100.0

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

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