PREVIEW / etf_30min / 2025-03-14

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-14.parquet
  size:    967 KB
  rows:    39,398

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-14 04:00:00	SPY	ETF	554.68	556.06	554.23	555.97	21277.0
2025-03-14 04:30:00	SPY	ETF	555.84	555.84	555.25	555.65	7378.0
2025-03-14 05:00:00	SPY	ETF	555.76	556.25	555.64	555.87	10491.0
2025-03-14 05:30:00	SPY	ETF	555.94	556.12	555.59	555.84	18930.0
2025-03-14 06:00:00	SPY	ETF	555.78	555.9	555.32	555.47	15087.0
2025-03-14 06:30:00	SPY	ETF	555.35	556.85	554.88	556.2	41602.0
2025-03-14 07:00:00	SPY	ETF	556.19	556.43	555.42	555.82	125878.0
2025-03-14 07:30:00	SPY	ETF	555.9	556.8	555.88	556.51	86359.0
2025-03-14 08:00:00	SPY	ETF	556.16	557.59	554.35	557.59	257283.0
2025-03-14 08:30:00	SPY	ETF	557.57	557.7	556.8	557.08	148709.0
2025-03-14 09:00:00	SPY	ETF	557.05	557.2308	555.96	556.14	210014.0
2025-03-14 09:30:00	SPY	ETF	556.11	559.69	555.8	558.44	4830455.0
2025-03-14 10:00:00	SPY	ETF	557.68	558.91	555.5	557.005	4588428.0
2025-03-14 10:30:00	SPY	ETF	556.995	560.2798	556.88	560.2798	2059295.0
2025-03-14 11:00:00	SPY	ETF	560.27	561.51	559.92	561.05	2290831.0
2025-03-14 11:30:00	SPY	ETF	561.06	562.43	561.05	562.14	1904272.0
2025-03-14 12:00:00	SPY	ETF	562.14	562.2	560.0201	560.22	1535695.0
2025-03-14 12:30:00	SPY	ETF	560.2397	562.43	560.05	562.09	1899990.0
2025-03-14 13:00:00	SPY	ETF	562.07	562.8	561.21	561.45	2010074.0
2025-03-14 13:30:00	SPY	ETF	561.45	561.95	560.49	560.63	1930610.0
2025-03-14 14:00:00	SPY	ETF	560.64	561.7499	560.23	560.69	1777714.0
2025-03-14 14:30:00	SPY	ETF	560.69	562.48	560.6832	561.76	1784949.0
2025-03-14 15:00:00	SPY	ETF	561.77	562.75	561.47	561.8	2037226.0
2025-03-14 15:30:00	SPY	ETF	561.81	563.83	561.37	562.79	7833477.0
2025-03-14 16:00:00	SPY	ETF	562.79	562.81	561.16	561.55	3982524.0
2025-03-14 16:30:00	SPY	ETF	561.59	561.89	561.54	561.75	322759.0
2025-03-14 17:00:00	SPY	ETF	561.9	561.95	561.61	561.65	28663.0
2025-03-14 17:30:00	SPY	ETF	561.7	561.74	561.5401	561.62	26275.0
2025-03-14 18:00:00	SPY	ETF	561.68	561.7	561.62	561.67	17307.0
2025-03-14 18:30:00	SPY	ETF	561.67	561.67	561.42	561.4792	23242.0
2025-03-14 19:00:00	SPY	ETF	561.48	561.95	561.48	561.95	19379.0
2025-03-14 19:30:00	SPY	ETF	561.95	562.18	561.95	562.08	30526.0
2025-03-14 04:00:00	QQQ	ETF	472.01	473.4	471.64	473.3	32259.0
2025-03-14 04:30:00	QQQ	ETF	473.37	473.38	472.6	472.84	21643.0
2025-03-14 05:00:00	QQQ	ETF	472.97	473.5	472.95	473.07	14761.0
2025-03-14 05:30:00	QQQ	ETF	473.0	473.6	472.87	473.22	22324.0
2025-03-14 06:00:00	QQQ	ETF	473.25	473.31	472.6	472.88	21152.0
2025-03-14 06:30:00	QQQ	ETF	472.77	474.22	472.2	473.5	44222.0
2025-03-14 07:00:00	QQQ	ETF	473.55	473.79	472.78	473.27	59091.0
2025-03-14 07:30:00	QQQ	ETF	473.27	474.26	473.27	473.98	55264.0
2025-03-14 08:00:00	QQQ	ETF	473.52	475.15	471.5	475.15	275536.0
2025-03-14 08:30:00	QQQ	ETF	475.14	475.4	474.31	474.48	157410.0
2025-03-14 09:00:00	QQQ	ETF	474.44	474.79	473.61	473.67	201223.0
2025-03-14 09:30:00	QQQ	ETF	473.74	477.51	473.4608	475.74	4482990.0
2025-03-14 10:00:00	QQQ	ETF	475.69	476.59	473.12	474.03	3546130.0
2025-03-14 10:30:00	QQQ	ETF	474.01	477.3	473.83	477.29	1885344.0
2025-03-14 11:00:00	QQQ	ETF	477.3	478.61	476.83	478.1275	1953887.0
2025-03-14 11:30:00	QQQ	ETF	478.15	479.55	478.03	478.985	1915445.0
2025-03-14 12:00:00	QQQ	ETF	478.985	479.25	477.241	477.39	1208939.0
2025-03-14 12:30:00	QQQ	ETF	477.41	479.64	477.16	479.19	993217.0

> showing 50 of 39,398 rows — these rows as CSV

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