PREVIEW / etf_1hour / 2026-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-01.parquet
  size:    760 KB
  rows:    29,687

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-06-01 04:00:00	SPY	ETF	758.02	759.08	757.68	758.47	98424.0
2026-06-01 05:00:00	SPY	ETF	758.5	758.68	757.99	758.09	30273.0
2026-06-01 06:00:00	SPY	ETF	758.15	758.84	758.14	758.68	111929.0
2026-06-01 07:00:00	SPY	ETF	758.68	759.26	758.42	758.44	138136.0
2026-06-01 08:00:00	SPY	ETF	758.48	758.52	757.71	757.95	194625.0
2026-06-01 09:00:00	SPY	ETF	757.95	758.06	754.69	755.55	5103198.0
2026-06-01 10:00:00	SPY	ETF	755.61	756.76	755.28	755.655	4449661.0
2026-06-01 11:00:00	SPY	ETF	755.65	757.42	755.45	756.715	3795243.0
2026-06-01 12:00:00	SPY	ETF	756.7	758.04	755.871	757.95	3045972.0
2026-06-01 13:00:00	SPY	ETF	757.94	760.28	757.02	759.55	5437777.0
2026-06-01 14:00:00	SPY	ETF	759.55	759.91	759.32	759.52	2338655.0
2026-06-01 15:00:00	SPY	ETF	759.52	759.76	758.04	758.43	6541701.0
2026-06-01 16:00:00	SPY	ETF	758.43	758.84	757.7	758.0	2524926.0
2026-06-01 17:00:00	SPY	ETF	757.86	758.14	757.74	758.1	82977.0
2026-06-01 18:00:00	SPY	ETF	758.12	758.18	756.25	756.5999	103237.0
2026-06-01 19:00:00	SPY	ETF	756.6	756.93	756.31	756.58	37207.0
2026-06-01 04:00:00	QQQ	ETF	741.2	743.1	739.585	740.92	261650.0
2026-06-01 05:00:00	QQQ	ETF	740.93	741.22	739.8	739.97	104573.0
2026-06-01 06:00:00	QQQ	ETF	740.03	741.04	739.8	740.7212	133656.0
2026-06-01 07:00:00	QQQ	ETF	740.75	740.94	739.77	740.02	248075.0
2026-06-01 08:00:00	QQQ	ETF	740.05	740.8	737.757	739.67	180311.0
2026-06-01 09:00:00	QQQ	ETF	739.8	740.13	735.83	736.45	4453315.0
2026-06-01 10:00:00	QQQ	ETF	736.31	739.73	735.99	739.47	4275021.0
2026-06-01 11:00:00	QQQ	ETF	739.5	742.28	738.93	741.04	3503712.0
2026-06-01 12:00:00	QQQ	ETF	741.01	743.02	739.84	742.95	2353063.0
2026-06-01 13:00:00	QQQ	ETF	742.94	745.65	741.87	745.11	3593395.0
2026-06-01 14:00:00	QQQ	ETF	745.0991	745.18	743.77	743.97	1576884.0
2026-06-01 15:00:00	QQQ	ETF	743.95	744.53	742.34	742.69	3398923.0
2026-06-01 16:00:00	QQQ	ETF	742.7	742.74	741.2	741.62	1597545.0
2026-06-01 17:00:00	QQQ	ETF	741.61	742.14	741.44	741.94	164811.0
2026-06-01 18:00:00	QQQ	ETF	741.99	742.05	739.4055	740.0401	116366.0
2026-06-01 19:00:00	QQQ	ETF	740.05	740.48	739.67	740.28	83100.0
2026-06-01 04:00:00	IWM	ETF	289.99	291.25	289.99	290.38	58179.0
2026-06-01 05:00:00	IWM	ETF	290.48	290.51	290.2	290.42	26589.0
2026-06-01 06:00:00	IWM	ETF	290.5	290.74	290.36	290.51	22728.0
2026-06-01 07:00:00	IWM	ETF	290.53	290.6	289.83	289.94	48374.0
2026-06-01 08:00:00	IWM	ETF	289.92	290.27	289.44	289.8	121766.0
2026-06-01 09:00:00	IWM	ETF	289.82	289.95	286.91	286.92	3501777.0
2026-06-01 10:00:00	IWM	ETF	286.95	287.83	286.27	286.585	3263939.0
2026-06-01 11:00:00	IWM	ETF	286.585	289.05	286.485	288.14	2814491.0
2026-06-01 12:00:00	IWM	ETF	288.14	289.0	287.495	288.85	1780842.0
2026-06-01 13:00:00	IWM	ETF	288.855	290.61	288.46	289.996	2706608.0
2026-06-01 14:00:00	IWM	ETF	289.9999	290.32	289.66	290.07	1381036.0
2026-06-01 15:00:00	IWM	ETF	290.08	290.14	288.9101	288.98	2296090.0
2026-06-01 16:00:00	IWM	ETF	288.98	289.2	288.3	288.5	1087161.0
2026-06-01 17:00:00	IWM	ETF	288.58	288.84	288.45	288.72	56276.0
2026-06-01 18:00:00	IWM	ETF	288.59	288.6	287.82	287.84	32325.0
2026-06-01 19:00:00	IWM	ETF	288.01	288.23	287.82	287.99	21368.0
2026-06-01 04:00:00	DIA	ETF	511.2377	511.83	510.91	511.83	3907.0
2026-06-01 05:00:00	DIA	ETF	512.27	512.75	512.27	512.65	940.0

> showing 50 of 29,687 rows — these rows as CSV

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