PREVIEW / etf_30min / 2025-04-29

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-29.parquet
  size:    950 KB
  rows:    38,645

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-29 04:00:00	SPY	ETF	552.81	552.83	551.4	552.23	30305.0
2025-04-29 04:30:00	SPY	ETF	552.2	552.79	551.95	552.3	16982.0
2025-04-29 05:00:00	SPY	ETF	552.3	552.4	551.69	551.92	7623.0
2025-04-29 05:30:00	SPY	ETF	552.03	552.32	551.77	552.11	8431.0
2025-04-29 06:00:00	SPY	ETF	552.18	552.46	551.78	552.46	12326.0
2025-04-29 06:30:00	SPY	ETF	552.41	552.41	549.14	550.55	84331.0
2025-04-29 07:00:00	SPY	ETF	550.62	551.24	550.48	550.94	82610.0
2025-04-29 07:30:00	SPY	ETF	550.96	551.36	550.59	550.88	52216.0
2025-04-29 08:00:00	SPY	ETF	550.89	553.0	549.83	550.35	236169.0
2025-04-29 08:30:00	SPY	ETF	550.34	551.55	549.27	549.4	484970.0
2025-04-29 09:00:00	SPY	ETF	549.4298	549.45	547.95	548.91	526818.0
2025-04-29 09:30:00	SPY	ETF	548.91	551.69	548.55	550.62	3192727.0
2025-04-29 10:00:00	SPY	ETF	550.68	552.8	549.41	549.92	3139499.0
2025-04-29 10:30:00	SPY	ETF	549.895	553.05	549.82	552.96	1847517.0
2025-04-29 11:00:00	SPY	ETF	552.97	553.2918	551.05	552.2398	1610588.0
2025-04-29 11:30:00	SPY	ETF	552.24	552.7636	550.872	551.73	1167224.0
2025-04-29 12:00:00	SPY	ETF	551.7302	553.45	551.71	552.89	1082386.0
2025-04-29 12:30:00	SPY	ETF	552.895	553.1899	550.51	551.07	1542051.0
2025-04-29 13:00:00	SPY	ETF	551.08	552.98	550.77	552.63	1468224.0
2025-04-29 13:30:00	SPY	ETF	552.6458	555.1	552.54	554.7325	2584833.0
2025-04-29 14:00:00	SPY	ETF	554.74	555.4406	554.12	554.91	2662754.0
2025-04-29 14:30:00	SPY	ETF	554.9	555.25	554.12	554.33	1414789.0
2025-04-29 15:00:00	SPY	ETF	554.34	555.27	554.19	554.6	2200787.0
2025-04-29 15:30:00	SPY	ETF	554.63	555.45	553.82	554.14	5660539.0
2025-04-29 16:00:00	SPY	ETF	554.15	554.8	553.88	554.28	2317846.0
2025-04-29 16:30:00	SPY	ETF	554.22	554.3992	553.5	554.13	273956.0
2025-04-29 17:00:00	SPY	ETF	554.12	554.12	553.8	553.98	81854.0
2025-04-29 17:30:00	SPY	ETF	553.99	554.0002	553.7	553.81	28129.0
2025-04-29 18:00:00	SPY	ETF	553.84	554.17	553.2206	553.3099	75275.0
2025-04-29 18:30:00	SPY	ETF	553.4	553.4978	553.0	553.06	19319.0
2025-04-29 19:00:00	SPY	ETF	552.97	553.15	552.6	552.8	21975.0
2025-04-29 19:30:00	SPY	ETF	552.85	553.1475	552.83	552.99	12675.0
2025-04-29 04:00:00	QQQ	ETF	474.51	474.58	472.88	473.63	33495.0
2025-04-29 04:30:00	QQQ	ETF	473.73	474.29	473.5	473.94	21112.0
2025-04-29 05:00:00	QQQ	ETF	473.9	473.99	473.23	473.44	10007.0
2025-04-29 05:30:00	QQQ	ETF	473.5	473.73	473.33	473.46	3366.0
2025-04-29 06:00:00	QQQ	ETF	473.56	473.82	473.23	473.82	6001.0
2025-04-29 06:30:00	QQQ	ETF	473.73	473.73	470.7	471.85	88777.0
2025-04-29 07:00:00	QQQ	ETF	471.88	472.52	471.81	472.28	56032.0
2025-04-29 07:30:00	QQQ	ETF	472.3	472.61	471.66	471.84	32227.0
2025-04-29 08:00:00	QQQ	ETF	471.89	474.79	470.89	471.64	152300.0
2025-04-29 08:30:00	QQQ	ETF	471.64	472.78	470.6	470.74	131515.0
2025-04-29 09:00:00	QQQ	ETF	470.72	470.72	469.01	470.11	353697.0
2025-04-29 09:30:00	QQQ	ETF	470.09	472.96	469.59	471.95	2520555.0
2025-04-29 10:00:00	QQQ	ETF	471.97	474.347	471.11	471.8	1909910.0
2025-04-29 10:30:00	QQQ	ETF	471.83	474.47	471.7196	474.23	1483160.0
2025-04-29 11:00:00	QQQ	ETF	474.24	474.62	472.18	473.19	1299084.0
2025-04-29 11:30:00	QQQ	ETF	473.19	473.82	471.92	472.81	914281.0
2025-04-29 12:00:00	QQQ	ETF	472.85	474.46	472.77	473.53	1131400.0
2025-04-29 12:30:00	QQQ	ETF	473.49	473.95	471.21	471.795	1442568.0

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

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