PREVIEW / etf_30min / 2025-12-18

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-12-18.parquet
  size:    1.1 MB
  rows:    45,358

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-12-18 04:00:00	SPY	ETF	673.05	673.66	673.05	673.62	13669.0
2025-12-18 04:30:00	SPY	ETF	673.65	674.35	673.65	674.33	56580.0
2025-12-18 05:00:00	SPY	ETF	674.38	674.41	673.95	674.15	31807.0
2025-12-18 05:30:00	SPY	ETF	674.17	674.5	674.01	674.19	23869.0
2025-12-18 06:00:00	SPY	ETF	674.24	674.66	674.09	674.52	30825.0
2025-12-18 06:30:00	SPY	ETF	674.5	674.86	674.4	674.79	96032.0
2025-12-18 07:00:00	SPY	ETF	674.71	674.89	674.33	674.38	115859.0
2025-12-18 07:30:00	SPY	ETF	674.33	674.55	674.04	674.17	147385.0
2025-12-18 08:00:00	SPY	ETF	674.66	674.85	671.89	674.56	328243.0
2025-12-18 08:30:00	SPY	ETF	674.67	677.49	674.56	676.55	1051889.0
2025-12-18 09:00:00	SPY	ETF	676.51	677.67	676.48	677.62	369377.0
2025-12-18 09:30:00	SPY	ETF	677.6	678.59	675.69	678.06	10686159.0
2025-12-18 10:00:00	SPY	ETF	678.06	679.11	676.14	679.01	6523740.0
2025-12-18 10:30:00	SPY	ETF	679.01	680.6	678.68	680.03	6782506.0
2025-12-18 11:00:00	SPY	ETF	680.03	680.74	679.52	679.745	3658067.0
2025-12-18 11:30:00	SPY	ETF	679.74	680.71	679.325	679.56	3912485.0
2025-12-18 12:00:00	SPY	ETF	679.55	679.5707	674.9	675.78	9193253.0
2025-12-18 12:30:00	SPY	ETF	675.79	678.69	675.48	678.37	5770195.0
2025-12-18 13:00:00	SPY	ETF	678.36	679.09	677.58	678.825	3326640.0
2025-12-18 13:30:00	SPY	ETF	678.83	679.7	678.04	678.275	3554583.0
2025-12-18 14:00:00	SPY	ETF	678.23	678.31	676.59	677.15	5806322.0
2025-12-18 14:30:00	SPY	ETF	677.16	677.31	675.32	675.72	5008732.0
2025-12-18 15:00:00	SPY	ETF	675.71	677.85	675.45	677.63	6026338.0
2025-12-18 15:30:00	SPY	ETF	677.62	678.55	676.41	676.48	13155036.0
2025-12-18 16:00:00	SPY	ETF	676.48	676.6025	675.6	676.0	2447555.0
2025-12-18 16:30:00	SPY	ETF	675.98	676.5915	675.72	675.93	275698.0
2025-12-18 17:00:00	SPY	ETF	675.95	676.07	675.9	675.93	96772.0
2025-12-18 17:30:00	SPY	ETF	675.92	676.21	675.71	676.21	46543.0
2025-12-18 18:00:00	SPY	ETF	676.17	676.47	675.61	675.88	121758.0
2025-12-18 18:30:00	SPY	ETF	675.89	676.59	675.8	676.59	29431.0
2025-12-18 19:00:00	SPY	ETF	676.65	676.68	675.979	676.21	17914.0
2025-12-18 19:30:00	SPY	ETF	676.18	676.5	675.96	676.43	13970.0
2025-12-18 04:00:00	QQQ	ETF	603.98	604.71	603.0	604.39	92602.0
2025-12-18 04:30:00	QQQ	ETF	604.41	605.53	604.41	605.5	65978.0
2025-12-18 05:00:00	QQQ	ETF	605.5	605.54	604.8	605.22	46167.0
2025-12-18 05:30:00	QQQ	ETF	605.23	605.56	604.85	605.09	32934.0
2025-12-18 06:00:00	QQQ	ETF	605.12	605.61	604.99	605.33	45475.0
2025-12-18 06:30:00	QQQ	ETF	605.26	606.0	605.2	605.67	75128.0
2025-12-18 07:00:00	QQQ	ETF	605.66	605.91	605.38	605.51	74629.0
2025-12-18 07:30:00	QQQ	ETF	605.52	605.79	605.25	605.44	93861.0
2025-12-18 08:00:00	QQQ	ETF	605.45	605.99	602.11	605.74	417884.0
2025-12-18 08:30:00	QQQ	ETF	605.75	609.46	605.66	608.43	1104395.0
2025-12-18 09:00:00	QQQ	ETF	608.51	609.9	608.43	609.76	522486.0
2025-12-18 09:30:00	QQQ	ETF	609.75	610.95	606.92	609.68	11136184.0
2025-12-18 10:00:00	QQQ	ETF	609.68	611.16	607.24	610.8299	6042868.0
2025-12-18 10:30:00	QQQ	ETF	610.82	612.82	610.46	611.81	5547979.0
2025-12-18 11:00:00	QQQ	ETF	611.81	612.93	611.315	611.54	3863903.0
2025-12-18 11:30:00	QQQ	ETF	611.53	612.92	611.48	612.31	3116304.0
2025-12-18 12:00:00	QQQ	ETF	612.31	612.31	607.51	608.61	6028551.0
2025-12-18 12:30:00	QQQ	ETF	608.59	611.75	608.25	611.5599	4033095.0

> showing 50 of 45,358 rows — these rows as CSV

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