PREVIEW / etf_30min / 2025-04-09

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-09.parquet
  size:    1.1 MB
  rows:    46,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-09 04:00:00	SPY	ETF	490.62	499.72	489.22	494.82	276047.0
2025-04-09 04:30:00	SPY	ETF	494.81	498.17	492.15	498.04	166566.0
2025-04-09 05:00:00	SPY	ETF	498.03	499.05	496.63	497.5	98616.0
2025-04-09 05:30:00	SPY	ETF	497.76	497.99	494.55	495.64	51903.0
2025-04-09 06:00:00	SPY	ETF	495.19	496.34	492.31	493.55	129450.0
2025-04-09 06:30:00	SPY	ETF	493.57	498.25	491.99	494.7	363002.0
2025-04-09 07:00:00	SPY	ETF	494.72	494.99	487.35	490.54	1569450.0
2025-04-09 07:30:00	SPY	ETF	490.64	493.18	485.28	487.71	1177669.0
2025-04-09 08:00:00	SPY	ETF	492.82	500.0	482.86	487.07	1174696.0
2025-04-09 08:30:00	SPY	ETF	486.96	494.07	486.11	491.34	1232009.0
2025-04-09 09:00:00	SPY	ETF	491.42	496.7	491.09	493.41	1927710.0
2025-04-09 09:30:00	SPY	ETF	493.44	502.04	493.41	499.85	12621012.0
2025-04-09 10:00:00	SPY	ETF	499.86	503.67	496.67	498.97	7376840.0
2025-04-09 10:30:00	SPY	ETF	499.07	501.68	493.0904	493.2084	6315589.0
2025-04-09 11:00:00	SPY	ETF	493.22	499.71	493.05	498.28	4644640.0
2025-04-09 11:30:00	SPY	ETF	498.29	499.59	494.83	495.975	3903864.0
2025-04-09 12:00:00	SPY	ETF	495.95	500.55	494.77	499.26	2739189.0
2025-04-09 12:30:00	SPY	ETF	499.19	502.58	498.65	501.2	3234080.0
2025-04-09 13:00:00	SPY	ETF	501.25	533.4	497.56	523.96	29487058.0
2025-04-09 13:30:00	SPY	ETF	524.02	536.5	522.95	534.87	22256534.0
2025-04-09 14:00:00	SPY	ETF	534.925	539.71	531.11	538.15	13515477.0
2025-04-09 14:30:00	SPY	ETF	538.16	539.87	530.59	530.93	10409314.0
2025-04-09 15:00:00	SPY	ETF	530.91	541.78	529.68	540.49	11150839.0
2025-04-09 15:30:00	SPY	ETF	540.45	546.33	539.54	543.37	23420145.0
2025-04-09 16:00:00	SPY	ETF	543.48	548.62	541.8	544.87	14803977.0
2025-04-09 16:30:00	SPY	ETF	544.79	546.13	543.7334	545.82	1000316.0
2025-04-09 17:00:00	SPY	ETF	545.82	546.3	545.37	545.45	300733.0
2025-04-09 17:30:00	SPY	ETF	545.41	545.5	543.52	544.3701	136549.0
2025-04-09 18:00:00	SPY	ETF	544.43	546.0	543.5214	545.85	362692.0
2025-04-09 18:30:00	SPY	ETF	545.89	546.231	545.25	546.2	185974.0
2025-04-09 19:00:00	SPY	ETF	546.29	547.07	545.5	545.78	102425.0
2025-04-09 19:30:00	SPY	ETF	545.78	546.21	545.36	545.9	72309.0
2025-04-09 04:00:00	QQQ	ETF	418.66	420.53	416.25	416.4	181987.0
2025-04-09 04:30:00	QQQ	ETF	416.41	419.43	413.67	419.11	173833.0
2025-04-09 05:00:00	QQQ	ETF	419.12	420.05	417.38	418.22	113852.0
2025-04-09 05:30:00	QQQ	ETF	418.55	419.01	416.0	416.98	86895.0
2025-04-09 06:00:00	QQQ	ETF	416.75	417.69	414.28	415.27	133862.0
2025-04-09 06:30:00	QQQ	ETF	415.42	419.47	413.76	416.44	411404.0
2025-04-09 07:00:00	QQQ	ETF	416.39	416.82	409.31	412.45	869310.0
2025-04-09 07:30:00	QQQ	ETF	412.53	413.64	407.39	409.65	459955.0
2025-04-09 08:00:00	QQQ	ETF	415.23	420.42	404.44	409.5	909886.0
2025-04-09 08:30:00	QQQ	ETF	409.32	415.78	408.15	413.59	732206.0
2025-04-09 09:00:00	QQQ	ETF	413.73	417.75	413.5	415.46	845709.0
2025-04-09 09:30:00	QQQ	ETF	415.49	423.97	415.43	421.29	8168873.0
2025-04-09 10:00:00	QQQ	ETF	421.31	424.94	418.57	421.28	4855612.0
2025-04-09 10:30:00	QQQ	ETF	421.31	423.86	415.74	415.8701	4207041.0
2025-04-09 11:00:00	QQQ	ETF	415.86	421.6	415.6	420.05	2829538.0
2025-04-09 11:30:00	QQQ	ETF	420.06	421.13	416.8474	418.161	2989330.0
2025-04-09 12:00:00	QQQ	ETF	418.18	422.64	417.21	421.47	2243889.0
2025-04-09 12:30:00	QQQ	ETF	421.455	424.42	420.87	423.26	2509365.0

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

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