PREVIEW / etf_30min / 2025-04-22

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-22.parquet
  size:    998 KB
  rows:    41,290

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-22 04:00:00	SPY	ETF	518.71	519.04	518.1	518.62	23277.0
2025-04-22 04:30:00	SPY	ETF	518.7	519.54	518.69	519.2	30744.0
2025-04-22 05:00:00	SPY	ETF	519.25	519.45	518.47	519.32	25564.0
2025-04-22 05:30:00	SPY	ETF	519.26	519.3	518.9	518.9	13320.0
2025-04-22 06:00:00	SPY	ETF	518.77	519.15	518.65	518.77	29408.0
2025-04-22 06:30:00	SPY	ETF	518.9	519.2	518.49	518.84	19733.0
2025-04-22 07:00:00	SPY	ETF	518.79	519.0	517.67	518.34	103162.0
2025-04-22 07:30:00	SPY	ETF	518.61	518.76	517.29	517.67	126589.0
2025-04-22 08:00:00	SPY	ETF	518.83	520.86	515.9	518.49	198030.0
2025-04-22 08:30:00	SPY	ETF	518.47	519.42	518.25	519.4	150733.0
2025-04-22 09:00:00	SPY	ETF	519.4	520.18	519.2102	520.18	396973.0
2025-04-22 09:30:00	SPY	ETF	520.12	522.3	519.1925	521.89	4144587.0
2025-04-22 10:00:00	SPY	ETF	521.96	523.44	521.73	523.06	3161546.0
2025-04-22 10:30:00	SPY	ETF	523.07	524.89	522.26	524.67	2740183.0
2025-04-22 11:00:00	SPY	ETF	524.67	525.8138	524.59	524.94	2950341.0
2025-04-22 11:30:00	SPY	ETF	524.95	526.55	523.76	526.17	3373341.0
2025-04-22 12:00:00	SPY	ETF	526.2	529.305	526.2	528.8	5508184.0
2025-04-22 12:30:00	SPY	ETF	528.79	529.11	526.93	527.5595	2725687.0
2025-04-22 13:00:00	SPY	ETF	527.57	528.97	522.33	522.65	6410734.0
2025-04-22 13:30:00	SPY	ETF	522.57	523.9327	521.76	521.85	3155862.0
2025-04-22 14:00:00	SPY	ETF	521.85	525.67	521.78	525.39	2934730.0
2025-04-22 14:30:00	SPY	ETF	525.39	527.23	525.35	526.76	2196131.0
2025-04-22 15:00:00	SPY	ETF	526.75	527.13	524.25	524.69	3350627.0
2025-04-22 15:30:00	SPY	ETF	524.67	527.5	524.21	526.94	7067021.0
2025-04-22 16:00:00	SPY	ETF	526.94	528.81	526.14	527.25	3157889.0
2025-04-22 16:30:00	SPY	ETF	527.29	527.54	526.7145	526.91	630912.0
2025-04-22 17:00:00	SPY	ETF	526.8	534.3169	526.8	534.14	1029107.0
2025-04-22 17:30:00	SPY	ETF	534.155	537.83	533.0	535.48	1105639.0
2025-04-22 18:00:00	SPY	ETF	535.31	536.85	533.28	535.7	648194.0
2025-04-22 18:30:00	SPY	ETF	535.74	537.01	534.4001	537.0	143192.0
2025-04-22 19:00:00	SPY	ETF	537.0	537.72	535.94	536.17	133030.0
2025-04-22 19:30:00	SPY	ETF	536.14	537.0	535.85	536.65	99720.0
2025-04-22 04:00:00	QQQ	ETF	436.72	437.45	436.56	437.24	47462.0
2025-04-22 04:30:00	QQQ	ETF	437.25	438.19	437.23	437.82	26060.0
2025-04-22 05:00:00	QQQ	ETF	437.97	438.12	437.11	438.01	19197.0
2025-04-22 05:30:00	QQQ	ETF	437.92	437.92	437.46	437.46	6585.0
2025-04-22 06:00:00	QQQ	ETF	437.29	437.7	437.14	437.19	9922.0
2025-04-22 06:30:00	QQQ	ETF	437.35	437.68	436.9	437.49	12956.0
2025-04-22 07:00:00	QQQ	ETF	437.49	437.6	436.51	436.97	58073.0
2025-04-22 07:30:00	QQQ	ETF	437.2	437.35	436.3	436.56	39752.0
2025-04-22 08:00:00	QQQ	ETF	437.3	438.85	434.68	437.35	145378.0
2025-04-22 08:30:00	QQQ	ETF	437.34	438.5	437.16	438.5	153158.0
2025-04-22 09:00:00	QQQ	ETF	438.53	438.94	438.09	438.84	214177.0
2025-04-22 09:30:00	QQQ	ETF	438.82	441.31	437.62	441.27	4157228.0
2025-04-22 10:00:00	QQQ	ETF	441.3	442.57	441.0	441.94	2627514.0
2025-04-22 10:30:00	QQQ	ETF	441.92	443.74	441.1	443.4175	2116083.0
2025-04-22 11:00:00	QQQ	ETF	443.4164	444.47	443.37	443.65	1938414.0
2025-04-22 11:30:00	QQQ	ETF	443.66	444.65	442.1198	444.31	2107149.0
2025-04-22 12:00:00	QQQ	ETF	444.35	447.58	444.35	447.12	3145777.0
2025-04-22 12:30:00	QQQ	ETF	447.18	447.4	445.36	446.03	1545188.0

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

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