PREVIEW / etf_30min / 2024-12-24

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-24.parquet
  size:    595 KB
  rows:    22,904

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
2024-12-24 04:00:00	SPY	ETF	595.05	595.71	595.0	595.47	5775.0
2024-12-24 04:30:00	SPY	ETF	595.28	595.75	595.28	595.69	2052.0
2024-12-24 05:00:00	SPY	ETF	595.8	595.8	595.58	595.58	4309.0
2024-12-24 05:30:00	SPY	ETF	595.65	595.67	595.4	595.67	4104.0
2024-12-24 06:00:00	SPY	ETF	595.66	595.79	595.45	595.48	5020.0
2024-12-24 06:30:00	SPY	ETF	595.44	595.47	595.1	595.3	1743.0
2024-12-24 07:00:00	SPY	ETF	595.26	595.59	595.2	595.43	32118.0
2024-12-24 07:30:00	SPY	ETF	595.5	595.68	595.32	595.68	23641.0
2024-12-24 08:00:00	SPY	ETF	595.37	595.6492	594.5	595.53	41311.0
2024-12-24 08:30:00	SPY	ETF	595.58	595.83	595.42	595.76	109902.0
2024-12-24 09:00:00	SPY	ETF	595.75	596.37	595.71	596.03	153204.0
2024-12-24 09:30:00	SPY	ETF	596.05	597.28	595.47	597.2	2356971.0
2024-12-24 10:00:00	SPY	ETF	597.2	598.34	597.2	598.2	2064072.0
2024-12-24 10:30:00	SPY	ETF	598.23	599.3701	598.16	599.18	1529722.0
2024-12-24 11:00:00	SPY	ETF	599.17	599.37	598.8	599.25	999845.0
2024-12-24 11:30:00	SPY	ETF	599.24	599.81	598.84	599.0117	1536020.0
2024-12-24 12:00:00	SPY	ETF	599.04	600.33	598.9	600.1601	1834977.0
2024-12-24 12:30:00	SPY	ETF	600.17	601.34	599.15	601.26	5767229.0
2024-12-24 13:00:00	SPY	ETF	601.23	602.2	600.78	601.02	2109865.0
2024-12-24 13:30:00	SPY	ETF	601.02	601.45	601.02	601.45	968629.0
2024-12-24 14:00:00	SPY	ETF	601.46	601.46	601.15	601.45	57761.0
2024-12-24 14:30:00	SPY	ETF	601.46	601.54	601.45	601.5	20323.0
2024-12-24 15:00:00	SPY	ETF	601.55	601.55	601.3	601.33	8216.0
2024-12-24 15:30:00	SPY	ETF	601.3	601.38	601.01	601.06	25091.0
2024-12-24 16:00:00	SPY	ETF	601.08	601.2	601.08	601.2	19401.0
2024-12-24 16:30:00	SPY	ETF	601.2	601.2	601.07	601.1	21589.0
2024-12-24 04:00:00	QQQ	ETF	523.24	524.04	523.09	523.78	28147.0
2024-12-24 04:30:00	QQQ	ETF	523.56	524.0	523.56	524.0	4758.0
2024-12-24 05:00:00	QQQ	ETF	524.14	524.27	523.87	524.05	5524.0
2024-12-24 05:30:00	QQQ	ETF	523.97	524.1	523.65	524.1	3908.0
2024-12-24 06:00:00	QQQ	ETF	524.14	524.22	523.7	523.86	21633.0
2024-12-24 06:30:00	QQQ	ETF	523.89	523.89	523.33	523.79	7417.0
2024-12-24 07:00:00	QQQ	ETF	523.77	524.2	523.67	523.98	28841.0
2024-12-24 07:30:00	QQQ	ETF	524.04	524.14	523.82	524.13	26756.0
2024-12-24 08:00:00	QQQ	ETF	523.86	524.24	522.65	524.18	78303.0
2024-12-24 08:30:00	QQQ	ETF	524.17	524.8	524.04	524.77	142855.0
2024-12-24 09:00:00	QQQ	ETF	524.75	525.24	524.48	524.8	138168.0
2024-12-24 09:30:00	QQQ	ETF	524.83	526.74	524.19	526.66	1767356.0
2024-12-24 10:00:00	QQQ	ETF	526.67	527.58	526.54	527.2	1528590.0
2024-12-24 10:30:00	QQQ	ETF	527.19	528.23	527.165	528.08	1242732.0
2024-12-24 11:00:00	QQQ	ETF	528.0738	528.67	527.8542	528.4624	1059532.0
2024-12-24 11:30:00	QQQ	ETF	528.46	528.93	527.95	528.1482	1072356.0
2024-12-24 12:00:00	QQQ	ETF	528.19	529.08	528.04	528.88	851371.0
2024-12-24 12:30:00	QQQ	ETF	528.86	530.05	527.72	530.02	2634403.0
2024-12-24 13:00:00	QQQ	ETF	530.0	530.35	529.8	529.9684	898945.0
2024-12-24 13:30:00	QQQ	ETF	529.97	530.1	529.9	530.1	279687.0
2024-12-24 14:00:00	QQQ	ETF	530.0	530.16	529.91	530.0	20392.0
2024-12-24 14:30:00	QQQ	ETF	529.95	530.06	529.93	529.96	3935.0
2024-12-24 15:00:00	QQQ	ETF	529.9201	530.0331	529.9	529.95	4295.0
2024-12-24 15:30:00	QQQ	ETF	530.0	530.01	529.71	529.88	13481.0

> showing 50 of 22,904 rows — these rows as CSV

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