PREVIEW / etf_30min / 2025-06-10

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-10.parquet
  size:    966 KB
  rows:    39,522

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-06-10 04:00:00	SPY	ETF	599.83	599.83	598.34	599.0	32207.0
2025-06-10 04:30:00	SPY	ETF	599.15	599.56	599.13	599.45	29971.0
2025-06-10 05:00:00	SPY	ETF	599.46	599.89	599.33	599.87	20876.0
2025-06-10 05:30:00	SPY	ETF	599.91	599.97	599.67	599.81	8370.0
2025-06-10 06:00:00	SPY	ETF	599.76	600.31	599.76	600.07	14743.0
2025-06-10 06:30:00	SPY	ETF	600.1	600.15	599.9	600.15	13716.0
2025-06-10 07:00:00	SPY	ETF	600.17	600.2	599.36	599.75	24104.0
2025-06-10 07:30:00	SPY	ETF	599.78	600.5	599.78	600.5	55696.0
2025-06-10 08:00:00	SPY	ETF	600.0	602.13	597.83	600.51	159796.0
2025-06-10 08:30:00	SPY	ETF	600.57	600.79	600.3501	600.48	56486.0
2025-06-10 09:00:00	SPY	ETF	600.49	600.61	600.05	600.23	156723.0
2025-06-10 09:30:00	SPY	ETF	600.22	601.13	600.16	600.57	4024707.0
2025-06-10 10:00:00	SPY	ETF	600.57	601.2699	600.51	601.19	2525815.0
2025-06-10 10:30:00	SPY	ETF	601.2	601.81	601.0001	601.06	2644468.0
2025-06-10 11:00:00	SPY	ETF	601.07	601.49	600.88	601.175	2386255.0
2025-06-10 11:30:00	SPY	ETF	601.16	601.285	599.09	601.27	4696014.0
2025-06-10 12:00:00	SPY	ETF	601.26	601.98	601.225	601.8791	2378911.0
2025-06-10 12:30:00	SPY	ETF	601.88	602.29	601.74	602.17	1932716.0
2025-06-10 13:00:00	SPY	ETF	602.17	602.67	601.72	601.91	2467505.0
2025-06-10 13:30:00	SPY	ETF	601.905	602.0088	601.27	601.32	2122040.0
2025-06-10 14:00:00	SPY	ETF	601.33	601.33	600.12	600.925	3888167.0
2025-06-10 14:30:00	SPY	ETF	600.92	602.89	600.85	602.4009	3669184.0
2025-06-10 15:00:00	SPY	ETF	602.4	603.47	602.31	602.632	4318096.0
2025-06-10 15:30:00	SPY	ETF	602.63	603.23	601.61	603.06	8241547.0
2025-06-10 16:00:00	SPY	ETF	603.05	603.08	602.21	602.54	2634939.0
2025-06-10 16:30:00	SPY	ETF	602.51	602.75	602.51	602.64	190718.0
2025-06-10 17:00:00	SPY	ETF	602.63	602.78	602.5	602.51	74220.0
2025-06-10 17:30:00	SPY	ETF	602.52	602.59	602.5	602.5	28566.0
2025-06-10 18:00:00	SPY	ETF	602.57	602.76	602.55	602.63	30306.0
2025-06-10 18:30:00	SPY	ETF	602.51	603.25	602.44	603.14	25110.0
2025-06-10 19:00:00	SPY	ETF	603.05	603.7	601.85	603.2	64029.0
2025-06-10 19:30:00	SPY	ETF	603.14	603.14	602.38	602.7	43244.0
2025-06-10 04:00:00	QQQ	ETF	534.04	534.04	529.41	530.11	29231.0
2025-06-10 04:30:00	QQQ	ETF	530.3	530.8	530.28	530.56	14078.0
2025-06-10 05:00:00	QQQ	ETF	530.64	531.21	530.47	531.16	28198.0
2025-06-10 05:30:00	QQQ	ETF	531.25	531.25	530.91	531.13	18775.0
2025-06-10 06:00:00	QQQ	ETF	531.24	531.66	531.15	531.25	12055.0
2025-06-10 06:30:00	QQQ	ETF	531.35	531.38	531.0	531.23	50009.0
2025-06-10 07:00:00	QQQ	ETF	531.27	531.39	530.4	530.91	32501.0
2025-06-10 07:30:00	QQQ	ETF	530.91	531.68	530.88	531.68	24576.0
2025-06-10 08:00:00	QQQ	ETF	531.33	533.5	528.96	531.7	161625.0
2025-06-10 08:30:00	QQQ	ETF	531.73	531.88	531.44	531.68	69363.0
2025-06-10 09:00:00	QQQ	ETF	531.62	531.8	531.0	531.16	100935.0
2025-06-10 09:30:00	QQQ	ETF	531.17	532.54	530.75	531.68	3708997.0
2025-06-10 10:00:00	QQQ	ETF	531.68	532.27	531.47	532.07	1626070.0
2025-06-10 10:30:00	QQQ	ETF	532.07	532.44	531.5	531.58	1527928.0
2025-06-10 11:00:00	QQQ	ETF	531.58	532.18	531.38	531.67	1372468.0
2025-06-10 11:30:00	QQQ	ETF	531.675	532.12	528.89	532.07	3689226.0
2025-06-10 12:00:00	QQQ	ETF	532.07	533.06	532.01	532.865	1996358.0
2025-06-10 12:30:00	QQQ	ETF	532.88	533.02	532.51	532.8901	1245425.0

> showing 50 of 39,522 rows — these rows as CSV

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