PREVIEW / etf_30min / 2025-07-24

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-24.parquet
  size:    1000 KB
  rows:    40,852

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-07-24 04:00:00	SPY	ETF	633.95	634.48	633.8	634.48	13015.0
2025-07-24 04:30:00	SPY	ETF	634.45	634.59	634.33	634.49	9144.0
2025-07-24 05:00:00	SPY	ETF	634.45	634.56	634.38	634.56	7800.0
2025-07-24 05:30:00	SPY	ETF	634.71	634.81	634.6	634.81	2379.0
2025-07-24 06:00:00	SPY	ETF	634.73	634.83	634.15	634.19	7605.0
2025-07-24 06:30:00	SPY	ETF	634.23	634.28	634.0	634.24	5602.0
2025-07-24 07:00:00	SPY	ETF	634.28	634.75	634.2	634.68	37268.0
2025-07-24 07:30:00	SPY	ETF	634.66	635.02	634.64	634.79	41962.0
2025-07-24 08:00:00	SPY	ETF	634.31	635.01	633.85	634.53	191595.0
2025-07-24 08:30:00	SPY	ETF	634.61	634.64	633.53	634.17	274061.0
2025-07-24 09:00:00	SPY	ETF	634.19	634.65	633.85	634.59	396540.0
2025-07-24 09:30:00	SPY	ETF	634.59	635.39	633.99	635.065	5414708.0
2025-07-24 10:00:00	SPY	ETF	635.11	635.34	634.07	634.82	3914222.0
2025-07-24 10:30:00	SPY	ETF	634.82	635.62	634.73	635.51	2701056.0
2025-07-24 11:00:00	SPY	ETF	635.52	635.89	635.39	635.525	2839787.0
2025-07-24 11:30:00	SPY	ETF	635.525	635.73	635.25	635.54	2032634.0
2025-07-24 12:00:00	SPY	ETF	635.53	635.58	634.28	634.565	2800820.0
2025-07-24 12:30:00	SPY	ETF	634.57	635.02	634.45	634.885	2298437.0
2025-07-24 13:00:00	SPY	ETF	634.88	635.98	634.76	635.38	2548592.0
2025-07-24 13:30:00	SPY	ETF	635.38	635.5883	635.125	635.245	1704144.0
2025-07-24 14:00:00	SPY	ETF	635.25	636.15	635.23	635.78	4683928.0
2025-07-24 14:30:00	SPY	ETF	635.785	635.93	634.69	635.2299	3894719.0
2025-07-24 15:00:00	SPY	ETF	635.22	635.755	635.13	635.4718	3055857.0
2025-07-24 15:30:00	SPY	ETF	635.475	635.575	634.25	634.43	9190552.0
2025-07-24 16:00:00	SPY	ETF	634.44	635.2392	634.25	634.78	2347074.0
2025-07-24 16:30:00	SPY	ETF	634.78	635.06	634.72	634.92	160137.0
2025-07-24 17:00:00	SPY	ETF	634.91	635.07	634.9	635.0	22092.0
2025-07-24 17:30:00	SPY	ETF	635.01	635.01	634.92	634.93	4630.0
2025-07-24 18:00:00	SPY	ETF	635.0	635.54	634.88	635.46	42916.0
2025-07-24 18:30:00	SPY	ETF	635.46	635.46	635.26	635.31	20018.0
2025-07-24 19:00:00	SPY	ETF	635.2504	635.33	635.06	635.1	14017.0
2025-07-24 19:30:00	SPY	ETF	635.12	635.49	635.099	635.44	8170.0
2025-07-24 04:00:00	QQQ	ETF	565.0	565.63	564.47	565.34	22847.0
2025-07-24 04:30:00	QQQ	ETF	565.32	565.53	565.28	565.47	13159.0
2025-07-24 05:00:00	QQQ	ETF	565.54	565.54	565.35	565.43	6988.0
2025-07-24 05:30:00	QQQ	ETF	565.57	565.65	565.46	565.55	6898.0
2025-07-24 06:00:00	QQQ	ETF	565.55	565.59	565.03	565.06	13380.0
2025-07-24 06:30:00	QQQ	ETF	565.13	565.17	564.91	565.13	9111.0
2025-07-24 07:00:00	QQQ	ETF	565.1	565.61	564.96	565.59	56566.0
2025-07-24 07:30:00	QQQ	ETF	565.5	565.829	565.39	565.4	22557.0
2025-07-24 08:00:00	QQQ	ETF	565.2	565.7486	564.487	565.19	89416.0
2025-07-24 08:30:00	QQQ	ETF	565.29	565.29	564.01	564.76	316514.0
2025-07-24 09:00:00	QQQ	ETF	564.79	565.22	564.46	565.12	200875.0
2025-07-24 09:30:00	QQQ	ETF	565.13	565.77	563.87	564.85	4166656.0
2025-07-24 10:00:00	QQQ	ETF	564.88	564.91	563.295	564.11	2523492.0
2025-07-24 10:30:00	QQQ	ETF	564.12	565.29	564.03	565.07	1635837.0
2025-07-24 11:00:00	QQQ	ETF	565.08	565.64	565.04	565.265	1465759.0
2025-07-24 11:30:00	QQQ	ETF	565.27	565.72	564.9748	565.42	1501622.0
2025-07-24 12:00:00	QQQ	ETF	565.395	565.43	564.27	564.54	1663433.0
2025-07-24 12:30:00	QQQ	ETF	564.545	565.1097	564.38	565.01	1253973.0

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

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