PREVIEW / etf_30min / 2025-07-10

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-10.parquet
  size:    1002 KB
  rows:    40,920

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-10 04:00:00	SPY	ETF	622.79	623.46	622.73	623.32	29349.0
2025-07-10 04:30:00	SPY	ETF	623.38	623.53	623.16	623.41	46432.0
2025-07-10 05:00:00	SPY	ETF	623.43	623.54	622.93	623.06	10981.0
2025-07-10 05:30:00	SPY	ETF	622.94	623.39	622.92	623.24	10790.0
2025-07-10 06:00:00	SPY	ETF	623.29	623.52	623.17	623.3	8101.0
2025-07-10 06:30:00	SPY	ETF	623.27	623.75	623.27	623.61	24852.0
2025-07-10 07:00:00	SPY	ETF	623.61	624.11	623.5	624.03	44312.0
2025-07-10 07:30:00	SPY	ETF	623.96	624.49	623.96	624.3	32692.0
2025-07-10 08:00:00	SPY	ETF	623.65	624.49	622.31	623.84	119253.0
2025-07-10 08:30:00	SPY	ETF	623.89	624.12	623.4	623.63	163640.0
2025-07-10 09:00:00	SPY	ETF	623.65	624.28	623.44	624.23	150783.0
2025-07-10 09:30:00	SPY	ETF	624.2	624.4181	623.12	623.395	4603609.0
2025-07-10 10:00:00	SPY	ETF	623.395	624.26	623.01	623.7348	4179081.0
2025-07-10 10:30:00	SPY	ETF	623.77	625.1	623.7448	624.865	3225606.0
2025-07-10 11:00:00	SPY	ETF	624.86	625.575	624.83	625.52	2761450.0
2025-07-10 11:30:00	SPY	ETF	625.52	625.785	625.37	625.7	1679735.0
2025-07-10 12:00:00	SPY	ETF	625.7	625.775	625.025	625.57	2258588.0
2025-07-10 12:30:00	SPY	ETF	625.57	625.78	625.24	625.54	1557984.0
2025-07-10 13:00:00	SPY	ETF	625.54	626.23	625.53	626.1	1883466.0
2025-07-10 13:30:00	SPY	ETF	626.09	626.77	626.08	626.585	2629012.0
2025-07-10 14:00:00	SPY	ETF	626.58	626.8701	626.45	626.59	2179945.0
2025-07-10 14:30:00	SPY	ETF	626.59	626.67	626.09	626.26	2423125.0
2025-07-10 15:00:00	SPY	ETF	626.26	626.56	626.12	626.205	2674401.0
2025-07-10 15:30:00	SPY	ETF	626.2	626.675	625.21	625.84	8176657.0
2025-07-10 16:00:00	SPY	ETF	625.82	625.9026	625.27	625.4901	1863335.0
2025-07-10 16:30:00	SPY	ETF	625.49	625.87	625.46	625.51	149968.0
2025-07-10 17:00:00	SPY	ETF	625.55	625.66	625.4904	625.52	15518.0
2025-07-10 17:30:00	SPY	ETF	625.59	625.64	625.47	625.55	23476.0
2025-07-10 18:00:00	SPY	ETF	625.53	626.05	625.5	625.98	78924.0
2025-07-10 18:30:00	SPY	ETF	625.871	626.13	625.78	626.13	7664.0
2025-07-10 19:00:00	SPY	ETF	626.13	626.25	626.01	626.05	14389.0
2025-07-10 19:30:00	SPY	ETF	626.1	626.37	626.04	626.31	9992.0
2025-07-10 04:00:00	QQQ	ETF	555.58	556.09	555.49	555.91	20079.0
2025-07-10 04:30:00	QQQ	ETF	555.91	556.21	555.91	556.18	11516.0
2025-07-10 05:00:00	QQQ	ETF	556.16	556.26	555.5	555.62	15984.0
2025-07-10 05:30:00	QQQ	ETF	555.55	555.9	555.4	555.77	18906.0
2025-07-10 06:00:00	QQQ	ETF	555.67	555.98	555.67	555.84	10480.0
2025-07-10 06:30:00	QQQ	ETF	555.94	556.34	555.94	556.13	27540.0
2025-07-10 07:00:00	QQQ	ETF	556.11	556.53	556.02	556.53	13816.0
2025-07-10 07:30:00	QQQ	ETF	556.38	556.91	556.38	556.8	43502.0
2025-07-10 08:00:00	QQQ	ETF	556.16	556.8996	554.69	556.5	150466.0
2025-07-10 08:30:00	QQQ	ETF	556.45	556.74	556.0	556.3	69715.0
2025-07-10 09:00:00	QQQ	ETF	556.32	557.0	556.13	556.98	111229.0
2025-07-10 09:30:00	QQQ	ETF	556.89	557.3	553.66	554.16	3612009.0
2025-07-10 10:00:00	QQQ	ETF	554.16	554.33	552.75	553.6	3269875.0
2025-07-10 10:30:00	QQQ	ETF	553.62	554.8	553.55	554.2407	1901156.0
2025-07-10 11:00:00	QQQ	ETF	554.23	555.16	553.69	555.0594	1511932.0
2025-07-10 11:30:00	QQQ	ETF	555.06	555.695	554.805	555.685	1416646.0
2025-07-10 12:00:00	QQQ	ETF	555.68	555.69	554.235	555.3053	1738677.0
2025-07-10 12:30:00	QQQ	ETF	555.3	555.45	554.7099	554.92	993299.0

> showing 50 of 40,920 rows — these rows as CSV

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