PREVIEW / etf_30min / 2025-08-07

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-07.parquet
  size:    1012 KB
  rows:    41,938

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-07 04:00:00	SPY	ETF	634.99	636.5	634.48	636.43	70665.0
2025-08-07 04:30:00	SPY	ETF	636.36	636.46	635.69	636.21	19083.0
2025-08-07 05:00:00	SPY	ETF	635.87	636.76	635.87	636.76	40511.0
2025-08-07 05:30:00	SPY	ETF	636.78	637.5	636.63	637.35	53859.0
2025-08-07 06:00:00	SPY	ETF	637.32	638.18	637.26	637.28	61597.0
2025-08-07 06:30:00	SPY	ETF	637.2	637.2	636.73	636.77	31695.0
2025-08-07 07:00:00	SPY	ETF	636.76	637.28	636.55	636.79	47186.0
2025-08-07 07:30:00	SPY	ETF	636.71	636.79	636.17	636.29	57988.0
2025-08-07 08:00:00	SPY	ETF	636.75	638.14	633.92	636.3	163715.0
2025-08-07 08:30:00	SPY	ETF	636.29	636.87	636.11	636.35	339148.0
2025-08-07 09:00:00	SPY	ETF	636.37	636.8	632.93	636.25	238824.0
2025-08-07 09:30:00	SPY	ETF	636.25	636.98	635.3	636.48	6212757.0
2025-08-07 10:00:00	SPY	ETF	636.49	636.82	633.12	633.82	5768209.0
2025-08-07 10:30:00	SPY	ETF	633.81	634.235	632.39	632.72	4336081.0
2025-08-07 11:00:00	SPY	ETF	632.73	633.14	631.76	631.9699	3597416.0
2025-08-07 11:30:00	SPY	ETF	631.97	632.44	631.35	631.8946	2997741.0
2025-08-07 12:00:00	SPY	ETF	631.86	632.6	631.1316	632.245	2589524.0
2025-08-07 12:30:00	SPY	ETF	632.25	632.61	630.07	631.24	3853034.0
2025-08-07 13:00:00	SPY	ETF	631.24	631.87	630.0	630.03	3132744.0
2025-08-07 13:30:00	SPY	ETF	630.0	631.08	629.69	630.74	3176432.0
2025-08-07 14:00:00	SPY	ETF	630.74	631.0399	629.11	629.92	3223457.0
2025-08-07 14:30:00	SPY	ETF	629.92	630.87	629.46	630.5107	2520352.0
2025-08-07 15:00:00	SPY	ETF	630.5213	630.79	630.01	630.27	2685956.0
2025-08-07 15:30:00	SPY	ETF	630.28	632.36	630.26	632.3	6731003.0
2025-08-07 16:00:00	SPY	ETF	632.29	633.25	632.18	632.77	2573626.0
2025-08-07 16:30:00	SPY	ETF	632.81	632.93	632.51	632.93	313450.0
2025-08-07 17:00:00	SPY	ETF	632.8017	632.96	632.73	632.86	75770.0
2025-08-07 17:30:00	SPY	ETF	632.91	632.96	632.0938	632.87	308639.0
2025-08-07 18:00:00	SPY	ETF	632.85	633.83	632.8	633.78	111188.0
2025-08-07 18:30:00	SPY	ETF	633.74	633.77	633.33	633.53	25078.0
2025-08-07 19:00:00	SPY	ETF	633.48	633.6196	633.37	633.37	8393.0
2025-08-07 19:30:00	SPY	ETF	633.41	633.43	633.17	633.3	21120.0
2025-08-07 04:00:00	QQQ	ETF	569.4	570.96	569.27	570.87	105738.0
2025-08-07 04:30:00	QQQ	ETF	570.8	570.91	570.18	570.6	17777.0
2025-08-07 05:00:00	QQQ	ETF	570.3	571.0	570.19	571.0	23577.0
2025-08-07 05:30:00	QQQ	ETF	571.05	571.73	570.88	571.6	21413.0
2025-08-07 06:00:00	QQQ	ETF	571.6	572.19	571.56	571.73	36098.0
2025-08-07 06:30:00	QQQ	ETF	571.83	572.11	571.55	571.91	46877.0
2025-08-07 07:00:00	QQQ	ETF	572.02	572.38	571.7	571.9	77054.0
2025-08-07 07:30:00	QQQ	ETF	571.84	571.88	571.1	571.21	43975.0
2025-08-07 08:00:00	QQQ	ETF	571.9	572.5	566.895	571.6	150068.0
2025-08-07 08:30:00	QQQ	ETF	571.49	571.92	571.22	571.52	127778.0
2025-08-07 09:00:00	QQQ	ETF	571.6201	572.04	571.4	571.63	110332.0
2025-08-07 09:30:00	QQQ	ETF	571.67	573.02	570.8896	572.92	4451938.0
2025-08-07 10:00:00	QQQ	ETF	572.92	573.32	570.26	571.025	3501381.0
2025-08-07 10:30:00	QQQ	ETF	571.03	571.46	569.67	570.15	2246801.0
2025-08-07 11:00:00	QQQ	ETF	570.15	570.64	569.16	569.48	2148609.0
2025-08-07 11:30:00	QQQ	ETF	569.465	569.98	568.69	569.19	1552290.0
2025-08-07 12:00:00	QQQ	ETF	569.17	569.55	568.27	569.08	1462000.0
2025-08-07 12:30:00	QQQ	ETF	569.07	569.4	566.575	568.2701	2496588.0

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

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