PREVIEW / etf_30min / 2025-12-29

all etf 30-min files

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

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-29 04:00:00	SPY	ETF	690.02	690.02	688.36	688.9	18090.0
2025-12-29 04:30:00	SPY	ETF	688.9	688.9	688.37	688.75	9482.0
2025-12-29 05:00:00	SPY	ETF	688.87	689.09	688.71	688.88	5375.0
2025-12-29 05:30:00	SPY	ETF	688.9	688.9	688.65	688.69	5208.0
2025-12-29 06:00:00	SPY	ETF	688.77	688.78	688.46	688.6	16033.0
2025-12-29 06:30:00	SPY	ETF	688.64	689.08	688.63	689.0	5378.0
2025-12-29 07:00:00	SPY	ETF	689.05	689.07	688.75	688.75	19140.0
2025-12-29 07:30:00	SPY	ETF	688.72	688.85	688.04	688.39	69419.0
2025-12-29 08:00:00	SPY	ETF	688.39	690.05	688.06	688.37	210967.0
2025-12-29 08:30:00	SPY	ETF	688.35	688.37	687.02	687.6488	256161.0
2025-12-29 09:00:00	SPY	ETF	687.67	687.69	686.67	687.59	337416.0
2025-12-29 09:30:00	SPY	ETF	687.55	689.2	687.19	687.56	6729174.0
2025-12-29 10:00:00	SPY	ETF	687.56	688.06	686.82	687.95	3312088.0
2025-12-29 10:30:00	SPY	ETF	687.94	688.4	686.89	687.35	2937293.0
2025-12-29 11:00:00	SPY	ETF	687.35	687.6376	686.945	687.1699	2292630.0
2025-12-29 11:30:00	SPY	ETF	687.16	687.49	686.69	687.08	2332974.0
2025-12-29 12:00:00	SPY	ETF	687.08	687.23	686.07	686.27	1782870.0
2025-12-29 12:30:00	SPY	ETF	686.27	687.0956	686.18	686.99	2024775.0
2025-12-29 13:00:00	SPY	ETF	686.99	687.545	686.79	687.33	2017405.0
2025-12-29 13:30:00	SPY	ETF	687.33	687.89	687.17	687.225	2290302.0
2025-12-29 14:00:00	SPY	ETF	687.22	687.47	686.87	687.46	2617523.0
2025-12-29 14:30:00	SPY	ETF	687.45	688.46	687.43	688.3	3824824.0
2025-12-29 15:00:00	SPY	ETF	688.3	688.62	688.11	688.18	3281307.0
2025-12-29 15:30:00	SPY	ETF	688.18	688.405	687.4	687.84	8749817.0
2025-12-29 16:00:00	SPY	ETF	687.84	688.0	687.54	688.0	1398864.0
2025-12-29 16:30:00	SPY	ETF	688.0	688.02	687.81	687.98	136799.0
2025-12-29 17:00:00	SPY	ETF	687.99	688.05	687.87	688.03	39751.0
2025-12-29 17:30:00	SPY	ETF	688.0	688.02	687.93	687.931	5765.0
2025-12-29 18:00:00	SPY	ETF	687.98	688.0	687.4146	687.4146	28973.0
2025-12-29 18:30:00	SPY	ETF	687.6	687.76	687.4	687.48	22342.0
2025-12-29 19:00:00	SPY	ETF	687.46	687.7301	687.44	687.7	5105.0
2025-12-29 19:30:00	SPY	ETF	687.76	687.76	687.33	687.34	6379.0
2025-12-29 04:00:00	QQQ	ETF	620.96	622.85	620.87	621.57	72914.0
2025-12-29 04:30:00	QQQ	ETF	621.54	621.54	620.77	621.44	22110.0
2025-12-29 05:00:00	QQQ	ETF	621.36	621.6	621.14	621.41	10834.0
2025-12-29 05:30:00	QQQ	ETF	621.42	621.42	621.0	621.04	12763.0
2025-12-29 06:00:00	QQQ	ETF	621.0	621.21	620.8	620.99	14458.0
2025-12-29 06:30:00	QQQ	ETF	621.03	621.71	621.03	621.57	19526.0
2025-12-29 07:00:00	QQQ	ETF	621.6	621.79	621.39	621.57	27765.0
2025-12-29 07:30:00	QQQ	ETF	621.56	621.7	620.8	621.08	75608.0
2025-12-29 08:00:00	QQQ	ETF	621.02	624.357	620.78	621.09	156402.0
2025-12-29 08:30:00	QQQ	ETF	621.0714	621.1	619.01	619.78	315960.0
2025-12-29 09:00:00	QQQ	ETF	619.81	620.25	618.92	620.14	276605.0
2025-12-29 09:30:00	QQQ	ETF	620.13	622.78	619.11	620.48	5628643.0
2025-12-29 10:00:00	QQQ	ETF	620.48	621.15	619.03	621.03	2687567.0
2025-12-29 10:30:00	QQQ	ETF	621.02	621.69	619.345	620.02	2255345.0
2025-12-29 11:00:00	QQQ	ETF	620.01	620.3634	619.49	620.07	1310679.0
2025-12-29 11:30:00	QQQ	ETF	620.03	620.38	619.485	619.86	1282905.0
2025-12-29 12:00:00	QQQ	ETF	619.86	620.13	618.73	618.976	1174657.0
2025-12-29 12:30:00	QQQ	ETF	618.98	620.0899	618.9	619.95	1483593.0

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

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