PREVIEW / etf_30min / 2025-01-07

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-07.parquet
  size:    942 KB
  rows:    38,291

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-07 04:00:00	SPY	ETF	595.67	595.96	595.56	595.65	7529.0
2025-01-07 04:30:00	SPY	ETF	595.69	595.84	595.11	595.35	16828.0
2025-01-07 05:00:00	SPY	ETF	595.23	596.02	595.08	596.02	8017.0
2025-01-07 05:30:00	SPY	ETF	595.88	596.05	595.78	596.03	7704.0
2025-01-07 06:00:00	SPY	ETF	596.01	596.15	595.7	596.15	1731.0
2025-01-07 06:30:00	SPY	ETF	596.15	596.15	595.4	595.69	88991.0
2025-01-07 07:00:00	SPY	ETF	595.8	595.96	595.36	595.6	20464.0
2025-01-07 07:30:00	SPY	ETF	595.74	596.4	595.71	595.81	99298.0
2025-01-07 08:00:00	SPY	ETF	595.36	596.421	594.23	596.13	64936.0
2025-01-07 08:30:00	SPY	ETF	596.18	597.0	596.01	596.95	89526.0
2025-01-07 09:00:00	SPY	ETF	596.92	597.43	596.88	597.42	134813.0
2025-01-07 09:30:00	SPY	ETF	597.43	597.75	596.1	596.34	2249429.0
2025-01-07 10:00:00	SPY	ETF	596.34	596.34	592.03	593.6	4779245.0
2025-01-07 10:30:00	SPY	ETF	593.61	593.75	590.27	593.44	3589335.0
2025-01-07 11:00:00	SPY	ETF	593.45	593.72	592.05	593.11	2050482.0
2025-01-07 11:30:00	SPY	ETF	593.02	593.26	590.51	590.7	1642934.0
2025-01-07 12:00:00	SPY	ETF	590.715	591.73	590.2125	590.62	1675441.0
2025-01-07 12:30:00	SPY	ETF	590.65	591.58	589.64	590.905	1262171.0
2025-01-07 13:00:00	SPY	ETF	590.91	592.409	590.84	592.28	1223498.0
2025-01-07 13:30:00	SPY	ETF	592.28	592.28	590.73	591.0	839047.0
2025-01-07 14:00:00	SPY	ETF	591.0	591.57	590.55	591.07	1056588.0
2025-01-07 14:30:00	SPY	ETF	591.06	591.1	589.83	590.02	1414871.0
2025-01-07 15:00:00	SPY	ETF	590.02	590.13	587.69	587.83	2957061.0
2025-01-07 15:30:00	SPY	ETF	587.82	588.8502	586.78	588.72	8116940.0
2025-01-07 16:00:00	SPY	ETF	588.73	591.273	588.63	588.87	3573612.0
2025-01-07 16:30:00	SPY	ETF	588.9	588.95	588.63	588.72	306252.0
2025-01-07 17:00:00	SPY	ETF	588.76	588.9	588.75	588.84	32495.0
2025-01-07 17:30:00	SPY	ETF	588.8202	588.8202	588.71	588.77	24943.0
2025-01-07 18:00:00	SPY	ETF	588.74	588.78	588.18	588.65	101303.0
2025-01-07 18:30:00	SPY	ETF	588.65	589.16	588.65	589.15	32741.0
2025-01-07 19:00:00	SPY	ETF	589.16	589.44	589.01	589.34	35430.0
2025-01-07 19:30:00	SPY	ETF	589.36	589.62	589.32	589.48	42642.0
2025-01-07 04:00:00	QQQ	ETF	524.7	525.17	524.56	524.78	41432.0
2025-01-07 04:30:00	QQQ	ETF	524.75	524.99	524.0	524.23	21856.0
2025-01-07 05:00:00	QQQ	ETF	524.03	524.96	523.81	524.75	15915.0
2025-01-07 05:30:00	QQQ	ETF	524.9	525.05	524.8	525.05	15402.0
2025-01-07 06:00:00	QQQ	ETF	525.0	525.05	524.36	524.81	43262.0
2025-01-07 06:30:00	QQQ	ETF	524.87	524.87	523.91	524.2	28016.0
2025-01-07 07:00:00	QQQ	ETF	524.33	524.52	523.85	524.0	87869.0
2025-01-07 07:30:00	QQQ	ETF	524.16	524.88	524.11	524.46	37740.0
2025-01-07 08:00:00	QQQ	ETF	523.96	524.88	522.52	524.43	125563.0
2025-01-07 08:30:00	QQQ	ETF	524.53	525.2	524.3	525.2	75203.0
2025-01-07 09:00:00	QQQ	ETF	525.26	525.7	525.11	525.7	182641.0
2025-01-07 09:30:00	QQQ	ETF	525.61	525.99	523.3	523.65	2549012.0
2025-01-07 10:00:00	QQQ	ETF	523.61	523.61	519.2	520.41	3209032.0
2025-01-07 10:30:00	QQQ	ETF	520.4101	520.56	516.14	519.76	2906815.0
2025-01-07 11:00:00	QQQ	ETF	519.76	520.3299	518.4464	519.97	1960516.0
2025-01-07 11:30:00	QQQ	ETF	519.93	520.05	516.82	517.03	1673455.0
2025-01-07 12:00:00	QQQ	ETF	517.08	517.98	516.43	516.833	1078219.0
2025-01-07 12:30:00	QQQ	ETF	516.899	517.75	515.88	517.28	1020357.0

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

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