PREVIEW / etf_1hour / 2025-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-03-06.parquet
  size:    642 KB
  rows:    25,242

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-03-06 04:00:00	SPY	ETF	581.38	582.39	576.71	577.27	89199.0
2025-03-06 05:00:00	SPY	ETF	576.81	577.8	576.11	576.28	48035.0
2025-03-06 06:00:00	SPY	ETF	576.26	577.79	575.71	577.7	210281.0
2025-03-06 07:00:00	SPY	ETF	577.79	577.85	576.12	576.55	276318.0
2025-03-06 08:00:00	SPY	ETF	577.8	583.05	575.06	576.06	868136.0
2025-03-06 09:00:00	SPY	ETF	576.05	576.94	573.45	574.423	4854176.0
2025-03-06 10:00:00	SPY	ETF	574.41	580.06	574.085	578.71	6807080.0
2025-03-06 11:00:00	SPY	ETF	578.71	580.1736	574.42	574.5	5753469.0
2025-03-06 12:00:00	SPY	ETF	574.48	574.99	571.04	573.0699	7881968.0
2025-03-06 13:00:00	SPY	ETF	572.985	574.16	570.42	572.179	5013040.0
2025-03-06 14:00:00	SPY	ETF	572.08	574.93	570.12	570.98	8254945.0
2025-03-06 15:00:00	SPY	ETF	571.03	574.27	570.46	572.8	10406019.0
2025-03-06 16:00:00	SPY	ETF	572.8	575.17	571.89	574.2	4425476.0
2025-03-06 17:00:00	SPY	ETF	574.09	574.92	573.97	574.6	204466.0
2025-03-06 18:00:00	SPY	ETF	574.59	574.98	572.7506	574.38	552805.0
2025-03-06 19:00:00	SPY	ETF	574.55	574.97	573.77	574.37	163753.0
2025-03-06 04:00:00	QQQ	ETF	499.89	500.39	495.31	496.0	153156.0
2025-03-06 05:00:00	QQQ	ETF	495.93	496.76	495.0	495.4	118525.0
2025-03-06 06:00:00	QQQ	ETF	495.19	496.53	494.72	496.33	101745.0
2025-03-06 07:00:00	QQQ	ETF	496.38	496.49	494.76	495.15	227786.0
2025-03-06 08:00:00	QQQ	ETF	496.45	501.7	493.41	494.09	667595.0
2025-03-06 09:00:00	QQQ	ETF	494.13	495.08	491.6508	493.0	4930816.0
2025-03-06 10:00:00	QQQ	ETF	492.87	498.58	492.31	496.6	5807582.0
2025-03-06 11:00:00	QQQ	ETF	496.63	498.18	492.17	492.24	4543321.0
2025-03-06 12:00:00	QQQ	ETF	492.26	492.82	488.37	490.33	5156587.0
2025-03-06 13:00:00	QQQ	ETF	490.26	491.2	487.16	489.06	3433345.0
2025-03-06 14:00:00	QQQ	ETF	489.04	491.17	486.2	487.34	5879066.0
2025-03-06 15:00:00	QQQ	ETF	487.37	489.8696	486.8	488.33	6974108.0
2025-03-06 16:00:00	QQQ	ETF	488.33	491.29	487.96	490.34	2720183.0
2025-03-06 17:00:00	QQQ	ETF	490.39	491.52	490.2	491.42	297172.0
2025-03-06 18:00:00	QQQ	ETF	491.38	491.5	490.19	490.56	168249.0
2025-03-06 19:00:00	QQQ	ETF	490.6416	490.86	489.56	490.33	110225.0
2025-03-06 04:00:00	IWM	ETF	207.03	207.56	206.3	206.52	81878.0
2025-03-06 05:00:00	IWM	ETF	206.5	206.8	206.11	206.3	29844.0
2025-03-06 06:00:00	IWM	ETF	206.1	206.66	205.85	206.6	232827.0
2025-03-06 07:00:00	IWM	ETF	206.57	206.66	205.76	205.96	159729.0
2025-03-06 08:00:00	IWM	ETF	206.17	208.79	204.92	205.98	402829.0
2025-03-06 09:00:00	IWM	ETF	205.89	206.34	204.5043	205.15	3220457.0
2025-03-06 10:00:00	IWM	ETF	205.16	207.6	205.0	207.33	5204349.0
2025-03-06 11:00:00	IWM	ETF	207.35	208.12	205.97	205.98	3837154.0
2025-03-06 12:00:00	IWM	ETF	205.96	206.28	204.38	205.17	2956201.0
2025-03-06 13:00:00	IWM	ETF	205.12	205.72	204.185	204.66	2302688.0
2025-03-06 14:00:00	IWM	ETF	204.64	206.93	203.9	204.72	4370298.0
2025-03-06 15:00:00	IWM	ETF	204.74	206.26	204.5575	205.26	5780831.0
2025-03-06 16:00:00	IWM	ETF	205.26	206.0	205.1	205.63	2059914.0
2025-03-06 17:00:00	IWM	ETF	205.59	205.88	205.5	205.63	23892.0
2025-03-06 18:00:00	IWM	ETF	205.55	205.7906	205.42	205.6701	8920.0
2025-03-06 19:00:00	IWM	ETF	205.7	205.94	205.42	205.66	24440.0
2025-03-06 04:00:00	DIA	ETF	427.11	428.0	426.72	427.08	3110.0
2025-03-06 05:00:00	DIA	ETF	426.83	427.11	426.11	426.11	5314.0

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

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