PREVIEW / etf_30min / 2025-02-06

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-02-06.parquet
  size:    949 KB
  rows:    38,442

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-02-06 04:00:00	SPY	ETF	605.59	606.03	605.57	605.72	10536.0
2025-02-06 04:30:00	SPY	ETF	605.59	605.77	605.45	605.48	4689.0
2025-02-06 05:00:00	SPY	ETF	605.48	605.75	605.4	605.4	5871.0
2025-02-06 05:30:00	SPY	ETF	605.31	605.42	605.16	605.16	8671.0
2025-02-06 06:00:00	SPY	ETF	605.1	605.1	604.55	604.57	14326.0
2025-02-06 06:30:00	SPY	ETF	604.54	604.8	604.34	604.5	34329.0
2025-02-06 07:00:00	SPY	ETF	604.47	604.83	604.33	604.75	14095.0
2025-02-06 07:30:00	SPY	ETF	604.83	605.35	604.55	605.3	170109.0
2025-02-06 08:00:00	SPY	ETF	604.36	606.0304	604.3318	605.56	72752.0
2025-02-06 08:30:00	SPY	ETF	605.7	605.7	605.1007	605.68	46830.0
2025-02-06 09:00:00	SPY	ETF	605.7	606.22	605.7	605.98	115207.0
2025-02-06 09:30:00	SPY	ETF	605.98	606.1	604.94	605.2699	2713760.0
2025-02-06 10:00:00	SPY	ETF	605.22	605.945	604.83	604.94	1037766.0
2025-02-06 10:30:00	SPY	ETF	604.94	605.75	604.16	604.62	1378242.0
2025-02-06 11:00:00	SPY	ETF	604.63	605.6999	604.54	605.53	809564.0
2025-02-06 11:30:00	SPY	ETF	605.55	605.56	604.765	605.12	798892.0
2025-02-06 12:00:00	SPY	ETF	605.13	605.63	604.75	605.14	733015.0
2025-02-06 12:30:00	SPY	ETF	605.14	605.78	604.86	605.61	537687.0
2025-02-06 13:00:00	SPY	ETF	605.61	605.99	605.3	605.58	854244.0
2025-02-06 13:30:00	SPY	ETF	605.59	605.79	605.0401	605.16	704437.0
2025-02-06 14:00:00	SPY	ETF	605.15	605.49	604.36	604.56	1550595.0
2025-02-06 14:30:00	SPY	ETF	604.58	604.58	602.63	603.73	2297990.0
2025-02-06 15:00:00	SPY	ETF	603.72	604.82	603.53	604.765	1595575.0
2025-02-06 15:30:00	SPY	ETF	604.77	606.4525	604.58	606.34	5054707.0
2025-02-06 16:00:00	SPY	ETF	606.36	606.47	603.32	605.37	4743731.0
2025-02-06 16:30:00	SPY	ETF	605.39	605.68	604.94	605.12	247777.0
2025-02-06 17:00:00	SPY	ETF	605.17	605.18	604.71	604.85	90465.0
2025-02-06 17:30:00	SPY	ETF	604.93	605.12	604.52	604.66	34447.0
2025-02-06 18:00:00	SPY	ETF	604.55	605.7	604.5	605.67	51650.0
2025-02-06 18:30:00	SPY	ETF	605.6599	605.67	605.49	605.63	3093.0
2025-02-06 19:00:00	SPY	ETF	605.6	605.8	605.6	605.69	5457.0
2025-02-06 19:30:00	SPY	ETF	605.7299	605.99	605.41	605.99	16561.0
2025-02-06 04:00:00	QQQ	ETF	527.98	528.61	527.77	528.14	18130.0
2025-02-06 04:30:00	QQQ	ETF	528.07	528.17	527.71	527.71	15814.0
2025-02-06 05:00:00	QQQ	ETF	527.78	528.09	527.53	527.53	11218.0
2025-02-06 05:30:00	QQQ	ETF	527.46	527.73	527.3	527.34	15866.0
2025-02-06 06:00:00	QQQ	ETF	527.37	527.37	526.5	526.63	32216.0
2025-02-06 06:30:00	QQQ	ETF	526.66	526.69	525.88	526.11	30186.0
2025-02-06 07:00:00	QQQ	ETF	526.12	526.48	525.7	526.47	71641.0
2025-02-06 07:30:00	QQQ	ETF	526.4	527.01	526.1	526.94	53779.0
2025-02-06 08:00:00	QQQ	ETF	526.03	528.51	525.6305	527.09	146096.0
2025-02-06 08:30:00	QQQ	ETF	526.95	527.29	526.51	527.27	91485.0
2025-02-06 09:00:00	QQQ	ETF	527.3	527.4	526.95	527.23	63072.0
2025-02-06 09:30:00	QQQ	ETF	527.36	528.4	526.4	527.62	2267391.0
2025-02-06 10:00:00	QQQ	ETF	527.63	529.02	527.03	527.69	1207886.0
2025-02-06 10:30:00	QQQ	ETF	527.68	528.73	526.44	527.1994	1415240.0
2025-02-06 11:00:00	QQQ	ETF	527.19	528.2	527.1202	527.87	706126.0
2025-02-06 11:30:00	QQQ	ETF	527.88	527.92	526.77	527.1498	642753.0
2025-02-06 12:00:00	QQQ	ETF	527.18	528.0201	526.63	527.432	635378.0
2025-02-06 12:30:00	QQQ	ETF	527.46	528.575	527.11	528.23	558634.0

> showing 50 of 38,442 rows — these rows as CSV

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