PREVIEW / etf_30min / 2025-01-15

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-15.parquet
  size:    941 KB
  rows:    37,917

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-01-15 04:00:00	SPY	ETF	582.11	582.69	582.11	582.61	6342.0
2025-01-15 04:30:00	SPY	ETF	582.67	583.15	582.67	582.96	28273.0
2025-01-15 05:00:00	SPY	ETF	582.92	583.01	582.7	582.96	4934.0
2025-01-15 05:30:00	SPY	ETF	583.0	583.22	583.0	583.21	32327.0
2025-01-15 06:00:00	SPY	ETF	583.25	583.4	583.2	583.24	5964.0
2025-01-15 06:30:00	SPY	ETF	583.57	584.57	583.57	584.39	33430.0
2025-01-15 07:00:00	SPY	ETF	584.26	584.6	583.93	583.95	222339.0
2025-01-15 07:30:00	SPY	ETF	583.94	584.48	583.8	584.06	62588.0
2025-01-15 08:00:00	SPY	ETF	584.27	584.56	582.19	584.22	205191.0
2025-01-15 08:30:00	SPY	ETF	584.56	591.78	584.51	590.9001	2109805.0
2025-01-15 09:00:00	SPY	ETF	590.87	591.3589	590.02	590.32	708777.0
2025-01-15 09:30:00	SPY	ETF	590.35	592.14	589.195	591.93	5413836.0
2025-01-15 10:00:00	SPY	ETF	591.95	592.97	591.56	592.33	3034147.0
2025-01-15 10:30:00	SPY	ETF	592.34	592.53	591.09	591.17	2129200.0
2025-01-15 11:00:00	SPY	ETF	591.17	592.0	590.71	591.0201	1509933.0
2025-01-15 11:30:00	SPY	ETF	591.02	591.02	589.5	590.0268	2030011.0
2025-01-15 12:00:00	SPY	ETF	590.03	591.38	589.92	591.12	1159150.0
2025-01-15 12:30:00	SPY	ETF	591.12	591.95	590.89	591.0	1013862.0
2025-01-15 13:00:00	SPY	ETF	591.0	592.27	591.0	592.27	771094.0
2025-01-15 13:30:00	SPY	ETF	592.255	592.66	591.98	592.53	825271.0
2025-01-15 14:00:00	SPY	ETF	592.53	593.14	592.44	593.1	1452770.0
2025-01-15 14:30:00	SPY	ETF	593.12	593.72	593.02	593.4	1850288.0
2025-01-15 15:00:00	SPY	ETF	593.4	593.94	593.29	593.69	2323606.0
2025-01-15 15:30:00	SPY	ETF	593.68	593.84	592.68	592.78	8067517.0
2025-01-15 16:00:00	SPY	ETF	592.74	593.15	592.51	592.681	3846124.0
2025-01-15 16:30:00	SPY	ETF	592.6499	592.75	592.0474	592.68	101813.0
2025-01-15 17:00:00	SPY	ETF	592.67	592.78	592.52	592.78	70563.0
2025-01-15 17:30:00	SPY	ETF	592.78	593.0	592.73	592.87	27491.0
2025-01-15 18:00:00	SPY	ETF	592.87	593.19	592.6	593.19	55764.0
2025-01-15 18:30:00	SPY	ETF	593.32	593.32	593.15	593.22	5813.0
2025-01-15 19:00:00	SPY	ETF	593.33	594.02	593.26	593.74	18533.0
2025-01-15 19:30:00	SPY	ETF	593.65	593.87	593.42	593.66	45925.0
2025-01-15 04:00:00	QQQ	ETF	505.44	505.83	505.44	505.83	17010.0
2025-01-15 04:30:00	QQQ	ETF	505.84	506.34	505.83	506.14	8021.0
2025-01-15 05:00:00	QQQ	ETF	506.07	506.14	505.55	506.05	8277.0
2025-01-15 05:30:00	QQQ	ETF	506.01	506.3	506.01	506.3	2901.0
2025-01-15 06:00:00	QQQ	ETF	506.33	506.43	506.28	506.31	4968.0
2025-01-15 06:30:00	QQQ	ETF	506.31	507.39	506.31	507.07	18188.0
2025-01-15 07:00:00	QQQ	ETF	506.97	507.41	506.63	506.74	61020.0
2025-01-15 07:30:00	QQQ	ETF	506.72	507.33	506.53	506.88	95795.0
2025-01-15 08:00:00	QQQ	ETF	507.18	507.39	505.0	507.0001	98963.0
2025-01-15 08:30:00	QQQ	ETF	507.2	514.88	507.0	513.75	1398591.0
2025-01-15 09:00:00	QQQ	ETF	513.72	514.3	512.91	513.1	321940.0
2025-01-15 09:30:00	QQQ	ETF	513.03	515.25	511.46	514.82	4438688.0
2025-01-15 10:00:00	QQQ	ETF	514.87	516.73	514.87	516.33	2341513.0
2025-01-15 10:30:00	QQQ	ETF	516.34	516.52	514.64	514.65	1648368.0
2025-01-15 11:00:00	QQQ	ETF	514.72	515.85	514.6426	514.92	1144609.0
2025-01-15 11:30:00	QQQ	ETF	514.91	514.93	512.925	513.56	1629429.0
2025-01-15 12:00:00	QQQ	ETF	513.48	514.86	513.31	514.7939	1004906.0
2025-01-15 12:30:00	QQQ	ETF	514.8197	515.72	514.65	514.6801	764461.0

> showing 50 of 37,917 rows — these rows as CSV

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