PREVIEW / etf_30min / 2025-03-05

all etf 30-min files

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

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-05 04:00:00	SPY	ETF	580.7	581.69	579.94	581.56	25323.0
2025-03-05 04:30:00	SPY	ETF	581.52	582.27	581.5	581.9	26727.0
2025-03-05 05:00:00	SPY	ETF	582.0	582.11	580.3	580.48	60410.0
2025-03-05 05:30:00	SPY	ETF	580.38	581.28	580.23	580.23	21501.0
2025-03-05 06:00:00	SPY	ETF	580.2	580.5	579.9	580.19	39320.0
2025-03-05 06:30:00	SPY	ETF	580.31	580.35	577.64	578.9	85997.0
2025-03-05 07:00:00	SPY	ETF	578.89	579.55	577.76	578.67	155849.0
2025-03-05 07:30:00	SPY	ETF	578.66	579.43	577.95	578.17	104539.0
2025-03-05 08:00:00	SPY	ETF	578.15	581.94	576.31	576.66	589134.0
2025-03-05 08:30:00	SPY	ETF	576.78	577.79	576.55	576.77	332537.0
2025-03-05 09:00:00	SPY	ETF	576.77	577.89	575.9	576.66	513052.0
2025-03-05 09:30:00	SPY	ETF	576.71	579.12	575.0	575.81	5179486.0
2025-03-05 10:00:00	SPY	ETF	576.51	579.64	575.4	575.8915	4569775.0
2025-03-05 10:30:00	SPY	ETF	575.92	578.35	575.5004	576.92	2164643.0
2025-03-05 11:00:00	SPY	ETF	576.9	576.91	573.8	574.85	2577058.0
2025-03-05 11:30:00	SPY	ETF	574.84	576.8	573.0796	575.89	3592902.0
2025-03-05 12:00:00	SPY	ETF	575.86	578.79	575.77	578.7	2662491.0
2025-03-05 12:30:00	SPY	ETF	578.69	580.91	577.91	580.7463	2395821.0
2025-03-05 13:00:00	SPY	ETF	580.75	581.16	577.74	579.23	3411679.0
2025-03-05 13:30:00	SPY	ETF	579.27	581.57	577.91	581.465	2456103.0
2025-03-05 14:00:00	SPY	ETF	581.46	584.34	580.83	582.8	4405694.0
2025-03-05 14:30:00	SPY	ETF	582.8	584.2	581.98	583.09	1997744.0
2025-03-05 15:00:00	SPY	ETF	583.025	584.88	582.25	584.13	3119410.0
2025-03-05 15:30:00	SPY	ETF	584.1	584.16	581.39	583.05	6887640.0
2025-03-05 16:00:00	SPY	ETF	583.04	583.18	580.4099	582.84	3709105.0
2025-03-05 16:30:00	SPY	ETF	582.85	582.91	582.3	582.52	175691.0
2025-03-05 17:00:00	SPY	ETF	582.47	582.68	582.47	582.55	23973.0
2025-03-05 17:30:00	SPY	ETF	582.55	582.66	582.29	582.36	51068.0
2025-03-05 18:00:00	SPY	ETF	582.45	583.26	582.45	582.79	51521.0
2025-03-05 18:30:00	SPY	ETF	582.7	582.7	582.23	582.51	23410.0
2025-03-05 19:00:00	SPY	ETF	582.4	582.9	582.27	582.87	16007.0
2025-03-05 19:30:00	SPY	ETF	582.83	582.87	581.8	581.9	89627.0
2025-03-05 04:00:00	QQQ	ETF	499.3	500.59	498.73	500.38	26645.0
2025-03-05 04:30:00	QQQ	ETF	500.48	501.21	500.39	500.8	47582.0
2025-03-05 05:00:00	QQQ	ETF	500.82	500.88	499.11	499.2	50442.0
2025-03-05 05:30:00	QQQ	ETF	499.25	500.28	499.15	499.3	16118.0
2025-03-05 06:00:00	QQQ	ETF	499.2	499.42	498.87	499.19	26211.0
2025-03-05 06:30:00	QQQ	ETF	499.1	499.51	496.81	497.9	60215.0
2025-03-05 07:00:00	QQQ	ETF	497.96	498.77	497.29	497.98	102030.0
2025-03-05 07:30:00	QQQ	ETF	498.0	498.72	497.57	497.78	104641.0
2025-03-05 08:00:00	QQQ	ETF	497.8	500.872	495.92	496.32	290865.0
2025-03-05 08:30:00	QQQ	ETF	496.38	497.36	495.99	496.16	240406.0
2025-03-05 09:00:00	QQQ	ETF	496.13	497.22	495.25	496.19	213131.0
2025-03-05 09:30:00	QQQ	ETF	496.2	497.13	492.57	493.77	4021314.0
2025-03-05 10:00:00	QQQ	ETF	493.82	498.05	493.3	494.0303	2795094.0
2025-03-05 10:30:00	QQQ	ETF	494.09	496.7	493.62	495.55	1587094.0
2025-03-05 11:00:00	QQQ	ETF	495.47	495.47	492.12	493.33	1827672.0
2025-03-05 11:30:00	QQQ	ETF	493.3	495.23	491.26	494.2334	2176920.0
2025-03-05 12:00:00	QQQ	ETF	494.205	497.63	494.09	497.52	1912055.0
2025-03-05 12:30:00	QQQ	ETF	497.53	500.0	496.68	499.888	1954646.0

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

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