PREVIEW / etf_30min / 2025-04-10

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-10.parquet
  size:    1.0 MB
  rows:    43,639

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-10 04:00:00	SPY	ETF	540.14	540.14	533.12	534.13	447724.0
2025-04-10 04:30:00	SPY	ETF	534.05	534.38	530.68	531.67	244455.0
2025-04-10 05:00:00	SPY	ETF	531.92	533.42	530.7	531.98	106108.0
2025-04-10 05:30:00	SPY	ETF	532.05	534.21	531.92	532.77	156453.0
2025-04-10 06:00:00	SPY	ETF	532.83	536.9	532.55	535.45	455703.0
2025-04-10 06:30:00	SPY	ETF	535.46	537.35	533.75	533.8	149485.0
2025-04-10 07:00:00	SPY	ETF	533.75	535.32	533.42	534.15	313583.0
2025-04-10 07:30:00	SPY	ETF	534.23	536.04	533.63	535.37	365947.0
2025-04-10 08:00:00	SPY	ETF	535.25	543.01	531.2104	533.0	1103863.0
2025-04-10 08:30:00	SPY	ETF	535.0	539.32	531.0	533.19	1526215.0
2025-04-10 09:00:00	SPY	ETF	533.3	535.15	531.77	532.27	666707.0
2025-04-10 09:30:00	SPY	ETF	532.24	533.495	528.51	529.0025	10517001.0
2025-04-10 10:00:00	SPY	ETF	528.99	530.73	526.3401	528.11	6098565.0
2025-04-10 10:30:00	SPY	ETF	528.12	531.96	526.05	526.29	5210571.0
2025-04-10 11:00:00	SPY	ETF	526.29	528.7	523.71	523.7102	4946493.0
2025-04-10 11:30:00	SPY	ETF	523.72	524.27	517.91	518.6143	6963904.0
2025-04-10 12:00:00	SPY	ETF	518.56	520.09	509.32	511.86	12701473.0
2025-04-10 12:30:00	SPY	ETF	511.815	520.55	511.5127	519.76	10135656.0
2025-04-10 13:00:00	SPY	ETF	519.67	524.7	512.87	519.32	8878025.0
2025-04-10 13:30:00	SPY	ETF	519.21	525.55	518.32	524.28	6745397.0
2025-04-10 14:00:00	SPY	ETF	524.19	528.76	520.31	528.39	7168813.0
2025-04-10 14:30:00	SPY	ETF	528.39	529.71	523.57	526.07	5876652.0
2025-04-10 15:00:00	SPY	ETF	526.17	529.43	522.37	522.43	6066545.0
2025-04-10 15:30:00	SPY	ETF	522.47	526.52	518.2	524.7	17444145.0
2025-04-10 16:00:00	SPY	ETF	524.67	526.88	523.346	524.4	4745059.0
2025-04-10 16:30:00	SPY	ETF	524.4	525.16	523.7	525.16	501116.0
2025-04-10 17:00:00	SPY	ETF	525.16	525.25	524.58	524.97	124881.0
2025-04-10 17:30:00	SPY	ETF	524.9	524.97	524.3	524.3	42848.0
2025-04-10 18:00:00	SPY	ETF	524.43	526.5193	524.43	525.87	117892.0
2025-04-10 18:30:00	SPY	ETF	526.2	527.5	525.75	525.75	69647.0
2025-04-10 19:00:00	SPY	ETF	525.81	526.03	522.39	523.08	126950.0
2025-04-10 19:30:00	SPY	ETF	523.27	523.96	521.29	522.1017	103623.0
2025-04-10 04:00:00	QQQ	ETF	458.61	460.0	454.99	455.8	432380.0
2025-04-10 04:30:00	QQQ	ETF	455.48	455.78	451.71	453.4	315490.0
2025-04-10 05:00:00	QQQ	ETF	453.32	455.44	452.84	454.44	79123.0
2025-04-10 05:30:00	QQQ	ETF	454.64	456.33	454.41	455.05	78726.0
2025-04-10 06:00:00	QQQ	ETF	455.24	458.38	455.13	457.16	143651.0
2025-04-10 06:30:00	QQQ	ETF	457.35	458.65	455.49	455.65	126723.0
2025-04-10 07:00:00	QQQ	ETF	455.67	457.2	455.58	456.39	185956.0
2025-04-10 07:30:00	QQQ	ETF	456.49	457.63	455.92	457.02	167789.0
2025-04-10 08:00:00	QQQ	ETF	456.24	463.0	453.368	454.54	498740.0
2025-04-10 08:30:00	QQQ	ETF	454.96	459.0	452.24	454.5	871437.0
2025-04-10 09:00:00	QQQ	ETF	454.54	456.3	453.3204	453.63	614990.0
2025-04-10 09:30:00	QQQ	ETF	453.64	455.59	450.48	450.52	7930406.0
2025-04-10 10:00:00	QQQ	ETF	450.51	452.46	448.27	450.14	5227903.0
2025-04-10 10:30:00	QQQ	ETF	450.16	453.92	448.44	448.69	3499232.0
2025-04-10 11:00:00	QQQ	ETF	448.7	450.93	445.85	445.865	3579533.0
2025-04-10 11:30:00	QQQ	ETF	445.88	446.42	440.8015	441.32	5316048.0
2025-04-10 12:00:00	QQQ	ETF	441.31	442.67	432.63	434.9	7510004.0
2025-04-10 12:30:00	QQQ	ETF	434.83	442.6699	434.53	442.15	5694985.0

> showing 50 of 43,639 rows — these rows as CSV

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