PREVIEW / etf_30min / 2025-04-03

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-03.parquet
  size:    1.0 MB
  rows:    43,830

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-04-03 04:00:00	SPY	ETF	548.0	549.13	547.46	548.82	75728.0
2025-04-03 04:30:00	SPY	ETF	549.08	549.38	548.29	548.88	56136.0
2025-04-03 05:00:00	SPY	ETF	548.92	549.33	547.11	547.11	53800.0
2025-04-03 05:30:00	SPY	ETF	547.31	547.92	546.27	546.54	47050.0
2025-04-03 06:00:00	SPY	ETF	546.6	547.0	545.08	545.4	112335.0
2025-04-03 06:30:00	SPY	ETF	545.39	546.12	544.36	545.44	209902.0
2025-04-03 07:00:00	SPY	ETF	545.53	546.75	545.13	545.68	265120.0
2025-04-03 07:30:00	SPY	ETF	545.61	546.41	544.78	546.0	338717.0
2025-04-03 08:00:00	SPY	ETF	545.35	550.09	544.62	545.86	792134.0
2025-04-03 08:30:00	SPY	ETF	545.8573	546.24	543.55	543.68	521504.0
2025-04-03 09:00:00	SPY	ETF	543.51	545.4	543.188	545.06	718243.0
2025-04-03 09:30:00	SPY	ETF	545.11	547.97	544.18	544.92	11581900.0
2025-04-03 10:00:00	SPY	ETF	544.86	545.22	541.57	543.07	7874042.0
2025-04-03 10:30:00	SPY	ETF	543.04	543.9	540.1	540.19	5436342.0
2025-04-03 11:00:00	SPY	ETF	540.2	542.77	539.58	541.73	5433129.0
2025-04-03 11:30:00	SPY	ETF	541.78	544.4199	541.64	543.51	4449246.0
2025-04-03 12:00:00	SPY	ETF	543.51	545.96	543.39	545.92	3755521.0
2025-04-03 12:30:00	SPY	ETF	545.94	546.36	542.985	543.44	3202980.0
2025-04-03 13:00:00	SPY	ETF	543.46	544.37	541.92	542.26	2412449.0
2025-04-03 13:30:00	SPY	ETF	542.24	543.79	541.77	541.85	2456211.0
2025-04-03 14:00:00	SPY	ETF	541.84	542.53	540.365	540.79	2981974.0
2025-04-03 14:30:00	SPY	ETF	540.77	542.35	539.9402	541.79	3804909.0
2025-04-03 15:00:00	SPY	ETF	541.77	542.0	538.55	539.03	5269787.0
2025-04-03 15:30:00	SPY	ETF	539.04	539.63	536.9	537.64	15659213.0
2025-04-03 16:00:00	SPY	ETF	537.67	538.76	535.66	535.66	7660535.0
2025-04-03 16:30:00	SPY	ETF	535.6797	536.68	535.65	536.21	926313.0
2025-04-03 17:00:00	SPY	ETF	536.25	536.73	536.16	536.3999	195553.0
2025-04-03 17:30:00	SPY	ETF	536.48	536.65	536.16	536.59	106446.0
2025-04-03 18:00:00	SPY	ETF	536.45	537.19	534.91	535.65	260455.0
2025-04-03 18:30:00	SPY	ETF	535.71	536.35	535.71	536.21	43740.0
2025-04-03 19:00:00	SPY	ETF	536.12	536.43	535.4	536.43	139183.0
2025-04-03 19:30:00	SPY	ETF	536.43	537.0	536.28	536.38	107282.0
2025-04-03 04:00:00	QQQ	ETF	460.46	461.8	460.11	461.66	86149.0
2025-04-03 04:30:00	QQQ	ETF	461.69	462.51	461.18	461.96	88153.0
2025-04-03 05:00:00	QQQ	ETF	461.87	462.47	460.07	460.07	66983.0
2025-04-03 05:30:00	QQQ	ETF	460.15	460.9	458.76	459.03	63718.0
2025-04-03 06:00:00	QQQ	ETF	459.06	459.29	457.84	457.92	80742.0
2025-04-03 06:30:00	QQQ	ETF	458.04	458.79	457.04	458.06	98137.0
2025-04-03 07:00:00	QQQ	ETF	458.1	459.11	457.33	457.91	256477.0
2025-04-03 07:30:00	QQQ	ETF	458.04	458.37	457.27	458.04	232953.0
2025-04-03 08:00:00	QQQ	ETF	457.92	462.333	457.24	457.6	610314.0
2025-04-03 08:30:00	QQQ	ETF	457.6001	458.0	454.55	454.63	408302.0
2025-04-03 09:00:00	QQQ	ETF	454.53	456.55	454.19	456.47	492178.0
2025-04-03 09:30:00	QQQ	ETF	456.44	460.07	456.11	458.07	8363948.0
2025-04-03 10:00:00	QQQ	ETF	457.95	458.4	454.82	456.4	4649421.0
2025-04-03 10:30:00	QQQ	ETF	456.39	457.03	452.55	452.66	3749019.0
2025-04-03 11:00:00	QQQ	ETF	452.64	455.17	451.5608	454.0	3802909.0
2025-04-03 11:30:00	QQQ	ETF	453.99	456.72	453.88	455.54	2989534.0
2025-04-03 12:00:00	QQQ	ETF	455.51	457.94	455.39	457.57	2448096.0
2025-04-03 12:30:00	QQQ	ETF	457.61	457.985	454.88	455.2799	2304049.0

> showing 50 of 43,830 rows — these rows as CSV

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