PREVIEW / etf_30min / 2025-05-06

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-06.parquet
  size:    965 KB
  rows:    39,683

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-06 04:00:00	SPY	ETF	560.39	560.49	558.95	558.95	52443.0
2025-05-06 04:30:00	SPY	ETF	558.98	559.8	558.84	559.75	13187.0
2025-05-06 05:00:00	SPY	ETF	559.76	559.76	558.78	558.94	53188.0
2025-05-06 05:30:00	SPY	ETF	559.0	559.6	558.75	559.6	8443.0
2025-05-06 06:00:00	SPY	ETF	559.7	559.78	559.26	559.68	6394.0
2025-05-06 06:30:00	SPY	ETF	559.78	560.26	559.72	560.07	16150.0
2025-05-06 07:00:00	SPY	ETF	560.23	560.55	558.85	559.055	124803.0
2025-05-06 07:30:00	SPY	ETF	559.1	559.75	558.0	558.79	144494.0
2025-05-06 08:00:00	SPY	ETF	560.54	562.41	558.0	558.799	248122.0
2025-05-06 08:30:00	SPY	ETF	558.78	559.14	558.21	558.95	181736.0
2025-05-06 09:00:00	SPY	ETF	558.98	559.16	557.76	557.86	290751.0
2025-05-06 09:30:00	SPY	ETF	557.93	559.76	556.96	557.4	4131948.0
2025-05-06 10:00:00	SPY	ETF	557.4	560.9	557.09	560.62	3025835.0
2025-05-06 10:30:00	SPY	ETF	560.59	561.41	560.3398	560.75	1852100.0
2025-05-06 11:00:00	SPY	ETF	560.75	561.82	560.48	561.65	1769710.0
2025-05-06 11:30:00	SPY	ETF	561.65	561.94	560.19	560.37	1369556.0
2025-05-06 12:00:00	SPY	ETF	560.375	563.3476	560.14	560.5896	3687863.0
2025-05-06 12:30:00	SPY	ETF	560.55	561.46	559.1204	559.21	1467461.0
2025-05-06 13:00:00	SPY	ETF	559.24	560.5899	559.19	559.72	1531623.0
2025-05-06 13:30:00	SPY	ETF	559.6798	560.15	558.32	558.44	1294058.0
2025-05-06 14:00:00	SPY	ETF	558.45	560.51	558.43	560.49	1931016.0
2025-05-06 14:30:00	SPY	ETF	560.4615	561.08	559.93	561.04	1927960.0
2025-05-06 15:00:00	SPY	ETF	561.06	561.1198	559.8701	560.785	1821908.0
2025-05-06 15:30:00	SPY	ETF	560.8	561.4	558.72	558.8	6447866.0
2025-05-06 16:00:00	SPY	ETF	558.83	559.5	556.82	557.02	2522238.0
2025-05-06 16:30:00	SPY	ETF	557.1	558.8	557.03	557.8501	376820.0
2025-05-06 17:00:00	SPY	ETF	557.9	557.94	557.25	557.62	122962.0
2025-05-06 17:30:00	SPY	ETF	557.68	558.8	557.27	557.36	336487.0
2025-05-06 18:00:00	SPY	ETF	557.36	565.06	557.36	563.7896	801910.0
2025-05-06 18:30:00	SPY	ETF	563.77	564.0	561.99	563.431	201397.0
2025-05-06 19:00:00	SPY	ETF	563.5	563.65	562.55	563.1	127900.0
2025-05-06 19:30:00	SPY	ETF	563.01	563.45	562.54	563.4	49263.0
2025-05-06 04:00:00	QQQ	ETF	482.22	482.97	480.59	480.62	68182.0
2025-05-06 04:30:00	QQQ	ETF	480.59	481.6	480.49	481.47	36873.0
2025-05-06 05:00:00	QQQ	ETF	481.38	481.42	480.42	480.63	32039.0
2025-05-06 05:30:00	QQQ	ETF	480.98	481.29	480.3	481.29	18054.0
2025-05-06 06:00:00	QQQ	ETF	481.16	481.4	480.95	481.25	24776.0
2025-05-06 06:30:00	QQQ	ETF	481.26	481.89	481.25	481.81	39919.0
2025-05-06 07:00:00	QQQ	ETF	481.84	482.2	480.55	480.8	71436.0
2025-05-06 07:30:00	QQQ	ETF	480.84	481.5	479.87	480.62	92446.0
2025-05-06 08:00:00	QQQ	ETF	482.15	484.23	479.9296	480.32	141806.0
2025-05-06 08:30:00	QQQ	ETF	480.3795	480.78	479.77	480.61	156963.0
2025-05-06 09:00:00	QQQ	ETF	480.63	480.7	479.25	479.53	206587.0
2025-05-06 09:30:00	QQQ	ETF	479.56	481.19	478.4	478.6109	3573411.0
2025-05-06 10:00:00	QQQ	ETF	478.66	482.29	478.19	482.055	2277952.0
2025-05-06 10:30:00	QQQ	ETF	482.035	482.92	481.6	482.15	1176525.0
2025-05-06 11:00:00	QQQ	ETF	482.14	483.14	481.75	483.04	925895.0
2025-05-06 11:30:00	QQQ	ETF	483.02	483.29	481.7	481.93	1022157.0
2025-05-06 12:00:00	QQQ	ETF	481.95	485.05	481.61	482.1999	2460955.0
2025-05-06 12:30:00	QQQ	ETF	482.13	483.12	481.06	481.16	1144944.0

> showing 50 of 39,683 rows — these rows as CSV

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