PREVIEW / etf_1hour / 2024-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-10-14.parquet
  size:    561 KB
  rows:    21,133

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-10-14 04:00:00	SPY	ETF	579.34	580.17	579.3	579.86	53563.0
2024-10-14 05:00:00	SPY	ETF	579.96	580.39	579.95	580.29	38940.0
2024-10-14 06:00:00	SPY	ETF	580.29	580.93	580.29	580.5	77511.0
2024-10-14 07:00:00	SPY	ETF	580.5	580.57	580.16	580.49	140314.0
2024-10-14 08:00:00	SPY	ETF	580.44	580.94	579.2	580.92	311924.0
2024-10-14 09:00:00	SPY	ETF	580.91	583.3	580.73	583.3	3573943.0
2024-10-14 10:00:00	SPY	ETF	583.3	583.78	582.61	582.8305	3160098.0
2024-10-14 11:00:00	SPY	ETF	582.83	583.46	582.3	583.45	2210247.0
2024-10-14 12:00:00	SPY	ETF	583.45	583.96	583.4	583.8001	1673513.0
2024-10-14 13:00:00	SPY	ETF	583.8	584.14	583.52	583.6	1179628.0
2024-10-14 14:00:00	SPY	ETF	583.6	584.64	583.31	584.26	2394408.0
2024-10-14 15:00:00	SPY	ETF	584.26	585.27	584.0	584.28	7880029.0
2024-10-14 16:00:00	SPY	ETF	584.28	584.86	584.07	584.73	1974177.0
2024-10-14 17:00:00	SPY	ETF	584.74	584.79	584.32	584.54	161295.0
2024-10-14 18:00:00	SPY	ETF	584.54	584.85	584.44	584.58	46078.0
2024-10-14 19:00:00	SPY	ETF	584.59	584.79	584.52	584.71	38001.0
2024-10-14 04:00:00	QQQ	ETF	493.64	494.2	493.56	493.81	60966.0
2024-10-14 05:00:00	QQQ	ETF	493.76	494.33	493.76	494.25	28994.0
2024-10-14 06:00:00	QQQ	ETF	494.31	495.15	494.31	494.83	34022.0
2024-10-14 07:00:00	QQQ	ETF	494.79	494.97	494.5	494.76	104305.0
2024-10-14 08:00:00	QQQ	ETF	494.57	495.57	492.32	495.57	228799.0
2024-10-14 09:00:00	QQQ	ETF	495.58	498.62	495.54	498.62	2947124.0
2024-10-14 10:00:00	QQQ	ETF	498.63	498.83	495.84	496.1099	3602904.0
2024-10-14 11:00:00	QQQ	ETF	496.14	496.69	495.26	496.64	2654121.0
2024-10-14 12:00:00	QQQ	ETF	496.63	497.41	496.48	497.065	1196280.0
2024-10-14 13:00:00	QQQ	ETF	497.07	497.53	496.84	497.17	958880.0
2024-10-14 14:00:00	QQQ	ETF	497.175	497.95	496.9	497.605	1097099.0
2024-10-14 15:00:00	QQQ	ETF	497.6	498.59	497.28	497.5	3218198.0
2024-10-14 16:00:00	QQQ	ETF	497.48	497.91	497.05	497.8	795713.0
2024-10-14 17:00:00	QQQ	ETF	497.84	497.84	497.5	497.5125	145091.0
2024-10-14 18:00:00	QQQ	ETF	497.69	497.95	497.35	497.54	41482.0
2024-10-14 19:00:00	QQQ	ETF	497.6	497.8	497.47	497.73	19211.0
2024-10-14 04:00:00	IWM	ETF	221.95	222.18	221.74	221.99	32349.0
2024-10-14 05:00:00	IWM	ETF	222.02	222.09	221.66	221.8	17249.0
2024-10-14 06:00:00	IWM	ETF	221.85	222.19	221.71	221.72	24528.0
2024-10-14 07:00:00	IWM	ETF	221.73	221.91	221.5	221.6	74910.0
2024-10-14 08:00:00	IWM	ETF	221.72	222.0596	221.22	221.52	140859.0
2024-10-14 09:00:00	IWM	ETF	221.42	221.815	220.4301	221.045	2351292.0
2024-10-14 10:00:00	IWM	ETF	221.07	222.04	220.84	221.935	2506433.0
2024-10-14 11:00:00	IWM	ETF	221.93	222.74	221.62	222.43	2106301.0
2024-10-14 12:00:00	IWM	ETF	222.44	222.725	222.36	222.6204	941265.0
2024-10-14 13:00:00	IWM	ETF	222.62	222.71	222.2	222.66	495408.0
2024-10-14 14:00:00	IWM	ETF	222.665	222.86	222.39	222.51	1189524.0
2024-10-14 15:00:00	IWM	ETF	222.53	223.11	222.4	222.95	2961454.0
2024-10-14 16:00:00	IWM	ETF	222.89	223.1	222.78	222.97	1018641.0
2024-10-14 17:00:00	IWM	ETF	222.97	223.16	222.96	223.0335	14117.0
2024-10-14 18:00:00	IWM	ETF	223.03	223.16	222.91	223.08	12281.0
2024-10-14 19:00:00	IWM	ETF	223.07	223.15	222.89	223.0	5297.0
2024-10-14 04:00:00	DIA	ETF	428.69	428.69	428.4	428.42	934.0
2024-10-14 07:00:00	DIA	ETF	428.04	428.15	427.941	427.941	3870.0

> showing 50 of 21,133 rows — these rows as CSV

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