PREVIEW / etf_30min / 2025-01-30

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-30.parquet
  size:    934 KB
  rows:    37,688

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-01-30 04:00:00	SPY	ETF	605.0	605.03	604.6	604.87	9872.0
2025-01-30 04:30:00	SPY	ETF	604.58	604.58	604.0	604.08	5624.0
2025-01-30 05:00:00	SPY	ETF	603.97	604.21	603.74	603.8	1765.0
2025-01-30 05:30:00	SPY	ETF	604.2	604.24	603.81	603.81	3138.0
2025-01-30 06:00:00	SPY	ETF	603.9	604.49	603.9	604.31	35895.0
2025-01-30 06:30:00	SPY	ETF	604.13	604.33	603.73	603.84	8306.0
2025-01-30 07:00:00	SPY	ETF	603.7	603.99	602.48	602.72	52065.0
2025-01-30 07:30:00	SPY	ETF	602.76	603.45	602.55	603.32	29089.0
2025-01-30 08:00:00	SPY	ETF	603.24	605.16	602.5	603.43	91650.0
2025-01-30 08:30:00	SPY	ETF	603.35	604.09	602.91	603.98	214175.0
2025-01-30 09:00:00	SPY	ETF	604.09	604.15	603.1	603.96	164195.0
2025-01-30 09:30:00	SPY	ETF	603.98	605.98	603.3711	604.94	2852471.0
2025-01-30 10:00:00	SPY	ETF	604.94	604.96	602.41	602.63	1952454.0
2025-01-30 10:30:00	SPY	ETF	602.64	603.88	601.43	601.4999	1652386.0
2025-01-30 11:00:00	SPY	ETF	601.445	602.96	600.715	602.96	1572960.0
2025-01-30 11:30:00	SPY	ETF	602.94	604.34	602.28	604.0401	1201950.0
2025-01-30 12:00:00	SPY	ETF	604.04	604.04	602.08	602.37	907485.0
2025-01-30 12:30:00	SPY	ETF	602.39	603.36	602.16	603.3303	822100.0
2025-01-30 13:00:00	SPY	ETF	603.34	604.31	603.19	604.0	701728.0
2025-01-30 13:30:00	SPY	ETF	603.985	605.07	603.94	604.95	889051.0
2025-01-30 14:00:00	SPY	ETF	604.9403	605.22	604.55	604.9568	1109114.0
2025-01-30 14:30:00	SPY	ETF	604.95	605.71	604.59	605.6801	931398.0
2025-01-30 15:00:00	SPY	ETF	605.67	606.6	605.6	606.31	1587358.0
2025-01-30 15:30:00	SPY	ETF	606.29	606.32	601.82	604.98	8601915.0
2025-01-30 16:00:00	SPY	ETF	604.96	605.64	603.93	604.68	3063782.0
2025-01-30 16:30:00	SPY	ETF	604.6	605.69	603.8	604.2	230671.0
2025-01-30 17:00:00	SPY	ETF	604.11	605.88	604.07	605.82	184470.0
2025-01-30 17:30:00	SPY	ETF	605.7	606.1	605.5	605.7	52517.0
2025-01-30 18:00:00	SPY	ETF	605.7	606.25	605.37	605.4416	58844.0
2025-01-30 18:30:00	SPY	ETF	605.43	606.0	605.16	605.83	12233.0
2025-01-30 19:00:00	SPY	ETF	605.52	605.91	605.44	605.87	18389.0
2025-01-30 19:30:00	SPY	ETF	605.95	606.06	605.74	605.89	10118.0
2025-01-30 04:00:00	QQQ	ETF	524.98	524.98	523.97	524.0	41770.0
2025-01-30 04:30:00	QQQ	ETF	524.1	524.16	523.28	523.35	26418.0
2025-01-30 05:00:00	QQQ	ETF	523.25	523.65	522.74	522.97	39576.0
2025-01-30 05:30:00	QQQ	ETF	523.14	523.48	522.98	523.05	8133.0
2025-01-30 06:00:00	QQQ	ETF	523.28	524.03	523.23	523.84	25920.0
2025-01-30 06:30:00	QQQ	ETF	523.78	524.2	523.39	523.48	35917.0
2025-01-30 07:00:00	QQQ	ETF	523.47	523.79	522.0	522.2	89778.0
2025-01-30 07:30:00	QQQ	ETF	522.18	523.37	522.01	523.25	79089.0
2025-01-30 08:00:00	QQQ	ETF	523.22	525.17	521.22	523.51	262350.0
2025-01-30 08:30:00	QQQ	ETF	523.0	524.18	522.74	524.15	259153.0
2025-01-30 09:00:00	QQQ	ETF	524.18	524.41	522.77	523.7099	227382.0
2025-01-30 09:30:00	QQQ	ETF	523.71	526.095	522.4834	524.31	2857848.0
2025-01-30 10:00:00	QQQ	ETF	524.38	524.38	520.69	520.9052	1937205.0
2025-01-30 10:30:00	QQQ	ETF	520.92	522.355	519.22	519.22	1633985.0
2025-01-30 11:00:00	QQQ	ETF	519.21	521.3601	518.21	521.34	1462330.0
2025-01-30 11:30:00	QQQ	ETF	521.35	523.1297	520.49	522.72	1007774.0
2025-01-30 12:00:00	QQQ	ETF	522.7136	522.72	520.27	520.654	667194.0
2025-01-30 12:30:00	QQQ	ETF	520.69	521.43	520.235	521.37	486735.0

> showing 50 of 37,688 rows — these rows as CSV

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