PREVIEW / etf_1hour / 2022-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-23.parquet
  size:    460 KB
  rows:    16,711

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-11-23 04:00:00	SPY	ETF	400.07	401.09	399.87	400.9	45176.0
2022-11-23 05:00:00	SPY	ETF	400.82	400.82	400.22	400.41	33873.0
2022-11-23 06:00:00	SPY	ETF	400.45	400.56	400.09	400.56	41711.0
2022-11-23 07:00:00	SPY	ETF	400.66	400.81	400.27	400.6	109657.0
2022-11-23 08:00:00	SPY	ETF	400.61	400.78	399.2	399.71	376078.0
2022-11-23 09:00:00	SPY	ETF	399.74	401.85	399.45	401.38	5559018.0
2022-11-23 10:00:00	SPY	ETF	401.41	402.74	400.69	402.09	7057273.0
2022-11-23 11:00:00	SPY	ETF	402.11	402.5	399.77	400.34	5820076.0
2022-11-23 12:00:00	SPY	ETF	400.34	401.02	399.31	399.79	4556096.0
2022-11-23 13:00:00	SPY	ETF	399.795	401.21	399.55	400.9699	3590852.0
2022-11-23 14:00:00	SPY	ETF	400.9886	402.88	400.21	402.2	10138795.0
2022-11-23 15:00:00	SPY	ETF	402.21	402.93	401.69	402.39	10304574.0
2022-11-23 16:00:00	SPY	ETF	402.39	402.88	402.22	402.86	3555357.0
2022-11-23 17:00:00	SPY	ETF	402.84	402.98	402.73	402.9	58207.0
2022-11-23 18:00:00	SPY	ETF	402.89	403.08	402.74	403.05	53237.0
2022-11-23 19:00:00	SPY	ETF	403.05	403.25	402.9	403.07	56199.0
2022-11-23 04:00:00	QQQ	ETF	285.6	286.68	285.6	286.56	26560.0
2022-11-23 05:00:00	QQQ	ETF	286.43	286.43	285.95	286.2	30292.0
2022-11-23 06:00:00	QQQ	ETF	286.23	286.6	285.92	286.6	37625.0
2022-11-23 07:00:00	QQQ	ETF	286.61	287.01	286.26	286.8	94663.0
2022-11-23 08:00:00	QQQ	ETF	286.53	287.0	285.63	286.17	541711.0
2022-11-23 09:00:00	QQQ	ETF	286.2101	288.45	285.89	287.9401	4513301.0
2022-11-23 10:00:00	QQQ	ETF	287.99	289.37	287.27	289.06	4680298.0
2022-11-23 11:00:00	QQQ	ETF	289.0452	289.28	286.39	286.87	3684422.0
2022-11-23 12:00:00	QQQ	ETF	286.85	287.61	285.79	286.25	3263843.0
2022-11-23 13:00:00	QQQ	ETF	286.245	287.78	286.045	287.48	2235784.0
2022-11-23 14:00:00	QQQ	ETF	287.5136	289.24	286.75	288.7813	7222177.0
2022-11-23 15:00:00	QQQ	ETF	288.79	289.46	288.17	288.86	6191050.0
2022-11-23 16:00:00	QQQ	ETF	288.86	289.14	288.6957	289.06	3191674.0
2022-11-23 17:00:00	QQQ	ETF	289.06	289.19	288.82	289.15	147533.0
2022-11-23 18:00:00	QQQ	ETF	289.19	289.37	289.05	289.33	46861.0
2022-11-23 19:00:00	QQQ	ETF	289.34	289.58	289.34	289.55	97151.0
2022-11-23 04:00:00	IWM	ETF	184.65	185.16	184.59	185.16	22163.0
2022-11-23 05:00:00	IWM	ETF	185.11	185.11	184.71	184.82	14287.0
2022-11-23 06:00:00	IWM	ETF	184.76	184.95	184.64	184.95	17235.0
2022-11-23 07:00:00	IWM	ETF	184.91	185.06	184.84	184.94	11993.0
2022-11-23 08:00:00	IWM	ETF	184.9	184.97	184.14	184.4	49772.0
2022-11-23 09:00:00	IWM	ETF	184.42	185.4	184.24	185.1	1414408.0
2022-11-23 10:00:00	IWM	ETF	185.13	185.73	184.69	185.68	1867777.0
2022-11-23 11:00:00	IWM	ETF	185.685	185.765	183.91	184.2499	1680369.0
2022-11-23 12:00:00	IWM	ETF	184.23	184.57	183.55	183.8399	1137209.0
2022-11-23 13:00:00	IWM	ETF	183.83	184.71	183.7	184.5	787360.0
2022-11-23 14:00:00	IWM	ETF	184.58	185.78	184.3	185.12	2355881.0
2022-11-23 15:00:00	IWM	ETF	185.12	185.43	184.885	185.18	1963292.0
2022-11-23 16:00:00	IWM	ETF	185.19	185.62	185.11	185.46	4122197.0
2022-11-23 17:00:00	IWM	ETF	185.48	185.54	185.43	185.53	16353.0
2022-11-23 18:00:00	IWM	ETF	185.56	185.65	185.451	185.6	14453.0
2022-11-23 19:00:00	IWM	ETF	185.66	185.74	185.55	185.65	23972.0
2022-11-23 04:00:00	DIA	ETF	340.96	341.79	340.96	341.78	477.0
2022-11-23 05:00:00	DIA	ETF	341.54	341.54	341.54	341.54	300.0

> showing 50 of 16,711 rows — these rows as CSV

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