PREVIEW / etf_1hour / 2026-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-16.parquet
  size:    726 KB
  rows:    28,431

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-16 04:00:00	SPY	ETF	693.93	694.49	693.86	693.86	76354.0
2026-01-16 05:00:00	SPY	ETF	694.01	694.4	693.79	694.26	40055.0
2026-01-16 06:00:00	SPY	ETF	694.27	694.45	693.0	693.4	86332.0
2026-01-16 07:00:00	SPY	ETF	693.36	693.85	692.86	693.24	115022.0
2026-01-16 08:00:00	SPY	ETF	693.27	694.65	692.9533	693.16	288592.0
2026-01-16 09:00:00	SPY	ETF	693.16	694.25	691.93	691.96	7581216.0
2026-01-16 10:00:00	SPY	ETF	691.96	692.81	690.1	691.86	13047158.0
2026-01-16 11:00:00	SPY	ETF	691.85	693.47	691.555	692.665	7727196.0
2026-01-16 12:00:00	SPY	ETF	692.65	692.9699	691.89	691.93	3594145.0
2026-01-16 13:00:00	SPY	ETF	691.94	693.25	691.82	692.64	3351458.0
2026-01-16 14:00:00	SPY	ETF	692.63	693.71	691.96	692.68	6638453.0
2026-01-16 15:00:00	SPY	ETF	692.67	692.87	691.47	691.58	12423161.0
2026-01-16 16:00:00	SPY	ETF	691.6	691.94	691.33	691.68	4333503.0
2026-01-16 17:00:00	SPY	ETF	691.6917	691.95	691.3	691.66	86405.0
2026-01-16 18:00:00	SPY	ETF	691.6584	692.0	691.3304	691.72	20484.0
2026-01-16 19:00:00	SPY	ETF	691.84	692.0	691.41	691.42	24493.0
2026-01-16 04:00:00	QQQ	ETF	624.0	624.97	624.0	624.34	103267.0
2026-01-16 05:00:00	QQQ	ETF	624.39	625.46	624.22	625.25	85404.0
2026-01-16 06:00:00	QQQ	ETF	625.3	625.69	624.6	624.73	101547.0
2026-01-16 07:00:00	QQQ	ETF	624.72	625.15	624.08	624.66	148265.0
2026-01-16 08:00:00	QQQ	ETF	624.8	625.65	621.314	624.52	485386.0
2026-01-16 09:00:00	QQQ	ETF	624.59	626.08	622.14	622.19	7684896.0
2026-01-16 10:00:00	QQQ	ETF	622.19	623.06	618.88	621.0276	12116053.0
2026-01-16 11:00:00	QQQ	ETF	621.02	622.7	620.54	621.825	6130213.0
2026-01-16 12:00:00	QQQ	ETF	621.83	621.94	620.41	620.455	3740980.0
2026-01-16 13:00:00	QQQ	ETF	620.48	622.1801	620.31	621.8	3495928.0
2026-01-16 14:00:00	QQQ	ETF	621.795	622.56	620.76	621.7964	4644842.0
2026-01-16 15:00:00	QQQ	ETF	621.8	622.12	620.97	621.04	6612936.0
2026-01-16 16:00:00	QQQ	ETF	621.05	621.44	620.73	621.0256	2384565.0
2026-01-16 17:00:00	QQQ	ETF	621.03	621.28	620.7	620.9999	60210.0
2026-01-16 18:00:00	QQQ	ETF	620.9998	621.4	620.72	621.38	29545.0
2026-01-16 19:00:00	QQQ	ETF	621.38	621.75	621.0	621.1261	35671.0
2026-01-16 04:00:00	IWM	ETF	266.51	266.71	266.51	266.57	27177.0
2026-01-16 05:00:00	IWM	ETF	266.57	266.76	266.56	266.63	14071.0
2026-01-16 06:00:00	IWM	ETF	266.59	266.74	266.18	266.18	18908.0
2026-01-16 07:00:00	IWM	ETF	266.23	266.6	265.88	265.99	56461.0
2026-01-16 08:00:00	IWM	ETF	266.66	266.7	265.58	265.75	123157.0
2026-01-16 09:00:00	IWM	ETF	265.86	266.235	264.805	265.51	3361579.0
2026-01-16 10:00:00	IWM	ETF	265.52	266.66	264.71	265.72	4376517.0
2026-01-16 11:00:00	IWM	ETF	265.72	267.0199	265.685	266.655	2956710.0
2026-01-16 12:00:00	IWM	ETF	266.66	266.72	266.385	266.54	1559165.0
2026-01-16 13:00:00	IWM	ETF	266.53	267.215	266.45	266.79	1856621.0
2026-01-16 14:00:00	IWM	ETF	266.77	267.15	266.05	266.21	2181645.0
2026-01-16 15:00:00	IWM	ETF	266.215	266.23	265.6637	265.74	4112178.0
2026-01-16 16:00:00	IWM	ETF	265.74	265.93	265.6868	265.89	1470779.0
2026-01-16 17:00:00	IWM	ETF	265.85	266.1	265.79	265.93	25165.0
2026-01-16 18:00:00	IWM	ETF	265.88	265.93	265.84	265.88	1263.0
2026-01-16 19:00:00	IWM	ETF	265.98	266.07	265.85	265.89	3217.0
2026-01-16 04:00:00	DIA	ETF	495.12	495.12	495.02	495.04	320.0
2026-01-16 05:00:00	DIA	ETF	495.0	495.0	494.91	494.91	256.0

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

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