PREVIEW / etf_30min / 2025-10-20

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-20.parquet
  size:    1.0 MB
  rows:    44,383

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-10-20 04:00:00	SPY	ETF	666.0	667.21	666.0	666.64	14248.0
2025-10-20 04:30:00	SPY	ETF	666.64	666.76	666.0	666.15	34311.0
2025-10-20 05:00:00	SPY	ETF	666.05	666.6	665.81	666.47	11777.0
2025-10-20 05:30:00	SPY	ETF	666.53	666.53	665.89	666.29	2939.0
2025-10-20 06:00:00	SPY	ETF	666.32	666.49	665.94	665.98	4037.0
2025-10-20 06:30:00	SPY	ETF	666.1	666.72	665.22	665.52	25925.0
2025-10-20 07:00:00	SPY	ETF	665.29	666.24	665.27	666.17	61673.0
2025-10-20 07:30:00	SPY	ETF	666.05	666.47	665.851	666.36	81005.0
2025-10-20 08:00:00	SPY	ETF	666.35	667.58	665.2791	666.34	113617.0
2025-10-20 08:30:00	SPY	ETF	666.43	667.4	666.43	667.37	338205.0
2025-10-20 09:00:00	SPY	ETF	667.38	667.78	667.17	667.25	301298.0
2025-10-20 09:30:00	SPY	ETF	667.3	669.455	667.27	668.74	5706704.0
2025-10-20 10:00:00	SPY	ETF	668.75	670.39	668.73	670.265	3581334.0
2025-10-20 10:30:00	SPY	ETF	670.26	671.46	669.81	671.2101	2966013.0
2025-10-20 11:00:00	SPY	ETF	671.22	671.25	670.26	670.92	2162454.0
2025-10-20 11:30:00	SPY	ETF	670.93	671.31	670.16	670.55	2423124.0
2025-10-20 12:00:00	SPY	ETF	670.58	670.94	670.21	670.81	1562263.0
2025-10-20 12:30:00	SPY	ETF	670.805	671.09	670.3	671.045	1341476.0
2025-10-20 13:00:00	SPY	ETF	671.03	672.01	671.01	671.6099	1950154.0
2025-10-20 13:30:00	SPY	ETF	671.61	672.12	671.545	671.7988	1234276.0
2025-10-20 14:00:00	SPY	ETF	671.8	672.21	671.73	671.8414	1578933.0
2025-10-20 14:30:00	SPY	ETF	671.85	671.92	671.175	671.66	2025401.0
2025-10-20 15:00:00	SPY	ETF	671.67	672.03	671.21	671.71	2220900.0
2025-10-20 15:30:00	SPY	ETF	671.72	672.1	671.2	671.27	6946766.0
2025-10-20 16:00:00	SPY	ETF	671.27	671.73	670.93	671.73	2368012.0
2025-10-20 16:30:00	SPY	ETF	671.7	671.92	671.69	671.9	177325.0
2025-10-20 17:00:00	SPY	ETF	671.9	672.23	671.85	671.99	67853.0
2025-10-20 17:30:00	SPY	ETF	672.0	672.04	672.0	672.0	7634.0
2025-10-20 18:00:00	SPY	ETF	671.96	672.0	671.62	671.9	60383.0
2025-10-20 18:30:00	SPY	ETF	671.88	671.88	671.58	671.7	19127.0
2025-10-20 19:00:00	SPY	ETF	671.82	672.1	671.71	671.92	27285.0
2025-10-20 19:30:00	SPY	ETF	672.02	672.05	671.5813	671.7497	15182.0
2025-10-20 04:00:00	QQQ	ETF	607.3	607.51	606.59	606.78	60362.0
2025-10-20 04:30:00	QQQ	ETF	606.75	606.98	606.0	606.14	69603.0
2025-10-20 05:00:00	QQQ	ETF	606.16	606.74	605.85	606.54	53779.0
2025-10-20 05:30:00	QQQ	ETF	606.54	606.63	606.0	606.44	38813.0
2025-10-20 06:00:00	QQQ	ETF	606.44	606.65	605.86	605.96	56452.0
2025-10-20 06:30:00	QQQ	ETF	606.05	606.81	605.3	605.39	114178.0
2025-10-20 07:00:00	QQQ	ETF	605.31	606.32	605.27	606.27	71660.0
2025-10-20 07:30:00	QQQ	ETF	606.22	606.5	605.88	606.38	41523.0
2025-10-20 08:00:00	QQQ	ETF	606.34	607.85	603.478	606.43	225954.0
2025-10-20 08:30:00	QQQ	ETF	606.46	607.48	606.46	607.43	303160.0
2025-10-20 09:00:00	QQQ	ETF	607.43	607.93	607.15	607.15	266211.0
2025-10-20 09:30:00	QQQ	ETF	607.14	610.07	607.065	609.63	4666500.0
2025-10-20 10:00:00	QQQ	ETF	609.65	611.14	609.42	611.0991	2426479.0
2025-10-20 10:30:00	QQQ	ETF	611.09	612.03	610.7	611.84	2425921.0
2025-10-20 11:00:00	QQQ	ETF	611.86	612.17	611.24	611.99	1681932.0
2025-10-20 11:30:00	QQQ	ETF	612.03	612.58	611.45	611.905	1924123.0
2025-10-20 12:00:00	QQQ	ETF	611.91	612.16	611.4	611.78	1312367.0
2025-10-20 12:30:00	QQQ	ETF	611.78	611.95	611.27	611.85	821428.0

> showing 50 of 44,383 rows — these rows as CSV

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