PREVIEW / etf_1hour / 2022-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-25.parquet
  size:    282 KB
  rows:    9,677

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-25 04:00:00	SPY	ETF	402.97	403.31	402.33	402.53	43949.0
2022-11-25 05:00:00	SPY	ETF	402.46	403.01	402.3	403.0	32729.0
2022-11-25 06:00:00	SPY	ETF	402.89	403.11	402.65	402.72	11506.0
2022-11-25 07:00:00	SPY	ETF	402.67	403.15	402.67	402.72	47767.0
2022-11-25 08:00:00	SPY	ETF	402.8399	403.38	402.02	402.07	521803.0
2022-11-25 09:00:00	SPY	ETF	402.07	402.56	401.52	402.44	3136285.0
2022-11-25 10:00:00	SPY	ETF	402.44	402.78	402.28	402.62	3818871.0
2022-11-25 11:00:00	SPY	ETF	402.62	402.91	401.98	402.478	3455290.0
2022-11-25 12:00:00	SPY	ETF	402.47	402.59	401.845	402.26	5632894.0
2022-11-25 13:00:00	SPY	ETF	402.26	402.64	402.11	402.27	1273743.0
2022-11-25 14:00:00	SPY	ETF	402.27	402.59	402.2101	402.3	105576.0
2022-11-25 15:00:00	SPY	ETF	402.3	402.5001	402.3	402.37	26907.0
2022-11-25 16:00:00	SPY	ETF	402.33	402.47	402.0	402.01	91539.0
2022-11-25 04:00:00	QQQ	ETF	289.82	289.82	288.41	288.5	86080.0
2022-11-25 05:00:00	QQQ	ETF	288.53	289.02	288.39	288.82	24754.0
2022-11-25 06:00:00	QQQ	ETF	288.81	288.84	288.25	288.26	23848.0
2022-11-25 07:00:00	QQQ	ETF	288.27	288.57	288.02	288.09	100197.0
2022-11-25 08:00:00	QQQ	ETF	288.38	289.95	287.6	287.71	256810.0
2022-11-25 09:00:00	QQQ	ETF	287.71	287.8	286.42	287.33	3314996.0
2022-11-25 10:00:00	QQQ	ETF	287.33	287.91	287.09	287.395	2277393.0
2022-11-25 11:00:00	QQQ	ETF	287.395	287.81	286.52	287.21	2604070.0
2022-11-25 12:00:00	QQQ	ETF	287.205	287.3199	286.6801	286.85	3147495.0
2022-11-25 13:00:00	QQQ	ETF	286.86	286.95	286.62	286.91	894797.0
2022-11-25 14:00:00	QQQ	ETF	286.82	286.96	286.7999	286.9	33667.0
2022-11-25 15:00:00	QQQ	ETF	286.875	286.89	286.82	286.8499	10852.0
2022-11-25 16:00:00	QQQ	ETF	286.85	286.9	286.78	286.83	29607.0
2022-11-25 04:00:00	IWM	ETF	185.77	185.87	185.36	185.45	27585.0
2022-11-25 05:00:00	IWM	ETF	185.39	185.78	185.31	185.78	30851.0
2022-11-25 06:00:00	IWM	ETF	185.72	185.84	185.62	185.62	1620.0
2022-11-25 07:00:00	IWM	ETF	185.62	185.83	185.59	185.68	10067.0
2022-11-25 08:00:00	IWM	ETF	185.7	185.84	185.18	185.24	36792.0
2022-11-25 09:00:00	IWM	ETF	185.31	185.78	184.66	185.67	1209897.0
2022-11-25 10:00:00	IWM	ETF	185.67	186.37	185.5	185.94	1754594.0
2022-11-25 11:00:00	IWM	ETF	185.95	186.21	185.71	186.06	1071244.0
2022-11-25 12:00:00	IWM	ETF	186.06	186.13	185.48	185.59	1907305.0
2022-11-25 13:00:00	IWM	ETF	185.58	186.0	185.46	185.58	2764114.0
2022-11-25 14:00:00	IWM	ETF	185.68	185.8	185.6	185.69	46177.0
2022-11-25 15:00:00	IWM	ETF	185.64	185.68	185.64	185.67	3318.0
2022-11-25 16:00:00	IWM	ETF	185.6	185.61	185.51	185.52	2115.0
2022-11-25 04:00:00	DIA	ETF	342.45	342.48	342.15	342.15	1767.0
2022-11-25 05:00:00	DIA	ETF	342.09	342.09	342.09	342.09	500.0
2022-11-25 06:00:00	DIA	ETF	342.57	342.57	342.45	342.45	250.0
2022-11-25 07:00:00	DIA	ETF	342.57	342.8	342.52	342.7	9900.0
2022-11-25 08:00:00	DIA	ETF	342.65	342.77	342.15	342.19	16235.0
2022-11-25 09:00:00	DIA	ETF	342.14	343.32	342.0	343.2101	235233.0
2022-11-25 10:00:00	DIA	ETF	343.22	343.6798	343.115	343.52	351308.0
2022-11-25 11:00:00	DIA	ETF	343.56	343.795	343.4	343.65	282238.0
2022-11-25 12:00:00	DIA	ETF	343.64	343.73	343.13	343.45	255741.0
2022-11-25 13:00:00	DIA	ETF	343.52	343.61	343.4	343.5999	34058.0
2022-11-25 14:00:00	DIA	ETF	343.22	343.52	343.22	343.52	472.0

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

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