PREVIEW / etf_30min / 2025-08-08

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-08.parquet
  size:    998 KB
  rows:    40,196

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-08-08 04:00:00	SPY	ETF	633.56	634.06	633.51	633.97	22079.0
2025-08-08 04:30:00	SPY	ETF	633.93	634.08	633.73	633.87	4820.0
2025-08-08 05:00:00	SPY	ETF	633.83	634.32	633.82	634.16	10891.0
2025-08-08 05:30:00	SPY	ETF	634.12	634.23	634.0	634.16	3142.0
2025-08-08 06:00:00	SPY	ETF	634.24	634.48	634.2	634.26	7689.0
2025-08-08 06:30:00	SPY	ETF	634.27	634.48	634.25	634.38	5755.0
2025-08-08 07:00:00	SPY	ETF	634.37	634.72	634.24	634.52	47237.0
2025-08-08 07:30:00	SPY	ETF	634.511	634.73	634.4	634.66	144313.0
2025-08-08 08:00:00	SPY	ETF	634.26	634.74	633.0	633.8	161264.0
2025-08-08 08:30:00	SPY	ETF	633.83	634.07	633.62	633.74	76653.0
2025-08-08 09:00:00	SPY	ETF	633.75	634.13	631.3	634.09	102672.0
2025-08-08 09:30:00	SPY	ETF	634.07	635.9	633.74	635.8492	5529363.0
2025-08-08 10:00:00	SPY	ETF	635.85	636.78	635.755	636.44	4287963.0
2025-08-08 10:30:00	SPY	ETF	636.43	637.04	635.7	635.8028	3193015.0
2025-08-08 11:00:00	SPY	ETF	635.81	636.48	635.57	636.01	2518652.0
2025-08-08 11:30:00	SPY	ETF	636.0	636.445	634.86	636.36	2885412.0
2025-08-08 12:00:00	SPY	ETF	636.35	637.36	636.28	636.875	2329996.0
2025-08-08 12:30:00	SPY	ETF	636.88	637.12	636.44	636.55	1775690.0
2025-08-08 13:00:00	SPY	ETF	636.56	636.85	636.125	636.395	1794833.0
2025-08-08 13:30:00	SPY	ETF	636.3913	637.33	636.38	637.19	1533542.0
2025-08-08 14:00:00	SPY	ETF	637.228	637.645	636.94	637.22	2029533.0
2025-08-08 14:30:00	SPY	ETF	637.22	637.515	637.21	637.26	2227603.0
2025-08-08 15:00:00	SPY	ETF	637.26	637.625	637.04	637.26	2856113.0
2025-08-08 15:30:00	SPY	ETF	637.25	637.27	636.05	637.14	7769098.0
2025-08-08 16:00:00	SPY	ETF	637.12	638.29	632.1468	638.1302	4256342.0
2025-08-08 16:30:00	SPY	ETF	638.13	638.3	637.91	638.22	201637.0
2025-08-08 17:00:00	SPY	ETF	638.2	638.21	638.01	638.01	30028.0
2025-08-08 17:30:00	SPY	ETF	638.02	638.28	638.02	638.16	21095.0
2025-08-08 18:00:00	SPY	ETF	638.17	638.38	638.17	638.37	67848.0
2025-08-08 18:30:00	SPY	ETF	638.37	638.6	638.37	638.48	37007.0
2025-08-08 19:00:00	SPY	ETF	638.44	638.48	638.3501	638.358	12581.0
2025-08-08 19:30:00	SPY	ETF	638.37	638.6	638.37	638.6	22099.0
2025-08-08 04:00:00	QQQ	ETF	573.0	573.0	570.15	570.75	13818.0
2025-08-08 04:30:00	QQQ	ETF	570.8	570.82	570.57	570.78	7309.0
2025-08-08 05:00:00	QQQ	ETF	570.84	571.31	570.73	571.1	5100.0
2025-08-08 05:30:00	QQQ	ETF	571.06	571.13	570.93	570.94	6320.0
2025-08-08 06:00:00	QQQ	ETF	571.01	571.25	570.96	571.02	10333.0
2025-08-08 06:30:00	QQQ	ETF	571.0	571.25	571.0	571.04	7967.0
2025-08-08 07:00:00	QQQ	ETF	571.09	571.39	570.95	571.2	24452.0
2025-08-08 07:30:00	QQQ	ETF	571.21	571.42	571.21	571.27	26285.0
2025-08-08 08:00:00	QQQ	ETF	571.0	571.41	568.814	570.14	159389.0
2025-08-08 08:30:00	QQQ	ETF	570.1798	570.57	569.91	570.22	75308.0
2025-08-08 09:00:00	QQQ	ETF	570.29	570.54	569.98	570.43	42208.0
2025-08-08 09:30:00	QQQ	ETF	570.43	572.98	570.15	572.835	3413255.0
2025-08-08 10:00:00	QQQ	ETF	572.85	573.8	572.43	573.62	2746028.0
2025-08-08 10:30:00	QQQ	ETF	573.61	574.26	572.88	573.0594	2477053.0
2025-08-08 11:00:00	QQQ	ETF	573.07	573.77	572.86	573.39	1484961.0
2025-08-08 11:30:00	QQQ	ETF	573.37	573.75	572.11	573.74	1663852.0
2025-08-08 12:00:00	QQQ	ETF	573.74	574.34	573.6	574.0	1283478.0
2025-08-08 12:30:00	QQQ	ETF	574.0	574.2	573.62	573.64	945323.0

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

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