PREVIEW / etf_30min / 2025-01-14

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-14.parquet
  size:    932 KB
  rows:    37,646

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-01-14 04:00:00	SPY	ETF	583.98	585.0	583.98	584.55	13538.0
2025-01-14 04:30:00	SPY	ETF	584.51	584.84	584.32	584.61	3965.0
2025-01-14 05:00:00	SPY	ETF	584.31	584.63	584.07	584.19	5505.0
2025-01-14 05:30:00	SPY	ETF	584.3	584.71	584.3	584.53	3756.0
2025-01-14 06:00:00	SPY	ETF	584.25	584.27	583.77	583.91	5391.0
2025-01-14 06:30:00	SPY	ETF	583.92	584.0	583.48	583.68	55940.0
2025-01-14 07:00:00	SPY	ETF	583.63	583.81	582.23	582.92	153597.0
2025-01-14 07:30:00	SPY	ETF	582.9	583.29	582.74	582.95	60755.0
2025-01-14 08:00:00	SPY	ETF	583.55	584.88	581.5	581.76	225047.0
2025-01-14 08:30:00	SPY	ETF	582.06	585.99	581.98	583.74	899939.0
2025-01-14 09:00:00	SPY	ETF	583.74	584.53	583.18	584.33	337699.0
2025-01-14 09:30:00	SPY	ETF	584.32	585.0	581.97	582.3	4054302.0
2025-01-14 10:00:00	SPY	ETF	582.3	584.64	582.16	583.15	2464993.0
2025-01-14 10:30:00	SPY	ETF	583.1752	583.61	581.79	581.79	1750097.0
2025-01-14 11:00:00	SPY	ETF	581.81	581.9599	580.18	580.86	1946278.0
2025-01-14 11:30:00	SPY	ETF	580.83	581.4	578.77	578.77	1713478.0
2025-01-14 12:00:00	SPY	ETF	578.75	580.13	578.57	579.72	1475019.0
2025-01-14 12:30:00	SPY	ETF	579.71	580.56	578.35	580.22	1220338.0
2025-01-14 13:00:00	SPY	ETF	580.21	582.237	580.1	582.02	1030324.0
2025-01-14 13:30:00	SPY	ETF	582.02	583.755	581.79	583.49	2027584.0
2025-01-14 14:00:00	SPY	ETF	583.47	583.81	582.85	583.04	1683704.0
2025-01-14 14:30:00	SPY	ETF	583.04	583.74	580.39	580.56	1734151.0
2025-01-14 15:00:00	SPY	ETF	580.55	580.87	578.9	580.49	2717448.0
2025-01-14 15:30:00	SPY	ETF	580.47	582.29	579.58	582.19	5714461.0
2025-01-14 16:00:00	SPY	ETF	582.17	584.0	581.93	583.24	2554498.0
2025-01-14 16:30:00	SPY	ETF	583.22	583.4	583.05	583.07	253069.0
2025-01-14 17:00:00	SPY	ETF	583.04	583.05	582.9001	582.94	74980.0
2025-01-14 17:30:00	SPY	ETF	583.0	583.0	582.77	582.95	55839.0
2025-01-14 18:00:00	SPY	ETF	582.95	582.96	582.53	582.55	41140.0
2025-01-14 18:30:00	SPY	ETF	582.5315	582.6	582.44	582.5699	22485.0
2025-01-14 19:00:00	SPY	ETF	582.56	582.62	582.43	582.5	23302.0
2025-01-14 19:30:00	SPY	ETF	582.41	582.69	582.41	582.65	30348.0
2025-01-14 04:00:00	QQQ	ETF	509.22	510.07	509.03	509.34	39947.0
2025-01-14 04:30:00	QQQ	ETF	509.37	509.8	509.2	509.35	15120.0
2025-01-14 05:00:00	QQQ	ETF	509.3	509.55	508.8	508.91	13323.0
2025-01-14 05:30:00	QQQ	ETF	508.92	509.37	508.89	509.23	5738.0
2025-01-14 06:00:00	QQQ	ETF	509.11	509.17	508.29	508.35	32269.0
2025-01-14 06:30:00	QQQ	ETF	508.38	508.48	507.84	508.03	33922.0
2025-01-14 07:00:00	QQQ	ETF	508.03	508.38	506.37	507.2	129880.0
2025-01-14 07:30:00	QQQ	ETF	507.2	507.63	506.9	507.08	68939.0
2025-01-14 08:00:00	QQQ	ETF	508.03	510.34	505.66	506.06	216678.0
2025-01-14 08:30:00	QQQ	ETF	506.37	510.36	506.36	508.5	734492.0
2025-01-14 09:00:00	QQQ	ETF	508.43	509.19	507.66	508.78	343786.0
2025-01-14 09:30:00	QQQ	ETF	508.76	510.155	506.25	506.58	2903832.0
2025-01-14 10:00:00	QQQ	ETF	506.58	509.65	506.28	507.37	1741975.0
2025-01-14 10:30:00	QQQ	ETF	507.4336	507.68	505.456	505.47	1571366.0
2025-01-14 11:00:00	QQQ	ETF	505.49	505.96	504.01	504.73	1576491.0
2025-01-14 11:30:00	QQQ	ETF	504.68	505.2999	502.7	502.79	1086081.0
2025-01-14 12:00:00	QQQ	ETF	502.75	504.06	502.42	503.54	1252495.0
2025-01-14 12:30:00	QQQ	ETF	503.44	504.24	502.03	503.75	981599.0

> showing 50 of 37,646 rows — these rows as CSV

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