PREVIEW / etf_30min / 2025-04-02

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-02.parquet
  size:    983 KB
  rows:    41,018

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-04-02 04:00:00	SPY	ETF	559.66	559.66	558.97	559.47	14005.0
2025-04-02 04:30:00	SPY	ETF	559.62	560.16	559.36	559.36	7621.0
2025-04-02 05:00:00	SPY	ETF	559.34	559.8	559.28	559.53	4557.0
2025-04-02 05:30:00	SPY	ETF	559.09	559.5	559.0	559.04	5316.0
2025-04-02 06:00:00	SPY	ETF	559.1	559.19	557.77	558.47	170044.0
2025-04-02 06:30:00	SPY	ETF	558.47	558.52	557.6	557.95	153174.0
2025-04-02 07:00:00	SPY	ETF	557.99	558.25	557.46	557.65	98838.0
2025-04-02 07:30:00	SPY	ETF	557.68	558.0	557.11	557.16	77722.0
2025-04-02 08:00:00	SPY	ETF	557.53	560.83	555.0	555.02	400849.0
2025-04-02 08:30:00	SPY	ETF	555.0396	556.4	555.0396	556.16	192211.0
2025-04-02 09:00:00	SPY	ETF	556.18	556.2	554.84	555.05	222548.0
2025-04-02 09:30:00	SPY	ETF	555.05	559.78	554.81	558.73	4212231.0
2025-04-02 10:00:00	SPY	ETF	558.71	560.9162	558.29	560.86	2220023.0
2025-04-02 10:30:00	SPY	ETF	560.845	562.2696	560.34	562.09	1859558.0
2025-04-02 11:00:00	SPY	ETF	562.07	563.75	560.86	563.33	2098284.0
2025-04-02 11:30:00	SPY	ETF	563.3	563.73	561.1022	562.2836	2227868.0
2025-04-02 12:00:00	SPY	ETF	562.31	564.28	562.08	564.28	1581734.0
2025-04-02 12:30:00	SPY	ETF	564.29	566.06	563.57	565.68	2532205.0
2025-04-02 13:00:00	SPY	ETF	565.69	567.42	565.62	566.0769	2581554.0
2025-04-02 13:30:00	SPY	ETF	566.03	566.0989	563.21	564.1	2653634.0
2025-04-02 14:00:00	SPY	ETF	564.08	564.45	561.1	561.1	2189514.0
2025-04-02 14:30:00	SPY	ETF	561.11	563.785	560.96	561.11	2397125.0
2025-04-02 15:00:00	SPY	ETF	561.15	563.3702	561.135	563.2	1846713.0
2025-04-02 15:30:00	SPY	ETF	563.18	565.655	562.65	564.65	6997110.0
2025-04-02 16:00:00	SPY	ETF	564.64	570.74	555.5	556.47	8601831.0
2025-04-02 16:30:00	SPY	ETF	556.62	558.5	550.5	552.29	6104407.0
2025-04-02 17:00:00	SPY	ETF	552.3	552.42	548.99	549.85	2005015.0
2025-04-02 17:30:00	SPY	ETF	549.88	550.59	546.36	547.3	1097859.0
2025-04-02 18:00:00	SPY	ETF	547.25	548.77	542.2	545.45	1300409.0
2025-04-02 18:30:00	SPY	ETF	545.45	547.5	544.89	546.58	387859.0
2025-04-02 19:00:00	SPY	ETF	546.48	546.48	544.0	545.57	330619.0
2025-04-02 19:30:00	SPY	ETF	545.59	545.61	544.0	544.83	248752.0
2025-04-02 04:00:00	QQQ	ETF	471.0	471.42	470.2	471.37	36748.0
2025-04-02 04:30:00	QQQ	ETF	471.31	471.76	470.91	470.91	11042.0
2025-04-02 05:00:00	QQQ	ETF	470.83	471.31	470.63	470.67	10160.0
2025-04-02 05:30:00	QQQ	ETF	470.85	471.24	470.58	470.58	17869.0
2025-04-02 06:00:00	QQQ	ETF	470.56	470.7	469.25	469.89	55005.0
2025-04-02 06:30:00	QQQ	ETF	469.8	469.95	469.14	469.59	31673.0
2025-04-02 07:00:00	QQQ	ETF	469.54	469.75	468.97	469.23	86711.0
2025-04-02 07:30:00	QQQ	ETF	469.25	469.55	468.43	468.56	84561.0
2025-04-02 08:00:00	QQQ	ETF	469.37	472.23	466.48	466.48	359490.0
2025-04-02 08:30:00	QQQ	ETF	466.72	467.65	466.57	467.52	311412.0
2025-04-02 09:00:00	QQQ	ETF	467.45	467.48	465.92	466.06	231697.0
2025-04-02 09:30:00	QQQ	ETF	466.12	472.15	465.86	470.97	3246802.0
2025-04-02 10:00:00	QQQ	ETF	470.95	473.11	469.99	472.54	2179217.0
2025-04-02 10:30:00	QQQ	ETF	472.53	473.54	471.6702	473.4085	1855592.0
2025-04-02 11:00:00	QQQ	ETF	473.34	475.33	472.085	474.9	1895647.0
2025-04-02 11:30:00	QQQ	ETF	474.85	475.3099	472.87	474.26	1872601.0
2025-04-02 12:00:00	QQQ	ETF	474.195	476.63	474.03	476.58	1317734.0
2025-04-02 12:30:00	QQQ	ETF	476.65	478.11	475.87	477.73	2013487.0

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

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