PREVIEW / etf_30min / 2025-11-28

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-11-28.parquet
  size:    675 KB
  rows:    27,035

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-11-28 04:00:00	SPY	ETF	681.14	681.9	681.14	681.72	19311.0
2025-11-28 04:30:00	SPY	ETF	681.72	681.74	681.64	681.74	29785.0
2025-11-28 05:00:00	SPY	ETF	681.7	681.74	681.4	681.65	16542.0
2025-11-28 05:30:00	SPY	ETF	681.69	681.71	681.35	681.35	10641.0
2025-11-28 06:00:00	SPY	ETF	681.34	681.7	681.26	681.52	26397.0
2025-11-28 06:30:00	SPY	ETF	681.54	681.61	681.39	681.45	26627.0
2025-11-28 07:00:00	SPY	ETF	681.46	682.25	681.35	682.04	60756.0
2025-11-28 07:30:00	SPY	ETF	682.06	682.13	681.59	682.04	65236.0
2025-11-28 08:00:00	SPY	ETF	681.99	683.41	680.189	681.67	139236.0
2025-11-28 08:30:00	SPY	ETF	681.66	681.78	681.0	681.16	168584.0
2025-11-28 09:00:00	SPY	ETF	681.17	681.43	680.56	680.87	222333.0
2025-11-28 09:30:00	SPY	ETF	680.85	681.85	680.5	681.24	4361908.0
2025-11-28 10:00:00	SPY	ETF	681.25	682.32	681.03	681.69	3607426.0
2025-11-28 10:30:00	SPY	ETF	681.69	682.63	681.61	682.4601	3252211.0
2025-11-28 11:00:00	SPY	ETF	682.46	682.94	681.65	682.15	3452106.0
2025-11-28 11:30:00	SPY	ETF	682.16	682.91	681.8	682.755	3453255.0
2025-11-28 12:00:00	SPY	ETF	682.755	683.0	682.25	682.315	3335731.0
2025-11-28 12:30:00	SPY	ETF	682.315	683.665	681.88	683.39	8011522.0
2025-11-28 13:00:00	SPY	ETF	683.4	683.7	682.82	683.11	4121317.0
2025-11-28 13:30:00	SPY	ETF	683.11	683.44	682.92	683.0009	499725.0
2025-11-28 14:00:00	SPY	ETF	683.0299	683.405	673.715	683.22	995706.0
2025-11-28 14:30:00	SPY	ETF	683.3	683.96	683.2	683.64	93301.0
2025-11-28 15:00:00	SPY	ETF	683.66	683.87	683.59	683.71	39034.0
2025-11-28 15:30:00	SPY	ETF	683.71	683.85	683.39	683.68	35562.0
2025-11-28 16:00:00	SPY	ETF	683.68	683.68	683.55	683.6	22627.0
2025-11-28 16:30:00	SPY	ETF	683.6	683.8	683.2	683.54	121329.0
2025-11-28 04:00:00	QQQ	ETF	615.42	617.08	615.42	616.75	36148.0
2025-11-28 04:30:00	QQQ	ETF	616.72	617.13	616.69	616.82	23819.0
2025-11-28 05:00:00	QQQ	ETF	616.89	616.99	616.75	616.99	18844.0
2025-11-28 05:30:00	QQQ	ETF	616.96	617.09	616.91	616.94	21813.0
2025-11-28 06:00:00	QQQ	ETF	616.99	617.1	616.8	616.91	15616.0
2025-11-28 06:30:00	QQQ	ETF	616.9	616.97	616.75	616.84	29294.0
2025-11-28 07:00:00	QQQ	ETF	616.8	617.6	616.65	617.53	60433.0
2025-11-28 07:30:00	QQQ	ETF	617.52	617.55	617.01	617.37	38113.0
2025-11-28 08:00:00	QQQ	ETF	616.76	617.8	613.81	616.7	138570.0
2025-11-28 08:30:00	QQQ	ETF	616.53	616.96	616.24	616.43	147343.0
2025-11-28 09:00:00	QQQ	ETF	616.45	616.81	615.86	616.1793	119538.0
2025-11-28 09:30:00	QQQ	ETF	616.11	617.58	615.4174	616.31	3555499.0
2025-11-28 10:00:00	QQQ	ETF	616.31	617.14	615.91	616.31	2114329.0
2025-11-28 10:30:00	QQQ	ETF	616.31	617.57	616.085	617.295	1647753.0
2025-11-28 11:00:00	QQQ	ETF	617.3	617.94	616.28	616.77	1934905.0
2025-11-28 11:30:00	QQQ	ETF	616.78	617.83	616.42	617.68	1819922.0
2025-11-28 12:00:00	QQQ	ETF	617.67	618.0	617.165	617.52	1716716.0
2025-11-28 12:30:00	QQQ	ETF	617.52	619.24	616.91	619.18	3903293.0
2025-11-28 13:00:00	QQQ	ETF	619.18	619.49	618.74	618.965	1219273.0
2025-11-28 13:30:00	QQQ	ETF	619.07	619.27	618.761	618.8612	118937.0
2025-11-28 14:00:00	QQQ	ETF	618.94	619.08	618.79	619.03	48135.0
2025-11-28 14:30:00	QQQ	ETF	619.0	619.31	619.0	619.2987	42838.0
2025-11-28 15:00:00	QQQ	ETF	619.3	619.51	619.23	619.36	51099.0
2025-11-28 15:30:00	QQQ	ETF	619.29	619.45	619.06	619.06	313327.0

> showing 50 of 27,035 rows — these rows as CSV

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