PREVIEW / etf_1hour / 2022-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-05.parquet
  size:    475 KB
  rows:    17,233

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
2022-12-05 04:00:00	SPY	ETF	406.91	406.91	404.8	405.5	102567.0
2022-12-05 05:00:00	SPY	ETF	405.46	405.72	404.89	405.05	92973.0
2022-12-05 06:00:00	SPY	ETF	405.17	405.75	405.0	405.65	77922.0
2022-12-05 07:00:00	SPY	ETF	405.71	405.72	404.64	404.95	449607.0
2022-12-05 08:00:00	SPY	ETF	404.96	406.2	403.82	404.0	646461.0
2022-12-05 09:00:00	SPY	ETF	404.0101	404.93	403.28	403.32	5153576.0
2022-12-05 10:00:00	SPY	ETF	403.28	403.66	401.59	403.35	8618973.0
2022-12-05 11:00:00	SPY	ETF	403.35	403.9781	400.88	400.95	6836977.0
2022-12-05 12:00:00	SPY	ETF	400.94	401.83	400.24	400.36	5274531.0
2022-12-05 13:00:00	SPY	ETF	400.36	400.93	399.12	399.1901	5261107.0
2022-12-05 14:00:00	SPY	ETF	399.17	399.7	398.17	398.9354	6830445.0
2022-12-05 15:00:00	SPY	ETF	398.92	399.95	398.62	399.61	12414503.0
2022-12-05 16:00:00	SPY	ETF	399.62	400.04	399.52	400.0	5915946.0
2022-12-05 17:00:00	SPY	ETF	400.02	400.15	399.91	400.01	56820.0
2022-12-05 18:00:00	SPY	ETF	400.01	400.43	399.8	400.23	145644.0
2022-12-05 19:00:00	SPY	ETF	400.3	400.56	399.57	400.41	154968.0
2022-12-05 04:00:00	QQQ	ETF	292.08	292.15	291.24	291.8	80930.0
2022-12-05 05:00:00	QQQ	ETF	291.85	292.0	291.44	291.77	36106.0
2022-12-05 06:00:00	QQQ	ETF	291.7	292.23	291.59	292.23	41019.0
2022-12-05 07:00:00	QQQ	ETF	292.22	292.26	291.15	291.39	122715.0
2022-12-05 08:00:00	QQQ	ETF	292.08	292.769	290.41	290.54	392564.0
2022-12-05 09:00:00	QQQ	ETF	290.57	291.68	290.19	290.69	3722460.0
2022-12-05 10:00:00	QQQ	ETF	290.68	290.7	289.0	290.46	5634021.0
2022-12-05 11:00:00	QQQ	ETF	290.47	291.16	288.52	288.641	3660222.0
2022-12-05 12:00:00	QQQ	ETF	288.6	289.25	287.87	287.956	3331558.0
2022-12-05 13:00:00	QQQ	ETF	287.96	288.655	287.01	287.085	3341111.0
2022-12-05 14:00:00	QQQ	ETF	287.06	287.53	286.15	286.72	3601652.0
2022-12-05 15:00:00	QQQ	ETF	286.71	287.69	286.35	287.52	5688220.0
2022-12-05 16:00:00	QQQ	ETF	287.54	287.88	287.28	287.76	4404654.0
2022-12-05 17:00:00	QQQ	ETF	287.72	287.8	287.58	287.691	86389.0
2022-12-05 18:00:00	QQQ	ETF	287.67	288.15	287.49	287.93	75197.0
2022-12-05 19:00:00	QQQ	ETF	287.99	288.33	287.99	288.19	162663.0
2022-12-05 04:00:00	IWM	ETF	187.58	187.69	187.15	187.51	26546.0
2022-12-05 05:00:00	IWM	ETF	187.56	187.66	187.2	187.34	6432.0
2022-12-05 06:00:00	IWM	ETF	187.36	187.67	187.3	187.54	11391.0
2022-12-05 07:00:00	IWM	ETF	187.6	187.67	187.08	187.33	48135.0
2022-12-05 08:00:00	IWM	ETF	187.58	188.05	186.78	186.8	99486.0
2022-12-05 09:00:00	IWM	ETF	186.85	187.06	185.0	185.15	2185220.0
2022-12-05 10:00:00	IWM	ETF	185.02	185.16	184.28	184.69	3260295.0
2022-12-05 11:00:00	IWM	ETF	184.7	185.04	183.09	183.18	2465598.0
2022-12-05 12:00:00	IWM	ETF	183.15	183.85	183.02	183.3	1582598.0
2022-12-05 13:00:00	IWM	ETF	183.3	183.5	182.67	182.71	1284800.0
2022-12-05 14:00:00	IWM	ETF	182.7	183.03	182.36	182.71	2119126.0
2022-12-05 15:00:00	IWM	ETF	182.69	182.925	182.1838	182.84	4029415.0
2022-12-05 16:00:00	IWM	ETF	182.87	183.05	182.75	183.04	2977212.0
2022-12-05 17:00:00	IWM	ETF	183.19	183.19	183.01	183.12	5467.0
2022-12-05 18:00:00	IWM	ETF	183.04	183.27	182.91	183.19	57975.0
2022-12-05 19:00:00	IWM	ETF	183.13	183.35	183.02	183.13	21301.0
2022-12-05 04:00:00	DIA	ETF	343.24	343.37	343.16	343.37	800.0
2022-12-05 05:00:00	DIA	ETF	343.43	343.45	343.43	343.45	4500.0

> showing 50 of 17,233 rows — these rows as CSV

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