PREVIEW / etf_30min / 2025-10-30

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-30.parquet
  size:    1.1 MB
  rows:    45,767

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-30 04:00:00	SPY	ETF	687.35	687.47	686.32	686.98	51476.0
2025-10-30 04:30:00	SPY	ETF	686.7	687.2	686.53	686.8	4766.0
2025-10-30 05:00:00	SPY	ETF	686.95	687.18	685.93	686.2	9288.0
2025-10-30 05:30:00	SPY	ETF	686.3	686.3	685.22	685.56	14033.0
2025-10-30 06:00:00	SPY	ETF	685.5	685.93	685.31	685.92	19963.0
2025-10-30 06:30:00	SPY	ETF	685.87	686.57	685.77	686.4	38703.0
2025-10-30 07:00:00	SPY	ETF	686.38	687.45	686.3	687.38	25704.0
2025-10-30 07:30:00	SPY	ETF	687.38	687.5	686.73	686.76	40001.0
2025-10-30 08:00:00	SPY	ETF	686.34	689.0	684.47	684.7	295133.0
2025-10-30 08:30:00	SPY	ETF	684.74	685.2937	683.69	683.76	311591.0
2025-10-30 09:00:00	SPY	ETF	683.7	684.4626	683.4	683.91	307465.0
2025-10-30 09:30:00	SPY	ETF	683.9	685.64	681.39	685.005	8471783.0
2025-10-30 10:00:00	SPY	ETF	685.005	685.94	683.25	683.47	4556477.0
2025-10-30 10:30:00	SPY	ETF	683.46	685.72	683.41	684.41	3104580.0
2025-10-30 11:00:00	SPY	ETF	684.41	685.53	684.4	684.8	1811927.0
2025-10-30 11:30:00	SPY	ETF	684.8	684.91	683.01	683.38	2469825.0
2025-10-30 12:00:00	SPY	ETF	683.4	685.15	683.22	684.93	1838702.0
2025-10-30 12:30:00	SPY	ETF	684.95	684.95	683.58	684.44	1758793.0
2025-10-30 13:00:00	SPY	ETF	684.42	684.61	683.07	684.4	1828385.0
2025-10-30 13:30:00	SPY	ETF	684.4	684.64	683.6	684.3984	1637840.0
2025-10-30 14:00:00	SPY	ETF	684.395	684.395	682.54	682.94	2781731.0
2025-10-30 14:30:00	SPY	ETF	682.93	683.49	682.165	682.37	2609810.0
2025-10-30 15:00:00	SPY	ETF	682.36	682.43	680.34	681.28	3943785.0
2025-10-30 15:30:00	SPY	ETF	681.29	681.985	679.86	679.95	9037902.0
2025-10-30 16:00:00	SPY	ETF	679.96	683.1398	679.72	682.3582	2712377.0
2025-10-30 16:30:00	SPY	ETF	682.31	684.2	680.0	683.98	1530046.0
2025-10-30 17:00:00	SPY	ETF	684.0	684.2	683.9499	684.04	207106.0
2025-10-30 17:30:00	SPY	ETF	684.11	684.16	683.85	684.14	42892.0
2025-10-30 18:00:00	SPY	ETF	684.11	684.46	683.84	684.18	68962.0
2025-10-30 18:30:00	SPY	ETF	684.19	684.33	683.74	683.92	42124.0
2025-10-30 19:00:00	SPY	ETF	683.89	684.2	683.48	683.72	42249.0
2025-10-30 19:30:00	SPY	ETF	683.74	684.49	683.4304	684.48	28100.0
2025-10-30 04:00:00	QQQ	ETF	635.54	638.41	634.85	635.38	78239.0
2025-10-30 04:30:00	QQQ	ETF	635.32	636.03	635.0	635.64	38353.0
2025-10-30 05:00:00	QQQ	ETF	635.79	636.18	634.52	635.02	49572.0
2025-10-30 05:30:00	QQQ	ETF	635.05	635.13	633.88	634.13	77130.0
2025-10-30 06:00:00	QQQ	ETF	634.17	634.7	633.92	634.62	72215.0
2025-10-30 06:30:00	QQQ	ETF	634.59	635.05	634.45	634.78	64245.0
2025-10-30 07:00:00	QQQ	ETF	634.74	635.91	634.58	635.8	63664.0
2025-10-30 07:30:00	QQQ	ETF	635.82	636.07	635.35	635.44	75114.0
2025-10-30 08:00:00	QQQ	ETF	635.44	638.11	632.88	632.95	464546.0
2025-10-30 08:30:00	QQQ	ETF	632.98	633.42	631.22	631.221	659267.0
2025-10-30 09:00:00	QQQ	ETF	631.24	632.32	631.09	632.15	439158.0
2025-10-30 09:30:00	QQQ	ETF	632.15	632.74	627.76	632.19	7356570.0
2025-10-30 10:00:00	QQQ	ETF	632.19	633.5	629.32	629.63	3912934.0
2025-10-30 10:30:00	QQQ	ETF	629.62	631.52	628.66	629.5614	2717846.0
2025-10-30 11:00:00	QQQ	ETF	629.57	631.01	629.56	630.5599	1662082.0
2025-10-30 11:30:00	QQQ	ETF	630.57	630.67	628.37	628.96	1901887.0
2025-10-30 12:00:00	QQQ	ETF	628.98	631.5	628.83	631.16	1425697.0
2025-10-30 12:30:00	QQQ	ETF	631.19	631.19	630.09	630.96	1438722.0

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

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