PREVIEW / etf_1hour / 2025-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-23.parquet
  size:    692 KB
  rows:    26,923

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
2025-09-23 04:00:00	SPY	ETF	666.57	667.18	666.0	666.8	37355.0
2025-09-23 05:00:00	SPY	ETF	666.74	666.98	666.69	666.94	4382.0
2025-09-23 06:00:00	SPY	ETF	666.95	666.96	666.37	666.6	30546.0
2025-09-23 07:00:00	SPY	ETF	666.48	666.85	666.14	666.85	57099.0
2025-09-23 08:00:00	SPY	ETF	666.47	666.96	666.16	666.879	123725.0
2025-09-23 09:00:00	SPY	ETF	666.89	667.34	666.57	666.89	6091570.0
2025-09-23 10:00:00	SPY	ETF	666.9	667.245	666.155	666.3153	7046834.0
2025-09-23 11:00:00	SPY	ETF	666.31	666.47	665.49	665.55	4453741.0
2025-09-23 12:00:00	SPY	ETF	665.56	665.84	664.88	665.155	6470173.0
2025-09-23 13:00:00	SPY	ETF	665.165	665.25	662.035	663.23	10362634.0
2025-09-23 14:00:00	SPY	ETF	663.24	663.38	661.98	662.11	6916068.0
2025-09-23 15:00:00	SPY	ETF	662.1	663.54	662.09	663.23	13141266.0
2025-09-23 16:00:00	SPY	ETF	663.25	663.5392	663.0	663.35	2296276.0
2025-09-23 17:00:00	SPY	ETF	663.38	663.9	663.36	663.52	81504.0
2025-09-23 18:00:00	SPY	ETF	663.55	663.95	663.48	663.75	104898.0
2025-09-23 19:00:00	SPY	ETF	663.759	663.759	663.5301	663.55	10590.0
2025-09-23 04:00:00	QQQ	ETF	601.34	602.98	601.34	602.44	44930.0
2025-09-23 05:00:00	QQQ	ETF	602.44	602.7	602.3	602.63	42547.0
2025-09-23 06:00:00	QQQ	ETF	602.63	602.75	602.11	602.43	46945.0
2025-09-23 07:00:00	QQQ	ETF	602.41	602.43	601.63	602.36	66264.0
2025-09-23 08:00:00	QQQ	ETF	601.94	602.87	601.73	602.57	144231.0
2025-09-23 09:00:00	QQQ	ETF	602.57	602.6	600.69	600.87	5428826.0
2025-09-23 10:00:00	QQQ	ETF	600.89	601.7	600.62	600.97	5637220.0
2025-09-23 11:00:00	QQQ	ETF	600.97	601.57	600.61	601.0	3579066.0
2025-09-23 12:00:00	QQQ	ETF	601.0	601.2006	600.26	600.58	4469824.0
2025-09-23 13:00:00	QQQ	ETF	600.58	600.62	596.98	598.35	8644118.0
2025-09-23 14:00:00	QQQ	ETF	598.35	598.6	597.1	597.2501	5532743.0
2025-09-23 15:00:00	QQQ	ETF	597.26	598.46	597.23	598.14	7790023.0
2025-09-23 16:00:00	QQQ	ETF	598.18	598.77	598.04	598.32	3575284.0
2025-09-23 17:00:00	QQQ	ETF	598.36	598.8532	598.35	598.8532	110065.0
2025-09-23 18:00:00	QQQ	ETF	598.52	598.9121	598.44	598.72	46273.0
2025-09-23 19:00:00	QQQ	ETF	598.72	598.76	598.4	598.4	28527.0
2025-09-23 04:00:00	IWM	ETF	243.91	244.49	243.66	244.49	32232.0
2025-09-23 05:00:00	IWM	ETF	244.5	244.63	244.32	244.52	22860.0
2025-09-23 06:00:00	IWM	ETF	244.55	244.61	244.23	244.53	18462.0
2025-09-23 07:00:00	IWM	ETF	244.42	244.98	244.26	244.98	54355.0
2025-09-23 08:00:00	IWM	ETF	244.41	244.94	243.68	244.85	46186.0
2025-09-23 09:00:00	IWM	ETF	244.91	246.98	244.75	246.775	4459153.0
2025-09-23 10:00:00	IWM	ETF	246.78	247.175	245.99	246.92	4054938.0
2025-09-23 11:00:00	IWM	ETF	246.91	246.92	245.665	245.8	2995721.0
2025-09-23 12:00:00	IWM	ETF	245.81	246.24	245.48	245.92	2709225.0
2025-09-23 13:00:00	IWM	ETF	245.93	246.025	243.62	244.025	4830115.0
2025-09-23 14:00:00	IWM	ETF	244.02	244.33	243.44	243.64	3712678.0
2025-09-23 15:00:00	IWM	ETF	243.63	244.42	243.54	243.87	5078595.0
2025-09-23 16:00:00	IWM	ETF	243.84	243.94	243.7	243.83	1325642.0
2025-09-23 17:00:00	IWM	ETF	243.8785	244.09	243.74	243.8596	22414.0
2025-09-23 18:00:00	IWM	ETF	243.85	244.15	243.85	243.96	31627.0
2025-09-23 19:00:00	IWM	ETF	243.95	243.99	243.87	243.96	8531.0
2025-09-23 04:00:00	DIA	ETF	463.66	464.23	463.66	464.08	800.0
2025-09-23 05:00:00	DIA	ETF	464.21	464.38	464.21	464.36	1700.0

> showing 50 of 26,923 rows — these rows as CSV

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