PREVIEW / etf_30min / 2025-03-04

all etf 30-min files

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

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-04 04:00:00	SPY	ETF	584.63	585.31	584.4	584.7	8716.0
2025-03-04 04:30:00	SPY	ETF	584.7	584.85	583.76	584.03	28545.0
2025-03-04 05:00:00	SPY	ETF	583.72	584.18	583.0	583.17	27939.0
2025-03-04 05:30:00	SPY	ETF	583.45	583.45	582.8	583.31	16511.0
2025-03-04 06:00:00	SPY	ETF	583.34	583.79	583.06	583.65	9986.0
2025-03-04 06:30:00	SPY	ETF	583.72	583.85	582.75	583.39	17970.0
2025-03-04 07:00:00	SPY	ETF	583.31	583.42	579.86	580.17	166130.0
2025-03-04 07:30:00	SPY	ETF	580.01	581.29	580.01	580.2	130979.0
2025-03-04 08:00:00	SPY	ETF	582.47	586.0	579.03	579.26	345509.0
2025-03-04 08:30:00	SPY	ETF	579.21	580.65	579.21	579.84	443928.0
2025-03-04 09:00:00	SPY	ETF	579.83	581.34	579.56	579.71	690742.0
2025-03-04 09:30:00	SPY	ETF	579.71	580.21	575.59	575.7	8024458.0
2025-03-04 10:00:00	SPY	ETF	575.71	576.21	572.25	574.51	6582209.0
2025-03-04 10:30:00	SPY	ETF	574.52	576.1	573.4	574.09	4107284.0
2025-03-04 11:00:00	SPY	ETF	574.1	575.09	572.3	572.9601	3849875.0
2025-03-04 11:30:00	SPY	ETF	572.99	576.57	572.92	575.985	3338595.0
2025-03-04 12:00:00	SPY	ETF	576.02	578.57	575.33	577.86	2997024.0
2025-03-04 12:30:00	SPY	ETF	577.85	578.17	575.9	576.494	3141540.0
2025-03-04 13:00:00	SPY	ETF	576.51	580.0696	576.03	577.54	2552507.0
2025-03-04 13:30:00	SPY	ETF	577.48	580.83	576.97	580.285	1778853.0
2025-03-04 14:00:00	SPY	ETF	580.26	582.929	580.18	581.4	3481771.0
2025-03-04 14:30:00	SPY	ETF	581.42	583.13	580.8	582.89	2823588.0
2025-03-04 15:00:00	SPY	ETF	582.82	585.39	582.2	583.84	3277604.0
2025-03-04 15:30:00	SPY	ETF	583.86	584.03	574.69	576.87	15764129.0
2025-03-04 16:00:00	SPY	ETF	576.88	581.81	576.84	580.93	4785466.0
2025-03-04 16:30:00	SPY	ETF	581.0401	581.15	579.06	580.39	959263.0
2025-03-04 17:00:00	SPY	ETF	580.31	580.4	579.95	580.12	131424.0
2025-03-04 17:30:00	SPY	ETF	580.1	580.76	580.04	580.75	66622.0
2025-03-04 18:00:00	SPY	ETF	580.75	581.32	580.2	581.32	151306.0
2025-03-04 18:30:00	SPY	ETF	581.35	581.539	580.78	581.24	99228.0
2025-03-04 19:00:00	SPY	ETF	581.25	581.45	579.99	580.35	62899.0
2025-03-04 19:30:00	SPY	ETF	580.45	580.59	579.4	580.43	84926.0
2025-03-04 04:00:00	QQQ	ETF	498.47	499.6	498.28	498.9	32272.0
2025-03-04 04:30:00	QQQ	ETF	498.85	498.92	497.8	497.97	33212.0
2025-03-04 05:00:00	QQQ	ETF	497.87	498.39	496.67	497.05	87448.0
2025-03-04 05:30:00	QQQ	ETF	497.5	497.5	496.76	497.29	78255.0
2025-03-04 06:00:00	QQQ	ETF	497.0	497.69	496.85	497.55	47720.0
2025-03-04 06:30:00	QQQ	ETF	497.58	497.82	496.65	497.42	58492.0
2025-03-04 07:00:00	QQQ	ETF	497.37	497.37	493.41	493.49	157685.0
2025-03-04 07:30:00	QQQ	ETF	493.5	495.02	493.44	493.75	222377.0
2025-03-04 08:00:00	QQQ	ETF	496.52	500.12	492.24	492.48	447770.0
2025-03-04 08:30:00	QQQ	ETF	492.47	494.51	492.45	493.7	528473.0
2025-03-04 09:00:00	QQQ	ETF	493.74	495.58	493.7	494.02	788432.0
2025-03-04 09:30:00	QQQ	ETF	494.18	496.32	491.46	491.5594	6746314.0
2025-03-04 10:00:00	QQQ	ETF	491.55	492.08	487.735	489.8	6336666.0
2025-03-04 10:30:00	QQQ	ETF	489.72	492.24	489.16	490.6862	2912312.0
2025-03-04 11:00:00	QQQ	ETF	490.69	491.46	488.52	489.38	2545890.0
2025-03-04 11:30:00	QQQ	ETF	489.38	494.07	489.27	493.15	2516638.0
2025-03-04 12:00:00	QQQ	ETF	493.158	496.42	492.35	495.51	2580838.0
2025-03-04 12:30:00	QQQ	ETF	495.49	495.94	493.59	494.0766	2024029.0

> showing 50 of 42,853 rows — these rows as CSV

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