PREVIEW / etf_1hour / 2024-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-07-23.parquet
  size:    554 KB
  rows:    20,717

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
2024-07-23 04:00:00	SPY	ETF	553.02	553.83	552.7	553.72	14627.0
2024-07-23 05:00:00	SPY	ETF	553.68	554.63	553.68	554.57	30004.0
2024-07-23 06:00:00	SPY	ETF	554.61	555.19	554.45	554.98	27953.0
2024-07-23 07:00:00	SPY	ETF	554.92	555.57	554.92	555.23	174772.0
2024-07-23 08:00:00	SPY	ETF	555.21	555.5081	552.83	554.72	119152.0
2024-07-23 09:00:00	SPY	ETF	554.73	555.81	554.13	555.52	2617318.0
2024-07-23 10:00:00	SPY	ETF	555.5401	556.41	554.28	554.92	3544015.0
2024-07-23 11:00:00	SPY	ETF	554.93	556.735	554.9	556.2	2464604.0
2024-07-23 12:00:00	SPY	ETF	556.17	556.36	554.18	554.61	2243609.0
2024-07-23 13:00:00	SPY	ETF	554.61	555.36	554.21	555.245	1927205.0
2024-07-23 14:00:00	SPY	ETF	555.24	555.55	554.53	555.0901	1925632.0
2024-07-23 15:00:00	SPY	ETF	555.1	555.35	553.275	553.72	5397881.0
2024-07-23 16:00:00	SPY	ETF	553.73	554.91	553.23	554.0	2515999.0
2024-07-23 17:00:00	SPY	ETF	554.013	554.16	552.56	552.6	295994.0
2024-07-23 18:00:00	SPY	ETF	552.51	552.51	551.25	551.82	193194.0
2024-07-23 19:00:00	SPY	ETF	551.73	551.76	551.32	551.34	74074.0
2024-07-23 04:00:00	QQQ	ETF	480.52	480.72	479.52	480.52	84809.0
2024-07-23 05:00:00	QQQ	ETF	480.54	481.7	480.54	481.41	48318.0
2024-07-23 06:00:00	QQQ	ETF	481.4	482.26	481.33	481.77	41305.0
2024-07-23 07:00:00	QQQ	ETF	481.75	482.82	481.75	482.34	283141.0
2024-07-23 08:00:00	QQQ	ETF	481.7603	482.78	479.5	481.7104	227195.0
2024-07-23 09:00:00	QQQ	ETF	481.73	483.28	480.87	482.58	2554901.0
2024-07-23 10:00:00	QQQ	ETF	482.64	483.57	480.7	481.68	3039358.0
2024-07-23 11:00:00	QQQ	ETF	481.65	484.43	481.64	483.2401	2047160.0
2024-07-23 12:00:00	QQQ	ETF	483.23	483.4143	480.72	481.2401	2232080.0
2024-07-23 13:00:00	QQQ	ETF	481.23	482.16	480.46	481.98	1615610.0
2024-07-23 14:00:00	QQQ	ETF	481.96	482.38	481.15	481.88	1133668.0
2024-07-23 15:00:00	QQQ	ETF	481.87	482.33	480.14	480.62	2506845.0
2024-07-23 16:00:00	QQQ	ETF	480.64	482.9	480.0	481.16	1052502.0
2024-07-23 17:00:00	QQQ	ETF	481.16	481.18	478.53	478.53	392096.0
2024-07-23 18:00:00	QQQ	ETF	479.0	479.19	477.33	477.96	368021.0
2024-07-23 19:00:00	QQQ	ETF	477.85	477.96	477.37	477.38	89826.0
2024-07-23 04:00:00	IWM	ETF	220.4	220.4	219.7	220.21	27384.0
2024-07-23 05:00:00	IWM	ETF	220.15	220.85	220.09	220.7	14736.0
2024-07-23 06:00:00	IWM	ETF	220.64	221.09	220.6	220.97	24515.0
2024-07-23 07:00:00	IWM	ETF	220.9	221.15	220.05	220.1	95164.0
2024-07-23 08:00:00	IWM	ETF	220.87	221.12	218.94	219.17	233411.0
2024-07-23 09:00:00	IWM	ETF	219.16	220.83	219.03	220.5999	3666555.0
2024-07-23 10:00:00	IWM	ETF	220.58	222.995	220.4625	221.77	7522041.0
2024-07-23 11:00:00	IWM	ETF	221.78	222.91	221.75	222.535	3166503.0
2024-07-23 12:00:00	IWM	ETF	222.54	222.83	221.7011	222.04	1875649.0
2024-07-23 13:00:00	IWM	ETF	222.03	222.77	221.89	222.65	1895621.0
2024-07-23 14:00:00	IWM	ETF	222.65	223.65	222.6	223.61	3181084.0
2024-07-23 15:00:00	IWM	ETF	223.6	223.75	222.52	222.57	5790838.0
2024-07-23 16:00:00	IWM	ETF	222.63	223.09	222.51	222.88	2022406.0
2024-07-23 17:00:00	IWM	ETF	222.95	222.95	222.3	222.36	153728.0
2024-07-23 18:00:00	IWM	ETF	222.36	222.59	222.05	222.16	59521.0
2024-07-23 19:00:00	IWM	ETF	222.13	222.42	222.04	222.2	43534.0
2024-07-23 04:00:00	DIA	ETF	403.37	403.37	403.37	403.37	100.0
2024-07-23 05:00:00	DIA	ETF	404.17	404.47	404.17	404.47	500.0

> showing 50 of 20,717 rows — these rows as CSV

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