PREVIEW / etf_1hour / 2025-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-21.parquet
  size:    651 KB
  rows:    25,088

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-21 04:00:00	SPY	ETF	598.27	600.28	598.27	600.28	22080.0
2025-01-21 05:00:00	SPY	ETF	600.44	601.0	599.9	599.9	18475.0
2025-01-21 06:00:00	SPY	ETF	599.93	600.25	599.18	599.49	21093.0
2025-01-21 07:00:00	SPY	ETF	599.48	600.22	598.81	599.969	165462.0
2025-01-21 08:00:00	SPY	ETF	599.74	600.7104	597.98	600.52	213149.0
2025-01-21 09:00:00	SPY	ETF	600.61	601.47	599.2	600.52	4063761.0
2025-01-21 10:00:00	SPY	ETF	600.5476	600.62	598.67	600.3701	3285148.0
2025-01-21 11:00:00	SPY	ETF	600.36	601.47	599.83	601.38	2268216.0
2025-01-21 12:00:00	SPY	ETF	601.35	602.49	600.93	602.445	2240145.0
2025-01-21 13:00:00	SPY	ETF	602.44	602.88	602.0725	602.62	1903389.0
2025-01-21 14:00:00	SPY	ETF	602.615	602.82	601.67	602.16	2948041.0
2025-01-21 15:00:00	SPY	ETF	602.18	602.98	601.995	602.92	6436329.0
2025-01-21 16:00:00	SPY	ETF	602.9	603.56	602.78	603.4	3686009.0
2025-01-21 17:00:00	SPY	ETF	603.43	604.06	603.2099	604.0	135840.0
2025-01-21 18:00:00	SPY	ETF	603.8	604.03	602.98	603.83	82873.0
2025-01-21 19:00:00	SPY	ETF	603.9	604.4	603.76	604.36	44117.0
2025-01-21 04:00:00	QQQ	ETF	522.5	524.43	522.5	524.43	52523.0
2025-01-21 05:00:00	QQQ	ETF	524.52	524.95	523.92	523.92	27571.0
2025-01-21 06:00:00	QQQ	ETF	523.97	524.44	523.43	523.52	47878.0
2025-01-21 07:00:00	QQQ	ETF	523.6	524.41	522.94	524.12	114598.0
2025-01-21 08:00:00	QQQ	ETF	523.43	524.93	521.349	524.82	242854.0
2025-01-21 09:00:00	QQQ	ETF	524.86	525.09	521.19	522.62	2740124.0
2025-01-21 10:00:00	QQQ	ETF	522.58	523.05	520.06	522.6758	2608987.0
2025-01-21 11:00:00	QQQ	ETF	522.63	523.79	521.72	523.6442	1391531.0
2025-01-21 12:00:00	QQQ	ETF	523.56	525.285	523.06	525.2473	1444759.0
2025-01-21 13:00:00	QQQ	ETF	525.24	525.97	524.74	525.53	1659430.0
2025-01-21 14:00:00	QQQ	ETF	525.535	525.7962	524.23	524.86	1214683.0
2025-01-21 15:00:00	QQQ	ETF	524.89	525.63	524.25	524.66	2778139.0
2025-01-21 16:00:00	QQQ	ETF	524.67	526.29	523.7978	526.04	1306342.0
2025-01-21 17:00:00	QQQ	ETF	526.04	527.82	525.81	527.6	307432.0
2025-01-21 18:00:00	QQQ	ETF	527.33	527.33	526.03	526.9511	306992.0
2025-01-21 19:00:00	QQQ	ETF	527.0	527.71	526.85	527.62	68647.0
2025-01-21 04:00:00	IWM	ETF	227.3	227.38	227.03	227.18	30394.0
2025-01-21 05:00:00	IWM	ETF	227.3	227.72	226.86	226.86	21354.0
2025-01-21 06:00:00	IWM	ETF	226.77	226.98	226.37	226.46	17689.0
2025-01-21 07:00:00	IWM	ETF	226.5	226.92	226.29	226.8	53557.0
2025-01-21 08:00:00	IWM	ETF	226.65	227.5	226.35	227.11	106248.0
2025-01-21 09:00:00	IWM	ETF	227.13	228.34	227.03	227.83	2284579.0
2025-01-21 10:00:00	IWM	ETF	227.83	228.97	226.985	228.8299	2135784.0
2025-01-21 11:00:00	IWM	ETF	228.83	229.146	228.29	228.8	1531386.0
2025-01-21 12:00:00	IWM	ETF	228.7901	229.5	228.62	229.41	1555029.0
2025-01-21 13:00:00	IWM	ETF	229.39	229.59	229.14	229.32	925498.0
2025-01-21 14:00:00	IWM	ETF	229.29	229.56	229.08	229.3	1025439.0
2025-01-21 15:00:00	IWM	ETF	229.28	229.87	229.105	229.84	3148118.0
2025-01-21 16:00:00	IWM	ETF	229.79	229.89	229.4	229.42	2391144.0
2025-01-21 17:00:00	IWM	ETF	229.49	229.78	229.4	229.4	22150.0
2025-01-21 18:00:00	IWM	ETF	229.38	229.41	228.92	229.35	24637.0
2025-01-21 19:00:00	IWM	ETF	229.4	229.56	229.33	229.47	11788.0
2025-01-21 04:00:00	DIA	ETF	436.09	436.33	436.03	436.19	9301.0
2025-01-21 05:00:00	DIA	ETF	436.62	436.74	436.47	436.47	400.0

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

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