PREVIEW / etf_30min / 2025-11-20

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-11-20.parquet
  size:    1.1 MB
  rows:    47,019

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-11-20 04:00:00	SPY	ETF	670.98	670.99	669.48	669.48	27995.0
2025-11-20 04:30:00	SPY	ETF	669.43	669.79	669.01	669.34	28624.0
2025-11-20 05:00:00	SPY	ETF	669.32	670.21	668.91	670.11	62876.0
2025-11-20 05:30:00	SPY	ETF	670.21	671.0	670.21	670.86	66203.0
2025-11-20 06:00:00	SPY	ETF	670.86	670.86	669.4	669.52	42251.0
2025-11-20 06:30:00	SPY	ETF	669.73	670.58	669.41	669.75	45671.0
2025-11-20 07:00:00	SPY	ETF	669.8	670.11	669.01	669.76	189037.0
2025-11-20 07:30:00	SPY	ETF	669.77	671.169	669.76	671.06	121528.0
2025-11-20 08:00:00	SPY	ETF	669.95	672.07	669.02	670.7	514339.0
2025-11-20 08:30:00	SPY	ETF	670.58	673.67	670.58	673.22	792260.0
2025-11-20 09:00:00	SPY	ETF	673.24	673.62	672.61	672.91	304615.0
2025-11-20 09:30:00	SPY	ETF	672.91	675.02	672.47	674.91	11106721.0
2025-11-20 10:00:00	SPY	ETF	674.92	675.41	672.79	674.83	6634076.0
2025-11-20 10:30:00	SPY	ETF	674.83	675.56	672.74	672.76	4666718.0
2025-11-20 11:00:00	SPY	ETF	672.78	672.82	667.42	667.9	11117395.0
2025-11-20 11:30:00	SPY	ETF	667.89	668.17	659.39	660.2	15295609.0
2025-11-20 12:00:00	SPY	ETF	660.19	662.38	656.6	658.57	15745805.0
2025-11-20 12:30:00	SPY	ETF	658.55	659.54	655.45	657.26	10480191.0
2025-11-20 13:00:00	SPY	ETF	657.29	661.97	656.72	659.58	9547503.0
2025-11-20 13:30:00	SPY	ETF	659.55	660.0	654.12	655.06	6470328.0
2025-11-20 14:00:00	SPY	ETF	655.04	657.54	653.86	657.01	5829502.0
2025-11-20 14:30:00	SPY	ETF	656.98	658.25	655.21	658.11	5839932.0
2025-11-20 15:00:00	SPY	ETF	658.12	658.13	655.35	656.2	6620285.0
2025-11-20 15:30:00	SPY	ETF	656.2	656.56	651.89	652.53	16669988.0
2025-11-20 16:00:00	SPY	ETF	652.52	652.83	651.69	652.4	4914485.0
2025-11-20 16:30:00	SPY	ETF	652.43	652.5	651.77	651.87	407401.0
2025-11-20 17:00:00	SPY	ETF	651.88	652.0	651.72	651.85	241268.0
2025-11-20 17:30:00	SPY	ETF	651.8736	652.31	651.72	652.28	88768.0
2025-11-20 18:00:00	SPY	ETF	652.28	653.17	650.7	652.77	361655.0
2025-11-20 18:30:00	SPY	ETF	652.81	653.7	652.36	653.12	134248.0
2025-11-20 19:00:00	SPY	ETF	653.24	654.43	652.87	654.25	148861.0
2025-11-20 19:30:00	SPY	ETF	654.16	654.71	653.92	654.3985	81571.0
2025-11-20 04:00:00	QQQ	ETF	610.5	611.0	608.4	608.4	78350.0
2025-11-20 04:30:00	QQQ	ETF	608.36	608.74	607.73	607.99	97162.0
2025-11-20 05:00:00	QQQ	ETF	608.1	608.66	607.13	608.38	86799.0
2025-11-20 05:30:00	QQQ	ETF	608.4	609.56	608.4	609.28	56607.0
2025-11-20 06:00:00	QQQ	ETF	609.24	609.32	607.72	608.15	117389.0
2025-11-20 06:30:00	QQQ	ETF	608.2	609.6	608.14	608.73	202812.0
2025-11-20 07:00:00	QQQ	ETF	608.67	609.22	608.01	608.74	157479.0
2025-11-20 07:30:00	QQQ	ETF	608.79	610.32	608.76	610.3	110901.0
2025-11-20 08:00:00	QQQ	ETF	610.28	611.56	600.319	610.0	540676.0
2025-11-20 08:30:00	QQQ	ETF	610.0	612.91	609.8	612.0884	1096592.0
2025-11-20 09:00:00	QQQ	ETF	612.09	612.52	611.33	611.57	531518.0
2025-11-20 09:30:00	QQQ	ETF	611.62	613.5601	610.03	613.16	9429648.0
2025-11-20 10:00:00	QQQ	ETF	613.19	613.79	610.34	612.78	5468932.0
2025-11-20 10:30:00	QQQ	ETF	612.79	614.03	610.35	610.48	5034395.0
2025-11-20 11:00:00	QQQ	ETF	610.49	610.53	603.83	604.29	8603461.0
2025-11-20 11:30:00	QQQ	ETF	604.3	604.83	594.74	595.765	10323786.0
2025-11-20 12:00:00	QQQ	ETF	595.75	597.91	590.93	593.25	9772963.0
2025-11-20 12:30:00	QQQ	ETF	593.2	594.5	589.83	591.9344	8268392.0

> showing 50 of 47,019 rows — these rows as CSV

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