PREVIEW / etf_30min / 2025-09-03

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-03.parquet
  size:    1.0 MB
  rows:    42,120

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-09-03 04:00:00	SPY	ETF	641.97	643.18	641.97	643.02	26991.0
2025-09-03 04:30:00	SPY	ETF	642.97	642.97	642.61	642.89	29073.0
2025-09-03 05:00:00	SPY	ETF	642.99	643.13	642.5	643.13	18769.0
2025-09-03 05:30:00	SPY	ETF	643.12	643.5	642.96	643.27	26120.0
2025-09-03 06:00:00	SPY	ETF	643.35	643.38	643.06	643.35	9618.0
2025-09-03 06:30:00	SPY	ETF	643.38	643.62	643.21	643.5	75397.0
2025-09-03 07:00:00	SPY	ETF	643.47	643.75	643.18	643.18	77412.0
2025-09-03 07:30:00	SPY	ETF	643.19	643.6	642.62	642.7	132151.0
2025-09-03 08:00:00	SPY	ETF	642.76	643.75	640.5	643.02	281770.0
2025-09-03 08:30:00	SPY	ETF	642.98	642.98	642.21	642.39	303845.0
2025-09-03 09:00:00	SPY	ETF	642.39	643.03	642.29	642.7	212640.0
2025-09-03 09:30:00	SPY	ETF	642.65	643.23	641.83	641.94	6878803.0
2025-09-03 10:00:00	SPY	ETF	642.0	643.2198	641.59	642.3612	4339514.0
2025-09-03 10:30:00	SPY	ETF	642.36	644.16	642.34	643.97	3434825.0
2025-09-03 11:00:00	SPY	ETF	643.98	644.21	642.29	642.43	3138626.0
2025-09-03 11:30:00	SPY	ETF	642.43	642.97	642.12	642.375	2606063.0
2025-09-03 12:00:00	SPY	ETF	642.37	643.125	641.995	642.43	1962575.0
2025-09-03 12:30:00	SPY	ETF	642.44	642.52	641.43	641.82	2340833.0
2025-09-03 13:00:00	SPY	ETF	641.82	642.85	641.82	642.27	1825953.0
2025-09-03 13:30:00	SPY	ETF	642.26	642.43	640.625	640.978	2754012.0
2025-09-03 14:00:00	SPY	ETF	640.98	641.29	640.54	641.13	2363120.0
2025-09-03 14:30:00	SPY	ETF	641.11	641.28	640.46	640.885	2473512.0
2025-09-03 15:00:00	SPY	ETF	640.88	641.2	640.56	641.02	2401682.0
2025-09-03 15:30:00	SPY	ETF	641.04	643.73	641.01	643.64	10782267.0
2025-09-03 16:00:00	SPY	ETF	643.64	643.98	643.56	643.9101	3201116.0
2025-09-03 16:30:00	SPY	ETF	643.94	644.05	643.78	643.79	160522.0
2025-09-03 17:00:00	SPY	ETF	643.76	643.79	643.7	643.7497	54316.0
2025-09-03 17:30:00	SPY	ETF	643.73	643.79	643.7	643.73	10100.0
2025-09-03 18:00:00	SPY	ETF	643.74	643.74	643.4	643.41	36199.0
2025-09-03 18:30:00	SPY	ETF	643.48	643.49	643.32	643.32	11457.0
2025-09-03 19:00:00	SPY	ETF	643.42	643.709	643.41	643.57	9201.0
2025-09-03 19:30:00	SPY	ETF	643.41	643.47	643.28	643.38	12238.0
2025-09-03 04:00:00	QQQ	ETF	568.13	569.44	567.93	569.2	75941.0
2025-09-03 04:30:00	QQQ	ETF	569.14	569.19	568.7	569.18	19965.0
2025-09-03 05:00:00	QQQ	ETF	569.29	569.4	568.71	569.4	19788.0
2025-09-03 05:30:00	QQQ	ETF	569.36	569.75	569.12	569.62	19708.0
2025-09-03 06:00:00	QQQ	ETF	569.61	569.7	569.29	569.67	15155.0
2025-09-03 06:30:00	QQQ	ETF	569.68	569.84	569.36	569.71	53771.0
2025-09-03 07:00:00	QQQ	ETF	569.69	570.08	569.32	569.32	86346.0
2025-09-03 07:30:00	QQQ	ETF	569.3	569.9	568.92	569.1	178913.0
2025-09-03 08:00:00	QQQ	ETF	569.14	570.0403	566.044	569.5899	191418.0
2025-09-03 08:30:00	QQQ	ETF	569.59	569.591	568.72	569.27	191199.0
2025-09-03 09:00:00	QQQ	ETF	569.27	570.06	569.1	569.33	230933.0
2025-09-03 09:30:00	QQQ	ETF	569.29	569.6	567.98	568.28	5266877.0
2025-09-03 10:00:00	QQQ	ETF	568.27	570.41	568.06	569.51	4077909.0
2025-09-03 10:30:00	QQQ	ETF	569.51	571.695	569.49	571.32	2880333.0
2025-09-03 11:00:00	QQQ	ETF	571.31	571.49	569.19	569.28	2631397.0
2025-09-03 11:30:00	QQQ	ETF	569.26	569.84	568.78	569.0866	2881700.0
2025-09-03 12:00:00	QQQ	ETF	569.07	570.2436	568.75	569.5	2136317.0
2025-09-03 12:30:00	QQQ	ETF	569.52	569.63	568.49	568.96	1651703.0

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

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