PREVIEW / etf_1hour / 2026-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-07.parquet
  size:    727 KB
  rows:    29,012

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-05-07 04:00:00	SPY	ETF	734.3	736.13	734.0	734.6234	112363.0
2026-05-07 05:00:00	SPY	ETF	734.57	735.03	734.32	734.43	37863.0
2026-05-07 06:00:00	SPY	ETF	734.5	734.94	734.08	734.62	26387.0
2026-05-07 07:00:00	SPY	ETF	734.68	735.0	734.4	734.7875	89367.0
2026-05-07 08:00:00	SPY	ETF	734.78	735.4	734.61	735.25	185701.0
2026-05-07 09:00:00	SPY	ETF	735.28	735.33	733.55	733.94	3946215.0
2026-05-07 10:00:00	SPY	ETF	733.93	736.11	733.88	736.08	4919354.0
2026-05-07 11:00:00	SPY	ETF	736.09	736.13	733.78	733.9799	3849877.0
2026-05-07 12:00:00	SPY	ETF	733.965	734.02	731.59	732.04	5038769.0
2026-05-07 13:00:00	SPY	ETF	732.1	732.67	729.76	731.72	5600169.0
2026-05-07 14:00:00	SPY	ETF	731.77	732.2	729.75	731.14	4197713.0
2026-05-07 15:00:00	SPY	ETF	731.16	731.9	729.99	731.56	8479475.0
2026-05-07 16:00:00	SPY	ETF	731.56	732.99	730.26	730.36	3164218.0
2026-05-07 17:00:00	SPY	ETF	730.64	730.77	728.5	728.64	363878.0
2026-05-07 18:00:00	SPY	ETF	729.04	731.04	728.96	730.1	565694.0
2026-05-07 19:00:00	SPY	ETF	730.1	731.5	730.1	731.4391	46007.0
2026-05-07 04:00:00	QQQ	ETF	696.54	698.11	695.02	696.26	242279.0
2026-05-07 05:00:00	QQQ	ETF	696.11	696.87	695.68	696.01	86313.0
2026-05-07 06:00:00	QQQ	ETF	696.06	696.39	695.19	696.11	110682.0
2026-05-07 07:00:00	QQQ	ETF	696.04	696.6	695.5	696.18	222149.0
2026-05-07 08:00:00	QQQ	ETF	696.05	696.81	695.22	696.67	334350.0
2026-05-07 09:00:00	QQQ	ETF	696.65	697.85	695.54	697.27	3827030.0
2026-05-07 10:00:00	QQQ	ETF	697.27	701.24	697.24	700.83	5389635.0
2026-05-07 11:00:00	QQQ	ETF	700.825	700.865	697.11	697.365	3324870.0
2026-05-07 12:00:00	QQQ	ETF	697.36	697.45	693.79	695.2101	4908569.0
2026-05-07 13:00:00	QQQ	ETF	695.26	695.61	691.77	695.22	4644877.0
2026-05-07 14:00:00	QQQ	ETF	695.23	695.78	692.48	693.94	3863879.0
2026-05-07 15:00:00	QQQ	ETF	693.98	695.55	692.58	694.93	6387469.0
2026-05-07 16:00:00	QQQ	ETF	694.89	696.9	693.73	693.91	1315642.0
2026-05-07 17:00:00	QQQ	ETF	694.06	694.17	690.75	691.36	450529.0
2026-05-07 18:00:00	QQQ	ETF	691.5	694.54	691.36	693.2155	425212.0
2026-05-07 19:00:00	QQQ	ETF	693.1	694.7809	693.08	694.73	56019.0
2026-05-07 04:00:00	IWM	ETF	287.49	287.96	286.9	286.99	75960.0
2026-05-07 05:00:00	IWM	ETF	286.97	287.07	286.64	286.71	24797.0
2026-05-07 06:00:00	IWM	ETF	286.74	286.84	286.53	286.67	58491.0
2026-05-07 07:00:00	IWM	ETF	286.73	286.8	286.5	286.75	46800.0
2026-05-07 08:00:00	IWM	ETF	286.7	287.42	286.57	287.14	196926.0
2026-05-07 09:00:00	IWM	ETF	287.15	287.58	284.35	284.53	2989481.0
2026-05-07 10:00:00	IWM	ETF	284.53	285.79	284.28	285.735	2814272.0
2026-05-07 11:00:00	IWM	ETF	285.74	285.8101	283.9499	284.075	2135455.0
2026-05-07 12:00:00	IWM	ETF	284.09	284.15	282.25	282.51	3045617.0
2026-05-07 13:00:00	IWM	ETF	282.53	282.96	281.15	282.42	4002279.0
2026-05-07 14:00:00	IWM	ETF	282.46	282.96	281.37	281.98	2273872.0
2026-05-07 15:00:00	IWM	ETF	281.99	282.34	281.47	282.29	3820570.0
2026-05-07 16:00:00	IWM	ETF	282.28	283.29	281.8	281.83	1144616.0
2026-05-07 17:00:00	IWM	ETF	281.84	281.97	280.82	281.01	70242.0
2026-05-07 18:00:00	IWM	ETF	281.08	281.88	280.93	281.3	157485.0
2026-05-07 19:00:00	IWM	ETF	281.37	282.0735	281.36	282.0735	17213.0
2026-05-07 04:00:00	DIA	ETF	500.01	500.58	499.56	499.59	8962.0
2026-05-07 05:00:00	DIA	ETF	499.55	499.61	499.14	499.14	460.0

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

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