PREVIEW / etf_1hour / 2026-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-27.parquet
  size:    717 KB
  rows:    28,505

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-07-27 04:00:00	SPY	ETF	744.23	746.11	744.1	746.02	74871.0
2026-07-27 05:00:00	SPY	ETF	746.04	746.53	745.78	746.39	19773.0
2026-07-27 06:00:00	SPY	ETF	746.35	746.53	746.0	746.3	90701.0
2026-07-27 07:00:00	SPY	ETF	746.28	746.33	744.93	745.36	157828.0
2026-07-27 08:00:00	SPY	ETF	745.53	745.65	744.62	745.4	129271.0
2026-07-27 09:00:00	SPY	ETF	745.46	745.63	741.6	741.6	3828778.0
2026-07-27 10:00:00	SPY	ETF	741.6	742.13	736.54	739.6901	7135648.0
2026-07-27 11:00:00	SPY	ETF	739.72	740.31	736.335	737.485	3440406.0
2026-07-27 12:00:00	SPY	ETF	737.4925	739.68	736.64	737.057	2635667.0
2026-07-27 13:00:00	SPY	ETF	737.07	737.85	735.87	737.8	2168945.0
2026-07-27 14:00:00	SPY	ETF	737.84	739.25	736.62	739.06	3102388.0
2026-07-27 15:00:00	SPY	ETF	739.06	739.85	738.49	739.02	6528329.0
2026-07-27 16:00:00	SPY	ETF	739.08	739.81	738.67	739.41	1688724.0
2026-07-27 17:00:00	SPY	ETF	739.4	739.5987	739.27	739.34	41553.0
2026-07-27 18:00:00	SPY	ETF	739.6	739.7	738.59	738.63	70310.0
2026-07-27 19:00:00	SPY	ETF	738.62	739.1	738.17	738.87	31058.0
2026-07-27 04:00:00	QQQ	ETF	692.23	695.52	691.9	695.22	242176.0
2026-07-27 05:00:00	QQQ	ETF	695.19	695.89	694.84	695.51	59508.0
2026-07-27 06:00:00	QQQ	ETF	695.54	695.66	695.0	695.3933	87549.0
2026-07-27 07:00:00	QQQ	ETF	695.331	695.4	693.18	693.7	208447.0
2026-07-27 08:00:00	QQQ	ETF	693.73	694.31	683.717	694.09	232265.0
2026-07-27 09:00:00	QQQ	ETF	694.14	694.4	685.6728	685.8	3973044.0
2026-07-27 10:00:00	QQQ	ETF	685.83	686.37	675.945	681.47	9407082.0
2026-07-27 11:00:00	QQQ	ETF	681.52	682.16	676.91	678.88	3854492.0
2026-07-27 12:00:00	QQQ	ETF	678.92	682.34	678.05	678.54	3440156.0
2026-07-27 13:00:00	QQQ	ETF	678.6	679.93	677.08	679.91	2408807.0
2026-07-27 14:00:00	QQQ	ETF	679.91	682.0	677.85	681.93	2538830.0
2026-07-27 15:00:00	QQQ	ETF	681.93	683.6	681.165	682.06	4416522.0
2026-07-27 16:00:00	QQQ	ETF	682.11	682.99	681.55	682.4	1055003.0
2026-07-27 17:00:00	QQQ	ETF	682.25	683.09	682.2	682.69	119759.0
2026-07-27 18:00:00	QQQ	ETF	682.77	682.95	680.4577	680.58	162017.0
2026-07-27 19:00:00	QQQ	ETF	680.63	681.65	680.0	681.2414	93685.0
2026-07-27 04:00:00	IWM	ETF	294.43	295.11	292.75	294.89	36870.0
2026-07-27 05:00:00	IWM	ETF	294.76	295.265	294.73	295.15	73049.0
2026-07-27 06:00:00	IWM	ETF	295.1	295.14	294.78	295.1	33947.0
2026-07-27 07:00:00	IWM	ETF	295.05	295.09	294.35	294.35	81087.0
2026-07-27 08:00:00	IWM	ETF	294.5	294.54	293.8	294.21	69384.0
2026-07-27 09:00:00	IWM	ETF	294.31	295.52	293.5	294.38	3094445.0
2026-07-27 10:00:00	IWM	ETF	294.4	294.49	291.1101	293.285	3273425.0
2026-07-27 11:00:00	IWM	ETF	293.3	293.32	291.36	291.6	1792557.0
2026-07-27 12:00:00	IWM	ETF	291.62	293.24	291.44	292.0	1753049.0
2026-07-27 13:00:00	IWM	ETF	292.02	292.4799	291.47	292.47	1125961.0
2026-07-27 14:00:00	IWM	ETF	292.47	292.76	291.78	292.685	1387419.0
2026-07-27 15:00:00	IWM	ETF	292.685	293.43	292.56	292.92	2916200.0
2026-07-27 16:00:00	IWM	ETF	292.93	293.33	292.84	293.02	989115.0
2026-07-27 17:00:00	IWM	ETF	293.01	293.33	292.99	293.11	10766.0
2026-07-27 18:00:00	IWM	ETF	293.16	293.16	292.8	292.85	20576.0
2026-07-27 19:00:00	IWM	ETF	292.76	292.9223	292.6699	292.8101	6588.0
2026-07-27 04:00:00	DIA	ETF	522.4	523.72	522.2	523.67	4455.0
2026-07-27 05:00:00	DIA	ETF	523.6	524.06	523.6	524.06	612.0

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

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