PREVIEW / etf_30min / 2025-06-25

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-25.parquet
  size:    972 KB
  rows:    39,920

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-06-25 04:00:00	SPY	ETF	607.0	607.22	606.76	606.99	22522.0
2025-06-25 04:30:00	SPY	ETF	606.79	607.2	606.65	607.2	3388.0
2025-06-25 05:00:00	SPY	ETF	607.21	607.5	607.1	607.22	11417.0
2025-06-25 05:30:00	SPY	ETF	607.19	607.23	606.88	606.88	4803.0
2025-06-25 06:00:00	SPY	ETF	606.93	607.02	606.63	606.97	9086.0
2025-06-25 06:30:00	SPY	ETF	606.88	607.36	606.87	607.22	26200.0
2025-06-25 07:00:00	SPY	ETF	607.22	607.25	607.03	607.2	26619.0
2025-06-25 07:30:00	SPY	ETF	607.25	608.13	607.25	608.05	56627.0
2025-06-25 08:00:00	SPY	ETF	607.24	608.12	606.87	607.99	81664.0
2025-06-25 08:30:00	SPY	ETF	608.0	608.15	607.2834	608.15	114667.0
2025-06-25 09:00:00	SPY	ETF	608.18	608.2292	607.84	607.95	114313.0
2025-06-25 09:30:00	SPY	ETF	607.91	608.61	607.45	608.16	6869880.0
2025-06-25 10:00:00	SPY	ETF	608.17	608.3499	607.31	607.69	3657732.0
2025-06-25 10:30:00	SPY	ETF	607.7	608.41	607.51	607.765	2961793.0
2025-06-25 11:00:00	SPY	ETF	607.76	607.805	606.86	607.155	3476468.0
2025-06-25 11:30:00	SPY	ETF	607.16	607.17	606.48	606.89	2662322.0
2025-06-25 12:00:00	SPY	ETF	606.89	607.27	606.8	606.975	1478553.0
2025-06-25 12:30:00	SPY	ETF	606.98	607.1	606.42	606.71	1626869.0
2025-06-25 13:00:00	SPY	ETF	606.705	607.14	606.26	607.02	2337419.0
2025-06-25 13:30:00	SPY	ETF	607.015	607.08	605.54	606.24	3157098.0
2025-06-25 14:00:00	SPY	ETF	606.27	606.55	606.05	606.3799	1687787.0
2025-06-25 14:30:00	SPY	ETF	606.38	606.51	606.06	606.42	1600231.0
2025-06-25 15:00:00	SPY	ETF	606.43	607.37	606.4	606.9948	2609523.0
2025-06-25 15:30:00	SPY	ETF	606.99	607.2	606.37	607.08	7543227.0
2025-06-25 16:00:00	SPY	ETF	607.08	607.15	606.75	606.8	2816120.0
2025-06-25 16:30:00	SPY	ETF	606.79	607.12	606.75	606.94	138209.0
2025-06-25 17:00:00	SPY	ETF	606.97	607.06	606.94	606.9792	32143.0
2025-06-25 17:30:00	SPY	ETF	606.94	606.94	606.5	606.65	86584.0
2025-06-25 18:00:00	SPY	ETF	606.65	607.3599	606.65	606.86	154047.0
2025-06-25 18:30:00	SPY	ETF	607.0	607.05	606.819	606.97	16455.0
2025-06-25 19:00:00	SPY	ETF	607.01	607.06	606.3	606.6	150171.0
2025-06-25 19:30:00	SPY	ETF	606.71	607.1	606.55	607.09	38043.0
2025-06-25 04:00:00	QQQ	ETF	540.27	540.47	540.0	540.12	20952.0
2025-06-25 04:30:00	QQQ	ETF	540.11	540.5	539.95	540.5	15431.0
2025-06-25 05:00:00	QQQ	ETF	540.49	540.93	540.39	540.47	28390.0
2025-06-25 05:30:00	QQQ	ETF	540.4	540.55	540.25	540.31	11090.0
2025-06-25 06:00:00	QQQ	ETF	540.32	540.55	540.07	540.49	13911.0
2025-06-25 06:30:00	QQQ	ETF	540.45	541.05	540.43	540.83	38620.0
2025-06-25 07:00:00	QQQ	ETF	540.87	541.12	540.74	540.97	24894.0
2025-06-25 07:30:00	QQQ	ETF	541.0	541.9	540.97	541.9	51182.0
2025-06-25 08:00:00	QQQ	ETF	540.83	541.96	539.82	541.93	94975.0
2025-06-25 08:30:00	QQQ	ETF	541.91	542.33	541.7	542.33	94871.0
2025-06-25 09:00:00	QQQ	ETF	542.3	542.37	541.97	542.1	124334.0
2025-06-25 09:30:00	QQQ	ETF	542.06	543.31	541.81	542.65	6377251.0
2025-06-25 10:00:00	QQQ	ETF	542.66	542.82	541.24	541.79	3073098.0
2025-06-25 10:30:00	QQQ	ETF	541.8	542.65	541.51	541.885	2184805.0
2025-06-25 11:00:00	QQQ	ETF	541.88	541.93	540.75	541.17	1875375.0
2025-06-25 11:30:00	QQQ	ETF	541.17	541.195	540.37	540.73	1421963.0
2025-06-25 12:00:00	QQQ	ETF	540.71	541.02	540.13	540.475	1240982.0
2025-06-25 12:30:00	QQQ	ETF	540.48	540.69	539.9	540.65	1231255.0

> showing 50 of 39,920 rows — these rows as CSV

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