PREVIEW / etf_30min / 2025-03-28

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-28.parquet
  size:    957 KB
  rows:    38,522

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-03-28 04:00:00	SPY	ETF	566.48	566.88	564.49	564.9	23415.0
2025-03-28 04:30:00	SPY	ETF	564.57	565.9	564.57	565.7	14198.0
2025-03-28 05:00:00	SPY	ETF	565.78	566.01	565.71	565.94	10132.0
2025-03-28 05:30:00	SPY	ETF	565.82	566.1	565.45	565.58	6516.0
2025-03-28 06:00:00	SPY	ETF	565.75	566.8	565.75	566.75	3800.0
2025-03-28 06:30:00	SPY	ETF	566.75	567.06	566.5	566.67	18974.0
2025-03-28 07:00:00	SPY	ETF	566.74	566.75	566.06	566.41	32003.0
2025-03-28 07:30:00	SPY	ETF	566.21	566.49	565.84	566.35	125318.0
2025-03-28 08:00:00	SPY	ETF	566.47	567.85	564.89	566.12	93474.0
2025-03-28 08:30:00	SPY	ETF	565.77	567.15	564.46	564.46	351652.0
2025-03-28 09:00:00	SPY	ETF	564.46	566.64	564.3	565.51	689011.0
2025-03-28 09:30:00	SPY	ETF	565.52	566.2675	563.76	563.9399	3362050.0
2025-03-28 10:00:00	SPY	ETF	563.84	564.36	559.49	559.57	5616921.0
2025-03-28 10:30:00	SPY	ETF	559.565	560.15	558.26	558.79	4221515.0
2025-03-28 11:00:00	SPY	ETF	558.8	559.35	557.77	558.94	3528613.0
2025-03-28 11:30:00	SPY	ETF	558.94	559.8	557.91	557.93	2171789.0
2025-03-28 12:00:00	SPY	ETF	557.92	558.8	556.631	556.84	2081977.0
2025-03-28 12:30:00	SPY	ETF	556.845	557.5786	556.44	556.5432	2015210.0
2025-03-28 13:00:00	SPY	ETF	556.5	556.7	555.25	555.39	2539224.0
2025-03-28 13:30:00	SPY	ETF	555.4	556.45	555.22	556.41	1989965.0
2025-03-28 14:00:00	SPY	ETF	556.39	556.97	555.63	555.99	2076402.0
2025-03-28 14:30:00	SPY	ETF	555.965	556.34	555.31	556.18	1784266.0
2025-03-28 15:00:00	SPY	ETF	556.21	556.72	555.66	555.77	2275559.0
2025-03-28 15:30:00	SPY	ETF	555.78	556.5	555.07	555.83	10535663.0
2025-03-28 16:00:00	SPY	ETF	555.84	555.8879	554.14	554.23	4867297.0
2025-03-28 16:30:00	SPY	ETF	554.24	554.38	553.75	553.7599	257131.0
2025-03-28 17:00:00	SPY	ETF	553.7	554.09	553.7	554.03	58035.0
2025-03-28 17:30:00	SPY	ETF	554.06	554.16	553.9	554.05	37697.0
2025-03-28 18:00:00	SPY	ETF	554.11	554.5	553.88	554.5	63416.0
2025-03-28 18:30:00	SPY	ETF	554.44	554.5191	554.0	554.203	14837.0
2025-03-28 19:00:00	SPY	ETF	554.3	554.37	554.15	554.2	9910.0
2025-03-28 19:30:00	SPY	ETF	554.2018	554.27	553.92	554.15	16245.0
2025-03-28 04:00:00	QQQ	ETF	478.64	479.45	478.44	478.8	54430.0
2025-03-28 04:30:00	QQQ	ETF	478.67	479.81	478.43	479.59	13294.0
2025-03-28 05:00:00	QQQ	ETF	479.8	480.07	479.76	480.02	11366.0
2025-03-28 05:30:00	QQQ	ETF	479.99	480.47	479.59	479.69	11900.0
2025-03-28 06:00:00	QQQ	ETF	479.79	480.8	479.79	480.73	51552.0
2025-03-28 06:30:00	QQQ	ETF	480.75	481.17	480.58	480.75	40521.0
2025-03-28 07:00:00	QQQ	ETF	480.76	480.91	480.1	480.31	27496.0
2025-03-28 07:30:00	QQQ	ETF	480.13	480.69	479.81	480.68	58853.0
2025-03-28 08:00:00	QQQ	ETF	480.27	482.02	478.42	480.57	106556.0
2025-03-28 08:30:00	QQQ	ETF	480.4	480.4	478.65	478.66	260820.0
2025-03-28 09:00:00	QQQ	ETF	478.63	481.031	478.39	479.62	355077.0
2025-03-28 09:30:00	QQQ	ETF	479.81	480.52	478.07	478.4522	3173565.0
2025-03-28 10:00:00	QQQ	ETF	478.44	479.05	473.01	473.2125	5584709.0
2025-03-28 10:30:00	QQQ	ETF	473.23	473.74	471.8	472.43	3355300.0
2025-03-28 11:00:00	QQQ	ETF	472.43	472.86	471.235	472.36	2214296.0
2025-03-28 11:30:00	QQQ	ETF	472.32	473.0751	470.92	470.92	1420836.0
2025-03-28 12:00:00	QQQ	ETF	470.92	471.89	469.57	469.95	1409280.0
2025-03-28 12:30:00	QQQ	ETF	469.94	470.6999	469.67	469.74	1524341.0

> showing 50 of 38,522 rows — these rows as CSV

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