PREVIEW / etf_1hour / 2025-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-14.parquet
  size:    718 KB
  rows:    27,794

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-10-14 04:00:00	SPY	ETF	659.83	659.83	656.49	658.53	123744.0
2025-10-14 05:00:00	SPY	ETF	658.59	658.9	657.23	657.44	69147.0
2025-10-14 06:00:00	SPY	ETF	657.26	657.4	654.52	655.53	210339.0
2025-10-14 07:00:00	SPY	ETF	655.66	658.0	655.49	657.7	257128.0
2025-10-14 08:00:00	SPY	ETF	655.655	662.96	654.61	656.88	645518.0
2025-10-14 09:00:00	SPY	ETF	656.8863	657.64	653.17	656.82	10135703.0
2025-10-14 10:00:00	SPY	ETF	656.8	660.32	656.49	659.745	9332433.0
2025-10-14 11:00:00	SPY	ETF	659.76	663.08	659.49	662.385	6627034.0
2025-10-14 12:00:00	SPY	ETF	662.41	665.64	661.44	664.37	6610570.0
2025-10-14 13:00:00	SPY	ETF	664.36	665.83	663.65	665.13	4377437.0
2025-10-14 14:00:00	SPY	ETF	665.15	665.37	664.452	664.9	4039748.0
2025-10-14 15:00:00	SPY	ETF	664.91	665.36	660.28	662.2	17536854.0
2025-10-14 16:00:00	SPY	ETF	662.2	662.98	660.89	662.04	2673911.0
2025-10-14 17:00:00	SPY	ETF	662.11	662.25	661.86	662.21	94441.0
2025-10-14 18:00:00	SPY	ETF	662.13	663.37	662.13	662.66	106243.0
2025-10-14 19:00:00	SPY	ETF	662.69	663.48	662.54	662.595	60196.0
2025-10-14 04:00:00	QQQ	ETF	598.5	598.83	594.08	596.51	181628.0
2025-10-14 05:00:00	QQQ	ETF	596.55	596.99	595.0	595.22	188801.0
2025-10-14 06:00:00	QQQ	ETF	595.28	595.35	592.0	593.28	339201.0
2025-10-14 07:00:00	QQQ	ETF	593.36	595.9	593.04	595.67	383644.0
2025-10-14 08:00:00	QQQ	ETF	593.365	601.85	592.04	594.74	822312.0
2025-10-14 09:00:00	QQQ	ETF	594.8	595.68	590.13	593.8	6058648.0
2025-10-14 10:00:00	QQQ	ETF	593.77	597.8199	593.34	596.52	5432730.0
2025-10-14 11:00:00	QQQ	ETF	596.56	600.07	596.39	599.27	4901219.0
2025-10-14 12:00:00	QQQ	ETF	599.29	602.69	598.25	601.355	4609513.0
2025-10-14 13:00:00	QQQ	ETF	601.33	602.44	600.535	601.49	3601294.0
2025-10-14 14:00:00	QQQ	ETF	601.53	602.14	601.08	601.485	2462782.0
2025-10-14 15:00:00	QQQ	ETF	601.48	602.16	596.37	598.05	7543175.0
2025-10-14 16:00:00	QQQ	ETF	598.05	598.8	596.6508	598.0	1884263.0
2025-10-14 17:00:00	QQQ	ETF	597.98	598.23	597.7969	598.15	56159.0
2025-10-14 18:00:00	QQQ	ETF	598.07	599.42	598.0	598.63	85347.0
2025-10-14 19:00:00	QQQ	ETF	598.54	599.4973	598.4	598.46	90537.0
2025-10-14 04:00:00	IWM	ETF	241.8	242.69	241.49	242.67	257606.0
2025-10-14 05:00:00	IWM	ETF	242.7	242.88	241.78	241.9	66494.0
2025-10-14 06:00:00	IWM	ETF	241.88	241.88	240.4	240.99	102101.0
2025-10-14 07:00:00	IWM	ETF	241.08	242.0	241.01	241.45	253023.0
2025-10-14 08:00:00	IWM	ETF	241.63	244.36	240.67	241.32	591951.0
2025-10-14 09:00:00	IWM	ETF	241.31	243.15	240.36	243.09	5128848.0
2025-10-14 10:00:00	IWM	ETF	243.06	244.82	242.63	244.31	3953762.0
2025-10-14 11:00:00	IWM	ETF	244.32	246.05	244.28	245.72	3183911.0
2025-10-14 12:00:00	IWM	ETF	245.73	247.72	245.32	247.09	3154366.0
2025-10-14 13:00:00	IWM	ETF	247.07	248.65	246.85	248.42	2949729.0
2025-10-14 14:00:00	IWM	ETF	248.45	248.95	248.305	248.855	2481072.0
2025-10-14 15:00:00	IWM	ETF	248.86	249.6	247.25	247.87	8302061.0
2025-10-14 16:00:00	IWM	ETF	247.86	248.1	247.19	247.64	1521216.0
2025-10-14 17:00:00	IWM	ETF	247.62	247.85	247.42	247.82	12838.0
2025-10-14 18:00:00	IWM	ETF	247.83	248.39	247.78	248.03	24260.0
2025-10-14 19:00:00	IWM	ETF	248.04	248.44	247.87	247.87	76652.0
2025-10-14 04:00:00	DIA	ETF	457.72	458.79	457.72	458.79	3200.0
2025-10-14 05:00:00	DIA	ETF	458.98	459.06	458.26	458.26	2147.0

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

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