PREVIEW / etf_30min / 2025-04-01

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-01.parquet
  size:    957 KB
  rows:    39,793

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-01 04:00:00	SPY	ETF	557.55	558.4	557.37	558.4	24559.0
2025-04-01 04:30:00	SPY	ETF	558.3	559.0	558.1	558.99	17640.0
2025-04-01 05:00:00	SPY	ETF	559.06	559.34	558.86	559.01	17385.0
2025-04-01 05:30:00	SPY	ETF	559.25	559.81	559.25	559.5	9220.0
2025-04-01 06:00:00	SPY	ETF	559.47	559.48	557.11	557.11	42616.0
2025-04-01 06:30:00	SPY	ETF	557.13	557.7	556.0	557.42	148762.0
2025-04-01 07:00:00	SPY	ETF	557.44	557.57	556.25	556.25	82228.0
2025-04-01 07:30:00	SPY	ETF	556.5	556.67	555.5	556.23	199254.0
2025-04-01 08:00:00	SPY	ETF	557.34	559.63	555.51	556.31	202734.0
2025-04-01 08:30:00	SPY	ETF	556.2	559.39	556.2	557.07	134944.0
2025-04-01 09:00:00	SPY	ETF	557.12	558.1	557.09	557.43	256883.0
2025-04-01 09:30:00	SPY	ETF	557.45	558.58	556.0	557.22	3441778.0
2025-04-01 10:00:00	SPY	ETF	557.1526	557.57	553.68	555.14	3682960.0
2025-04-01 10:30:00	SPY	ETF	555.135	559.8	555.03	559.72	3121944.0
2025-04-01 11:00:00	SPY	ETF	559.715	561.8794	559.4	560.799	3551897.0
2025-04-01 11:30:00	SPY	ETF	560.82	561.76	560.2	561.57	1832003.0
2025-04-01 12:00:00	SPY	ETF	561.59	562.94	560.65	560.75	1900350.0
2025-04-01 12:30:00	SPY	ETF	560.76	561.38	559.335	560.69	2529365.0
2025-04-01 13:00:00	SPY	ETF	560.6728	561.12	559.18	559.42	1288640.0
2025-04-01 13:30:00	SPY	ETF	559.33	560.36	558.91	559.0	1494493.0
2025-04-01 14:00:00	SPY	ETF	559.0	559.17	556.4293	556.6895	2607055.0
2025-04-01 14:30:00	SPY	ETF	556.675	557.7799	556.15	557.662	1753452.0
2025-04-01 15:00:00	SPY	ETF	557.66	558.995	557.43	558.4293	2104068.0
2025-04-01 15:30:00	SPY	ETF	558.43	561.52	558.1714	561.03	5704162.0
2025-04-01 16:00:00	SPY	ETF	561.06	561.37	560.39	560.45	2032268.0
2025-04-01 16:30:00	SPY	ETF	560.44	561.48	560.23	560.75	356656.0
2025-04-01 17:00:00	SPY	ETF	560.61	561.1	560.61	560.89	35180.0
2025-04-01 17:30:00	SPY	ETF	560.8904	561.13	560.8	560.81	66585.0
2025-04-01 18:00:00	SPY	ETF	560.83	563.0	560.8	562.32	106541.0
2025-04-01 18:30:00	SPY	ETF	562.32	562.32	561.73	561.94	82786.0
2025-04-01 19:00:00	SPY	ETF	561.81	562.16	561.59	562.1401	23154.0
2025-04-01 19:30:00	SPY	ETF	562.22	562.27	561.77	561.78	15679.0
2025-04-01 04:00:00	QQQ	ETF	466.94	470.0	466.94	468.97	53963.0
2025-04-01 04:30:00	QQQ	ETF	468.85	469.48	468.65	469.36	55276.0
2025-04-01 05:00:00	QQQ	ETF	469.5	469.84	469.2	469.68	30952.0
2025-04-01 05:30:00	QQQ	ETF	469.73	470.39	469.72	469.84	57592.0
2025-04-01 06:00:00	QQQ	ETF	469.88	469.88	467.6	467.6	100845.0
2025-04-01 06:30:00	QQQ	ETF	467.5	468.14	466.38	467.85	122156.0
2025-04-01 07:00:00	QQQ	ETF	467.89	467.96	466.7	466.72	80870.0
2025-04-01 07:30:00	QQQ	ETF	466.81	467.04	465.68	466.73	218383.0
2025-04-01 08:00:00	QQQ	ETF	466.65	470.2096	465.7401	466.8	263891.0
2025-04-01 08:30:00	QQQ	ETF	466.72	468.92	466.6727	467.33	78954.0
2025-04-01 09:00:00	QQQ	ETF	467.4	468.0	467.14	467.22	214016.0
2025-04-01 09:30:00	QQQ	ETF	467.3	469.28	466.28	467.69	3509196.0
2025-04-01 10:00:00	QQQ	ETF	467.71	468.33	464.42	466.17	2999657.0
2025-04-01 10:30:00	QQQ	ETF	466.15	470.65	466.01	470.5502	2220734.0
2025-04-01 11:00:00	QQQ	ETF	470.55	472.66	470.25	471.7093	2363906.0
2025-04-01 11:30:00	QQQ	ETF	471.775	472.725	470.92	472.3888	1619110.0
2025-04-01 12:00:00	QQQ	ETF	472.4	473.63	471.24	471.49	1886955.0
2025-04-01 12:30:00	QQQ	ETF	471.6	472.46	470.09	471.7102	1697812.0

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

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