PREVIEW / etf_30min / 2024-08-21

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-21.parquet
  size:    809 KB
  rows:    32,569

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
2024-08-21 04:00:00	SPY	ETF	559.0	559.21	558.62	558.65	4408.0
2024-08-21 04:30:00	SPY	ETF	558.74	558.97	558.68	558.71	3551.0
2024-08-21 05:00:00	SPY	ETF	558.64	558.93	558.63	558.78	4397.0
2024-08-21 05:30:00	SPY	ETF	558.69	558.96	558.6	558.6	1724.0
2024-08-21 06:00:00	SPY	ETF	558.76	559.03	558.76	558.97	1957.0
2024-08-21 06:30:00	SPY	ETF	558.97	559.6	558.97	559.6	30252.0
2024-08-21 07:00:00	SPY	ETF	559.55	559.81	559.26	559.61	169831.0
2024-08-21 07:30:00	SPY	ETF	559.47	559.74	559.33	559.52	17680.0
2024-08-21 08:00:00	SPY	ETF	559.52	559.95	558.99	559.94	144603.0
2024-08-21 08:30:00	SPY	ETF	559.95	559.98	559.56	559.6	79541.0
2024-08-21 09:00:00	SPY	ETF	559.64	559.84	559.6	559.74	94404.0
2024-08-21 09:30:00	SPY	ETF	559.74	560.45	559.35	560.35	2568022.0
2024-08-21 10:00:00	SPY	ETF	560.37	560.8495	559.02	560.1595	2286634.0
2024-08-21 10:30:00	SPY	ETF	560.18	562.11	558.58	559.28	3063544.0
2024-08-21 11:00:00	SPY	ETF	559.225	560.33	558.55	560.0	1563093.0
2024-08-21 11:30:00	SPY	ETF	559.99	560.18	558.63	558.89	1072936.0
2024-08-21 12:00:00	SPY	ETF	558.89	559.51	557.99	559.43	1372313.0
2024-08-21 12:30:00	SPY	ETF	559.43	560.31	559.35	560.13	853316.0
2024-08-21 13:00:00	SPY	ETF	560.14	560.37	559.94	560.02	697821.0
2024-08-21 13:30:00	SPY	ETF	560.02	560.54	559.88	560.3999	778721.0
2024-08-21 14:00:00	SPY	ETF	560.43	561.27	560.18	561.2526	1528054.0
2024-08-21 14:30:00	SPY	ETF	561.25	561.71	560.33	560.75	1773489.0
2024-08-21 15:00:00	SPY	ETF	560.74	560.89	559.22	560.1	2012752.0
2024-08-21 15:30:00	SPY	ETF	560.08	561.05	559.75	560.7	5622518.0
2024-08-21 16:00:00	SPY	ETF	560.7	561.07	560.22	560.71	2779012.0
2024-08-21 16:30:00	SPY	ETF	560.69	560.84	560.65	560.79	64550.0
2024-08-21 17:00:00	SPY	ETF	560.79	560.91	560.62	560.819	20834.0
2024-08-21 17:30:00	SPY	ETF	560.75	560.89	560.7	560.75	4215.0
2024-08-21 18:00:00	SPY	ETF	560.78	561.18	560.68	561.09	8808.0
2024-08-21 18:30:00	SPY	ETF	561.1	561.23	561.04	561.11	7440.0
2024-08-21 19:00:00	SPY	ETF	561.0	561.0	560.89	560.95	5133.0
2024-08-21 19:30:00	SPY	ETF	560.97	561.17	560.97	561.17	22508.0
2024-08-21 04:00:00	QQQ	ETF	480.29	480.65	479.89	479.96	20378.0
2024-08-21 04:30:00	QQQ	ETF	479.92	480.31	479.92	480.15	5032.0
2024-08-21 05:00:00	QQQ	ETF	479.95	480.27	479.9	480.13	2402.0
2024-08-21 05:30:00	QQQ	ETF	479.9	480.3	479.82	479.9	4525.0
2024-08-21 06:00:00	QQQ	ETF	479.91	480.47	479.91	480.34	17688.0
2024-08-21 06:30:00	QQQ	ETF	480.4	481.06	480.4	481.02	19386.0
2024-08-21 07:00:00	QQQ	ETF	481.03	481.42	480.92	481.01	51693.0
2024-08-21 07:30:00	QQQ	ETF	481.0	481.07	480.6	480.85	27809.0
2024-08-21 08:00:00	QQQ	ETF	481.26	481.4	480.12	481.4	88174.0
2024-08-21 08:30:00	QQQ	ETF	481.33	481.52	480.93	480.95	37763.0
2024-08-21 09:00:00	QQQ	ETF	480.95	481.35	480.93	481.0	92708.0
2024-08-21 09:30:00	QQQ	ETF	481.05	482.04	480.35	481.9	1851348.0
2024-08-21 10:00:00	QQQ	ETF	481.93	482.7	481.01	481.8401	1903472.0
2024-08-21 10:30:00	QQQ	ETF	481.86	484.37	480.09	480.84	3251412.0
2024-08-21 11:00:00	QQQ	ETF	480.81	482.28	480.07	481.574	1300494.0
2024-08-21 11:30:00	QQQ	ETF	481.62	481.7179	480.26	480.58	868711.0
2024-08-21 12:00:00	QQQ	ETF	480.545	481.09	479.32	480.96	1001436.0
2024-08-21 12:30:00	QQQ	ETF	480.95	481.91	480.87	481.729	492881.0

> showing 50 of 32,569 rows — these rows as CSV

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