PREVIEW / etf_1hour / 2026-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-27.parquet
  size:    754 KB
  rows:    29,039

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-01-27 04:00:00	SPY	ETF	694.45	694.66	694.2	694.23	49394.0
2026-01-27 05:00:00	SPY	ETF	694.3	694.72	694.23	694.64	98282.0
2026-01-27 06:00:00	SPY	ETF	694.6	695.08	694.42	694.87	48870.0
2026-01-27 07:00:00	SPY	ETF	694.82	694.89	694.21	694.41	125388.0
2026-01-27 08:00:00	SPY	ETF	694.83	695.3	694.13	694.2712	301352.0
2026-01-27 09:00:00	SPY	ETF	694.28	695.48	693.57	695.17	5999980.0
2026-01-27 10:00:00	SPY	ETF	695.18	696.14	694.51	696.0	6776782.0
2026-01-27 11:00:00	SPY	ETF	696.0	696.53	695.98	696.01	5227047.0
2026-01-27 12:00:00	SPY	ETF	696.01	696.14	695.38	695.425	4334749.0
2026-01-27 13:00:00	SPY	ETF	695.42	696.21	694.91	696.03	3679436.0
2026-01-27 14:00:00	SPY	ETF	696.02	696.36	695.74	696.075	3412423.0
2026-01-27 15:00:00	SPY	ETF	696.07	696.4	695.4	695.54	10969400.0
2026-01-27 16:00:00	SPY	ETF	695.55	695.85	695.24	695.6123	2988913.0
2026-01-27 17:00:00	SPY	ETF	695.64	695.85	695.43	695.75	60097.0
2026-01-27 18:00:00	SPY	ETF	695.72	696.16	695.72	695.95	32557.0
2026-01-27 19:00:00	SPY	ETF	695.96	697.28	695.9104	697.16	77349.0
2026-01-27 04:00:00	QQQ	ETF	628.91	629.18	628.56	628.72	89083.0
2026-01-27 05:00:00	QQQ	ETF	628.77	629.51	628.69	629.47	98840.0
2026-01-27 06:00:00	QQQ	ETF	629.46	630.35	629.15	630.1	109001.0
2026-01-27 07:00:00	QQQ	ETF	630.09	630.1	629.12	629.44	110980.0
2026-01-27 08:00:00	QQQ	ETF	630.02	630.27	624.991	629.09	402481.0
2026-01-27 09:00:00	QQQ	ETF	629.1	630.69	627.34	630.56	5870431.0
2026-01-27 10:00:00	QQQ	ETF	630.62	631.64	629.85	631.1703	5907207.0
2026-01-27 11:00:00	QQQ	ETF	631.18	631.83	631.035	631.18	3084639.0
2026-01-27 12:00:00	QQQ	ETF	631.19	631.49	630.51	630.775	2905575.0
2026-01-27 13:00:00	QQQ	ETF	630.78	631.62	630.22	631.46	2645031.0
2026-01-27 14:00:00	QQQ	ETF	631.46	631.69	631.07	631.52	2622215.0
2026-01-27 15:00:00	QQQ	ETF	631.51	632.0427	630.92	631.08	5864030.0
2026-01-27 16:00:00	QQQ	ETF	631.1	632.13	630.75	631.9	1271999.0
2026-01-27 17:00:00	QQQ	ETF	632.0	632.2	631.9077	632.16	47416.0
2026-01-27 18:00:00	QQQ	ETF	632.13	632.83	632.05	632.6	85447.0
2026-01-27 19:00:00	QQQ	ETF	632.6599	634.289	632.6	634.28	129544.0
2026-01-27 04:00:00	IWM	ETF	264.7	265.07	264.7	264.9	29257.0
2026-01-27 05:00:00	IWM	ETF	265.02	265.16	264.92	264.93	10600.0
2026-01-27 06:00:00	IWM	ETF	264.94	264.96	264.58	264.58	6811.0
2026-01-27 07:00:00	IWM	ETF	264.73	264.73	264.25	264.25	64683.0
2026-01-27 08:00:00	IWM	ETF	264.27	265.14	263.93	263.99	131107.0
2026-01-27 09:00:00	IWM	ETF	264.0	264.39	262.87	262.9	3065796.0
2026-01-27 10:00:00	IWM	ETF	262.91	264.51	262.66	263.7	3166978.0
2026-01-27 11:00:00	IWM	ETF	263.69	264.475	263.33	263.92	2016771.0
2026-01-27 12:00:00	IWM	ETF	263.9	264.05	263.225	263.38	2431349.0
2026-01-27 13:00:00	IWM	ETF	263.38	263.98	262.94	263.885	1995346.0
2026-01-27 14:00:00	IWM	ETF	263.88	264.475	263.735	264.4	1672860.0
2026-01-27 15:00:00	IWM	ETF	264.39	264.86	264.25	264.71	3745978.0
2026-01-27 16:00:00	IWM	ETF	264.73	264.89	264.41	264.83	1037350.0
2026-01-27 17:00:00	IWM	ETF	264.75	264.84	264.66	264.75	15164.0
2026-01-27 18:00:00	IWM	ETF	264.75	264.87	264.71	264.78	16584.0
2026-01-27 19:00:00	IWM	ETF	264.72	265.2	264.72	265.11	48249.0
2026-01-27 04:00:00	DIA	ETF	493.76	493.8	493.65	493.75	510.0
2026-01-27 05:00:00	DIA	ETF	493.83	494.04	493.61	493.61	3032.0

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

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