PREVIEW / etf_30min / 2025-07-14

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-14.parquet
  size:    1003 KB
  rows:    41,741

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-07-14 04:00:00	SPY	ETF	621.42	621.42	621.1	621.12	32327.0
2025-07-14 04:30:00	SPY	ETF	621.12	621.91	621.12	621.67	12381.0
2025-07-14 05:00:00	SPY	ETF	621.65	622.08	621.63	621.93	15108.0
2025-07-14 05:30:00	SPY	ETF	621.96	622.09	621.86	622.08	23240.0
2025-07-14 06:00:00	SPY	ETF	622.05	622.1	621.74	621.75	32390.0
2025-07-14 06:30:00	SPY	ETF	621.82	621.93	621.63	621.69	27001.0
2025-07-14 07:00:00	SPY	ETF	621.74	622.1	621.47	621.53	66736.0
2025-07-14 07:30:00	SPY	ETF	621.55	622.31	621.55	621.88	67201.0
2025-07-14 08:00:00	SPY	ETF	621.86	622.31	620.0	622.31	128435.0
2025-07-14 08:30:00	SPY	ETF	622.29	622.3	621.84	622.0	157948.0
2025-07-14 09:00:00	SPY	ETF	622.02	623.21	621.77	623.2	209734.0
2025-07-14 09:30:00	SPY	ETF	623.17	623.46	621.8	622.67	5430138.0
2025-07-14 10:00:00	SPY	ETF	622.67	623.71	622.26	622.6916	3493941.0
2025-07-14 10:30:00	SPY	ETF	622.68	623.52	622.37	623.48	2987019.0
2025-07-14 11:00:00	SPY	ETF	623.47	624.14	623.2801	624.13	2886300.0
2025-07-14 11:30:00	SPY	ETF	624.13	624.39	623.77	623.95	2402491.0
2025-07-14 12:00:00	SPY	ETF	623.94	624.32	623.81	623.885	1465090.0
2025-07-14 12:30:00	SPY	ETF	623.87	624.48	623.63	624.28	1850696.0
2025-07-14 13:00:00	SPY	ETF	624.285	624.97	624.28	624.7	2043392.0
2025-07-14 13:30:00	SPY	ETF	624.71	624.98	624.425	624.68	1749098.0
2025-07-14 14:00:00	SPY	ETF	624.68	625.0	624.595	624.95	1533973.0
2025-07-14 14:30:00	SPY	ETF	624.96	625.1581	624.91	624.94	1589284.0
2025-07-14 15:00:00	SPY	ETF	624.94	625.12	624.46	624.73	2665320.0
2025-07-14 15:30:00	SPY	ETF	624.73	624.99	624.3	624.74	6156838.0
2025-07-14 16:00:00	SPY	ETF	624.73	624.87	624.39	624.39	1708198.0
2025-07-14 16:30:00	SPY	ETF	624.4	624.65	624.39	624.6	121121.0
2025-07-14 17:00:00	SPY	ETF	624.52	624.65	624.49	624.53	17200.0
2025-07-14 17:30:00	SPY	ETF	624.5726	624.77	624.44	624.66	43123.0
2025-07-14 18:00:00	SPY	ETF	624.55	624.55	623.92	623.9887	36234.0
2025-07-14 18:30:00	SPY	ETF	624.02	624.14	623.85	623.91	20594.0
2025-07-14 19:00:00	SPY	ETF	623.93	624.0	623.81	623.96	30427.0
2025-07-14 19:30:00	SPY	ETF	623.96	624.17	623.93	624.12	9594.0
2025-07-14 04:00:00	QQQ	ETF	552.51	552.88	552.16	552.21	25648.0
2025-07-14 04:30:00	QQQ	ETF	552.21	552.93	552.16	552.65	56708.0
2025-07-14 05:00:00	QQQ	ETF	552.66	552.88	552.5	552.83	17597.0
2025-07-14 05:30:00	QQQ	ETF	552.81	553.05	552.73	552.96	15484.0
2025-07-14 06:00:00	QQQ	ETF	552.93	552.98	552.53	552.55	22268.0
2025-07-14 06:30:00	QQQ	ETF	552.57	552.66	552.28	552.4	26969.0
2025-07-14 07:00:00	QQQ	ETF	552.5	552.8	552.16	552.26	31014.0
2025-07-14 07:30:00	QQQ	ETF	552.33	553.0	552.26	552.71	42026.0
2025-07-14 08:00:00	QQQ	ETF	552.61	554.615	550.8	553.16	162609.0
2025-07-14 08:30:00	QQQ	ETF	553.17	553.19	552.68	552.91	57987.0
2025-07-14 09:00:00	QQQ	ETF	552.91	554.04	552.72	554.04	136481.0
2025-07-14 09:30:00	QQQ	ETF	554.0	554.87	551.63	553.27	4675885.0
2025-07-14 10:00:00	QQQ	ETF	553.28	555.08	553.15	553.9452	2706956.0
2025-07-14 10:30:00	QQQ	ETF	553.91	555.18	553.54	555.17	1823584.0
2025-07-14 11:00:00	QQQ	ETF	555.16	555.9199	555.01	555.6552	2227084.0
2025-07-14 11:30:00	QQQ	ETF	555.66	555.74	555.2	555.5801	1368228.0
2025-07-14 12:00:00	QQQ	ETF	555.57	556.06	555.36	555.725	1076638.0
2025-07-14 12:30:00	QQQ	ETF	555.72	556.32	555.48	556.16	1276897.0

> showing 50 of 41,741 rows — these rows as CSV

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