PREVIEW / etf_1hour / 2025-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-02.parquet
  size:    669 KB
  rows:    25,480

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
2025-07-02 04:00:00	SPY	ETF	618.49	618.79	618.02	618.26	38584.0
2025-07-02 05:00:00	SPY	ETF	618.26	618.45	618.07	618.43	23983.0
2025-07-02 06:00:00	SPY	ETF	618.4	618.44	617.99	618.25	30083.0
2025-07-02 07:00:00	SPY	ETF	618.25	618.58	617.4	617.78	82984.0
2025-07-02 08:00:00	SPY	ETF	617.7325	619.68	616.35	616.72	511449.0
2025-07-02 09:00:00	SPY	ETF	616.77	617.64	616.54	617.3094	4455325.0
2025-07-02 10:00:00	SPY	ETF	617.31	619.165	617.28	618.74	8468613.0
2025-07-02 11:00:00	SPY	ETF	618.77	619.455	618.55	619.2719	5119829.0
2025-07-02 12:00:00	SPY	ETF	619.27	619.601	618.86	619.585	4025072.0
2025-07-02 13:00:00	SPY	ETF	619.58	619.72	619.12	619.4199	3554657.0
2025-07-02 14:00:00	SPY	ETF	619.42	619.94	619.23	619.855	4669786.0
2025-07-02 15:00:00	SPY	ETF	619.855	620.49	619.61	620.39	10721009.0
2025-07-02 16:00:00	SPY	ETF	620.37	620.76	619.19	620.54	2613274.0
2025-07-02 17:00:00	SPY	ETF	620.59	620.71	620.51	620.54	111100.0
2025-07-02 18:00:00	SPY	ETF	620.54	620.72	620.2	620.51	70897.0
2025-07-02 19:00:00	SPY	ETF	620.58	620.669	620.49	620.6492	23328.0
2025-07-02 20:00:00	SPY	ETF	620.62	620.62	620.62	620.62	200.0
2025-07-02 04:00:00	QQQ	ETF	547.87	548.19	547.39	547.48	50715.0
2025-07-02 05:00:00	QQQ	ETF	547.59	547.65	547.16	547.61	35496.0
2025-07-02 06:00:00	QQQ	ETF	547.57	547.7	546.67	546.95	43750.0
2025-07-02 07:00:00	QQQ	ETF	546.95	547.35	545.82	546.42	83265.0
2025-07-02 08:00:00	QQQ	ETF	547.14	549.1	544.54	545.28	404815.0
2025-07-02 09:00:00	QQQ	ETF	545.31	547.958	544.97	547.42	3791958.0
2025-07-02 10:00:00	QQQ	ETF	547.41	550.4112	547.34	549.93	5169530.0
2025-07-02 11:00:00	QQQ	ETF	549.94	550.7599	549.62	550.18	3746139.0
2025-07-02 12:00:00	QQQ	ETF	550.17	550.75	549.88	550.64	2285249.0
2025-07-02 13:00:00	QQQ	ETF	550.64	550.8	549.89	550.29	2255974.0
2025-07-02 14:00:00	QQQ	ETF	550.31	550.59	550.02	550.38	1983665.0
2025-07-02 15:00:00	QQQ	ETF	550.39	551.0	550.03	550.81	5356108.0
2025-07-02 16:00:00	QQQ	ETF	550.82	551.12	550.4	551.0	1596920.0
2025-07-02 17:00:00	QQQ	ETF	551.03	551.1	550.87	550.9	51769.0
2025-07-02 18:00:00	QQQ	ETF	550.87	551.15	550.46	550.83	59120.0
2025-07-02 19:00:00	QQQ	ETF	550.79	550.95	550.79	550.94	48614.0
2025-07-02 04:00:00	IWM	ETF	219.39	219.49	218.99	219.09	28281.0
2025-07-02 05:00:00	IWM	ETF	219.15	219.72	219.15	219.62	20880.0
2025-07-02 06:00:00	IWM	ETF	219.53	220.02	219.43	219.75	63423.0
2025-07-02 07:00:00	IWM	ETF	219.75	219.93	218.87	219.01	222646.0
2025-07-02 08:00:00	IWM	ETF	219.84	220.51	217.98	218.09	414584.0
2025-07-02 09:00:00	IWM	ETF	218.1	218.47	217.36	218.135	5049434.0
2025-07-02 10:00:00	IWM	ETF	218.13	219.75	217.94	219.72	5868644.0
2025-07-02 11:00:00	IWM	ETF	219.72	220.17	219.3	219.69	3455393.0
2025-07-02 12:00:00	IWM	ETF	219.685	220.275	219.27	219.97	2220693.0
2025-07-02 13:00:00	IWM	ETF	219.98	220.195	219.475	220.13	2558591.0
2025-07-02 14:00:00	IWM	ETF	220.13	220.84	220.065	220.52	2223318.0
2025-07-02 15:00:00	IWM	ETF	220.53	221.095	220.415	221.04	6146433.0
2025-07-02 16:00:00	IWM	ETF	221.03	221.35	220.9	221.2	1373688.0
2025-07-02 17:00:00	IWM	ETF	221.2	221.24	221.03	221.17	28171.0
2025-07-02 18:00:00	IWM	ETF	221.18	221.35	221.04	221.32	11914.0
2025-07-02 19:00:00	IWM	ETF	221.3	221.54	221.3	221.49	14587.0
2025-07-02 04:00:00	DIA	ETF	445.52	445.64	445.2	445.34	2300.0

> showing 50 of 25,480 rows — these rows as CSV

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