PREVIEW / etf_30min / 2025-05-14

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-14.parquet
  size:    977 KB
  rows:    40,024

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-05-14 04:00:00	SPY	ETF	587.46	587.57	586.84	587.06	24690.0
2025-05-14 04:30:00	SPY	ETF	587.01	587.57	587.01	587.09	4681.0
2025-05-14 05:00:00	SPY	ETF	587.04	587.18	586.26	586.93	17850.0
2025-05-14 05:30:00	SPY	ETF	587.0	587.08	586.46	586.46	10785.0
2025-05-14 06:00:00	SPY	ETF	586.46	586.89	586.19	586.89	9365.0
2025-05-14 06:30:00	SPY	ETF	586.82	587.2	586.75	587.01	13155.0
2025-05-14 07:00:00	SPY	ETF	587.01	588.51	586.99	588.51	118391.0
2025-05-14 07:30:00	SPY	ETF	588.52	588.8	587.83	588.11	126928.0
2025-05-14 08:00:00	SPY	ETF	587.74	588.7799	586.8096	588.5099	164265.0
2025-05-14 08:30:00	SPY	ETF	588.53	588.88	587.86	588.0	161641.0
2025-05-14 09:00:00	SPY	ETF	587.97	588.35	587.62	587.8101	201997.0
2025-05-14 09:30:00	SPY	ETF	587.83	588.98	586.46	587.5308	5399469.0
2025-05-14 10:00:00	SPY	ETF	587.54	587.8175	586.39	587.52	3416448.0
2025-05-14 10:30:00	SPY	ETF	587.49	587.91	586.85	587.54	2334607.0
2025-05-14 11:00:00	SPY	ETF	587.54	588.1	585.8	587.86	3192502.0
2025-05-14 11:30:00	SPY	ETF	587.8599	588.35	587.705	588.0002	2015322.0
2025-05-14 12:00:00	SPY	ETF	588.0	588.545	587.69	587.915	1395700.0
2025-05-14 12:30:00	SPY	ETF	587.93	588.5651	587.1	587.4601	1818372.0
2025-05-14 13:00:00	SPY	ETF	587.47	587.51	585.535	586.33	3062271.0
2025-05-14 13:30:00	SPY	ETF	586.32	587.42	586.23	587.3355	1933658.0
2025-05-14 14:00:00	SPY	ETF	587.34	587.695	586.575	586.86	2004001.0
2025-05-14 14:30:00	SPY	ETF	586.87	588.22	586.85	587.625	2628258.0
2025-05-14 15:00:00	SPY	ETF	587.62	587.8	586.4702	587.005	2885105.0
2025-05-14 15:30:00	SPY	ETF	587.0	588.14	586.39	587.56	9607253.0
2025-05-14 16:00:00	SPY	ETF	587.55	587.66	587.15	587.4696	3347312.0
2025-05-14 16:30:00	SPY	ETF	587.4	587.65	587.1001	587.14	1179976.0
2025-05-14 17:00:00	SPY	ETF	587.07	587.24	586.82	586.86	35811.0
2025-05-14 17:30:00	SPY	ETF	586.83	586.83	586.58	586.7	46605.0
2025-05-14 18:00:00	SPY	ETF	586.67	586.86	586.57	586.72	65188.0
2025-05-14 18:30:00	SPY	ETF	586.6516	586.75	586.522	586.65	9514.0
2025-05-14 19:00:00	SPY	ETF	586.68	586.69	585.81	585.9	99374.0
2025-05-14 19:30:00	SPY	ETF	585.86	586.2	585.72	586.13	99652.0
2025-05-14 04:00:00	QQQ	ETF	516.49	516.73	515.35	515.97	69604.0
2025-05-14 04:30:00	QQQ	ETF	516.0	516.34	515.59	515.84	41682.0
2025-05-14 05:00:00	QQQ	ETF	515.71	516.13	514.9	515.88	69384.0
2025-05-14 05:30:00	QQQ	ETF	515.92	515.93	515.45	515.5	23378.0
2025-05-14 06:00:00	QQQ	ETF	515.41	516.08	515.29	516.04	28521.0
2025-05-14 06:30:00	QQQ	ETF	516.13	516.47	516.05	516.25	27250.0
2025-05-14 07:00:00	QQQ	ETF	516.33	518.13	516.24	518.1	167633.0
2025-05-14 07:30:00	QQQ	ETF	518.08	518.4	517.33	517.49	222512.0
2025-05-14 08:00:00	QQQ	ETF	516.4	518.4086	515.204	517.68	256503.0
2025-05-14 08:30:00	QQQ	ETF	517.67	518.0	516.8204	516.97	238796.0
2025-05-14 09:00:00	QQQ	ETF	516.96	517.45	516.67	516.75	311805.0
2025-05-14 09:30:00	QQQ	ETF	516.77	518.92	515.75	517.0992	5731648.0
2025-05-14 10:00:00	QQQ	ETF	517.12	517.85	516.33	517.42	3281641.0
2025-05-14 10:30:00	QQQ	ETF	517.4	518.05	516.73	517.7536	2081585.0
2025-05-14 11:00:00	QQQ	ETF	517.77	518.41	516.11	518.15	2645369.0
2025-05-14 11:30:00	QQQ	ETF	518.14	518.53	517.84	518.2	1755167.0
2025-05-14 12:00:00	QQQ	ETF	518.19	518.7	517.97	518.41	1282743.0
2025-05-14 12:30:00	QQQ	ETF	518.42	519.2279	517.73	517.98	1875833.0

> showing 50 of 40,024 rows — these rows as CSV

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