PREVIEW / etf_30min / 2025-04-17

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-17.parquet
  size:    962 KB
  rows:    39,207

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-17 04:00:00	SPY	ETF	531.5	531.5	530.77	531.5	18362.0
2025-04-17 04:30:00	SPY	ETF	531.3	531.3	529.86	530.04	24887.0
2025-04-17 05:00:00	SPY	ETF	529.8	531.16	529.59	530.7	21372.0
2025-04-17 05:30:00	SPY	ETF	530.82	531.05	530.25	530.38	10427.0
2025-04-17 06:00:00	SPY	ETF	530.26	530.32	528.34	528.97	107615.0
2025-04-17 06:30:00	SPY	ETF	528.95	529.11	527.68	528.33	91791.0
2025-04-17 07:00:00	SPY	ETF	528.4	528.79	527.19	528.3	86318.0
2025-04-17 07:30:00	SPY	ETF	528.34	528.54	527.43	528.25	73193.0
2025-04-17 08:00:00	SPY	ETF	528.36	532.31	527.2104	528.55	555849.0
2025-04-17 08:30:00	SPY	ETF	528.71	530.0	528.36	528.83	163831.0
2025-04-17 09:00:00	SPY	ETF	528.7	529.15	527.06	527.65	577194.0
2025-04-17 09:30:00	SPY	ETF	527.66	529.31	526.36	528.74	4336885.0
2025-04-17 10:00:00	SPY	ETF	528.68	529.15	525.1601	525.28	2694749.0
2025-04-17 10:30:00	SPY	ETF	525.28	526.2586	523.91	525.08	2729363.0
2025-04-17 11:00:00	SPY	ETF	525.09	528.85	525.025	526.71	2382985.0
2025-04-17 11:30:00	SPY	ETF	526.71	528.6	526.48	526.76	1544646.0
2025-04-17 12:00:00	SPY	ETF	526.76	529.87	526.22	529.45	5001505.0
2025-04-17 12:30:00	SPY	ETF	529.45	530.41	527.77	529.9105	2409449.0
2025-04-17 13:00:00	SPY	ETF	529.92	530.3386	527.61	527.68	1195616.0
2025-04-17 13:30:00	SPY	ETF	527.69	530.3285	527.67	529.57	1517712.0
2025-04-17 14:00:00	SPY	ETF	529.5796	531.165	529.36	530.02	2150172.0
2025-04-17 14:30:00	SPY	ETF	530.02	530.92	528.52	528.52	2549787.0
2025-04-17 15:00:00	SPY	ETF	528.54	528.8	526.63	527.31	2951066.0
2025-04-17 15:30:00	SPY	ETF	527.36	528.51	525.71	526.39	6400541.0
2025-04-17 16:00:00	SPY	ETF	526.37	528.1203	526.18	526.82	4342945.0
2025-04-17 16:30:00	SPY	ETF	526.83	528.37	526.41	527.79	550550.0
2025-04-17 17:00:00	SPY	ETF	527.9	528.0	527.0	527.12	79295.0
2025-04-17 17:30:00	SPY	ETF	527.24	527.4	526.65	526.7	59800.0
2025-04-17 18:00:00	SPY	ETF	526.6701	526.7913	526.49	526.5	401730.0
2025-04-17 18:30:00	SPY	ETF	526.56	526.68	526.41	526.68	45596.0
2025-04-17 19:00:00	SPY	ETF	526.68	527.13	526.68	527.1001	25583.0
2025-04-17 19:30:00	SPY	ETF	527.13	527.21	526.87	527.1	15860.0
2025-04-17 04:00:00	QQQ	ETF	450.08	450.08	449.22	449.73	27671.0
2025-04-17 04:30:00	QQQ	ETF	449.61	449.84	448.05	448.05	14100.0
2025-04-17 05:00:00	QQQ	ETF	448.15	449.39	447.83	448.97	29170.0
2025-04-17 05:30:00	QQQ	ETF	448.97	449.16	448.59	449.11	6518.0
2025-04-17 06:00:00	QQQ	ETF	449.1	449.15	448.05	448.53	32363.0
2025-04-17 06:30:00	QQQ	ETF	448.5	448.68	447.18	447.47	30449.0
2025-04-17 07:00:00	QQQ	ETF	447.39	447.67	446.18	447.47	79302.0
2025-04-17 07:30:00	QQQ	ETF	447.45	447.9	446.96	447.5	60897.0
2025-04-17 08:00:00	QQQ	ETF	447.38	450.61	446.2393	447.88	346017.0
2025-04-17 08:30:00	QQQ	ETF	447.94	449.32	447.75	447.95	189083.0
2025-04-17 09:00:00	QQQ	ETF	447.77	448.25	446.48	447.18	310520.0
2025-04-17 09:30:00	QQQ	ETF	447.17	447.37	444.18	446.355	3109352.0
2025-04-17 10:00:00	QQQ	ETF	446.34	446.8566	442.7	442.8013	2460318.0
2025-04-17 10:30:00	QQQ	ETF	442.79	443.89	441.36	442.36	2126428.0
2025-04-17 11:00:00	QQQ	ETF	442.37	445.75	442.09	443.2413	1907226.0
2025-04-17 11:30:00	QQQ	ETF	443.29	445.24	442.85	443.3	1496237.0
2025-04-17 12:00:00	QQQ	ETF	443.28	446.32	442.72	445.82	2326567.0
2025-04-17 12:30:00	QQQ	ETF	445.82	446.6264	444.04	446.07	1422003.0

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

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