PREVIEW / etf_1hour / 2026-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-17.parquet
  size:    700 KB
  rows:    28,276

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-17 04:00:00	SPY	ETF	751.76	752.97	750.89	751.6498	82532.0
2026-06-17 05:00:00	SPY	ETF	751.67	751.88	750.75	750.9	31100.0
2026-06-17 06:00:00	SPY	ETF	750.85	751.51	750.27	750.8	19506.0
2026-06-17 07:00:00	SPY	ETF	750.849	751.47	750.1	750.44	109938.0
2026-06-17 08:00:00	SPY	ETF	750.48	751.38	750.45	751.29	245287.0
2026-06-17 09:00:00	SPY	ETF	751.24	751.77	749.86	749.8794	3411714.0
2026-06-17 10:00:00	SPY	ETF	749.87	752.15	747.85	749.06	5552216.0
2026-06-17 11:00:00	SPY	ETF	749.06	750.8599	748.5912	750.62	3293973.0
2026-06-17 12:00:00	SPY	ETF	750.63	751.03	749.91	750.005	2125880.0
2026-06-17 13:00:00	SPY	ETF	749.99	750.91	748.42	750.865	2938293.0
2026-06-17 14:00:00	SPY	ETF	750.82	750.8698	743.4662	746.0	13590130.0
2026-06-17 15:00:00	SPY	ETF	745.98	747.39	739.22	741.02	20647350.0
2026-06-17 16:00:00	SPY	ETF	741.03	743.23	740.7	742.82	6174702.0
2026-06-17 17:00:00	SPY	ETF	742.9	743.02	742.1739	742.88	236686.0
2026-06-17 18:00:00	SPY	ETF	742.88	744.43	742.23	744.2	175893.0
2026-06-17 19:00:00	SPY	ETF	744.25	745.65	744.14	745.6005	129044.0
2026-06-17 04:00:00	QQQ	ETF	735.12	736.66	733.5	734.715	221737.0
2026-06-17 05:00:00	QQQ	ETF	734.97	735.17	733.32	733.6	46928.0
2026-06-17 06:00:00	QQQ	ETF	733.68	734.63	732.65	733.7	135902.0
2026-06-17 07:00:00	QQQ	ETF	733.72	734.45	732.0	732.65	192307.0
2026-06-17 08:00:00	QQQ	ETF	732.65	735.01	732.65	734.32	331421.0
2026-06-17 09:00:00	QQQ	ETF	734.3766	735.57	730.88	730.94	3268442.0
2026-06-17 10:00:00	QQQ	ETF	730.93	735.68	729.56	731.23	4853730.0
2026-06-17 11:00:00	QQQ	ETF	731.24	733.6254	730.87	733.43	2117810.0
2026-06-17 12:00:00	QQQ	ETF	733.46	733.98	732.15	732.48	1322159.0
2026-06-17 13:00:00	QQQ	ETF	732.485	734.11	730.48	734.0675	2071678.0
2026-06-17 14:00:00	QQQ	ETF	734.06	735.38	724.53	729.42	9879943.0
2026-06-17 15:00:00	QQQ	ETF	729.43	731.77	720.85	722.5	10042451.0
2026-06-17 16:00:00	QQQ	ETF	722.44	726.4	722.43	725.92	1791040.0
2026-06-17 17:00:00	QQQ	ETF	725.99	726.49	722.51	726.22	231139.0
2026-06-17 18:00:00	QQQ	ETF	726.2	728.76	724.99	728.29	254990.0
2026-06-17 19:00:00	QQQ	ETF	728.29	729.93	728.06	729.93	227538.0
2026-06-17 04:00:00	IWM	ETF	292.48	293.25	291.83	292.43	46030.0
2026-06-17 05:00:00	IWM	ETF	292.41	292.91	292.31	292.33	10583.0
2026-06-17 06:00:00	IWM	ETF	292.18	292.61	292.06	292.16	8939.0
2026-06-17 07:00:00	IWM	ETF	292.1113	292.53	291.82	292.07	63617.0
2026-06-17 08:00:00	IWM	ETF	292.09	292.5047	292.09	292.34	89366.0
2026-06-17 09:00:00	IWM	ETF	292.37	294.99	292.09	293.81	2609965.0
2026-06-17 10:00:00	IWM	ETF	293.85	294.74	292.35	293.59	2855420.0
2026-06-17 11:00:00	IWM	ETF	293.6	295.5101	293.53	295.42	2111899.0
2026-06-17 12:00:00	IWM	ETF	295.42	295.605	295.0299	295.54	1149306.0
2026-06-17 13:00:00	IWM	ETF	295.54	295.76	294.9	295.71	1875157.0
2026-06-17 14:00:00	IWM	ETF	295.81	295.82	290.37	292.76	9959859.0
2026-06-17 15:00:00	IWM	ETF	292.76	293.47	288.93	289.85	9361783.0
2026-06-17 16:00:00	IWM	ETF	289.83	290.86	289.79	289.88	1321064.0
2026-06-17 17:00:00	IWM	ETF	290.84	291.1	290.3172	290.7201	33743.0
2026-06-17 18:00:00	IWM	ETF	290.73	291.71	290.51	291.57	68462.0
2026-06-17 19:00:00	IWM	ETF	291.6283	292.42	291.57	292.42	28611.0
2026-06-17 04:00:00	DIA	ETF	521.92	522.04	520.85	521.2	6527.0
2026-06-17 05:00:00	DIA	ETF	521.32	521.59	521.24	521.29	16488.0

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

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