PREVIEW / etf_1hour / 2025-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-13.parquet
  size:    715 KB
  rows:    27,453

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-13 04:00:00	SPY	ETF	661.5	663.23	658.17	662.22	177706.0
2025-10-13 05:00:00	SPY	ETF	662.21	662.4	661.58	661.7	34268.0
2025-10-13 06:00:00	SPY	ETF	661.68	662.21	661.05	661.74	103033.0
2025-10-13 07:00:00	SPY	ETF	661.64	662.18	658.91	660.28	687178.0
2025-10-13 08:00:00	SPY	ETF	661.51	663.97	659.0	660.61	655875.0
2025-10-13 09:00:00	SPY	ETF	660.59	663.0	659.8	662.8788	11609402.0
2025-10-13 10:00:00	SPY	ETF	662.87	663.23	659.95	660.215	10064655.0
2025-10-13 11:00:00	SPY	ETF	660.21	663.175	659.7679	662.97	6157646.0
2025-10-13 12:00:00	SPY	ETF	662.98	665.13	662.64	664.24	5706146.0
2025-10-13 13:00:00	SPY	ETF	664.25	664.61	662.37	663.26	3771932.0
2025-10-13 14:00:00	SPY	ETF	663.25	664.27	661.82	662.08	5360155.0
2025-10-13 15:00:00	SPY	ETF	662.09	663.65	661.68	663.05	11259675.0
2025-10-13 16:00:00	SPY	ETF	663.06	663.22	662.48	662.63	2558392.0
2025-10-13 17:00:00	SPY	ETF	662.7799	662.83	662.56	662.8	40228.0
2025-10-13 18:00:00	SPY	ETF	662.71	663.26	662.61	663.14	60555.0
2025-10-13 19:00:00	SPY	ETF	663.1	663.1	662.46	662.68	24164.0
2025-10-13 04:00:00	QQQ	ETF	598.17	601.58	598.0	600.8	313335.0
2025-10-13 05:00:00	QQQ	ETF	600.8	600.94	599.9	600.18	231542.0
2025-10-13 06:00:00	QQQ	ETF	600.14	600.86	599.7	600.26	377090.0
2025-10-13 07:00:00	QQQ	ETF	600.23	600.63	597.46	598.96	908523.0
2025-10-13 08:00:00	QQQ	ETF	594.82	602.38	594.82	598.76	1632643.0
2025-10-13 09:00:00	QQQ	ETF	598.74	601.25	597.23	601.16	8690060.0
2025-10-13 10:00:00	QQQ	ETF	601.14	601.74	597.6842	598.0396	6760670.0
2025-10-13 11:00:00	QQQ	ETF	598.06	601.47	597.74	601.255	3987717.0
2025-10-13 12:00:00	QQQ	ETF	601.29	602.77	600.71	602.58	4065682.0
2025-10-13 13:00:00	QQQ	ETF	602.6	602.83	601.1601	602.09	2756430.0
2025-10-13 14:00:00	QQQ	ETF	602.08	602.95	601.21	601.47	2433901.0
2025-10-13 15:00:00	QQQ	ETF	601.48	602.6699	601.03	602.04	5587966.0
2025-10-13 16:00:00	QQQ	ETF	602.04	602.16	601.5	601.67	1704217.0
2025-10-13 17:00:00	QQQ	ETF	601.75	601.99	601.7	601.79	17296.0
2025-10-13 18:00:00	QQQ	ETF	601.83	602.2491	601.48	602.23	41632.0
2025-10-13 19:00:00	QQQ	ETF	602.25	602.25	601.5346	601.81	62183.0
2025-10-13 04:00:00	IWM	ETF	242.23	242.36	240.54	241.88	233910.0
2025-10-13 05:00:00	IWM	ETF	241.85	241.91	241.49	241.55	74387.0
2025-10-13 06:00:00	IWM	ETF	241.52	241.92	241.42	241.73	138913.0
2025-10-13 07:00:00	IWM	ETF	241.68	242.01	240.76	241.34	323133.0
2025-10-13 08:00:00	IWM	ETF	241.26	242.65	240.8127	241.86	487902.0
2025-10-13 09:00:00	IWM	ETF	241.85	243.24	241.59	243.21	4497746.0
2025-10-13 10:00:00	IWM	ETF	243.205	243.52	241.4001	242.155	3779524.0
2025-10-13 11:00:00	IWM	ETF	242.15	243.7	241.97	243.35	2835547.0
2025-10-13 12:00:00	IWM	ETF	243.36	244.03	243.06	243.97	2765607.0
2025-10-13 13:00:00	IWM	ETF	243.97	244.09	243.38	243.85	1753697.0
2025-10-13 14:00:00	IWM	ETF	243.85	244.63	243.74	243.855	2216650.0
2025-10-13 15:00:00	IWM	ETF	243.86	244.63	243.77	244.37	4833220.0
2025-10-13 16:00:00	IWM	ETF	244.41	244.48	243.92	244.04	1908337.0
2025-10-13 17:00:00	IWM	ETF	244.13	244.24	244.0007	244.24	3496.0
2025-10-13 18:00:00	IWM	ETF	244.24	244.38	244.14	244.38	16724.0
2025-10-13 19:00:00	IWM	ETF	244.27	244.34	244.0	244.11	46722.0
2025-10-13 04:00:00	DIA	ETF	459.88	460.29	459.26	459.26	4383.0
2025-10-13 05:00:00	DIA	ETF	459.44	459.6	459.23	459.3	4814.0

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

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