PREVIEW / etf_1hour / 2026-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-14.parquet
  size:    748 KB
  rows:    29,891

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-04-14 04:00:00	SPY	ETF	686.8	687.92	685.95	687.82	63819.0
2026-04-14 05:00:00	SPY	ETF	687.85	688.14	687.22	687.25	50761.0
2026-04-14 06:00:00	SPY	ETF	687.25	687.62	686.76	687.06	168432.0
2026-04-14 07:00:00	SPY	ETF	687.05	688.55	686.78	688.22	303485.0
2026-04-14 08:00:00	SPY	ETF	687.92	688.86	687.57	687.79	438981.0
2026-04-14 09:00:00	SPY	ETF	687.76	689.965	687.65	689.53	6002962.0
2026-04-14 10:00:00	SPY	ETF	689.52	691.68	689.43	691.605	7069070.0
2026-04-14 11:00:00	SPY	ETF	691.61	693.3	690.9	692.93	6107581.0
2026-04-14 12:00:00	SPY	ETF	692.92	693.72	692.78	692.89	5828405.0
2026-04-14 13:00:00	SPY	ETF	692.885	694.1	692.835	693.67	4197476.0
2026-04-14 14:00:00	SPY	ETF	693.67	693.935	692.13	692.63	5230306.0
2026-04-14 15:00:00	SPY	ETF	692.63	694.58	692.629	694.24	8059900.0
2026-04-14 16:00:00	SPY	ETF	694.24	694.5	693.85	694.13	5215055.0
2026-04-14 17:00:00	SPY	ETF	694.13	694.32	694.01	694.025	93608.0
2026-04-14 18:00:00	SPY	ETF	694.04	694.609	694.0	694.35	76262.0
2026-04-14 19:00:00	SPY	ETF	694.35	695.12	694.286	694.72	126419.0
2026-04-14 20:00:00	SPY	ETF	694.7	694.73	694.6	694.6	5819.0
2026-04-14 04:00:00	QQQ	ETF	618.45	620.41	618.0	620.3	206407.0
2026-04-14 05:00:00	QQQ	ETF	620.31	620.65	619.67	619.74	118204.0
2026-04-14 06:00:00	QQQ	ETF	619.78	620.21	619.4	619.66	87209.0
2026-04-14 07:00:00	QQQ	ETF	619.553	621.14	619.35	620.75	227128.0
2026-04-14 08:00:00	QQQ	ETF	620.6	621.71	616.927	620.63	484288.0
2026-04-14 09:00:00	QQQ	ETF	620.601	622.76	619.99	621.83	5773016.0
2026-04-14 10:00:00	QQQ	ETF	621.84	624.11	621.54	623.9	5144118.0
2026-04-14 11:00:00	QQQ	ETF	623.89	626.11	622.76	625.53	6385473.0
2026-04-14 12:00:00	QQQ	ETF	625.54	626.96	625.38	626.29	3785910.0
2026-04-14 13:00:00	QQQ	ETF	626.29	627.7	626.22	627.385	3330010.0
2026-04-14 14:00:00	QQQ	ETF	627.39	627.58	625.68	626.325	4191846.0
2026-04-14 15:00:00	QQQ	ETF	626.325	628.355	626.3	628.34	5830793.0
2026-04-14 16:00:00	QQQ	ETF	628.34	628.6	627.86	628.3	3159129.0
2026-04-14 17:00:00	QQQ	ETF	628.3	628.6	628.05	628.219	134262.0
2026-04-14 18:00:00	QQQ	ETF	628.22	628.8	628.0	628.4	173419.0
2026-04-14 19:00:00	QQQ	ETF	628.46	629.373	628.38	629.03	117037.0
2026-04-14 20:00:00	QQQ	ETF	629.06	629.06	628.92	628.92	1530.0
2026-04-14 04:00:00	IWM	ETF	266.07	266.59	265.45	266.51	67414.0
2026-04-14 05:00:00	IWM	ETF	266.53	266.67	266.19	266.23	22023.0
2026-04-14 06:00:00	IWM	ETF	266.26	266.36	265.96	266.2	115348.0
2026-04-14 07:00:00	IWM	ETF	266.17	267.37	266.05	267.26	168711.0
2026-04-14 08:00:00	IWM	ETF	267.12	267.62	266.79	267.01	195157.0
2026-04-14 09:00:00	IWM	ETF	267.09	267.62	266.28	267.52	2877705.0
2026-04-14 10:00:00	IWM	ETF	267.52	269.04	267.3	269.0	2300060.0
2026-04-14 11:00:00	IWM	ETF	269.0	269.42	268.17	269.04	2158061.0
2026-04-14 12:00:00	IWM	ETF	269.04	269.06	268.295	268.3	1003690.0
2026-04-14 13:00:00	IWM	ETF	268.29	268.915	268.26	268.31	1169901.0
2026-04-14 14:00:00	IWM	ETF	268.305	268.443	267.69	268.24	1948648.0
2026-04-14 15:00:00	IWM	ETF	268.24	268.91	268.24	268.63	2940777.0
2026-04-14 16:00:00	IWM	ETF	268.635	268.77	268.4	268.69	1596407.0
2026-04-14 17:00:00	IWM	ETF	268.73	268.77	268.57	268.71	20096.0
2026-04-14 18:00:00	IWM	ETF	268.62	268.75	268.48	268.65	39778.0
2026-04-14 19:00:00	IWM	ETF	268.63	268.98	268.63	268.75	33085.0

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

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