PREVIEW / etf_30min / 2025-03-06

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-06.parquet
  size:    984 KB
  rows:    41,219

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-03-06 04:00:00	SPY	ETF	581.38	582.39	577.2	577.25	38775.0
2025-03-06 04:30:00	SPY	ETF	577.24	578.1	576.71	577.27	50424.0
2025-03-06 05:00:00	SPY	ETF	576.81	577.8	576.35	577.6	23203.0
2025-03-06 05:30:00	SPY	ETF	577.57	577.59	576.11	576.28	24832.0
2025-03-06 06:00:00	SPY	ETF	576.26	576.85	575.71	576.58	152565.0
2025-03-06 06:30:00	SPY	ETF	576.55	577.79	576.55	577.7	57716.0
2025-03-06 07:00:00	SPY	ETF	577.79	577.85	576.3	577.38	149721.0
2025-03-06 07:30:00	SPY	ETF	577.33	577.4	576.12	576.55	126597.0
2025-03-06 08:00:00	SPY	ETF	577.8	583.05	575.06	575.7	453531.0
2025-03-06 08:30:00	SPY	ETF	575.71	577.13	575.41	576.06	414605.0
2025-03-06 09:00:00	SPY	ETF	576.05	576.94	575.22	575.44	269137.0
2025-03-06 09:30:00	SPY	ETF	575.48	575.99	573.45	574.423	4585039.0
2025-03-06 10:00:00	SPY	ETF	574.41	578.71	574.085	578.461	4466573.0
2025-03-06 10:30:00	SPY	ETF	578.46	580.06	577.49	578.71	2340507.0
2025-03-06 11:00:00	SPY	ETF	578.71	580.1736	577.11	578.49	2448990.0
2025-03-06 11:30:00	SPY	ETF	578.47	580.07	574.42	574.5	3304479.0
2025-03-06 12:00:00	SPY	ETF	574.48	574.99	572.0	572.55	3871277.0
2025-03-06 12:30:00	SPY	ETF	572.56	573.75	571.04	573.0699	4010691.0
2025-03-06 13:00:00	SPY	ETF	572.985	574.16	571.95	572.53	2358480.0
2025-03-06 13:30:00	SPY	ETF	572.5302	573.15	570.42	572.179	2654560.0
2025-03-06 14:00:00	SPY	ETF	572.08	572.36	570.12	570.6388	3071555.0
2025-03-06 14:30:00	SPY	ETF	570.6	574.93	570.12	570.98	5183390.0
2025-03-06 15:00:00	SPY	ETF	571.03	573.61	570.46	573.0131	3599155.0
2025-03-06 15:30:00	SPY	ETF	573.03	574.27	571.57	572.8	6806864.0
2025-03-06 16:00:00	SPY	ETF	572.8	575.17	571.89	574.52	4238460.0
2025-03-06 16:30:00	SPY	ETF	574.57	574.79	573.87	574.2	187016.0
2025-03-06 17:00:00	SPY	ETF	574.09	574.92	573.97	574.61	138747.0
2025-03-06 17:30:00	SPY	ETF	574.6	574.9	574.52	574.6	65719.0
2025-03-06 18:00:00	SPY	ETF	574.59	574.98	572.7506	574.29	421064.0
2025-03-06 18:30:00	SPY	ETF	574.3	574.63	574.21	574.38	131741.0
2025-03-06 19:00:00	SPY	ETF	574.55	574.84	573.77	574.04	100470.0
2025-03-06 19:30:00	SPY	ETF	574.01	574.97	574.01	574.37	63283.0
2025-03-06 04:00:00	QQQ	ETF	499.89	500.39	495.64	495.68	96246.0
2025-03-06 04:30:00	QQQ	ETF	495.84	496.8	495.31	496.0	56910.0
2025-03-06 05:00:00	QQQ	ETF	495.93	496.76	495.0	496.47	79551.0
2025-03-06 05:30:00	QQQ	ETF	496.46	496.51	495.03	495.4	38974.0
2025-03-06 06:00:00	QQQ	ETF	495.19	495.83	494.72	495.64	60377.0
2025-03-06 06:30:00	QQQ	ETF	495.5	496.53	495.46	496.33	41368.0
2025-03-06 07:00:00	QQQ	ETF	496.38	496.49	495.2	495.95	107959.0
2025-03-06 07:30:00	QQQ	ETF	495.93	496.06	494.76	495.15	119827.0
2025-03-06 08:00:00	QQQ	ETF	496.45	501.7	493.41	493.8	380857.0
2025-03-06 08:30:00	QQQ	ETF	493.68	495.45	493.68	494.09	286738.0
2025-03-06 09:00:00	QQQ	ETF	494.13	495.08	493.54	493.61	227899.0
2025-03-06 09:30:00	QQQ	ETF	493.69	494.46	491.6508	493.0	4702917.0
2025-03-06 10:00:00	QQQ	ETF	492.87	497.8963	492.31	497.29	3714512.0
2025-03-06 10:30:00	QQQ	ETF	497.28	498.58	495.53	496.6	2093070.0
2025-03-06 11:00:00	QQQ	ETF	496.63	498.18	494.6	496.05	2147127.0
2025-03-06 11:30:00	QQQ	ETF	496.04	497.7	492.17	492.24	2396194.0
2025-03-06 12:00:00	QQQ	ETF	492.26	492.82	489.26	489.925	3083790.0
2025-03-06 12:30:00	QQQ	ETF	489.98	491.14	488.37	490.33	2072797.0

> showing 50 of 41,219 rows — these rows as CSV

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