PREVIEW / etf_30min / 2025-08-18

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-18.parquet
  size:    990 KB
  rows:    41,421

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-08-18 04:00:00	SPY	ETF	642.97	644.26	642.14	642.53	79261.0
2025-08-18 04:30:00	SPY	ETF	642.59	643.16	642.59	642.84	20029.0
2025-08-18 05:00:00	SPY	ETF	642.86	642.86	642.08	642.35	16176.0
2025-08-18 05:30:00	SPY	ETF	642.4	642.57	642.36	642.53	4508.0
2025-08-18 06:00:00	SPY	ETF	642.59	642.7	642.53	642.67	9594.0
2025-08-18 06:30:00	SPY	ETF	642.67	643.06	642.66	642.95	15241.0
2025-08-18 07:00:00	SPY	ETF	642.98	643.04	642.73	642.81	25964.0
2025-08-18 07:30:00	SPY	ETF	642.74	642.93	642.61	642.91	14499.0
2025-08-18 08:00:00	SPY	ETF	642.86	644.55	642.19	642.94	93635.0
2025-08-18 08:30:00	SPY	ETF	642.94	643.1	642.6	643.05	179904.0
2025-08-18 09:00:00	SPY	ETF	643.05	643.28	642.7	642.84	155480.0
2025-08-18 09:30:00	SPY	ETF	642.86	643.8	642.53	642.73	4469855.0
2025-08-18 10:00:00	SPY	ETF	642.73	643.935	642.71	643.0	2701538.0
2025-08-18 10:30:00	SPY	ETF	642.99	643.43	642.3	643.23	2348957.0
2025-08-18 11:00:00	SPY	ETF	643.22	643.44	642.6	642.73	1677524.0
2025-08-18 11:30:00	SPY	ETF	642.73	643.039	642.5	642.7301	1216871.0
2025-08-18 12:00:00	SPY	ETF	642.73	643.28	642.69	643.12	1189785.0
2025-08-18 12:30:00	SPY	ETF	643.1234	643.36	642.18	642.51	1373804.0
2025-08-18 13:00:00	SPY	ETF	642.51	643.2	642.48	643.169	1168518.0
2025-08-18 13:30:00	SPY	ETF	643.165	643.815	642.6514	642.7894	1841067.0
2025-08-18 14:00:00	SPY	ETF	642.79	643.01	642.44	642.76	1448756.0
2025-08-18 14:30:00	SPY	ETF	642.75	643.56	642.74	643.43	2028411.0
2025-08-18 15:00:00	SPY	ETF	643.43	643.56	643.0601	643.255	1891226.0
2025-08-18 15:30:00	SPY	ETF	643.25	644.0	643.145	643.27	4964638.0
2025-08-18 16:00:00	SPY	ETF	643.28	643.47	643.01	643.16	1468782.0
2025-08-18 16:30:00	SPY	ETF	643.15	643.33	643.0996	643.13	123764.0
2025-08-18 17:00:00	SPY	ETF	643.11	643.2797	643.11	643.22	18008.0
2025-08-18 17:30:00	SPY	ETF	643.22	643.24	643.11	643.22	17774.0
2025-08-18 18:00:00	SPY	ETF	643.28	644.16	643.28	643.61	73245.0
2025-08-18 18:30:00	SPY	ETF	643.66	643.8496	643.5702	643.78	37980.0
2025-08-18 19:00:00	SPY	ETF	643.85	643.85	643.63	643.73	7898.0
2025-08-18 19:30:00	SPY	ETF	643.66	643.66	643.38	643.55	8449.0
2025-08-18 04:00:00	QQQ	ETF	577.25	577.44	575.9	576.33	19432.0
2025-08-18 04:30:00	QQQ	ETF	576.46	577.08	576.46	576.64	28644.0
2025-08-18 05:00:00	QQQ	ETF	576.72	576.72	575.82	576.04	11051.0
2025-08-18 05:30:00	QQQ	ETF	576.19	576.32	576.105	576.3	4430.0
2025-08-18 06:00:00	QQQ	ETF	576.25	576.6	576.2	576.39	6191.0
2025-08-18 06:30:00	QQQ	ETF	576.5	576.96	576.49	576.87	17886.0
2025-08-18 07:00:00	QQQ	ETF	576.91	576.99	576.24	576.35	22953.0
2025-08-18 07:30:00	QQQ	ETF	576.33	576.53	575.94	576.53	18492.0
2025-08-18 08:00:00	QQQ	ETF	576.86	578.65	575.92	576.48	102483.0
2025-08-18 08:30:00	QQQ	ETF	576.43	576.61	576.05	576.57	57415.0
2025-08-18 09:00:00	QQQ	ETF	576.55	576.89	576.17	576.4	96473.0
2025-08-18 09:30:00	QQQ	ETF	576.44	577.6	575.645	575.95	3559398.0
2025-08-18 10:00:00	QQQ	ETF	575.96	577.765	575.91	576.6	2327310.0
2025-08-18 10:30:00	QQQ	ETF	576.6	576.9	575.2412	576.64	2076656.0
2025-08-18 11:00:00	QQQ	ETF	576.652	576.8	575.71	575.8496	1431828.0
2025-08-18 11:30:00	QQQ	ETF	575.85	576.2	575.48	575.92	1161194.0
2025-08-18 12:00:00	QQQ	ETF	575.91	576.64	575.86	576.45	1025259.0
2025-08-18 12:30:00	QQQ	ETF	576.46	576.71	575.34	575.62	1087173.0

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

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