PREVIEW / etf_30min / 2025-08-29

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-29.parquet
  size:    1001 KB
  rows:    40,671

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-29 04:00:00	SPY	ETF	647.89	648.48	647.31	647.55	15698.0
2025-08-29 04:30:00	SPY	ETF	647.52	647.64	646.86	646.86	16432.0
2025-08-29 05:00:00	SPY	ETF	646.97	647.19	646.52	647.13	14073.0
2025-08-29 05:30:00	SPY	ETF	647.21	647.34	647.14	647.18	11595.0
2025-08-29 06:00:00	SPY	ETF	647.1	647.39	646.95	647.25	7418.0
2025-08-29 06:30:00	SPY	ETF	647.28	647.28	646.9	647.05	68349.0
2025-08-29 07:00:00	SPY	ETF	647.04	647.43	647.03	647.35	42075.0
2025-08-29 07:30:00	SPY	ETF	647.26	647.33	647.02	647.14	58739.0
2025-08-29 08:00:00	SPY	ETF	647.18	648.8	646.81	647.0	261033.0
2025-08-29 08:30:00	SPY	ETF	647.1078	648.09	647.1078	647.7	342030.0
2025-08-29 09:00:00	SPY	ETF	647.68	647.96	647.37	647.47	180058.0
2025-08-29 09:30:00	SPY	ETF	647.46	647.84	645.34	645.51	6774780.0
2025-08-29 10:00:00	SPY	ETF	645.5	646.063	643.63	644.6688	7028232.0
2025-08-29 10:30:00	SPY	ETF	644.67	645.11	643.14	643.82	3865657.0
2025-08-29 11:00:00	SPY	ETF	643.82	644.77	643.68	644.41	2264760.0
2025-08-29 11:30:00	SPY	ETF	644.41	644.55	643.71	643.79	2058909.0
2025-08-29 12:00:00	SPY	ETF	643.78	644.76	643.75	644.17	1859764.0
2025-08-29 12:30:00	SPY	ETF	644.18	645.0399	644.18	644.725	1614786.0
2025-08-29 13:00:00	SPY	ETF	644.7	644.7	643.46	644.0	2355847.0
2025-08-29 13:30:00	SPY	ETF	644.0	645.0142	643.84	644.64	1937650.0
2025-08-29 14:00:00	SPY	ETF	644.65	644.7	644.17	644.265	1819954.0
2025-08-29 14:30:00	SPY	ETF	644.265	644.74	644.1721	644.49	1560175.0
2025-08-29 15:00:00	SPY	ETF	644.49	644.99	644.305	644.58	3051457.0
2025-08-29 15:30:00	SPY	ETF	644.58	645.14	643.76	645.04	12066620.0
2025-08-29 16:00:00	SPY	ETF	645.03	645.4	644.5	644.9	3813013.0
2025-08-29 16:30:00	SPY	ETF	644.95	645.08	644.83	644.94	849083.0
2025-08-29 17:00:00	SPY	ETF	644.91	645.1	644.91	645.06	196056.0
2025-08-29 17:30:00	SPY	ETF	645.03	645.4999	644.96	645.23	58025.0
2025-08-29 18:00:00	SPY	ETF	645.25	645.28	644.84	645.0497	24792.0
2025-08-29 18:30:00	SPY	ETF	644.97	645.04	644.97	645.02	9497.0
2025-08-29 19:00:00	SPY	ETF	645.01	645.07	644.99	645.02	2420.0
2025-08-29 19:30:00	SPY	ETF	645.0	645.07	644.91	644.95	24391.0
2025-08-29 04:00:00	QQQ	ETF	575.44	575.96	574.77	575.03	41633.0
2025-08-29 04:30:00	QQQ	ETF	575.08	575.29	574.09	574.14	29532.0
2025-08-29 05:00:00	QQQ	ETF	574.18	574.78	573.74	574.72	52927.0
2025-08-29 05:30:00	QQQ	ETF	574.7	574.82	574.47	574.58	21543.0
2025-08-29 06:00:00	QQQ	ETF	574.46	574.89	574.25	574.61	21909.0
2025-08-29 06:30:00	QQQ	ETF	574.58	574.58	574.0	574.23	47215.0
2025-08-29 07:00:00	QQQ	ETF	574.27	574.75	574.24	574.52	25412.0
2025-08-29 07:30:00	QQQ	ETF	574.52	574.54	574.18	574.34	19306.0
2025-08-29 08:00:00	QQQ	ETF	574.61	576.66	573.94	574.16	140092.0
2025-08-29 08:30:00	QQQ	ETF	574.01	575.289	574.01	574.94	228014.0
2025-08-29 09:00:00	QQQ	ETF	574.93	575.07	574.59	574.67	169106.0
2025-08-29 09:30:00	QQQ	ETF	574.67	575.03	571.15	571.44	6210468.0
2025-08-29 10:00:00	QQQ	ETF	571.46	572.23	569.25	570.948	5823648.0
2025-08-29 10:30:00	QQQ	ETF	570.95	571.37	568.96	569.42	3109981.0
2025-08-29 11:00:00	QQQ	ETF	569.41	570.93	569.27	570.5401	2029052.0
2025-08-29 11:30:00	QQQ	ETF	570.53	570.645	569.17	569.32	1904129.0
2025-08-29 12:00:00	QQQ	ETF	569.33	570.46	569.26	569.86	1468400.0
2025-08-29 12:30:00	QQQ	ETF	569.85	570.74	569.84	570.43	1330516.0

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

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