PREVIEW / etf_1hour / 2026-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-30.parquet
  size:    743 KB
  rows:    29,667

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-01-30 04:00:00	SPY	ETF	690.79	691.79	687.08	688.03	97358.0
2026-01-30 05:00:00	SPY	ETF	687.97	689.62	687.97	689.19	76340.0
2026-01-30 06:00:00	SPY	ETF	689.19	692.25	689.1	692.1	137009.0
2026-01-30 07:00:00	SPY	ETF	692.05	692.74	690.84	691.37	272814.0
2026-01-30 08:00:00	SPY	ETF	689.4289	692.7491	687.08	690.85	924784.0
2026-01-30 09:00:00	SPY	ETF	690.81	693.71	690.7	691.69	7730865.0
2026-01-30 10:00:00	SPY	ETF	691.67	694.21	690.89	692.12	8924173.0
2026-01-30 11:00:00	SPY	ETF	692.1201	692.69	690.255	690.67	6504545.0
2026-01-30 12:00:00	SPY	ETF	690.68	691.53	688.73	689.17	7673953.0
2026-01-30 13:00:00	SPY	ETF	689.15	692.08	687.12	691.37	7548364.0
2026-01-30 14:00:00	SPY	ETF	691.38	692.7	690.4458	690.57	8866722.0
2026-01-30 15:00:00	SPY	ETF	690.57	692.8262	689.3	691.85	18837851.0
2026-01-30 16:00:00	SPY	ETF	691.85	692.48	690.91	691.36	3807600.0
2026-01-30 17:00:00	SPY	ETF	691.26	691.5	690.95	691.16	58206.0
2026-01-30 18:00:00	SPY	ETF	691.1296	691.19	690.35	690.39	47104.0
2026-01-30 19:00:00	SPY	ETF	690.4038	690.5909	690.12	690.49	34773.0
2026-01-30 04:00:00	QQQ	ETF	624.07	625.0	621.24	622.34	161174.0
2026-01-30 05:00:00	QQQ	ETF	622.38	624.58	622.38	623.98	147017.0
2026-01-30 06:00:00	QQQ	ETF	624.02	626.85	623.99	626.58	243641.0
2026-01-30 07:00:00	QQQ	ETF	626.58	627.39	625.36	625.95	179051.0
2026-01-30 08:00:00	QQQ	ETF	627.22	627.36	621.23	625.489	615978.0
2026-01-30 09:00:00	QQQ	ETF	625.45	628.256	625.03	625.55	6847924.0
2026-01-30 10:00:00	QQQ	ETF	625.53	628.11	624.19	625.875	9168357.0
2026-01-30 11:00:00	QQQ	ETF	625.88	626.53	623.52	623.83	6053225.0
2026-01-30 12:00:00	QQQ	ETF	623.85	624.76	621.95	621.99	6597124.0
2026-01-30 13:00:00	QQQ	ETF	621.96	624.18	619.2975	623.45	7132735.0
2026-01-30 14:00:00	QQQ	ETF	623.45	624.3999	621.281	621.43	4681648.0
2026-01-30 15:00:00	QQQ	ETF	621.41	623.14	619.3203	621.81	10465772.0
2026-01-30 16:00:00	QQQ	ETF	621.85	622.58	620.5634	620.86	1933338.0
2026-01-30 17:00:00	QQQ	ETF	621.0	621.22	620.5	620.53	53116.0
2026-01-30 18:00:00	QQQ	ETF	620.6842	620.96	619.9984	619.9984	86538.0
2026-01-30 19:00:00	QQQ	ETF	620.0	620.25	619.8	620.24	61318.0
2026-01-30 04:00:00	IWM	ETF	260.6	260.92	259.02	259.56	104006.0
2026-01-30 05:00:00	IWM	ETF	259.54	260.33	259.48	260.13	84987.0
2026-01-30 06:00:00	IWM	ETF	260.12	261.59	260.12	261.59	113581.0
2026-01-30 07:00:00	IWM	ETF	261.6	261.96	261.05	261.28	105572.0
2026-01-30 08:00:00	IWM	ETF	261.38	261.9506	259.29	260.55	341517.0
2026-01-30 09:00:00	IWM	ETF	260.48	262.98	260.24	260.4	4559886.0
2026-01-30 10:00:00	IWM	ETF	260.41	261.3	259.425	260.09	6098716.0
2026-01-30 11:00:00	IWM	ETF	260.095	260.175	258.695	259.04	4067097.0
2026-01-30 12:00:00	IWM	ETF	259.04	259.755	258.27	258.94	3705375.0
2026-01-30 13:00:00	IWM	ETF	258.92	260.32	257.94	259.96	3852532.0
2026-01-30 14:00:00	IWM	ETF	259.93	261.095	259.44	259.6	5659665.0
2026-01-30 15:00:00	IWM	ETF	259.59	260.025	258.87	259.64	8425961.0
2026-01-30 16:00:00	IWM	ETF	259.65	259.92	259.31	259.75	1899649.0
2026-01-30 17:00:00	IWM	ETF	259.67	259.8986	259.58	259.67	243766.0
2026-01-30 18:00:00	IWM	ETF	259.64	259.71	259.02	259.08	27841.0
2026-01-30 19:00:00	IWM	ETF	259.2	259.2	258.66	258.99	21128.0
2026-01-30 04:00:00	DIA	ETF	487.1	487.3	485.87	486.33	18011.0
2026-01-30 05:00:00	DIA	ETF	486.42	487.08	486.22	487.08	3470.0

> showing 50 of 29,667 rows — these rows as CSV

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