PREVIEW / etf_1hour / 2025-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-03-13.parquet
  size:    638 KB
  rows:    24,168

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-03-13 04:00:00	SPY	ETF	556.63	556.66	554.81	556.66	41932.0
2025-03-13 05:00:00	SPY	ETF	556.61	559.2	555.98	559.18	59583.0
2025-03-13 06:00:00	SPY	ETF	559.19	559.67	558.27	558.67	80227.0
2025-03-13 07:00:00	SPY	ETF	558.64	558.95	556.74	557.85	278561.0
2025-03-13 08:00:00	SPY	ETF	557.71	559.0	555.2	558.1	667571.0
2025-03-13 09:00:00	SPY	ETF	558.3	558.94	554.47	555.03	3513645.0
2025-03-13 10:00:00	SPY	ETF	555.02	559.105	554.45	555.98	5169677.0
2025-03-13 11:00:00	SPY	ETF	556.0	556.97	552.37	552.4898	5327547.0
2025-03-13 12:00:00	SPY	ETF	552.47	554.5762	551.36	552.595	5165431.0
2025-03-13 13:00:00	SPY	ETF	552.58	553.34	549.68	550.09	5307778.0
2025-03-13 14:00:00	SPY	ETF	550.07	554.32	549.975	553.94	5633708.0
2025-03-13 15:00:00	SPY	ETF	553.8041	554.62	550.16	551.51	10159687.0
2025-03-13 16:00:00	SPY	ETF	551.52	559.1292	551.3828	552.5016	9087902.0
2025-03-13 17:00:00	SPY	ETF	552.43	552.5	551.75	552.5	402442.0
2025-03-13 18:00:00	SPY	ETF	552.5	554.349	552.5	553.88	228238.0
2025-03-13 19:00:00	SPY	ETF	553.9	554.4799	553.74	553.89	95824.0
2025-03-13 04:00:00	QQQ	ETF	474.28	474.55	472.31	474.23	115597.0
2025-03-13 05:00:00	QQQ	ETF	474.24	477.05	473.54	477.02	114348.0
2025-03-13 06:00:00	QQQ	ETF	477.03	477.57	475.95	476.27	133802.0
2025-03-13 07:00:00	QQQ	ETF	476.25	476.66	474.31	475.2	220515.0
2025-03-13 08:00:00	QQQ	ETF	475.19	477.258	472.11	475.77	606129.0
2025-03-13 09:00:00	QQQ	ETF	475.85	476.6	470.56	471.22	3632431.0
2025-03-13 10:00:00	QQQ	ETF	471.13	476.15	470.17	472.6	4924377.0
2025-03-13 11:00:00	QQQ	ETF	472.65	473.87	469.0602	469.5	4052611.0
2025-03-13 12:00:00	QQQ	ETF	469.52	471.81	468.17	469.273	3515278.0
2025-03-13 13:00:00	QQQ	ETF	469.27	469.89	466.43	466.94	3048613.0
2025-03-13 14:00:00	QQQ	ETF	466.92	471.46	466.84	471.13	3353818.0
2025-03-13 15:00:00	QQQ	ETF	471.1	471.93	466.78	468.39	5314551.0
2025-03-13 16:00:00	QQQ	ETF	468.39	470.22	468.2	469.4	2094996.0
2025-03-13 17:00:00	QQQ	ETF	469.4	469.4	468.8036	469.1709	80642.0
2025-03-13 18:00:00	QQQ	ETF	469.45	471.49	469.45	471.01	234951.0
2025-03-13 19:00:00	QQQ	ETF	471.06	471.59	470.77	470.94	125277.0
2025-03-13 04:00:00	IWM	ETF	199.77	200.44	199.59	200.44	10678.0
2025-03-13 05:00:00	IWM	ETF	200.49	201.15	200.25	201.15	9411.0
2025-03-13 06:00:00	IWM	ETF	201.26	201.38	200.93	201.08	33733.0
2025-03-13 07:00:00	IWM	ETF	201.1	201.2	200.39	200.77	171697.0
2025-03-13 08:00:00	IWM	ETF	200.9	201.32	199.71	201.01	358380.0
2025-03-13 09:00:00	IWM	ETF	201.07	202.025	199.84	199.92	3185369.0
2025-03-13 10:00:00	IWM	ETF	199.92	201.44	199.5853	199.76	3580937.0
2025-03-13 11:00:00	IWM	ETF	199.77	200.12	198.36	198.44	3367376.0
2025-03-13 12:00:00	IWM	ETF	198.43	199.42	198.22	198.65	3015978.0
2025-03-13 13:00:00	IWM	ETF	198.64	198.86	197.0	197.065	2544449.0
2025-03-13 14:00:00	IWM	ETF	197.03	198.98	197.0	198.88	2657174.0
2025-03-13 15:00:00	IWM	ETF	198.87	199.23	197.84	198.08	4189023.0
2025-03-13 16:00:00	IWM	ETF	198.1	198.64	198.07	198.54	1161335.0
2025-03-13 17:00:00	IWM	ETF	198.56	198.58	198.1	198.39	309504.0
2025-03-13 18:00:00	IWM	ETF	198.59	199.42	198.59	199.32	66840.0
2025-03-13 19:00:00	IWM	ETF	199.35	199.57	199.2	199.33	100700.0
2025-03-13 04:00:00	DIA	ETF	412.2	412.57	411.76	412.57	2451.0
2025-03-13 05:00:00	DIA	ETF	413.02	414.09	412.58	414.01	1950.0

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

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