PREVIEW / etf_30min / 2025-07-07

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-07.parquet
  size:    1012 KB
  rows:    42,997

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-07 04:00:00	SPY	ETF	623.38	623.38	620.0	622.87	39724.0
2025-07-07 04:30:00	SPY	ETF	622.88	622.89	622.53	622.63	7771.0
2025-07-07 05:00:00	SPY	ETF	622.5	622.77	622.47	622.71	24181.0
2025-07-07 05:30:00	SPY	ETF	622.7	623.76	622.7	623.76	19487.0
2025-07-07 06:00:00	SPY	ETF	623.68	624.22	623.66	623.93	29908.0
2025-07-07 06:30:00	SPY	ETF	623.92	624.04	623.6	623.62	19068.0
2025-07-07 07:00:00	SPY	ETF	623.6	623.99	623.6	623.99	29361.0
2025-07-07 07:30:00	SPY	ETF	623.99	624.21	623.68	624.19	62920.0
2025-07-07 08:00:00	SPY	ETF	624.14	624.59	622.45	624.22	111876.0
2025-07-07 08:30:00	SPY	ETF	624.2	624.44	623.27	623.43	133200.0
2025-07-07 09:00:00	SPY	ETF	623.43	623.53	623.08	623.33	188181.0
2025-07-07 09:30:00	SPY	ETF	623.35	624.03	622.88	623.6526	3920446.0
2025-07-07 10:00:00	SPY	ETF	623.65	623.795	622.53	623.04	2464668.0
2025-07-07 10:30:00	SPY	ETF	623.04	623.105	621.96	622.1599	2924695.0
2025-07-07 11:00:00	SPY	ETF	622.16	622.39	621.56	622.07	2400993.0
2025-07-07 11:30:00	SPY	ETF	622.06	622.22	621.18	621.74	2257776.0
2025-07-07 12:00:00	SPY	ETF	621.75	622.29	619.241	620.575	7063601.0
2025-07-07 12:30:00	SPY	ETF	620.56	621.235	619.48	619.8006	3686960.0
2025-07-07 13:00:00	SPY	ETF	619.78	621.02	619.5912	620.19	2335370.0
2025-07-07 13:30:00	SPY	ETF	620.16	621.41	619.56	620.047	3864925.0
2025-07-07 14:00:00	SPY	ETF	620.04	620.3696	617.88	617.99	4196650.0
2025-07-07 14:30:00	SPY	ETF	617.99	620.2199	617.87	620.16	3343457.0
2025-07-07 15:00:00	SPY	ETF	620.15	620.39	619.375	619.46	3471037.0
2025-07-07 15:30:00	SPY	ETF	619.47	621.0	619.39	620.78	9680950.0
2025-07-07 16:00:00	SPY	ETF	620.77	620.81	619.86	620.02	3198478.0
2025-07-07 16:30:00	SPY	ETF	620.0	620.0199	619.08	619.52	329410.0
2025-07-07 17:00:00	SPY	ETF	619.53	619.78	619.4	619.41	46773.0
2025-07-07 17:30:00	SPY	ETF	619.4495	619.5	618.818	619.45	98259.0
2025-07-07 18:00:00	SPY	ETF	619.45	619.8	618.75	618.88	76976.0
2025-07-07 18:30:00	SPY	ETF	619.03	619.64	619.02	619.4597	27666.0
2025-07-07 19:00:00	SPY	ETF	619.43	619.9795	619.38	619.78	30643.0
2025-07-07 19:30:00	SPY	ETF	619.8716	620.04	619.75	620.0	22857.0
2025-07-07 04:00:00	QQQ	ETF	553.88	553.99	552.7	552.93	23930.0
2025-07-07 04:30:00	QQQ	ETF	552.96	553.11	552.77	552.84	18315.0
2025-07-07 05:00:00	QQQ	ETF	552.67	553.06	552.67	552.97	22222.0
2025-07-07 05:30:00	QQQ	ETF	552.98	554.02	552.96	554.02	23139.0
2025-07-07 06:00:00	QQQ	ETF	553.99	554.5	553.92	554.38	22032.0
2025-07-07 06:30:00	QQQ	ETF	554.33	554.54	553.9	553.95	16231.0
2025-07-07 07:00:00	QQQ	ETF	553.94	554.33	553.8	554.33	70635.0
2025-07-07 07:30:00	QQQ	ETF	554.33	554.5	554.0	554.48	39349.0
2025-07-07 08:00:00	QQQ	ETF	554.41	556.637	552.77	554.51	179241.0
2025-07-07 08:30:00	QQQ	ETF	554.51	554.69	553.57	553.73	112036.0
2025-07-07 09:00:00	QQQ	ETF	553.7	553.77	553.15	553.49	120608.0
2025-07-07 09:30:00	QQQ	ETF	553.52	554.34	552.49	553.6	3718053.0
2025-07-07 10:00:00	QQQ	ETF	553.59	553.97	552.56	553.38	2038213.0
2025-07-07 10:30:00	QQQ	ETF	553.37	553.41	552.05	552.335	1972570.0
2025-07-07 11:00:00	QQQ	ETF	552.33	553.01	552.19	552.95	1325642.0
2025-07-07 11:30:00	QQQ	ETF	552.94	553.33	552.42	553.13	1398732.0
2025-07-07 12:00:00	QQQ	ETF	553.12	553.94	550.8281	552.27	3855834.0
2025-07-07 12:30:00	QQQ	ETF	552.25	553.02	551.26	551.72	2198062.0

> showing 50 of 42,997 rows — these rows as CSV

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