PREVIEW / etf_1hour / 2026-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-18.parquet
  size:    719 KB
  rows:    28,908

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
2026-05-18 04:00:00	SPY	ETF	735.0	737.63	733.72	737.6	111267.0
2026-05-18 05:00:00	SPY	ETF	737.7	737.76	736.56	737.02	34427.0
2026-05-18 06:00:00	SPY	ETF	737.12	737.13	735.41	735.99	38930.0
2026-05-18 07:00:00	SPY	ETF	735.95	740.0	734.84	737.44	350293.0
2026-05-18 08:00:00	SPY	ETF	737.49	741.51	737.41	740.99	507851.0
2026-05-18 09:00:00	SPY	ETF	740.94	741.415	737.56	740.57	4238189.0
2026-05-18 10:00:00	SPY	ETF	740.6	740.8	736.37	738.285	4937125.0
2026-05-18 11:00:00	SPY	ETF	738.33	739.02	735.21	736.28	3875610.0
2026-05-18 12:00:00	SPY	ETF	736.37	737.93	734.225	736.49	3484521.0
2026-05-18 13:00:00	SPY	ETF	736.49	737.42	735.94	737.03	2499319.0
2026-05-18 14:00:00	SPY	ETF	737.04	737.145	733.39	733.67	4875658.0
2026-05-18 15:00:00	SPY	ETF	733.68	738.75	733.62	738.56	9475151.0
2026-05-18 16:00:00	SPY	ETF	738.52	738.7	737.61	738.0299	2356103.0
2026-05-18 17:00:00	SPY	ETF	738.02	738.65	737.82	738.09	64836.0
2026-05-18 18:00:00	SPY	ETF	738.09	739.7	738.09	739.36	127567.0
2026-05-18 19:00:00	SPY	ETF	739.34	739.77	738.6	738.89	63321.0
2026-05-18 04:00:00	QQQ	ETF	704.58	709.31	703.3	709.24	315048.0
2026-05-18 05:00:00	QQQ	ETF	709.4	709.42	707.55	707.945	60481.0
2026-05-18 06:00:00	QQQ	ETF	708.09	708.09	705.35	706.19	204424.0
2026-05-18 07:00:00	QQQ	ETF	706.271	710.0	704.7	707.63	504964.0
2026-05-18 08:00:00	QQQ	ETF	707.65	713.5	705.01	713.32	894235.0
2026-05-18 09:00:00	QQQ	ETF	713.22	713.48	706.67	709.29	5146097.0
2026-05-18 10:00:00	QQQ	ETF	709.13	710.62	702.72	705.3	6632070.0
2026-05-18 11:00:00	QQQ	ETF	705.37	706.4	701.94	703.28	4340329.0
2026-05-18 12:00:00	QQQ	ETF	703.31	705.16	699.61	703.47	4582601.0
2026-05-18 13:00:00	QQQ	ETF	703.4	704.29	702.43	703.69	2669929.0
2026-05-18 14:00:00	QQQ	ETF	703.72	703.8426	698.85	699.5601	4295514.0
2026-05-18 15:00:00	QQQ	ETF	699.59	706.16	699.43	705.71	7090429.0
2026-05-18 16:00:00	QQQ	ETF	705.8	706.0	705.05	705.24	1315783.0
2026-05-18 17:00:00	QQQ	ETF	705.2	705.5934	705.2	705.5	30429.0
2026-05-18 18:00:00	QQQ	ETF	705.61	707.46	705.61	707.1	127831.0
2026-05-18 19:00:00	QQQ	ETF	707.1013	707.7298	706.12	706.55	76003.0
2026-05-18 04:00:00	IWM	ETF	276.73	277.17	275.68	277.12	75430.0
2026-05-18 05:00:00	IWM	ETF	277.2	277.2	276.72	277.02	14335.0
2026-05-18 06:00:00	IWM	ETF	277.03	277.05	276.17	276.45	18883.0
2026-05-18 07:00:00	IWM	ETF	276.5296	278.43	275.72	277.13	300181.0
2026-05-18 08:00:00	IWM	ETF	277.1	279.34	276.94	279.13	435416.0
2026-05-18 09:00:00	IWM	ETF	279.04	279.34	276.26	278.04	4562571.0
2026-05-18 10:00:00	IWM	ETF	278.04	278.12	275.86	277.05	3343075.0
2026-05-18 11:00:00	IWM	ETF	277.05	277.41	275.59	275.88	2872238.0
2026-05-18 12:00:00	IWM	ETF	275.88	276.76	274.92	275.815	2049566.0
2026-05-18 13:00:00	IWM	ETF	275.78	276.24	274.98	275.31	1559827.0
2026-05-18 14:00:00	IWM	ETF	275.31	275.36	273.94	274.29	1730838.0
2026-05-18 15:00:00	IWM	ETF	274.3	276.77	274.26	275.99	4512520.0
2026-05-18 16:00:00	IWM	ETF	275.97	276.08	275.74	275.96	730338.0
2026-05-18 17:00:00	IWM	ETF	275.95	275.95	275.79	275.83	35850.0
2026-05-18 18:00:00	IWM	ETF	275.89	276.7	275.89	276.36	36962.0
2026-05-18 19:00:00	IWM	ETF	276.51	276.7	276.08	276.15	14679.0
2026-05-18 04:00:00	DIA	ETF	492.445	492.74	491.0	492.74	3995.0
2026-05-18 05:00:00	DIA	ETF	492.5	492.61	492.38	492.4	470.0

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

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