PREVIEW / etf_30min / 2025-01-17

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-17.parquet
  size:    947 KB
  rows:    37,574

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-17 04:00:00	SPY	ETF	593.4	594.23	593.26	594.23	21186.0
2025-01-17 04:30:00	SPY	ETF	594.1	594.1	593.77	593.79	3252.0
2025-01-17 05:00:00	SPY	ETF	593.9	594.04	593.61	593.84	6167.0
2025-01-17 05:30:00	SPY	ETF	593.81	593.92	593.61	593.85	6088.0
2025-01-17 06:00:00	SPY	ETF	593.98	594.2	593.85	594.1	37196.0
2025-01-17 06:30:00	SPY	ETF	594.14	594.4	593.65	593.72	46041.0
2025-01-17 07:00:00	SPY	ETF	593.76	594.19	593.16	594.1	229787.0
2025-01-17 07:30:00	SPY	ETF	594.1	594.14	593.62	594.03	82417.0
2025-01-17 08:00:00	SPY	ETF	593.6816	595.62	592.2	595.41	184800.0
2025-01-17 08:30:00	SPY	ETF	595.46	596.36	595.46	596.17	275677.0
2025-01-17 09:00:00	SPY	ETF	596.24	597.74	596.17	596.95	559293.0
2025-01-17 09:30:00	SPY	ETF	596.95	597.3	595.61	596.29	5058106.0
2025-01-17 10:00:00	SPY	ETF	596.32	597.54	596.05	596.97	2097135.0
2025-01-17 10:30:00	SPY	ETF	596.99	598.18	596.78	598.16	2055908.0
2025-01-17 11:00:00	SPY	ETF	598.14	599.1	597.714	598.77	1811833.0
2025-01-17 11:30:00	SPY	ETF	598.77	598.94	598.1	598.295	1262339.0
2025-01-17 12:00:00	SPY	ETF	598.28	599.04	597.82	598.9812	946279.0
2025-01-17 12:30:00	SPY	ETF	599.0	599.1	598.53	598.87	984545.0
2025-01-17 13:00:00	SPY	ETF	598.89	599.36	598.5651	599.03	1044602.0
2025-01-17 13:30:00	SPY	ETF	599.03	599.11	598.1701	598.59	986583.0
2025-01-17 14:00:00	SPY	ETF	598.5512	598.76	598.08	598.447	1195789.0
2025-01-17 14:30:00	SPY	ETF	598.48	598.71	598.02	598.24	1054103.0
2025-01-17 15:00:00	SPY	ETF	598.22	598.4699	597.53	598.1	2228477.0
2025-01-17 15:30:00	SPY	ETF	598.095	598.59	597.35	597.57	5849143.0
2025-01-17 16:00:00	SPY	ETF	597.55	598.2364	597.0	597.35	3138728.0
2025-01-17 16:30:00	SPY	ETF	597.35	597.49	597.23	597.45	135753.0
2025-01-17 17:00:00	SPY	ETF	597.45	597.45	597.19	597.299	58558.0
2025-01-17 17:30:00	SPY	ETF	597.4	597.5	597.4	597.46	22892.0
2025-01-17 18:00:00	SPY	ETF	597.48	597.52	597.4	597.5	23902.0
2025-01-17 18:30:00	SPY	ETF	597.5	597.69	597.48	597.57	13022.0
2025-01-17 19:00:00	SPY	ETF	597.59	597.62	597.54	597.58	2883.0
2025-01-17 19:30:00	SPY	ETF	597.62	597.7	597.57	597.69	8715.0
2025-01-17 04:00:00	QQQ	ETF	514.02	515.97	514.02	515.97	21593.0
2025-01-17 04:30:00	QQQ	ETF	515.73	515.78	515.48	515.62	6101.0
2025-01-17 05:00:00	QQQ	ETF	515.6	515.86	515.26	515.43	30755.0
2025-01-17 05:30:00	QQQ	ETF	515.47	515.55	515.25	515.55	9531.0
2025-01-17 06:00:00	QQQ	ETF	515.54	515.85	515.53	515.8	26294.0
2025-01-17 06:30:00	QQQ	ETF	515.83	516.08	515.15	515.28	76673.0
2025-01-17 07:00:00	QQQ	ETF	515.27	515.81	514.8	515.75	75807.0
2025-01-17 07:30:00	QQQ	ETF	515.81	515.889	515.37	515.79	58824.0
2025-01-17 08:00:00	QQQ	ETF	515.03	518.21	513.65	518.06	287785.0
2025-01-17 08:30:00	QQQ	ETF	518.1	520.44	518.1	520.34	856771.0
2025-01-17 09:00:00	QQQ	ETF	520.37	523.62	520.32	522.9	1247781.0
2025-01-17 09:30:00	QQQ	ETF	522.85	523.05	519.1049	519.56	4432393.0
2025-01-17 10:00:00	QQQ	ETF	519.572	521.3172	518.91	520.05	1899610.0
2025-01-17 10:30:00	QQQ	ETF	520.09	521.68	519.79	521.6006	1312490.0
2025-01-17 11:00:00	QQQ	ETF	521.6026	522.62	521.0538	522.41	975281.0
2025-01-17 11:30:00	QQQ	ETF	522.42	522.56	521.16	521.34	1097550.0
2025-01-17 12:00:00	QQQ	ETF	521.31	522.37	520.8	522.3	987137.0
2025-01-17 12:30:00	QQQ	ETF	522.3	522.4499	521.85	522.34	1205114.0

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

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