PREVIEW / etf_30min / 2025-06-18

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-18.parquet
  size:    959 KB
  rows:    39,437

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-06-18 04:00:00	SPY	ETF	599.02	599.47	598.22	599.06	62147.0
2025-06-18 04:30:00	SPY	ETF	598.94	599.43	598.93	599.35	11396.0
2025-06-18 05:00:00	SPY	ETF	599.35	600.05	599.35	599.6	25143.0
2025-06-18 05:30:00	SPY	ETF	599.72	599.75	599.31	599.39	17523.0
2025-06-18 06:00:00	SPY	ETF	599.31	599.31	598.29	598.61	93608.0
2025-06-18 06:30:00	SPY	ETF	598.68	598.71	597.41	597.5	35046.0
2025-06-18 07:00:00	SPY	ETF	597.51	598.21	597.39	598.08	59088.0
2025-06-18 07:30:00	SPY	ETF	598.05	599.19	598.0	598.7	71218.0
2025-06-18 08:00:00	SPY	ETF	597.66	599.5	597.082	598.55	102709.0
2025-06-18 08:30:00	SPY	ETF	598.56	598.75	598.02	598.08	81927.0
2025-06-18 09:00:00	SPY	ETF	598.18	598.79	598.07	598.44	192280.0
2025-06-18 09:30:00	SPY	ETF	598.44	599.5882	597.36	599.12	4602210.0
2025-06-18 10:00:00	SPY	ETF	599.13	601.04	598.73	600.7708	3774947.0
2025-06-18 10:30:00	SPY	ETF	600.78	601.22	600.54	600.84	2335671.0
2025-06-18 11:00:00	SPY	ETF	600.83	600.9	599.895	600.1	1513499.0
2025-06-18 11:30:00	SPY	ETF	600.13	600.52	599.62	599.7393	1779887.0
2025-06-18 12:00:00	SPY	ETF	599.72	600.32	599.4	599.495	1454168.0
2025-06-18 12:30:00	SPY	ETF	599.49	600.11	599.38	599.465	1549601.0
2025-06-18 13:00:00	SPY	ETF	599.46	599.705	598.82	598.875	1491597.0
2025-06-18 13:30:00	SPY	ETF	598.88	599.9699	598.04	599.52	2412523.0
2025-06-18 14:00:00	SPY	ETF	599.61	601.0	598.45	599.34	3938264.0
2025-06-18 14:30:00	SPY	ETF	599.35	600.87	596.67	597.27	5923424.0
2025-06-18 15:00:00	SPY	ETF	597.27	598.93	596.47	596.92	6811512.0
2025-06-18 15:30:00	SPY	ETF	596.89	598.795	596.63	597.46	7504385.0
2025-06-18 16:00:00	SPY	ETF	597.45	598.245	597.41	597.77	3731856.0
2025-06-18 16:30:00	SPY	ETF	597.85	597.98	597.5	597.5	154634.0
2025-06-18 17:00:00	SPY	ETF	597.5	597.7	596.6	597.3	134279.0
2025-06-18 17:30:00	SPY	ETF	597.3	597.39	597.1	597.35	40950.0
2025-06-18 18:00:00	SPY	ETF	597.39	597.57	596.59	597.09	94863.0
2025-06-18 18:30:00	SPY	ETF	596.92	596.97	596.54	596.9	23679.0
2025-06-18 19:00:00	SPY	ETF	596.97	597.21	596.84	596.98	24281.0
2025-06-18 19:30:00	SPY	ETF	596.96	597.3101	596.8	597.29	26932.0
2025-06-18 04:00:00	QQQ	ETF	530.46	531.02	529.62	530.61	37258.0
2025-06-18 04:30:00	QQQ	ETF	530.63	531.15	530.59	531.01	12989.0
2025-06-18 05:00:00	QQQ	ETF	531.03	531.72	531.03	531.38	24933.0
2025-06-18 05:30:00	QQQ	ETF	531.38	531.46	530.98	531.02	22010.0
2025-06-18 06:00:00	QQQ	ETF	530.98	531.03	530.08	530.4	21019.0
2025-06-18 06:30:00	QQQ	ETF	530.43	530.51	529.15	529.27	34011.0
2025-06-18 07:00:00	QQQ	ETF	529.21	530.0	529.14	529.88	34359.0
2025-06-18 07:30:00	QQQ	ETF	529.83	530.99	529.75	530.34	94544.0
2025-06-18 08:00:00	QQQ	ETF	530.88	531.5804	529.0	530.35	164553.0
2025-06-18 08:30:00	QQQ	ETF	530.31	530.46	529.81	529.91	58981.0
2025-06-18 09:00:00	QQQ	ETF	529.95	530.61	529.88	530.1	124340.0
2025-06-18 09:30:00	QQQ	ETF	530.1	530.86	528.48	530.28	2985386.0
2025-06-18 10:00:00	QQQ	ETF	530.29	532.18	529.78	531.98	2899770.0
2025-06-18 10:30:00	QQQ	ETF	531.985	532.55	531.64	532.11	2329869.0
2025-06-18 11:00:00	QQQ	ETF	532.1	532.24	531.22	531.41	1175108.0
2025-06-18 11:30:00	QQQ	ETF	531.42	532.04	531.0201	531.14	1470493.0
2025-06-18 12:00:00	QQQ	ETF	531.13	531.78	530.73	530.88	1017137.0
2025-06-18 12:30:00	QQQ	ETF	530.86	531.461	530.74	530.87	800364.0

> showing 50 of 39,437 rows — these rows as CSV

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