PREVIEW / etf_30min / 2024-11-26

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-26.parquet
  size:    904 KB
  rows:    36,032

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-11-26 04:00:00	SPY	ETF	597.13	597.62	596.97	597.53	18896.0
2024-11-26 04:30:00	SPY	ETF	597.47	597.59	597.34	597.53	2477.0
2024-11-26 05:00:00	SPY	ETF	597.73	598.01	597.45	597.45	3846.0
2024-11-26 05:30:00	SPY	ETF	597.45	598.0	597.2	598.0	10752.0
2024-11-26 06:00:00	SPY	ETF	598.0	598.17	597.82	597.87	3410.0
2024-11-26 06:30:00	SPY	ETF	597.7	599.19	597.69	598.96	14382.0
2024-11-26 07:00:00	SPY	ETF	598.95	599.22	598.6	598.99	226253.0
2024-11-26 07:30:00	SPY	ETF	598.98	599.2	598.93	599.15	113272.0
2024-11-26 08:00:00	SPY	ETF	599.2	599.33	596.73	598.72	139854.0
2024-11-26 08:30:00	SPY	ETF	598.74	599.24	598.74	598.8799	59518.0
2024-11-26 09:00:00	SPY	ETF	598.95	599.43	598.68	598.82	157833.0
2024-11-26 09:30:00	SPY	ETF	598.8	599.61	598.5	599.02	3394560.0
2024-11-26 10:00:00	SPY	ETF	598.96	599.43	598.07	598.815	1887270.0
2024-11-26 10:30:00	SPY	ETF	598.8	599.41	598.22	599.05	1165744.0
2024-11-26 11:00:00	SPY	ETF	599.11	599.6	598.87	599.56	1103800.0
2024-11-26 11:30:00	SPY	ETF	599.565	599.87	599.35	599.75	1149553.0
2024-11-26 12:00:00	SPY	ETF	599.74	599.77	599.07	599.335	714797.0
2024-11-26 12:30:00	SPY	ETF	599.35	600.1299	599.3	600.075	718458.0
2024-11-26 13:00:00	SPY	ETF	600.07	600.1399	599.602	599.8701	612510.0
2024-11-26 13:30:00	SPY	ETF	599.86	600.19	599.69	600.149	560765.0
2024-11-26 14:00:00	SPY	ETF	600.11	600.41	599.22	599.6801	1747888.0
2024-11-26 14:30:00	SPY	ETF	599.69	600.215	599.5	600.03	1287756.0
2024-11-26 15:00:00	SPY	ETF	600.02	600.45	599.93	600.3715	1817655.0
2024-11-26 15:30:00	SPY	ETF	600.37	601.33	600.26	600.74	7967434.0
2024-11-26 16:00:00	SPY	ETF	600.73	601.25	600.65	601.17	4771064.0
2024-11-26 16:30:00	SPY	ETF	601.18	601.29	601.11	601.11	50465.0
2024-11-26 17:00:00	SPY	ETF	601.2	601.2	600.65	600.91	30455.0
2024-11-26 17:30:00	SPY	ETF	600.92	601.06	600.9	601.06	17179.0
2024-11-26 18:00:00	SPY	ETF	601.0	601.23	600.651	600.97	28857.0
2024-11-26 18:30:00	SPY	ETF	600.94	601.13	600.94	601.05	6747.0
2024-11-26 19:00:00	SPY	ETF	601.02	601.02	600.72	600.7986	21556.0
2024-11-26 19:30:00	SPY	ETF	600.8	601.14	600.65	601.1	75731.0
2024-11-26 04:00:00	QQQ	ETF	505.72	507.1	505.72	507.01	41566.0
2024-11-26 04:30:00	QQQ	ETF	506.89	507.0	506.48	506.76	9957.0
2024-11-26 05:00:00	QQQ	ETF	507.02	507.22	506.6	506.6	12955.0
2024-11-26 05:30:00	QQQ	ETF	506.55	507.06	506.27	507.06	18295.0
2024-11-26 06:00:00	QQQ	ETF	507.0	507.31	506.87	506.9	13705.0
2024-11-26 06:30:00	QQQ	ETF	506.75	508.31	506.75	508.1	30049.0
2024-11-26 07:00:00	QQQ	ETF	508.11	508.48	507.9	508.2	129334.0
2024-11-26 07:30:00	QQQ	ETF	508.15	508.4	508.12	508.35	88310.0
2024-11-26 08:00:00	QQQ	ETF	508.47	508.5	506.24	507.74	140921.0
2024-11-26 08:30:00	QQQ	ETF	507.77	508.41	507.77	508.23	72204.0
2024-11-26 09:00:00	QQQ	ETF	508.26	509.08	507.79	508.05	338554.0
2024-11-26 09:30:00	QQQ	ETF	508.08	510.14	508.08	508.88	2926666.0
2024-11-26 10:00:00	QQQ	ETF	508.9	509.41	507.63	508.5	1496547.0
2024-11-26 10:30:00	QQQ	ETF	508.47	509.47	508.09	508.3502	995546.0
2024-11-26 11:00:00	QQQ	ETF	508.38	509.17	507.97	508.46	858949.0
2024-11-26 11:30:00	QQQ	ETF	508.42	508.78	507.72	508.72	776263.0
2024-11-26 12:00:00	QQQ	ETF	508.7	508.77	507.81	508.22	762531.0
2024-11-26 12:30:00	QQQ	ETF	508.18	509.16	508.07	509.0849	596026.0

> showing 50 of 36,032 rows — these rows as CSV

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