PREVIEW / etf_1hour / 2025-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-22.parquet
  size:    658 KB
  rows:    25,403

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-04-22 04:00:00	SPY	ETF	518.71	519.54	518.1	519.2	54021.0
2025-04-22 05:00:00	SPY	ETF	519.25	519.45	518.47	518.9	38884.0
2025-04-22 06:00:00	SPY	ETF	518.77	519.2	518.49	518.84	49141.0
2025-04-22 07:00:00	SPY	ETF	518.79	519.0	517.29	517.67	229751.0
2025-04-22 08:00:00	SPY	ETF	518.83	520.86	515.9	519.4	348763.0
2025-04-22 09:00:00	SPY	ETF	519.4	522.3	519.1925	521.89	4541560.0
2025-04-22 10:00:00	SPY	ETF	521.96	524.89	521.73	524.67	5901729.0
2025-04-22 11:00:00	SPY	ETF	524.67	526.55	523.76	526.17	6323682.0
2025-04-22 12:00:00	SPY	ETF	526.2	529.305	526.2	527.5595	8233871.0
2025-04-22 13:00:00	SPY	ETF	527.57	528.97	521.76	521.85	9566596.0
2025-04-22 14:00:00	SPY	ETF	521.85	527.23	521.78	526.76	5130861.0
2025-04-22 15:00:00	SPY	ETF	526.75	527.5	524.21	526.94	10417648.0
2025-04-22 16:00:00	SPY	ETF	526.94	528.81	526.14	526.91	3788801.0
2025-04-22 17:00:00	SPY	ETF	526.8	537.83	526.8	535.48	2134746.0
2025-04-22 18:00:00	SPY	ETF	535.31	537.01	533.28	537.0	791386.0
2025-04-22 19:00:00	SPY	ETF	537.0	537.72	535.85	536.65	232750.0
2025-04-22 04:00:00	QQQ	ETF	436.72	438.19	436.56	437.82	73522.0
2025-04-22 05:00:00	QQQ	ETF	437.97	438.12	437.11	437.46	25782.0
2025-04-22 06:00:00	QQQ	ETF	437.29	437.7	436.9	437.49	22878.0
2025-04-22 07:00:00	QQQ	ETF	437.49	437.6	436.3	436.56	97825.0
2025-04-22 08:00:00	QQQ	ETF	437.3	438.85	434.68	438.5	298536.0
2025-04-22 09:00:00	QQQ	ETF	438.53	441.31	437.62	441.27	4371405.0
2025-04-22 10:00:00	QQQ	ETF	441.3	443.74	441.0	443.4175	4743597.0
2025-04-22 11:00:00	QQQ	ETF	443.4164	444.65	442.1198	444.31	4045563.0
2025-04-22 12:00:00	QQQ	ETF	444.35	447.58	444.35	446.03	4690965.0
2025-04-22 13:00:00	QQQ	ETF	446.04	447.1	440.29	440.58	6012104.0
2025-04-22 14:00:00	QQQ	ETF	440.5725	444.83	440.47	444.44	3316835.0
2025-04-22 15:00:00	QQQ	ETF	444.5	444.99	441.01	444.38	5506726.0
2025-04-22 16:00:00	QQQ	ETF	444.39	445.94	442.5536	443.7901	1604856.0
2025-04-22 17:00:00	QQQ	ETF	443.9899	454.19	443.8	452.62	1213495.0
2025-04-22 18:00:00	QQQ	ETF	452.52	453.84	450.81	453.7	729997.0
2025-04-22 19:00:00	QQQ	ETF	453.75	454.69	452.88	453.68	350528.0
2025-04-22 04:00:00	IWM	ETF	184.3	184.61	184.2	184.61	29068.0
2025-04-22 05:00:00	IWM	ETF	184.68	184.78	184.51	184.64	7900.0
2025-04-22 06:00:00	IWM	ETF	184.64	184.71	184.45	184.49	28285.0
2025-04-22 07:00:00	IWM	ETF	184.48	184.54	184.09	184.25	68087.0
2025-04-22 08:00:00	IWM	ETF	184.5	185.25	183.97	184.97	211261.0
2025-04-22 09:00:00	IWM	ETF	184.92	186.39	184.85	185.725	3107742.0
2025-04-22 10:00:00	IWM	ETF	185.74	185.8	184.55	184.86	3089947.0
2025-04-22 11:00:00	IWM	ETF	184.84	186.935	184.81	186.76	3930263.0
2025-04-22 12:00:00	IWM	ETF	186.78	188.1	186.76	187.46	2924378.0
2025-04-22 13:00:00	IWM	ETF	187.45	188.0	185.59	185.82	3540600.0
2025-04-22 14:00:00	IWM	ETF	185.835	187.84	185.82	187.73	2109529.0
2025-04-22 15:00:00	IWM	ETF	187.72	187.98	186.945	187.51	4819025.0
2025-04-22 16:00:00	IWM	ETF	187.52	188.14	187.47	187.69	1794304.0
2025-04-22 17:00:00	IWM	ETF	187.79	191.7599	187.55	190.32	480107.0
2025-04-22 18:00:00	IWM	ETF	190.32	191.85	190.11	191.84	142923.0
2025-04-22 19:00:00	IWM	ETF	191.99	192.12	191.42	191.8	142822.0
2025-04-22 04:00:00	DIA	ETF	384.5	385.18	384.47	384.76	2600.0
2025-04-22 05:00:00	DIA	ETF	384.51	384.92	384.51	384.92	300.0

> showing 50 of 25,403 rows — these rows as CSV

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