PREVIEW / etf_30min / 2025-03-31

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-31.parquet
  size:    994 KB
  rows:    41,690

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-31 04:00:00	SPY	ETF	552.6	552.6	551.46	551.55	55743.0
2025-03-31 04:30:00	SPY	ETF	551.69	551.7	550.76	550.81	41828.0
2025-03-31 05:00:00	SPY	ETF	550.73	551.05	549.81	550.97	54260.0
2025-03-31 05:30:00	SPY	ETF	551.01	551.08	550.15	550.42	24536.0
2025-03-31 06:00:00	SPY	ETF	550.47	550.64	550.13	550.61	117999.0
2025-03-31 06:30:00	SPY	ETF	550.56	551.06	550.56	550.69	85199.0
2025-03-31 07:00:00	SPY	ETF	550.75	551.0	549.17	549.25	122591.0
2025-03-31 07:30:00	SPY	ETF	549.28	549.92	548.701	549.79	250463.0
2025-03-31 08:00:00	SPY	ETF	550.81	552.45	548.7204	550.06	272778.0
2025-03-31 08:30:00	SPY	ETF	550.01	550.9	549.91	550.81	170748.0
2025-03-31 09:00:00	SPY	ETF	550.9	551.2	549.71	549.89	310715.0
2025-03-31 09:30:00	SPY	ETF	549.82	550.63	546.87	549.74	6737171.0
2025-03-31 10:00:00	SPY	ETF	549.75	551.59	549.43	549.51	3197260.0
2025-03-31 10:30:00	SPY	ETF	549.55	551.98	549.49	551.6	2457038.0
2025-03-31 11:00:00	SPY	ETF	551.61	553.47	551.236	552.53	2427650.0
2025-03-31 11:30:00	SPY	ETF	552.51	554.12	552.0937	553.32	1792924.0
2025-03-31 12:00:00	SPY	ETF	553.32	554.59	551.915	554.555	1441662.0
2025-03-31 12:30:00	SPY	ETF	554.55	554.55	553.12	553.33	1288568.0
2025-03-31 13:00:00	SPY	ETF	553.26	555.16	552.82	553.64	1988728.0
2025-03-31 13:30:00	SPY	ETF	553.6303	554.21	552.71	553.16	1210285.0
2025-03-31 14:00:00	SPY	ETF	553.15	556.96	553.02	556.95	4793359.0
2025-03-31 14:30:00	SPY	ETF	556.93	557.95	556.26	556.39	3834996.0
2025-03-31 15:00:00	SPY	ETF	556.39	559.19	556.365	557.41	5551922.0
2025-03-31 15:30:00	SPY	ETF	557.39	560.7112	557.13	559.15	14113186.0
2025-03-31 16:00:00	SPY	ETF	559.14	559.39	557.56	558.04	9054589.0
2025-03-31 16:30:00	SPY	ETF	558.04	559.0648	557.9	557.97	155282.0
2025-03-31 17:00:00	SPY	ETF	557.96	558.2	557.96	557.9994	35217.0
2025-03-31 17:30:00	SPY	ETF	558.0899	558.18	558.0	558.09	31122.0
2025-03-31 18:00:00	SPY	ETF	558.01	558.06	556.2	557.0	229933.0
2025-03-31 18:30:00	SPY	ETF	557.17	557.98	557.05	557.41	68259.0
2025-03-31 19:00:00	SPY	ETF	557.3717	558.04	557.05	557.17	29984.0
2025-03-31 19:30:00	SPY	ETF	557.13	557.22	556.75	557.001	44469.0
2025-03-31 04:00:00	QQQ	ETF	464.66	464.66	462.96	463.49	86408.0
2025-03-31 04:30:00	QQQ	ETF	463.45	463.61	462.82	462.84	72920.0
2025-03-31 05:00:00	QQQ	ETF	462.73	463.39	461.9	463.17	67368.0
2025-03-31 05:30:00	QQQ	ETF	463.25	463.58	462.31	462.64	23586.0
2025-03-31 06:00:00	QQQ	ETF	462.65	462.93	462.33	462.82	63087.0
2025-03-31 06:30:00	QQQ	ETF	462.83	463.48	462.76	463.06	110560.0
2025-03-31 07:00:00	QQQ	ETF	463.13	463.31	461.25	461.35	187969.0
2025-03-31 07:30:00	QQQ	ETF	461.37	462.2	460.71	462.09	195810.0
2025-03-31 08:00:00	QQQ	ETF	462.77	464.24	460.88	462.28	336354.0
2025-03-31 08:30:00	QQQ	ETF	462.27	469.291	462.12	463.21	169037.0
2025-03-31 09:00:00	QQQ	ETF	463.25	463.57	461.78	461.81	247093.0
2025-03-31 09:30:00	QQQ	ETF	461.92	462.52	457.33	460.02	7366194.0
2025-03-31 10:00:00	QQQ	ETF	460.03	461.9568	459.26	459.345	2610753.0
2025-03-31 10:30:00	QQQ	ETF	459.35	461.86	459.34	461.29	2317261.0
2025-03-31 11:00:00	QQQ	ETF	461.3	463.5188	460.71	462.45	2329753.0
2025-03-31 11:30:00	QQQ	ETF	462.38	464.27	461.8601	463.28	1975201.0
2025-03-31 12:00:00	QQQ	ETF	463.3	464.83	462.15	464.81	1555723.0
2025-03-31 12:30:00	QQQ	ETF	464.82	464.82	463.005	463.16	1039144.0

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

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