PREVIEW / etf_30min / 2025-07-18

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-18.parquet
  size:    978 KB
  rows:    40,144

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-07-18 04:00:00	SPY	ETF	628.74	629.15	628.68	629.04	23321.0
2025-07-18 04:30:00	SPY	ETF	628.96	629.15	628.82	628.98	25089.0
2025-07-18 05:00:00	SPY	ETF	629.01	629.1	628.94	629.05	18577.0
2025-07-18 05:30:00	SPY	ETF	629.08	629.16	628.97	628.99	9006.0
2025-07-18 06:00:00	SPY	ETF	628.95	629.02	628.33	628.44	15247.0
2025-07-18 06:30:00	SPY	ETF	628.42	628.54	628.33	628.51	14291.0
2025-07-18 07:00:00	SPY	ETF	628.45	628.67	628.18	628.42	44704.0
2025-07-18 07:30:00	SPY	ETF	628.42	628.67	628.35	628.48	63896.0
2025-07-18 08:00:00	SPY	ETF	629.2	629.65	628.21	628.77	144211.0
2025-07-18 08:30:00	SPY	ETF	628.74	628.97	628.53	628.88	246018.0
2025-07-18 09:00:00	SPY	ETF	628.91	629.45	628.66	629.29	416523.0
2025-07-18 09:30:00	SPY	ETF	629.29	629.47	628.44	628.64	4622911.0
2025-07-18 10:00:00	SPY	ETF	628.65	629.35	627.24	627.37	4223453.0
2025-07-18 10:30:00	SPY	ETF	627.4	627.91	627.12	627.13	2378261.0
2025-07-18 11:00:00	SPY	ETF	627.13	627.695	626.91	627.605	2211580.0
2025-07-18 11:30:00	SPY	ETF	627.62	628.17	627.578	628.115	1793976.0
2025-07-18 12:00:00	SPY	ETF	628.115	628.16	626.54	626.96	2819820.0
2025-07-18 12:30:00	SPY	ETF	626.98	627.385	626.48	626.68	2562761.0
2025-07-18 13:00:00	SPY	ETF	626.67	627.21	626.46	626.94	2035514.0
2025-07-18 13:30:00	SPY	ETF	626.94	627.53	626.795	627.08	1385025.0
2025-07-18 14:00:00	SPY	ETF	627.09	627.4	626.66	627.115	1904703.0
2025-07-18 14:30:00	SPY	ETF	627.11	627.41	627.0401	627.215	1557509.0
2025-07-18 15:00:00	SPY	ETF	627.21	627.6	627.02	627.39	2256097.0
2025-07-18 15:30:00	SPY	ETF	627.375	627.76	627.01	627.58	6297705.0
2025-07-18 16:00:00	SPY	ETF	627.59	627.68	627.43	627.51	1947122.0
2025-07-18 16:30:00	SPY	ETF	627.53	627.7	627.46	627.59	1099170.0
2025-07-18 17:00:00	SPY	ETF	627.59	627.81	627.46	627.8	42885.0
2025-07-18 17:30:00	SPY	ETF	627.84	627.9	627.58	627.59	21795.0
2025-07-18 18:00:00	SPY	ETF	627.59	627.79	627.58	627.6501	23405.0
2025-07-18 18:30:00	SPY	ETF	627.68	627.86	627.68	627.83	19909.0
2025-07-18 19:00:00	SPY	ETF	627.84	627.98	627.67	627.72	31841.0
2025-07-18 19:30:00	SPY	ETF	627.72	627.9	627.67	627.9	18089.0
2025-07-18 04:00:00	QQQ	ETF	562.31	562.73	562.25	562.64	9125.0
2025-07-18 04:30:00	QQQ	ETF	562.62	562.7	562.46	562.66	8314.0
2025-07-18 05:00:00	QQQ	ETF	562.65	562.8	562.59	562.71	7570.0
2025-07-18 05:30:00	QQQ	ETF	562.7	562.77	562.51	562.54	6491.0
2025-07-18 06:00:00	QQQ	ETF	562.54	562.62	561.99	562.15	16048.0
2025-07-18 06:30:00	QQQ	ETF	562.08	562.3	561.98	562.26	12536.0
2025-07-18 07:00:00	QQQ	ETF	562.26	562.4	561.95	562.14	24713.0
2025-07-18 07:30:00	QQQ	ETF	562.17	562.47	562.17	562.25	28190.0
2025-07-18 08:00:00	QQQ	ETF	562.35	563.24	561.94	562.25	103484.0
2025-07-18 08:30:00	QQQ	ETF	562.18	562.39	562.0	562.33	57915.0
2025-07-18 09:00:00	QQQ	ETF	562.35	563.8	562.0501	563.12	1184689.0
2025-07-18 09:30:00	QQQ	ETF	563.12	563.32	561.95	562.08	3200798.0
2025-07-18 10:00:00	QQQ	ETF	562.12	562.87	560.33	560.4801	2823943.0
2025-07-18 10:30:00	QQQ	ETF	560.49	561.38	560.41	560.778	1928611.0
2025-07-18 11:00:00	QQQ	ETF	560.78	561.17	560.32	561.045	1561737.0
2025-07-18 11:30:00	QQQ	ETF	561.05	561.92	561.05	561.805	1376107.0
2025-07-18 12:00:00	QQQ	ETF	561.81	561.85	560.13	560.72	1698230.0
2025-07-18 12:30:00	QQQ	ETF	560.73	561.0374	559.98	560.36	1632661.0

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

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