PREVIEW / etf_30min / 2025-02-05

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-02-05.parquet
  size:    956 KB
  rows:    38,424

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-02-05 04:00:00	SPY	ETF	598.43	599.18	598.16	598.49	21104.0
2025-02-05 04:30:00	SPY	ETF	598.34	598.4	597.7	597.78	14495.0
2025-02-05 05:00:00	SPY	ETF	597.66	598.53	597.66	598.53	7174.0
2025-02-05 05:30:00	SPY	ETF	598.42	598.74	598.42	598.64	5074.0
2025-02-05 06:00:00	SPY	ETF	598.7	599.15	598.7	599.0	5363.0
2025-02-05 06:30:00	SPY	ETF	599.0	599.28	598.95	599.22	12243.0
2025-02-05 07:00:00	SPY	ETF	599.18	599.3	598.79	599.18	29823.0
2025-02-05 07:30:00	SPY	ETF	599.15	599.52	599.08	599.48	48797.0
2025-02-05 08:00:00	SPY	ETF	598.96	599.71	598.36	599.67	93151.0
2025-02-05 08:30:00	SPY	ETF	599.7	600.49	599.4	599.9906	113668.0
2025-02-05 09:00:00	SPY	ETF	600.0	600.76	599.8	600.64	158648.0
2025-02-05 09:30:00	SPY	ETF	600.64	601.09	599.47	600.12	2264111.0
2025-02-05 10:00:00	SPY	ETF	600.12	601.1	598.58	600.63	2345676.0
2025-02-05 10:30:00	SPY	ETF	600.62	600.99	599.77	600.585	1124484.0
2025-02-05 11:00:00	SPY	ETF	600.57	601.4	600.135	601.27	914176.0
2025-02-05 11:30:00	SPY	ETF	601.24	602.88	601.125	602.65	2122012.0
2025-02-05 12:00:00	SPY	ETF	602.64	603.17	602.33	602.49	1115954.0
2025-02-05 12:30:00	SPY	ETF	602.5	602.85	602.32	602.67	496563.0
2025-02-05 13:00:00	SPY	ETF	602.675	602.9	602.21	602.566	460025.0
2025-02-05 13:30:00	SPY	ETF	602.56	603.4	602.39	602.93	675525.0
2025-02-05 14:00:00	SPY	ETF	602.92	603.635	602.91	603.27	752989.0
2025-02-05 14:30:00	SPY	ETF	603.29	603.41	602.88	603.0699	814817.0
2025-02-05 15:00:00	SPY	ETF	603.07	603.97	603.03	603.73	1440304.0
2025-02-05 15:30:00	SPY	ETF	603.72	604.37	602.91	604.17	3571399.0
2025-02-05 16:00:00	SPY	ETF	604.15	604.72	603.95	604.44	2524907.0
2025-02-05 16:30:00	SPY	ETF	604.41	604.59	602.0031	604.52	116257.0
2025-02-05 17:00:00	SPY	ETF	604.57	604.65	604.383	604.58	39645.0
2025-02-05 17:30:00	SPY	ETF	604.58	604.6	604.35	604.45	16186.0
2025-02-05 18:00:00	SPY	ETF	604.45	604.5	604.28	604.5	24274.0
2025-02-05 18:30:00	SPY	ETF	604.35	604.56	604.26	604.5	15321.0
2025-02-05 19:00:00	SPY	ETF	604.54	605.07	604.54	604.97	18680.0
2025-02-05 19:30:00	SPY	ETF	605.04	605.04	604.54	604.74	32435.0
2025-02-05 04:00:00	QQQ	ETF	519.82	520.65	519.56	519.92	46195.0
2025-02-05 04:30:00	QQQ	ETF	519.67	519.72	519.01	519.1	29416.0
2025-02-05 05:00:00	QQQ	ETF	518.98	519.88	518.89	519.77	18849.0
2025-02-05 05:30:00	QQQ	ETF	519.72	520.1	519.65	520.06	10187.0
2025-02-05 06:00:00	QQQ	ETF	520.03	520.37	520.0	520.25	26732.0
2025-02-05 06:30:00	QQQ	ETF	520.26	520.5	520.02	520.42	45021.0
2025-02-05 07:00:00	QQQ	ETF	520.45	520.55	519.88	520.55	52666.0
2025-02-05 07:30:00	QQQ	ETF	520.51	520.9	520.3	520.86	43630.0
2025-02-05 08:00:00	QQQ	ETF	520.4	524.077	519.163	521.23	148118.0
2025-02-05 08:30:00	QQQ	ETF	521.24	521.7	520.8	521.26	134615.0
2025-02-05 09:00:00	QQQ	ETF	521.28	521.9	520.83	521.88	165749.0
2025-02-05 09:30:00	QQQ	ETF	521.82	522.73	521.04	522.1	2959559.0
2025-02-05 10:00:00	QQQ	ETF	522.26	523.25	520.62	522.54	1879136.0
2025-02-05 10:30:00	QQQ	ETF	522.5	523.05	521.69	522.7648	775618.0
2025-02-05 11:00:00	QQQ	ETF	522.75	523.74	522.1	523.49	1064884.0
2025-02-05 11:30:00	QQQ	ETF	523.45	525.81	523.3	525.595	1202550.0
2025-02-05 12:00:00	QQQ	ETF	525.64	526.36	525.3301	525.52	959639.0
2025-02-05 12:30:00	QQQ	ETF	525.5451	525.8	525.0	525.47	524668.0

> showing 50 of 38,424 rows — these rows as CSV

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