PREVIEW / etf_1hour / 2024-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-12-26.parquet
  size:    593 KB
  rows:    22,286

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-12-26 04:00:00	SPY	ETF	600.5	600.5	599.0	599.18	39908.0
2024-12-26 05:00:00	SPY	ETF	598.93	599.05	598.54	598.95	15390.0
2024-12-26 06:00:00	SPY	ETF	598.72	599.21	598.35	599.21	12946.0
2024-12-26 07:00:00	SPY	ETF	599.19	599.48	599.0	599.33	42207.0
2024-12-26 08:00:00	SPY	ETF	599.39	601.69	598.69	599.13	184436.0
2024-12-26 09:00:00	SPY	ETF	599.12	600.27	598.0825	599.9	2689699.0
2024-12-26 10:00:00	SPY	ETF	599.92	600.91	599.41	600.88	2914859.0
2024-12-26 11:00:00	SPY	ETF	600.89	601.91	600.53	601.81	1908053.0
2024-12-26 12:00:00	SPY	ETF	601.84	602.48	600.35	600.99	1670669.0
2024-12-26 13:00:00	SPY	ETF	600.9596	601.82	600.75	601.32	1471538.0
2024-12-26 14:00:00	SPY	ETF	601.265	601.81	600.66	601.745	1584362.0
2024-12-26 15:00:00	SPY	ETF	601.74	602.1	601.06	601.25	4180055.0
2024-12-26 16:00:00	SPY	ETF	601.23	601.56	600.93	600.99	8602129.0
2024-12-26 17:00:00	SPY	ETF	600.99	601.09	600.87	600.91	61705.0
2024-12-26 18:00:00	SPY	ETF	600.91	601.23	600.8	601.15	39235.0
2024-12-26 19:00:00	SPY	ETF	601.17	601.3	600.25	600.41	51677.0
2024-12-26 04:00:00	QQQ	ETF	529.88	529.95	527.48	527.7	91075.0
2024-12-26 05:00:00	QQQ	ETF	527.49	527.8	526.77	527.73	45568.0
2024-12-26 06:00:00	QQQ	ETF	527.68	528.34	527.32	528.31	64593.0
2024-12-26 07:00:00	QQQ	ETF	528.34	528.65	527.63	528.05	165176.0
2024-12-26 08:00:00	QQQ	ETF	528.5	531.52	526.876	528.1	303444.0
2024-12-26 09:00:00	QQQ	ETF	527.96	529.54	526.31	528.3701	2189357.0
2024-12-26 10:00:00	QQQ	ETF	528.37	529.7119	527.7	529.66	1894986.0
2024-12-26 11:00:00	QQQ	ETF	529.63	530.455	528.9	530.44	1512257.0
2024-12-26 12:00:00	QQQ	ETF	530.42	531.24	528.83	529.615	1885660.0
2024-12-26 13:00:00	QQQ	ETF	529.61	530.4	529.33	529.85	1252099.0
2024-12-26 14:00:00	QQQ	ETF	529.83	530.59	529.32	530.5301	901467.0
2024-12-26 15:00:00	QQQ	ETF	530.55	530.87	529.42	529.55	2227278.0
2024-12-26 16:00:00	QQQ	ETF	529.56	529.92	528.97	529.02	554190.0
2024-12-26 17:00:00	QQQ	ETF	529.03	529.22	529.0	529.189	9240.0
2024-12-26 18:00:00	QQQ	ETF	529.11	529.56	528.9095	529.54	25432.0
2024-12-26 19:00:00	QQQ	ETF	529.5699	529.6	528.4	528.7899	35336.0
2024-12-26 04:00:00	IWM	ETF	222.92	222.98	222.65	222.76	29531.0
2024-12-26 05:00:00	IWM	ETF	222.76	222.76	222.5	222.5	13598.0
2024-12-26 06:00:00	IWM	ETF	222.47	222.57	222.3	222.48	21323.0
2024-12-26 07:00:00	IWM	ETF	222.48	222.59	222.33	222.53	27140.0
2024-12-26 08:00:00	IWM	ETF	222.4306	223.59	222.06	222.3	111961.0
2024-12-26 09:00:00	IWM	ETF	222.24	222.77	221.465	222.68	1823376.0
2024-12-26 10:00:00	IWM	ETF	222.71	224.48	222.47	224.43	2567627.0
2024-12-26 11:00:00	IWM	ETF	224.42	225.34	224.265	225.28	2139525.0
2024-12-26 12:00:00	IWM	ETF	225.2899	225.2899	224.29	224.51	1358088.0
2024-12-26 13:00:00	IWM	ETF	224.5	225.59	224.45	225.13	1689199.0
2024-12-26 14:00:00	IWM	ETF	225.12	225.36	224.92	225.24	1001798.0
2024-12-26 15:00:00	IWM	ETF	225.25	226.1407	225.0	225.73	2853822.0
2024-12-26 16:00:00	IWM	ETF	225.68	226.1	225.51	225.54	860512.0
2024-12-26 17:00:00	IWM	ETF	225.61	225.68	225.61	225.64	15940.0
2024-12-26 18:00:00	IWM	ETF	225.7	225.73	225.53	225.72	32377.0
2024-12-26 19:00:00	IWM	ETF	225.68	225.68	225.28	225.3101	53143.0
2024-12-26 04:00:00	DIA	ETF	431.57	431.58	431.36	431.39	1805.0
2024-12-26 05:00:00	DIA	ETF	430.89	430.95	430.85	430.9	2050.0

> showing 50 of 22,286 rows — these rows as CSV

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