PREVIEW / etf_30min / 2025-07-28

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-28.parquet
  size:    1013 KB
  rows:    42,096

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-28 04:00:00	SPY	ETF	639.24	639.33	639.07	639.13	32756.0
2025-07-28 04:30:00	SPY	ETF	639.15	639.25	639.02	639.04	23397.0
2025-07-28 05:00:00	SPY	ETF	639.09	639.17	638.73	638.9	9229.0
2025-07-28 05:30:00	SPY	ETF	639.02	639.02	638.66	638.66	12406.0
2025-07-28 06:00:00	SPY	ETF	638.75	638.85	638.46	638.57	18771.0
2025-07-28 06:30:00	SPY	ETF	638.56	638.57	638.02	638.21	29244.0
2025-07-28 07:00:00	SPY	ETF	638.15	638.39	638.09	638.17	59113.0
2025-07-28 07:30:00	SPY	ETF	638.13	638.34	638.08	638.26	39293.0
2025-07-28 08:00:00	SPY	ETF	638.3	640.26	638.01	638.3	236898.0
2025-07-28 08:30:00	SPY	ETF	638.27	638.62	638.09	638.51	151053.0
2025-07-28 09:00:00	SPY	ETF	638.54	638.54	637.46	637.49	427732.0
2025-07-28 09:30:00	SPY	ETF	637.5	637.84	637.08	637.45	5272368.0
2025-07-28 10:00:00	SPY	ETF	637.44	638.04	637.27	637.735	3225557.0
2025-07-28 10:30:00	SPY	ETF	637.74	637.8999	637.24	637.4353	2259968.0
2025-07-28 11:00:00	SPY	ETF	637.44	637.52	636.33	637.07	2895487.0
2025-07-28 11:30:00	SPY	ETF	637.07	637.57	636.98	637.39	1544746.0
2025-07-28 12:00:00	SPY	ETF	637.38	637.65	637.045	637.4	1456111.0
2025-07-28 12:30:00	SPY	ETF	637.395	637.41	636.7501	636.885	1501556.0
2025-07-28 13:00:00	SPY	ETF	636.8896	637.145	636.16	636.32	2196462.0
2025-07-28 13:30:00	SPY	ETF	636.31	636.76	636.065	636.11	1403241.0
2025-07-28 14:00:00	SPY	ETF	636.1	636.23	635.54	636.03	3329398.0
2025-07-28 14:30:00	SPY	ETF	636.04	636.29	635.82	636.08	2062740.0
2025-07-28 15:00:00	SPY	ETF	636.07	636.1399	635.69	636.04	2331197.0
2025-07-28 15:30:00	SPY	ETF	636.05	637.02	635.82	636.92	5828965.0
2025-07-28 16:00:00	SPY	ETF	636.9	637.13	636.79	637.0001	2087898.0
2025-07-28 16:30:00	SPY	ETF	637.03	637.15	636.96	637.01	112273.0
2025-07-28 17:00:00	SPY	ETF	636.94	637.01	636.9	636.98	17756.0
2025-07-28 17:30:00	SPY	ETF	636.99	637.04	636.97	637.04	7719.0
2025-07-28 18:00:00	SPY	ETF	637.0	637.45	637.0	637.36	25375.0
2025-07-28 18:30:00	SPY	ETF	637.38	637.43	637.27	637.43	9065.0
2025-07-28 19:00:00	SPY	ETF	637.45	637.45	637.21	637.3199	16921.0
2025-07-28 19:30:00	SPY	ETF	637.29	637.38	637.28	637.38	7447.0
2025-07-28 04:00:00	QQQ	ETF	569.88	569.88	569.19	569.33	44651.0
2025-07-28 04:30:00	QQQ	ETF	569.29	569.45	569.26	569.31	17611.0
2025-07-28 05:00:00	QQQ	ETF	569.3	569.41	569.0	569.1	13701.0
2025-07-28 05:30:00	QQQ	ETF	569.15	569.24	568.97	569.06	14089.0
2025-07-28 06:00:00	QQQ	ETF	569.04	569.06	568.77	568.83	11330.0
2025-07-28 06:30:00	QQQ	ETF	568.82	568.85	568.08	568.3	24927.0
2025-07-28 07:00:00	QQQ	ETF	568.23	568.57	568.2	568.4	23863.0
2025-07-28 07:30:00	QQQ	ETF	568.41	568.61	568.4	568.49	15805.0
2025-07-28 08:00:00	QQQ	ETF	568.53	570.38	565.946	568.59	116553.0
2025-07-28 08:30:00	QQQ	ETF	568.5	568.87	568.34	568.69	75088.0
2025-07-28 09:00:00	QQQ	ETF	568.73	568.74	567.56	567.71	241667.0
2025-07-28 09:30:00	QQQ	ETF	567.74	568.88	567.54	568.86	3528897.0
2025-07-28 10:00:00	QQQ	ETF	568.86	569.04	567.81	568.46	2288432.0
2025-07-28 10:30:00	QQQ	ETF	568.44	568.83	567.98	568.235	1219372.0
2025-07-28 11:00:00	QQQ	ETF	568.23	568.39	566.87	567.9167	1766264.0
2025-07-28 11:30:00	QQQ	ETF	567.925	568.38	567.85	568.245	1209344.0
2025-07-28 12:00:00	QQQ	ETF	568.25	568.57	567.77	568.255	1140946.0
2025-07-28 12:30:00	QQQ	ETF	568.255	568.265	567.78	568.04	904521.0

> showing 50 of 42,096 rows — these rows as CSV

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