PREVIEW / etf_30min / 2025-02-18

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-02-18.parquet
  size:    988 KB
  rows:    40,374

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-18 04:00:00	SPY	ETF	610.77	611.87	610.77	611.55	26673.0
2025-02-18 04:30:00	SPY	ETF	611.51	611.57	611.32	611.33	5494.0
2025-02-18 05:00:00	SPY	ETF	611.2	611.37	611.11	611.37	1674.0
2025-02-18 05:30:00	SPY	ETF	611.53	611.72	611.51	611.72	1753.0
2025-02-18 06:00:00	SPY	ETF	611.76	611.88	611.69	611.84	16347.0
2025-02-18 06:30:00	SPY	ETF	611.87	611.87	611.67	611.79	2765.0
2025-02-18 07:00:00	SPY	ETF	611.74	612.0	611.64	611.98	24220.0
2025-02-18 07:30:00	SPY	ETF	611.95	612.11	611.95	611.95	22529.0
2025-02-18 08:00:00	SPY	ETF	611.7	612.31	611.0	612.1	48917.0
2025-02-18 08:30:00	SPY	ETF	612.15	612.2499	612.05	612.23	21398.0
2025-02-18 09:00:00	SPY	ETF	612.24	612.24	610.87	610.87	122533.0
2025-02-18 09:30:00	SPY	ETF	610.88	611.0	609.95	610.11	2275321.0
2025-02-18 10:00:00	SPY	ETF	610.1538	610.3099	609.33	609.63	1556408.0
2025-02-18 10:30:00	SPY	ETF	609.64	610.62	609.4	610.61	950327.0
2025-02-18 11:00:00	SPY	ETF	610.605	610.74	609.76	610.41	773107.0
2025-02-18 11:30:00	SPY	ETF	610.4	610.855	610.06	610.25	727854.0
2025-02-18 12:00:00	SPY	ETF	610.24	610.32	609.78	610.035	568568.0
2025-02-18 12:30:00	SPY	ETF	610.0402	610.545	610.0402	610.35	567008.0
2025-02-18 13:00:00	SPY	ETF	610.34	610.6587	609.52	609.89	750989.0
2025-02-18 13:30:00	SPY	ETF	609.88	609.93	609.4519	609.66	706395.0
2025-02-18 14:00:00	SPY	ETF	609.655	609.83	608.38	609.219	1819450.0
2025-02-18 14:30:00	SPY	ETF	609.22	610.04	609.11	609.85	1296295.0
2025-02-18 15:00:00	SPY	ETF	609.87	609.96	609.63	609.78	1045429.0
2025-02-18 15:30:00	SPY	ETF	609.77	611.38	609.63	611.35	3723598.0
2025-02-18 16:00:00	SPY	ETF	611.37	611.5	611.1	611.21	1818064.0
2025-02-18 16:30:00	SPY	ETF	611.22	611.22	610.93	611.0	101418.0
2025-02-18 17:00:00	SPY	ETF	611.0	611.04	610.96	611.02	31438.0
2025-02-18 17:30:00	SPY	ETF	611.02	611.08	610.92	610.98	10079.0
2025-02-18 18:00:00	SPY	ETF	610.98	611.57	610.98	611.24	23893.0
2025-02-18 18:30:00	SPY	ETF	611.24	611.5	611.24	611.5	7322.0
2025-02-18 19:00:00	SPY	ETF	611.41	611.7	611.38	611.68	9942.0
2025-02-18 19:30:00	SPY	ETF	611.66	611.95	611.603	611.95	31139.0
2025-02-18 04:00:00	QQQ	ETF	540.0	540.95	540.0	540.5	41429.0
2025-02-18 04:30:00	QQQ	ETF	540.46	540.56	540.01	540.13	20480.0
2025-02-18 05:00:00	QQQ	ETF	540.15	540.34	539.92	540.3	12576.0
2025-02-18 05:30:00	QQQ	ETF	540.34	540.43	540.17	540.43	7709.0
2025-02-18 06:00:00	QQQ	ETF	540.4	540.48	540.24	540.48	7631.0
2025-02-18 06:30:00	QQQ	ETF	540.45	540.48	540.08	540.29	9584.0
2025-02-18 07:00:00	QQQ	ETF	540.27	540.65	540.03	540.53	34563.0
2025-02-18 07:30:00	QQQ	ETF	540.55	540.84	540.45	540.45	60347.0
2025-02-18 08:00:00	QQQ	ETF	540.05	541.28	537.747	540.66	119117.0
2025-02-18 08:30:00	QQQ	ETF	540.7	541.0899	540.5	541.07	85426.0
2025-02-18 09:00:00	QQQ	ETF	541.1	541.24	539.67	539.7	175482.0
2025-02-18 09:30:00	QQQ	ETF	539.73	540.0	537.54	538.39	2076634.0
2025-02-18 10:00:00	QQQ	ETF	538.4	538.54	536.6948	536.89	1166430.0
2025-02-18 10:30:00	QQQ	ETF	536.9	538.1	536.57	538.04	1033706.0
2025-02-18 11:00:00	QQQ	ETF	538.03	538.52	537.52	538.5	774826.0
2025-02-18 11:30:00	QQQ	ETF	538.49	538.73	537.78	538.04	537734.0
2025-02-18 12:00:00	QQQ	ETF	538.01	538.186	537.44	537.71	402812.0
2025-02-18 12:30:00	QQQ	ETF	537.71	538.4	537.69	538.23	435591.0

> showing 50 of 40,374 rows — these rows as CSV

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