PREVIEW / etf_1hour / 2025-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-13.parquet
  size:    722 KB
  rows:    27,890

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-11-13 04:00:00	SPY	ETF	683.0	684.51	681.72	682.38	47473.0
2025-11-13 05:00:00	SPY	ETF	682.33	683.41	682.24	682.87	24972.0
2025-11-13 06:00:00	SPY	ETF	682.82	683.26	681.71	682.55	31659.0
2025-11-13 07:00:00	SPY	ETF	682.55	683.0	681.86	682.38	138862.0
2025-11-13 08:00:00	SPY	ETF	682.31	684.95	680.73	680.88	395248.0
2025-11-13 09:00:00	SPY	ETF	680.91	681.1	677.53	678.8	8078636.0
2025-11-13 10:00:00	SPY	ETF	678.78	680.86	675.34	676.48	11901699.0
2025-11-13 11:00:00	SPY	ETF	676.48	676.81	674.22	675.19	9207653.0
2025-11-13 12:00:00	SPY	ETF	675.195	676.5	673.97	674.15	7411429.0
2025-11-13 13:00:00	SPY	ETF	674.16	674.76	671.52	672.69	8378002.0
2025-11-13 14:00:00	SPY	ETF	672.68	673.63	670.52	671.69	8933302.0
2025-11-13 15:00:00	SPY	ETF	671.68	673.02	670.53	672.06	19224893.0
2025-11-13 16:00:00	SPY	ETF	672.06	673.68	671.8448	672.08	4098893.0
2025-11-13 17:00:00	SPY	ETF	672.06	672.38	671.72	672.3	370931.0
2025-11-13 18:00:00	SPY	ETF	672.23	673.36	672.23	672.57	131826.0
2025-11-13 19:00:00	SPY	ETF	672.63	673.27	672.395	672.6	176208.0
2025-11-13 04:00:00	QQQ	ETF	623.0	623.0	618.92	619.66	195075.0
2025-11-13 05:00:00	QQQ	ETF	619.68	621.25	619.63	620.59	97840.0
2025-11-13 06:00:00	QQQ	ETF	620.46	621.22	619.37	620.35	92940.0
2025-11-13 07:00:00	QQQ	ETF	620.32	620.9	619.401	620.25	141335.0
2025-11-13 08:00:00	QQQ	ETF	620.32	623.48	617.911	618.04	541767.0
2025-11-13 09:00:00	QQQ	ETF	618.04	618.3	612.84	615.25	6612703.0
2025-11-13 10:00:00	QQQ	ETF	615.27	618.04	610.8	612.2901	8869518.0
2025-11-13 11:00:00	QQQ	ETF	612.3	612.77	609.88	610.68	7513206.0
2025-11-13 12:00:00	QQQ	ETF	610.61	612.18	609.05	609.32	6719808.0
2025-11-13 13:00:00	QQQ	ETF	609.37	610.0	606.32	607.74	6598502.0
2025-11-13 14:00:00	QQQ	ETF	607.72	609.25	606.08	607.33	5688590.0
2025-11-13 15:00:00	QQQ	ETF	607.32	609.53	606.4	608.41	11283423.0
2025-11-13 16:00:00	QQQ	ETF	608.41	610.04	607.93	608.07	2304012.0
2025-11-13 17:00:00	QQQ	ETF	608.1	608.2191	607.95	608.1	128672.0
2025-11-13 18:00:00	QQQ	ETF	608.15	609.63	608.1	608.64	213736.0
2025-11-13 19:00:00	QQQ	ETF	608.71	609.39	608.29	608.52	178804.0
2025-11-13 04:00:00	IWM	ETF	243.85	243.92	242.82	242.96	28490.0
2025-11-13 05:00:00	IWM	ETF	242.91	243.5	242.89	243.17	16415.0
2025-11-13 06:00:00	IWM	ETF	243.14	243.25	242.55	242.79	25048.0
2025-11-13 07:00:00	IWM	ETF	242.78	242.98	242.5	242.74	67222.0
2025-11-13 08:00:00	IWM	ETF	242.7391	244.15	242.03	242.09	276103.0
2025-11-13 09:00:00	IWM	ETF	242.12	242.68	241.04	241.16	4933982.0
2025-11-13 10:00:00	IWM	ETF	241.175	241.86	239.41	239.95	7199894.0
2025-11-13 11:00:00	IWM	ETF	239.94	240.09	238.9	239.3641	7322450.0
2025-11-13 12:00:00	IWM	ETF	239.35	239.65	238.43	238.52	5511124.0
2025-11-13 13:00:00	IWM	ETF	238.54	238.72	236.85	237.285	6568318.0
2025-11-13 14:00:00	IWM	ETF	237.27	237.665	236.2	236.67	7692266.0
2025-11-13 15:00:00	IWM	ETF	236.67	237.255	235.84	236.8	10346353.0
2025-11-13 16:00:00	IWM	ETF	236.8	237.58	236.79	236.91	1545136.0
2025-11-13 17:00:00	IWM	ETF	236.86	236.92	236.4295	236.8	28418.0
2025-11-13 18:00:00	IWM	ETF	236.84	237.35	236.84	237.1	31498.0
2025-11-13 19:00:00	IWM	ETF	237.1	237.34	236.94	237.1	66879.0
2025-11-13 04:00:00	DIA	ETF	483.65	483.65	482.82	482.82	3978.0
2025-11-13 05:00:00	DIA	ETF	482.91	483.2	482.84	483.0	817.0

> showing 50 of 27,890 rows — these rows as CSV

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