PREVIEW / etf_1hour / 2026-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-10.parquet
  size:    724 KB
  rows:    28,914

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
2026-08-10 04:00:00	SPY	ETF	774.53	774.88	773.56	774.51	42635.0
2026-08-10 05:00:00	SPY	ETF	774.49	774.67	774.19	774.3	18843.0
2026-08-10 06:00:00	SPY	ETF	774.27	774.42	773.76	773.9	26441.0
2026-08-10 07:00:00	SPY	ETF	773.84	774.01	773.1928	773.52	238762.0
2026-08-10 08:00:00	SPY	ETF	773.5589	773.88	771.62	772.621	170199.0
2026-08-10 09:00:00	SPY	ETF	772.66	773.63	772.3	773.469	3025247.0
2026-08-10 10:00:00	SPY	ETF	773.42	775.05	773.39	773.515	5637177.0
2026-08-10 11:00:00	SPY	ETF	773.51	774.41	773.16	774.31	2859112.0
2026-08-10 12:00:00	SPY	ETF	774.34	774.435	771.62	772.95	3489448.0
2026-08-10 13:00:00	SPY	ETF	772.94	773.28	772.49	772.739	2067465.0
2026-08-10 14:00:00	SPY	ETF	772.73	773.33	772.32	773.19	2792188.0
2026-08-10 15:00:00	SPY	ETF	773.2	773.44	772.315	773.06	5581877.0
2026-08-10 16:00:00	SPY	ETF	773.06	773.11	772.63	773.02	1483726.0
2026-08-10 17:00:00	SPY	ETF	773.04	773.19	772.78	773.13	30976.0
2026-08-10 18:00:00	SPY	ETF	773.17	773.33	772.45	772.649	31215.0
2026-08-10 19:00:00	SPY	ETF	772.68	772.68	772.03	772.35	18929.0
2026-08-10 04:00:00	QQQ	ETF	725.52	726.6237	723.9	726.39	151504.0
2026-08-10 05:00:00	QQQ	ETF	726.48	726.74	725.61	725.61	45109.0
2026-08-10 06:00:00	QQQ	ETF	725.65	726.1	724.97	724.99	94074.0
2026-08-10 07:00:00	QQQ	ETF	724.97	725.29	723.38	723.93	260971.0
2026-08-10 08:00:00	QQQ	ETF	724.01	724.3	721.61	721.77	192575.0
2026-08-10 09:00:00	QQQ	ETF	721.75	723.25	720.34	722.45	3041528.0
2026-08-10 10:00:00	QQQ	ETF	722.44	724.67	721.75	721.78	3649454.0
2026-08-10 11:00:00	QQQ	ETF	721.79	723.56	720.83	723.32	2142238.0
2026-08-10 12:00:00	QQQ	ETF	723.325	723.645	720.57	721.76	2252398.0
2026-08-10 13:00:00	QQQ	ETF	721.78	722.54	720.91	721.28	1318399.0
2026-08-10 14:00:00	QQQ	ETF	721.26	721.88	720.69	721.835	1026723.0
2026-08-10 15:00:00	QQQ	ETF	721.83	722.14	720.33	720.805	4158702.0
2026-08-10 16:00:00	QQQ	ETF	720.81	721.53	720.73	721.3601	792772.0
2026-08-10 17:00:00	QQQ	ETF	721.28	721.4922	721.0004	721.0004	45861.0
2026-08-10 18:00:00	QQQ	ETF	721.14	721.87	720.351	720.6	56923.0
2026-08-10 19:00:00	QQQ	ETF	720.6	720.6034	719.3135	719.9628	55925.0
2026-08-10 04:00:00	IWM	ETF	301.57	301.75	301.125	301.19	44007.0
2026-08-10 05:00:00	IWM	ETF	301.1939	301.1939	300.82	300.9	5933.0
2026-08-10 06:00:00	IWM	ETF	300.85	300.89	300.61	300.61	8235.0
2026-08-10 07:00:00	IWM	ETF	300.61	301.19	300.59	301.19	39997.0
2026-08-10 08:00:00	IWM	ETF	301.23	301.37	300.41	300.46	49869.0
2026-08-10 09:00:00	IWM	ETF	300.42	301.39	300.17	300.595	2417084.0
2026-08-10 10:00:00	IWM	ETF	300.59	301.14	300.04	300.04	1797254.0
2026-08-10 11:00:00	IWM	ETF	300.05	300.5	299.855	300.26	1581785.0
2026-08-10 12:00:00	IWM	ETF	300.26	300.295	299.08	299.925	1772648.0
2026-08-10 13:00:00	IWM	ETF	299.93	299.975	299.39	299.64	1241543.0
2026-08-10 14:00:00	IWM	ETF	299.63	299.835	299.52	299.71	1224265.0
2026-08-10 15:00:00	IWM	ETF	299.715	300.09	299.63	299.98	2498017.0
2026-08-10 16:00:00	IWM	ETF	299.98	300.07	299.85	299.99	1166591.0
2026-08-10 17:00:00	IWM	ETF	299.87	300.0	299.83	299.97	3630.0
2026-08-10 18:00:00	IWM	ETF	299.96	300.04	299.59	299.68	18013.0
2026-08-10 19:00:00	IWM	ETF	299.6952	299.74	299.5	299.58	10265.0
2026-08-10 04:00:00	DIA	ETF	538.9	539.88	538.9	539.35	7096.0
2026-08-10 05:00:00	DIA	ETF	539.34	539.6	539.34	539.6	1042.0

> showing 50 of 28,914 rows — these rows as CSV

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