PREVIEW / etf_30min / 2025-01-08

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-08.parquet
  size:    932 KB
  rows:    37,911

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-08 04:00:00	SPY	ETF	589.8	590.54	589.8	590.5	16299.0
2025-01-08 04:30:00	SPY	ETF	590.33	590.41	590.13	590.33	6293.0
2025-01-08 05:00:00	SPY	ETF	590.52	590.71	590.44	590.6	10478.0
2025-01-08 05:30:00	SPY	ETF	590.45	590.8	590.45	590.77	2972.0
2025-01-08 06:00:00	SPY	ETF	590.84	590.84	588.25	589.47	38447.0
2025-01-08 06:30:00	SPY	ETF	589.53	589.53	587.05	588.8	109441.0
2025-01-08 07:00:00	SPY	ETF	588.9	588.9	586.2	586.59	213932.0
2025-01-08 07:30:00	SPY	ETF	586.64	587.6	586.07	586.75	239993.0
2025-01-08 08:00:00	SPY	ETF	587.77	590.6	586.1999	588.68	372103.0
2025-01-08 08:30:00	SPY	ETF	588.52	589.63	587.96	589.19	314432.0
2025-01-08 09:00:00	SPY	ETF	589.28	589.42	588.17	588.7	245988.0
2025-01-08 09:30:00	SPY	ETF	588.7	588.77	586.5001	587.38	3504865.0
2025-01-08 10:00:00	SPY	ETF	587.3	588.73	586.0	586.475	2536387.0
2025-01-08 10:30:00	SPY	ETF	586.47	588.49	586.38	588.42	1551586.0
2025-01-08 11:00:00	SPY	ETF	588.42	588.72	587.205	588.11	1120517.0
2025-01-08 11:30:00	SPY	ETF	588.12	589.94	588.12	589.43	1333024.0
2025-01-08 12:00:00	SPY	ETF	589.4254	589.4594	585.38	585.63	1416955.0
2025-01-08 12:30:00	SPY	ETF	585.64	587.26	585.195	586.9432	1415136.0
2025-01-08 13:00:00	SPY	ETF	586.94	589.57	586.88	589.11	1441710.0
2025-01-08 13:30:00	SPY	ETF	589.12	589.41	586.96	587.77	1151942.0
2025-01-08 14:00:00	SPY	ETF	587.8	590.5799	587.09	590.2716	2321008.0
2025-01-08 14:30:00	SPY	ETF	590.28	590.28	588.17	588.53	1548494.0
2025-01-08 15:00:00	SPY	ETF	588.54	589.29	587.88	589.09	1147184.0
2025-01-08 15:30:00	SPY	ETF	589.105	589.79	588.23	589.42	4863643.0
2025-01-08 16:00:00	SPY	ETF	589.415	590.0	589.23	589.59	1956894.0
2025-01-08 16:30:00	SPY	ETF	589.62	589.62	588.59	588.96	225181.0
2025-01-08 17:00:00	SPY	ETF	588.91	589.14	588.91	588.99	82082.0
2025-01-08 17:30:00	SPY	ETF	588.99	589.0	588.91	588.95	17326.0
2025-01-08 18:00:00	SPY	ETF	588.95	589.0655	588.65	589.05	23187.0
2025-01-08 18:30:00	SPY	ETF	588.92	588.92	588.41	588.41	15288.0
2025-01-08 19:00:00	SPY	ETF	588.55	588.57	587.8799	587.8799	44687.0
2025-01-08 19:30:00	SPY	ETF	588.04	588.2	587.53	588.17	47223.0
2025-01-08 04:00:00	QQQ	ETF	516.54	517.02	516.54	516.72	13408.0
2025-01-08 04:30:00	QQQ	ETF	516.77	516.9	516.57	516.9	3589.0
2025-01-08 05:00:00	QQQ	ETF	516.99	517.27	516.89	517.04	4548.0
2025-01-08 05:30:00	QQQ	ETF	517.2	517.38	516.96	517.38	6688.0
2025-01-08 06:00:00	QQQ	ETF	517.3	517.38	515.64	515.87	31618.0
2025-01-08 06:30:00	QQQ	ETF	515.91	515.91	513.5	515.29	133418.0
2025-01-08 07:00:00	QQQ	ETF	515.39	515.39	512.35	512.59	175887.0
2025-01-08 07:30:00	QQQ	ETF	512.6	513.7	511.92	512.83	181513.0
2025-01-08 08:00:00	QQQ	ETF	514.84	517.25	511.9393	515.02	471887.0
2025-01-08 08:30:00	QQQ	ETF	515.27	515.97	514.14	515.58	208614.0
2025-01-08 09:00:00	QQQ	ETF	515.62	515.89	514.42	515.06	202160.0
2025-01-08 09:30:00	QQQ	ETF	515.08	515.8	513.41	514.8	2442348.0
2025-01-08 10:00:00	QQQ	ETF	514.73	516.29	512.1	513.49	2064374.0
2025-01-08 10:30:00	QQQ	ETF	513.45	515.41	513.21	515.08	882738.0
2025-01-08 11:00:00	QQQ	ETF	515.11	515.45	513.41	514.57	938792.0
2025-01-08 11:30:00	QQQ	ETF	514.58	516.5703	514.58	515.83	1021933.0
2025-01-08 12:00:00	QQQ	ETF	515.83	515.83	510.848	511.14	1359697.0
2025-01-08 12:30:00	QQQ	ETF	511.2	513.41	510.57	513.0	1267940.0

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

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