PREVIEW / etf_1hour / 2026-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-05.parquet
  size:    744 KB
  rows:    29,266

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-05 04:00:00	SPY	ETF	753.11	754.31	752.32	753.56	120849.0
2026-06-05 05:00:00	SPY	ETF	753.52	755.38	753.49	754.29	77393.0
2026-06-05 06:00:00	SPY	ETF	754.33	754.87	754.28	754.35	52208.0
2026-06-05 07:00:00	SPY	ETF	754.29	754.63	753.45	753.8001	221833.0
2026-06-05 08:00:00	SPY	ETF	753.829	754.5	752.15	752.53	711011.0
2026-06-05 09:00:00	SPY	ETF	752.54	753.34	748.67	748.73	5574312.0
2026-06-05 10:00:00	SPY	ETF	748.76	750.96	748.225	749.88	6283651.0
2026-06-05 11:00:00	SPY	ETF	749.89	750.18	746.19	746.58	5223740.0
2026-06-05 12:00:00	SPY	ETF	746.5681	746.59	742.46	744.54	8101044.0
2026-06-05 13:00:00	SPY	ETF	744.54	745.295	742.81	744.67	6076685.0
2026-06-05 14:00:00	SPY	ETF	744.68	744.79	738.48	739.23	9938893.0
2026-06-05 15:00:00	SPY	ETF	739.23	739.8	735.525	737.42	18122253.0
2026-06-05 16:00:00	SPY	ETF	737.44	740.4489	733.48	734.43	5417716.0
2026-06-05 17:00:00	SPY	ETF	734.36	736.16	733.96	735.1	542864.0
2026-06-05 18:00:00	SPY	ETF	735.02	737.18	734.91	736.78	255190.0
2026-06-05 19:00:00	SPY	ETF	736.73	737.5	734.61	735.3639	170770.0
2026-06-05 04:00:00	QQQ	ETF	732.88	735.0	730.8	733.01	265047.0
2026-06-05 05:00:00	QQQ	ETF	733.08	735.4	732.86	734.03	123371.0
2026-06-05 06:00:00	QQQ	ETF	733.94	734.94	733.84	733.84	103138.0
2026-06-05 07:00:00	QQQ	ETF	733.84	733.91	732.5	732.72	272874.0
2026-06-05 08:00:00	QQQ	ETF	732.76	740.055	730.16	730.56	1299702.0
2026-06-05 09:00:00	QQQ	ETF	730.5	732.37	723.654	723.72	7479772.0
2026-06-05 10:00:00	QQQ	ETF	723.74	727.84	723.34	725.6602	7968255.0
2026-06-05 11:00:00	QQQ	ETF	725.68	726.05	719.86	720.99	6524860.0
2026-06-05 12:00:00	QQQ	ETF	720.9401	720.985	714.16	716.81	8920713.0
2026-06-05 13:00:00	QQQ	ETF	716.82	717.21	713.69	716.39	5237312.0
2026-06-05 14:00:00	QQQ	ETF	716.43	716.52	707.3	709.66	10910392.0
2026-06-05 15:00:00	QQQ	ETF	709.66	710.11	704.32	705.26	16187966.0
2026-06-05 16:00:00	QQQ	ETF	705.35	709.1	699.76	700.98	4670663.0
2026-06-05 17:00:00	QQQ	ETF	701.1	704.48	701.07	703.2	903611.0
2026-06-05 18:00:00	QQQ	ETF	703.0301	705.0	701.99	703.65	279842.0
2026-06-05 19:00:00	QQQ	ETF	703.63	703.64	700.11	700.3	164174.0
2026-06-05 04:00:00	IWM	ETF	290.16	290.7	289.67	290.23	171873.0
2026-06-05 05:00:00	IWM	ETF	290.28	291.26	290.24	290.69	27173.0
2026-06-05 06:00:00	IWM	ETF	290.69	290.96	290.6	290.67	48614.0
2026-06-05 07:00:00	IWM	ETF	290.64	290.9	290.26	290.36	76816.0
2026-06-05 08:00:00	IWM	ETF	290.31	292.01	289.18	289.31	584867.0
2026-06-05 09:00:00	IWM	ETF	289.3	289.61	285.9301	285.97	4611237.0
2026-06-05 10:00:00	IWM	ETF	285.98	287.98	285.63	287.8	4415064.0
2026-06-05 11:00:00	IWM	ETF	287.81	287.85	285.27	285.57	2263215.0
2026-06-05 12:00:00	IWM	ETF	285.57	285.58	283.29	284.57	3064896.0
2026-06-05 13:00:00	IWM	ETF	284.6	284.6	283.41	284.09	2366807.0
2026-06-05 14:00:00	IWM	ETF	284.1	284.14	281.16	281.61	3475672.0
2026-06-05 15:00:00	IWM	ETF	281.62	282.475	280.15	281.68	7103471.0
2026-06-05 16:00:00	IWM	ETF	281.65	281.67	279.54	280.1	1882946.0
2026-06-05 17:00:00	IWM	ETF	280.12	280.7	280.0	280.28	87845.0
2026-06-05 18:00:00	IWM	ETF	280.42	280.6	279.74	280.3	88730.0
2026-06-05 19:00:00	IWM	ETF	280.3	280.33	279.49	279.5	29929.0
2026-06-05 04:00:00	DIA	ETF	516.96	517.25	516.23	517.25	4568.0
2026-06-05 05:00:00	DIA	ETF	517.24	518.28	517.23	517.64	12892.0

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

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