PREVIEW / etf_1hour / 2025-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-22.parquet
  size:    641 KB
  rows:    24,213

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-01-22 04:00:00	SPY	ETF	604.71	605.77	604.71	605.33	14386.0
2025-01-22 05:00:00	SPY	ETF	605.3	605.53	605.09	605.47	60306.0
2025-01-22 06:00:00	SPY	ETF	605.38	605.83	605.16	605.27	51223.0
2025-01-22 07:00:00	SPY	ETF	605.31	605.94	605.23	605.6	238430.0
2025-01-22 08:00:00	SPY	ETF	605.35	606.18	604.12	606.15	198420.0
2025-01-22 09:00:00	SPY	ETF	606.17	606.57	605.36	606.4906	3842473.0
2025-01-22 10:00:00	SPY	ETF	606.5	607.08	606.0	606.5512	3656340.0
2025-01-22 11:00:00	SPY	ETF	606.55	607.78	606.26	607.65	2477544.0
2025-01-22 12:00:00	SPY	ETF	607.65	607.82	607.3	607.31	1929751.0
2025-01-22 13:00:00	SPY	ETF	607.3	607.6267	606.9412	607.04	1546073.0
2025-01-22 14:00:00	SPY	ETF	607.04	607.62	606.7801	607.6	2164252.0
2025-01-22 15:00:00	SPY	ETF	607.59	607.62	606.23	606.34	7306799.0
2025-01-22 16:00:00	SPY	ETF	606.34	606.883	605.86	606.3003	3476701.0
2025-01-22 17:00:00	SPY	ETF	606.3	606.34	606.17	606.27	55082.0
2025-01-22 18:00:00	SPY	ETF	606.23	606.3	605.86	605.9499	59518.0
2025-01-22 19:00:00	SPY	ETF	605.85	606.08	605.72	605.87	31076.0
2025-01-22 04:00:00	QQQ	ETF	528.96	529.37	528.15	528.81	63526.0
2025-01-22 05:00:00	QQQ	ETF	528.77	529.04	528.49	529.0	59741.0
2025-01-22 06:00:00	QQQ	ETF	528.89	529.3	528.8	528.86	45805.0
2025-01-22 07:00:00	QQQ	ETF	528.84	529.65	528.74	529.45	146067.0
2025-01-22 08:00:00	QQQ	ETF	529.46	529.98	527.72	529.89	292345.0
2025-01-22 09:00:00	QQQ	ETF	529.92	532.215	529.19	531.89	6205289.0
2025-01-22 10:00:00	QQQ	ETF	531.92	532.59	530.97	531.45	3066507.0
2025-01-22 11:00:00	QQQ	ETF	531.4406	533.46	531.33	533.36	2702800.0
2025-01-22 12:00:00	QQQ	ETF	533.36	533.82	532.72	532.96	2071160.0
2025-01-22 13:00:00	QQQ	ETF	532.95	533.07	531.8202	532.23	1547897.0
2025-01-22 14:00:00	QQQ	ETF	532.225	532.66	531.74	532.53	950022.0
2025-01-22 15:00:00	QQQ	ETF	532.53	532.565	531.13	531.51	2929347.0
2025-01-22 16:00:00	QQQ	ETF	531.51	531.69	530.85	531.18	1973790.0
2025-01-22 17:00:00	QQQ	ETF	531.2	531.2	530.82	530.88	37329.0
2025-01-22 18:00:00	QQQ	ETF	530.94	531.16	530.61	530.72	89215.0
2025-01-22 19:00:00	QQQ	ETF	530.73	530.84	530.2	530.34	77568.0
2025-01-22 04:00:00	IWM	ETF	229.98	230.36	229.93	229.99	27366.0
2025-01-22 05:00:00	IWM	ETF	229.91	229.99	229.7	229.7	6464.0
2025-01-22 06:00:00	IWM	ETF	229.73	230.07	229.51	229.67	8376.0
2025-01-22 07:00:00	IWM	ETF	229.69	229.89	229.5	229.52	25137.0
2025-01-22 08:00:00	IWM	ETF	229.69	230.31	229.23	229.51	65480.0
2025-01-22 09:00:00	IWM	ETF	229.48	229.85	228.78	229.05	2033495.0
2025-01-22 10:00:00	IWM	ETF	229.08	229.45	228.02	228.04	2262232.0
2025-01-22 11:00:00	IWM	ETF	228.05	228.76	227.92	228.45	1663447.0
2025-01-22 12:00:00	IWM	ETF	228.44	228.66	227.83	228.0	1398268.0
2025-01-22 13:00:00	IWM	ETF	228.01	228.7	227.86	228.41	1263948.0
2025-01-22 14:00:00	IWM	ETF	228.41	228.6914	228.19	228.55	1152718.0
2025-01-22 15:00:00	IWM	ETF	228.55	228.649	228.085	228.26	3349363.0
2025-01-22 16:00:00	IWM	ETF	228.29	228.37	228.14	228.35	1012650.0
2025-01-22 17:00:00	IWM	ETF	228.37	228.45	228.2	228.29	29277.0
2025-01-22 18:00:00	IWM	ETF	228.29	228.35	228.12	228.27	12903.0
2025-01-22 19:00:00	IWM	ETF	228.17	228.34	228.14	228.2	10833.0
2025-01-22 04:00:00	DIA	ETF	440.92	441.05	440.83	440.83	3106.0
2025-01-22 05:00:00	DIA	ETF	440.85	440.88	440.81	440.82	2387.0

> showing 50 of 24,213 rows — these rows as CSV

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