PREVIEW / etf_1hour / 2026-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-14.parquet
  size:    716 KB
  rows:    28,340

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-14 04:00:00	SPY	ETF	743.5	744.67	742.71	744.35	49493.0
2026-05-14 05:00:00	SPY	ETF	744.43	744.57	743.08	744.08	28634.0
2026-05-14 06:00:00	SPY	ETF	744.1	745.02	743.86	744.57	32433.0
2026-05-14 07:00:00	SPY	ETF	744.361	745.01	744.07	744.77	107884.0
2026-05-14 08:00:00	SPY	ETF	744.66	745.44	744.21	744.52	222417.0
2026-05-14 09:00:00	SPY	ETF	744.5	745.885	743.56	744.43	3662570.0
2026-05-14 10:00:00	SPY	ETF	744.42	747.53	744.28	747.18	3902044.0
2026-05-14 11:00:00	SPY	ETF	747.19	749.28	747.12	749.265	3553362.0
2026-05-14 12:00:00	SPY	ETF	749.28	749.53	747.15	747.829	3098169.0
2026-05-14 13:00:00	SPY	ETF	747.83	748.31	746.307	747.74	3837012.0
2026-05-14 14:00:00	SPY	ETF	747.72	748.38	746.65	748.3	3211722.0
2026-05-14 15:00:00	SPY	ETF	748.3	748.69	747.78	748.15	7800703.0
2026-05-14 16:00:00	SPY	ETF	748.09	748.55	746.63	747.77	3276935.0
2026-05-14 17:00:00	SPY	ETF	747.7301	747.93	747.5	747.62	78672.0
2026-05-14 18:00:00	SPY	ETF	747.78	748.13	747.5948	747.93	160691.0
2026-05-14 19:00:00	SPY	ETF	747.97	748.32	747.48	747.6515	47601.0
2026-05-14 04:00:00	QQQ	ETF	717.54	718.5	715.59	717.04	199008.0
2026-05-14 05:00:00	QQQ	ETF	717.13	717.3505	714.78	715.97	108150.0
2026-05-14 06:00:00	QQQ	ETF	715.98	717.425	715.58	716.3	98850.0
2026-05-14 07:00:00	QQQ	ETF	716.27	717.03	715.4	716.1	184016.0
2026-05-14 08:00:00	QQQ	ETF	716.15	717.01	714.67	715.02	228493.0
2026-05-14 09:00:00	QQQ	ETF	715.0	719.69	713.89	716.27	4373425.0
2026-05-14 10:00:00	QQQ	ETF	716.24	720.74	716.04	719.42	4767912.0
2026-05-14 11:00:00	QQQ	ETF	719.46	721.81	719.23	721.39	3465667.0
2026-05-14 12:00:00	QQQ	ETF	721.4	722.03	719.91	720.755	2495724.0
2026-05-14 13:00:00	QQQ	ETF	720.77	721.36	717.56	720.79	3440509.0
2026-05-14 14:00:00	QQQ	ETF	720.79	720.79	718.65	720.2722	2661045.0
2026-05-14 15:00:00	QQQ	ETF	720.27	720.91	719.56	719.73	3398642.0
2026-05-14 16:00:00	QQQ	ETF	719.76	720.94	718.53	719.75	1321121.0
2026-05-14 17:00:00	QQQ	ETF	719.7	719.79	719.51	719.71	71789.0
2026-05-14 18:00:00	QQQ	ETF	719.73	720.47	719.35	720.151	108529.0
2026-05-14 19:00:00	QQQ	ETF	720.23	720.78	719.5	719.72	64387.0
2026-05-14 04:00:00	IWM	ETF	282.43	283.1	282.09	282.85	60396.0
2026-05-14 05:00:00	IWM	ETF	282.88	282.99	282.26	282.72	30746.0
2026-05-14 06:00:00	IWM	ETF	282.75	283.27	282.61	282.94	25779.0
2026-05-14 07:00:00	IWM	ETF	282.92	283.43	282.92	283.29	65405.0
2026-05-14 08:00:00	IWM	ETF	283.2	284.5	283.17	283.77	238916.0
2026-05-14 09:00:00	IWM	ETF	283.76	284.28	281.96	282.5	2818729.0
2026-05-14 10:00:00	IWM	ETF	282.49	284.36	282.39	284.06	2530636.0
2026-05-14 11:00:00	IWM	ETF	284.08	285.04	283.98	284.945	1477900.0
2026-05-14 12:00:00	IWM	ETF	284.93	285.655	284.23	284.6633	1432846.0
2026-05-14 13:00:00	IWM	ETF	284.67	285.12	283.53	284.32	1594587.0
2026-05-14 14:00:00	IWM	ETF	284.3	285.1	283.91	284.58	1125284.0
2026-05-14 15:00:00	IWM	ETF	284.58	284.8155	284.15	284.46	2465749.0
2026-05-14 16:00:00	IWM	ETF	284.45	284.62	283.9	284.28	594240.0
2026-05-14 17:00:00	IWM	ETF	284.33	284.38	284.2	284.3	13330.0
2026-05-14 18:00:00	IWM	ETF	284.29	284.37	284.08	284.2305	18219.0
2026-05-14 19:00:00	IWM	ETF	284.17	284.25	283.65	283.65	63117.0
2026-05-14 04:00:00	DIA	ETF	498.3292	499.5	498.26	499.45	9403.0
2026-05-14 05:00:00	DIA	ETF	499.42	499.69	498.89	499.68	4456.0

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

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