PREVIEW / etf_1hour / 2025-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-04.parquet
  size:    727 KB
  rows:    28,640

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-04 04:00:00	SPY	ETF	535.28	535.28	533.14	533.44	63901.0
2025-04-04 05:00:00	SPY	ETF	533.53	533.85	532.07	532.88	78162.0
2025-04-04 06:00:00	SPY	ETF	533.24	533.88	520.75	521.8	1880350.0
2025-04-04 07:00:00	SPY	ETF	521.97	523.69	515.95	523.01	2434379.0
2025-04-04 08:00:00	SPY	ETF	523.01	537.0	516.0	524.82	3654714.0
2025-04-04 09:00:00	SPY	ETF	524.93	526.56	519.15	523.18	16474130.0
2025-04-04 10:00:00	SPY	ETF	523.18	523.26	510.05	515.525	20797845.0
2025-04-04 11:00:00	SPY	ETF	515.47	522.59	514.0	514.96	22032296.0
2025-04-04 12:00:00	SPY	ETF	514.98	517.4585	510.91	512.075	10284672.0
2025-04-04 13:00:00	SPY	ETF	512.08	514.64	508.325	514.57	13270556.0
2025-04-04 14:00:00	SPY	ETF	514.59	515.82	505.52	507.78	14876493.0
2025-04-04 15:00:00	SPY	ETF	507.78	513.9197	505.06	505.5	33254746.0
2025-04-04 16:00:00	SPY	ETF	505.5	514.4198	502.19	504.5	14061877.0
2025-04-04 17:00:00	SPY	ETF	504.6725	506.26	504.56	505.0799	585876.0
2025-04-04 18:00:00	SPY	ETF	504.94	505.59	504.6404	505.2	1566181.0
2025-04-04 19:00:00	SPY	ETF	504.95	505.67	504.45	505.5	138519.0
2025-04-04 04:00:00	QQQ	ETF	450.0	450.15	448.09	448.54	114220.0
2025-04-04 05:00:00	QQQ	ETF	448.57	448.7	446.95	448.15	130455.0
2025-04-04 06:00:00	QQQ	ETF	448.26	448.71	435.23	436.37	1516656.0
2025-04-04 07:00:00	QQQ	ETF	436.44	438.21	430.23	437.46	1814789.0
2025-04-04 08:00:00	QQQ	ETF	437.66	450.5	430.4784	439.54	2194190.0
2025-04-04 09:00:00	QQQ	ETF	439.55	441.0	434.48	439.09	11301209.0
2025-04-04 10:00:00	QQQ	ETF	439.05	439.19	426.1	430.93	15666381.0
2025-04-04 11:00:00	QQQ	ETF	430.91	437.92	430.21	431.54	11849798.0
2025-04-04 12:00:00	QQQ	ETF	431.53	433.88	427.4	428.43	6694892.0
2025-04-04 13:00:00	QQQ	ETF	428.45	431.23	425.25	431.17	7812330.0
2025-04-04 14:00:00	QQQ	ETF	431.2104	432.33	423.58	425.38	7844863.0
2025-04-04 15:00:00	QQQ	ETF	425.41	431.34	423.05	423.2012	14433046.0
2025-04-04 16:00:00	QQQ	ETF	423.23	424.19	419.69	422.17	4448440.0
2025-04-04 17:00:00	QQQ	ETF	422.15	423.65	422.1084	422.85	172865.0
2025-04-04 18:00:00	QQQ	ETF	422.85	422.93	422.1	422.297	65436.0
2025-04-04 19:00:00	QQQ	ETF	422.2	422.4	421.2664	422.2	105980.0
2025-04-04 04:00:00	IWM	ETF	188.23	188.23	186.52	186.71	72512.0
2025-04-04 05:00:00	IWM	ETF	186.74	187.15	186.43	186.92	135189.0
2025-04-04 06:00:00	IWM	ETF	187.01	187.22	180.83	181.26	376673.0
2025-04-04 07:00:00	IWM	ETF	181.53	182.43	178.68	181.9	1113155.0
2025-04-04 08:00:00	IWM	ETF	182.07	188.93	178.8427	182.56	1013662.0
2025-04-04 09:00:00	IWM	ETF	182.7	183.71	180.83	182.1	8957180.0
2025-04-04 10:00:00	IWM	ETF	182.09	182.22	176.67	179.48	10379686.0
2025-04-04 11:00:00	IWM	ETF	179.47	184.05	179.29	180.14	12654544.0
2025-04-04 12:00:00	IWM	ETF	180.165	181.45	178.99	179.415	5820129.0
2025-04-04 13:00:00	IWM	ETF	179.42	181.99	178.28	181.96	6248819.0
2025-04-04 14:00:00	IWM	ETF	181.97	182.63	179.39	180.05	6258506.0
2025-04-04 15:00:00	IWM	ETF	180.05	182.65	179.5	181.15	13012964.0
2025-04-04 16:00:00	IWM	ETF	181.19	181.43	179.46	180.71	2700494.0
2025-04-04 17:00:00	IWM	ETF	180.71	181.16	180.62	181.14	109651.0
2025-04-04 18:00:00	IWM	ETF	181.14	181.14	180.08	180.3	18776.0
2025-04-04 19:00:00	IWM	ETF	180.35	181.45	180.16	180.96	22753.0
2025-04-04 04:00:00	DIA	ETF	402.25	402.44	401.09	401.38	3489.0
2025-04-04 05:00:00	DIA	ETF	401.25	401.25	400.69	400.69	843.0

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

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