PREVIEW / etf_1hour / 2019-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-03.parquet
  size:    343 KB
  rows:    11,116

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
2019-10-03 04:00:00	SPY	ETF	288.4	288.7	288.03	288.4	36069.0
2019-10-03 05:00:00	SPY	ETF	288.39	288.53	288.1	288.5	11851.0
2019-10-03 06:00:00	SPY	ETF	288.45	288.59	287.89	287.9	45045.0
2019-10-03 07:00:00	SPY	ETF	287.9	288.1	287.18	287.39	195085.0
2019-10-03 08:00:00	SPY	ETF	288.0101	288.72	287.16	287.56	464384.0
2019-10-03 09:00:00	SPY	ETF	287.56	288.45	287.38	288.33	6319267.0
2019-10-03 10:00:00	SPY	ETF	288.03	288.33	284.82	287.3898	26546407.0
2019-10-03 11:00:00	SPY	ETF	287.37	289.46	287.09	288.09	16013310.0
2019-10-03 12:00:00	SPY	ETF	288.09	289.63	288.09	289.48	5528551.0
2019-10-03 13:00:00	SPY	ETF	289.49	290.09	289.16	289.98	4940168.0
2019-10-03 14:00:00	SPY	ETF	289.985	290.225	289.635	289.71	6534134.0
2019-10-03 15:00:00	SPY	ETF	289.71	290.4	289.09	290.37	13949884.0
2019-10-03 16:00:00	SPY	ETF	290.38	290.55	290.3111	290.45	3950528.0
2019-10-03 17:00:00	SPY	ETF	290.45	290.47	290.35	290.36	152665.0
2019-10-03 18:00:00	SPY	ETF	290.45	290.53	290.21	290.21	70640.0
2019-10-03 19:00:00	SPY	ETF	290.22	290.3	290.02	290.07	114155.0
2019-10-03 04:00:00	QQQ	ETF	184.26	184.54	184.05	184.27	8691.0
2019-10-03 05:00:00	QQQ	ETF	184.26	184.44	184.22	184.38	11450.0
2019-10-03 06:00:00	QQQ	ETF	184.47	184.47	184.04	184.06	8599.0
2019-10-03 07:00:00	QQQ	ETF	184.12	184.17	183.52	183.71	77637.0
2019-10-03 08:00:00	QQQ	ETF	184.02	184.55	183.55	183.78	190692.0
2019-10-03 09:00:00	QQQ	ETF	183.78	184.4975	183.6322	184.1974	3450610.0
2019-10-03 10:00:00	QQQ	ETF	184.19	184.19	181.82	183.7	10540728.0
2019-10-03 11:00:00	QQQ	ETF	183.69	185.37	183.5	184.54	5546111.0
2019-10-03 12:00:00	QQQ	ETF	184.57	185.8	184.57	185.65	3741617.0
2019-10-03 13:00:00	QQQ	ETF	185.68	186.2065	185.49	186.03	2562893.0
2019-10-03 14:00:00	QQQ	ETF	186.04	186.17	185.75	185.83	2459577.0
2019-10-03 15:00:00	QQQ	ETF	185.83	186.17	185.4	186.13	5722563.0
2019-10-03 16:00:00	QQQ	ETF	186.13	186.34	186.07	186.31	1139639.0
2019-10-03 17:00:00	QQQ	ETF	186.3	186.34	186.12	186.22	25042.0
2019-10-03 18:00:00	QQQ	ETF	186.22	186.26	186.07	186.08	33445.0
2019-10-03 19:00:00	QQQ	ETF	186.08	186.12	185.92	185.95	30660.0
2019-10-03 04:00:00	IWM	ETF	147.08	147.29	147.08	147.19	5200.0
2019-10-03 05:00:00	IWM	ETF	147.15	147.15	147.15	147.15	400.0
2019-10-03 06:00:00	IWM	ETF	147.17	147.18	147.0	147.0	12500.0
2019-10-03 07:00:00	IWM	ETF	146.9	146.96	146.3	146.3	46024.0
2019-10-03 08:00:00	IWM	ETF	146.38	147.1	146.38	146.72	49208.0
2019-10-03 09:00:00	IWM	ETF	146.76	147.03	146.31	146.66	2301446.0
2019-10-03 10:00:00	IWM	ETF	146.6	146.66	144.93	146.21	5370509.0
2019-10-03 11:00:00	IWM	ETF	146.215	147.44	145.97	146.21	4033850.0
2019-10-03 12:00:00	IWM	ETF	146.21	147.33	146.145	147.13	2299964.0
2019-10-03 13:00:00	IWM	ETF	147.14	147.8239	146.9704	147.535	1942466.0
2019-10-03 14:00:00	IWM	ETF	147.54	147.94	147.36	147.61	1817153.0
2019-10-03 15:00:00	IWM	ETF	147.61	147.79	147.13	147.76	2916691.0
2019-10-03 16:00:00	IWM	ETF	147.77	147.86	147.086	147.73	1635063.0
2019-10-03 17:00:00	IWM	ETF	147.71	147.77	147.68	147.76	20650.0
2019-10-03 18:00:00	IWM	ETF	147.71	147.74	147.59	147.59	12602.0
2019-10-03 19:00:00	IWM	ETF	147.58	147.59	147.43	147.43	4850.0
2019-10-03 04:00:00	DIA	ETF	260.88	261.23	260.8	261.0	2550.0
2019-10-03 06:00:00	DIA	ETF	260.94	260.94	260.72	260.72	1400.0

> showing 50 of 11,116 rows — these rows as CSV

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