PREVIEW / etf_30min / 2025-08-22

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-22.parquet
  size:    1013 KB
  rows:    41,148

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-22 04:00:00	SPY	ETF	636.02	636.97	635.97	636.74	16000.0
2025-08-22 04:30:00	SPY	ETF	636.58	637.42	636.54	637.03	35551.0
2025-08-22 05:00:00	SPY	ETF	637.22	637.22	636.96	637.15	4277.0
2025-08-22 05:30:00	SPY	ETF	637.08	637.26	636.93	637.26	2977.0
2025-08-22 06:00:00	SPY	ETF	637.3	637.45	637.22	637.45	4474.0
2025-08-22 06:30:00	SPY	ETF	637.44	637.54	637.31	637.41	1945.0
2025-08-22 07:00:00	SPY	ETF	637.42	637.54	637.09	637.12	99448.0
2025-08-22 07:30:00	SPY	ETF	637.12	637.22	636.87	636.97	49198.0
2025-08-22 08:00:00	SPY	ETF	637.43	637.55	633.85	637.5	113047.0
2025-08-22 08:30:00	SPY	ETF	637.52	637.57	636.96	637.02	145208.0
2025-08-22 09:00:00	SPY	ETF	636.99	637.76	636.92	637.76	230662.0
2025-08-22 09:30:00	SPY	ETF	637.76	639.72	637.25	638.41	5416973.0
2025-08-22 10:00:00	SPY	ETF	638.41	645.55	638.41	644.11	14162372.0
2025-08-22 10:30:00	SPY	ETF	644.1338	646.17	644.13	645.6458	5003389.0
2025-08-22 11:00:00	SPY	ETF	645.65	646.27	645.47	646.0	4439823.0
2025-08-22 11:30:00	SPY	ETF	646.01	646.5	645.3	645.41	3151139.0
2025-08-22 12:00:00	SPY	ETF	645.415	645.91	644.695	644.78	2713187.0
2025-08-22 12:30:00	SPY	ETF	644.78	645.4406	644.295	644.72	1621567.0
2025-08-22 13:00:00	SPY	ETF	644.7	646.26	644.7	646.15	2474389.0
2025-08-22 13:30:00	SPY	ETF	646.15	646.4	645.69	645.77	1775759.0
2025-08-22 14:00:00	SPY	ETF	645.785	646.04	645.285	645.385	2376509.0
2025-08-22 14:30:00	SPY	ETF	645.44	645.86	645.255	645.45	2586082.0
2025-08-22 15:00:00	SPY	ETF	645.45	645.64	645.052	645.08	3161907.0
2025-08-22 15:30:00	SPY	ETF	645.07	645.455	644.295	645.27	11489114.0
2025-08-22 16:00:00	SPY	ETF	645.25	645.59	644.94	645.42	2438670.0
2025-08-22 16:30:00	SPY	ETF	645.4	645.59	645.3202	645.4	41469.0
2025-08-22 17:00:00	SPY	ETF	645.43	645.49	645.15	645.4	33484.0
2025-08-22 17:30:00	SPY	ETF	645.39	645.58	645.29	645.29	48345.0
2025-08-22 18:00:00	SPY	ETF	645.29	645.3982	645.25	645.3982	20440.0
2025-08-22 18:30:00	SPY	ETF	645.36	645.61	645.31	645.61	19613.0
2025-08-22 19:00:00	SPY	ETF	645.6	645.6998	645.6	645.6992	6418.0
2025-08-22 19:30:00	SPY	ETF	645.6284	645.72	645.44	645.5	13822.0
2025-08-22 04:00:00	QQQ	ETF	563.01	564.29	562.91	563.9	41554.0
2025-08-22 04:30:00	QQQ	ETF	563.75	564.43	563.68	564.36	32669.0
2025-08-22 05:00:00	QQQ	ETF	564.32	564.35	563.96	564.21	8347.0
2025-08-22 05:30:00	QQQ	ETF	564.18	564.42	563.89	564.37	13709.0
2025-08-22 06:00:00	QQQ	ETF	564.36	564.9	564.36	564.75	23008.0
2025-08-22 06:30:00	QQQ	ETF	564.75	564.91	564.56	564.64	39897.0
2025-08-22 07:00:00	QQQ	ETF	564.66	565.0	564.36	564.41	69454.0
2025-08-22 07:30:00	QQQ	ETF	564.44	564.52	564.13	564.33	73209.0
2025-08-22 08:00:00	QQQ	ETF	564.72	564.99	560.45	564.82	174710.0
2025-08-22 08:30:00	QQQ	ETF	564.83	564.85	564.1	564.14	114073.0
2025-08-22 09:00:00	QQQ	ETF	564.16	564.67	564.06	564.67	112870.0
2025-08-22 09:30:00	QQQ	ETF	564.65	566.54	563.27	564.71	4038477.0
2025-08-22 10:00:00	QQQ	ETF	564.76	573.58	564.75	571.68	8938467.0
2025-08-22 10:30:00	QQQ	ETF	571.71	573.88	571.695	572.885	3307012.0
2025-08-22 11:00:00	QQQ	ETF	572.9	573.99	572.855	573.32	2306026.0
2025-08-22 11:30:00	QQQ	ETF	573.3	573.89	571.965	572.05	1711887.0
2025-08-22 12:00:00	QQQ	ETF	572.07	572.59	570.97	571.2203	1798424.0
2025-08-22 12:30:00	QQQ	ETF	571.235	571.871	570.57	571.075	1480949.0

> showing 50 of 41,148 rows — these rows as CSV

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