PREVIEW / etf_1hour / 2025-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-08.parquet
  size:    705 KB
  rows:    27,570

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-08 04:00:00	SPY	ETF	510.22	513.53	510.07	512.88	139114.0
2025-04-08 05:00:00	SPY	ETF	512.5	512.98	510.61	510.67	119438.0
2025-04-08 06:00:00	SPY	ETF	510.59	512.76	510.0	511.74	275242.0
2025-04-08 07:00:00	SPY	ETF	511.94	518.3	511.19	518.22	984787.0
2025-04-08 08:00:00	SPY	ETF	518.0	519.3	509.04	517.03	1521910.0
2025-04-08 09:00:00	SPY	ETF	517.0	523.29	516.49	522.5926	15804537.0
2025-04-08 10:00:00	SPY	ETF	522.59	524.98	517.81	517.85	12423881.0
2025-04-08 11:00:00	SPY	ETF	517.86	519.27	514.0	516.77	11870750.0
2025-04-08 12:00:00	SPY	ETF	516.74	517.29	507.02	507.1442	15740306.0
2025-04-08 13:00:00	SPY	ETF	507.08	509.11	502.03	506.72	17303879.0
2025-04-08 14:00:00	SPY	ETF	506.76	507.82	501.4	501.69	11377348.0
2025-04-08 15:00:00	SPY	ETF	501.71	502.12	489.16	496.74	34390662.0
2025-04-08 16:00:00	SPY	ETF	496.75	498.64	486.2007	496.0	6968154.0
2025-04-08 17:00:00	SPY	ETF	495.95	496.5	495.5	495.85	388560.0
2025-04-08 18:00:00	SPY	ETF	495.84	496.22	489.93	492.25	806864.0
2025-04-08 19:00:00	SPY	ETF	492.15	492.15	487.75	490.5665	613610.0
2025-04-08 04:00:00	QQQ	ETF	431.25	432.0	427.73	430.3	215391.0
2025-04-08 05:00:00	QQQ	ETF	429.89	430.41	427.91	427.91	149572.0
2025-04-08 06:00:00	QQQ	ETF	427.9	430.22	427.32	429.3	122710.0
2025-04-08 07:00:00	QQQ	ETF	429.4	435.05	428.87	434.88	720726.0
2025-04-08 08:00:00	QQQ	ETF	429.94	436.0	426.74	434.18	1131315.0
2025-04-08 09:00:00	QQQ	ETF	434.03	440.969	433.8	440.57	11179506.0
2025-04-08 10:00:00	QQQ	ETF	440.53	443.1384	437.331	437.36	8648571.0
2025-04-08 11:00:00	QQQ	ETF	437.3901	438.92	433.39	435.75	7576908.0
2025-04-08 12:00:00	QQQ	ETF	435.75	436.2899	426.2005	426.38	9193143.0
2025-04-08 13:00:00	QQQ	ETF	426.3	428.78	422.2	426.53	9595266.0
2025-04-08 14:00:00	QQQ	ETF	426.67	427.43	421.06	421.06	5838185.0
2025-04-08 15:00:00	QQQ	ETF	421.1	421.61	409.79	416.24	15578944.0
2025-04-08 16:00:00	QQQ	ETF	416.24	422.5915	413.89	416.0	3441485.0
2025-04-08 17:00:00	QQQ	ETF	416.0	416.86	415.5	416.43	146404.0
2025-04-08 18:00:00	QQQ	ETF	416.26	416.44	410.0	411.98	767907.0
2025-04-08 19:00:00	QQQ	ETF	411.9	411.9	407.53	410.18	518267.0
2025-04-08 04:00:00	IWM	ETF	183.69	183.86	182.24	183.23	48233.0
2025-04-08 05:00:00	IWM	ETF	183.14	183.22	182.14	182.14	29783.0
2025-04-08 06:00:00	IWM	ETF	182.18	183.37	182.06	183.09	70899.0
2025-04-08 07:00:00	IWM	ETF	183.14	185.5	182.67	185.19	382880.0
2025-04-08 08:00:00	IWM	ETF	185.02	186.08	181.45	184.17	350821.0
2025-04-08 09:00:00	IWM	ETF	184.15	186.21	183.4	185.03	6628116.0
2025-04-08 10:00:00	IWM	ETF	185.03	185.81	182.7	182.71	5228546.0
2025-04-08 11:00:00	IWM	ETF	182.71	183.19	181.18	182.52	4548619.0
2025-04-08 12:00:00	IWM	ETF	182.47	182.68	177.52	177.53	6141279.0
2025-04-08 13:00:00	IWM	ETF	177.52	178.76	175.79	178.07	6688267.0
2025-04-08 14:00:00	IWM	ETF	178.07	178.9	175.77	175.77	4061766.0
2025-04-08 15:00:00	IWM	ETF	175.83	176.06	172.34	174.83	13437461.0
2025-04-08 16:00:00	IWM	ETF	174.83	175.62	173.75	174.15	2430257.0
2025-04-08 17:00:00	IWM	ETF	174.0	174.49	173.75	174.48	26755.0
2025-04-08 18:00:00	IWM	ETF	174.36	174.36	172.0	173.19	27720.0
2025-04-08 19:00:00	IWM	ETF	172.7	172.7	171.23	172.45	57641.0
2025-04-08 04:00:00	DIA	ETF	386.83	387.5	386.0	387.37	2715.0
2025-04-08 05:00:00	DIA	ETF	387.09	387.16	387.08	387.16	400.0

> showing 50 of 27,570 rows — these rows as CSV

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