PREVIEW / etf_30min / 2024-11-07

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-07.parquet
  size:    924 KB
  rows:    37,338

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-07 04:00:00	SPY	ETF	591.95	592.59	591.82	592.3	35791.0
2024-11-07 04:30:00	SPY	ETF	592.24	592.43	592.03	592.1	8223.0
2024-11-07 05:00:00	SPY	ETF	592.1	592.41	592.06	592.11	11266.0
2024-11-07 05:30:00	SPY	ETF	592.14	592.43	592.14	592.29	42128.0
2024-11-07 06:00:00	SPY	ETF	592.29	592.3	591.9	592.16	8874.0
2024-11-07 06:30:00	SPY	ETF	592.16	592.31	591.89	592.3	40938.0
2024-11-07 07:00:00	SPY	ETF	592.37	592.86	592.36	592.76	77670.0
2024-11-07 07:30:00	SPY	ETF	592.75	592.78	592.26	592.66	41242.0
2024-11-07 08:00:00	SPY	ETF	592.43	593.04	591.26	592.65	138153.0
2024-11-07 08:30:00	SPY	ETF	592.61	592.83	592.06	592.6	127493.0
2024-11-07 09:00:00	SPY	ETF	592.52	593.21	592.5	593.05	220228.0
2024-11-07 09:30:00	SPY	ETF	593.08	594.05	592.9999	594.0	3399508.0
2024-11-07 10:00:00	SPY	ETF	593.97	594.405	593.78	594.27	2137822.0
2024-11-07 10:30:00	SPY	ETF	594.27	594.965	594.06	594.8166	1961179.0
2024-11-07 11:00:00	SPY	ETF	594.83	595.0	594.1	594.61	1549364.0
2024-11-07 11:30:00	SPY	ETF	594.59	595.28	594.58	595.135	1149771.0
2024-11-07 12:00:00	SPY	ETF	595.14	595.3	594.76	595.235	1324056.0
2024-11-07 12:30:00	SPY	ETF	595.21	595.56	594.99	595.3913	761214.0
2024-11-07 13:00:00	SPY	ETF	595.4	595.44	594.55	594.85	1023248.0
2024-11-07 13:30:00	SPY	ETF	594.85	595.13	594.21	594.8062	1351021.0
2024-11-07 14:00:00	SPY	ETF	594.78	595.4	594.2	594.74	1758883.0
2024-11-07 14:30:00	SPY	ETF	594.7199	596.03	593.92	596.02	2187607.0
2024-11-07 15:00:00	SPY	ETF	596.025	596.65	595.53	596.15	2031985.0
2024-11-07 15:30:00	SPY	ETF	596.13	596.4	595.18	595.55	6608201.0
2024-11-07 16:00:00	SPY	ETF	595.55	596.25	595.44	596.03	2835297.0
2024-11-07 16:30:00	SPY	ETF	596.01	596.11	595.85	596.0	218020.0
2024-11-07 17:00:00	SPY	ETF	595.95	596.04	595.61	595.97	348067.0
2024-11-07 17:30:00	SPY	ETF	595.9636	596.0901	595.96	596.06	37827.0
2024-11-07 18:00:00	SPY	ETF	596.13	596.14	595.6	595.9	48984.0
2024-11-07 18:30:00	SPY	ETF	596.0	596.12	595.9	596.09	8286.0
2024-11-07 19:00:00	SPY	ETF	596.07	596.2	595.88	595.88	13529.0
2024-11-07 19:30:00	SPY	ETF	595.93	595.97	595.71	595.73	15186.0
2024-11-07 04:00:00	QQQ	ETF	506.65	507.2	506.17	506.97	61729.0
2024-11-07 04:30:00	QQQ	ETF	506.97	507.13	506.75	506.75	52061.0
2024-11-07 05:00:00	QQQ	ETF	506.8	507.01	506.7	506.76	10754.0
2024-11-07 05:30:00	QQQ	ETF	506.7	506.92	506.66	506.69	5900.0
2024-11-07 06:00:00	QQQ	ETF	506.73	506.73	506.42	506.59	16810.0
2024-11-07 06:30:00	QQQ	ETF	506.67	506.86	506.41	506.8	68963.0
2024-11-07 07:00:00	QQQ	ETF	506.8	507.64	506.78	507.64	79855.0
2024-11-07 07:30:00	QQQ	ETF	507.55	507.61	507.13	507.39	73677.0
2024-11-07 08:00:00	QQQ	ETF	507.33	508.18	505.201	507.72	131460.0
2024-11-07 08:30:00	QQQ	ETF	507.62	508.09	507.24	507.85	159117.0
2024-11-07 09:00:00	QQQ	ETF	507.9	508.7	507.79	508.5096	199186.0
2024-11-07 09:30:00	QQQ	ETF	508.4	510.92	508.34	510.89	3011846.0
2024-11-07 10:00:00	QQQ	ETF	510.88	511.3499	510.45	510.91	1925070.0
2024-11-07 10:30:00	QQQ	ETF	510.9265	512.23	510.3501	512.06	1508582.0
2024-11-07 11:00:00	QQQ	ETF	512.08	512.34	511.24	511.96	1052220.0
2024-11-07 11:30:00	QQQ	ETF	511.94	512.989	511.86	512.9	1099540.0
2024-11-07 12:00:00	QQQ	ETF	512.9	512.9	512.07	512.56	851768.0
2024-11-07 12:30:00	QQQ	ETF	512.53	512.96	512.18	512.86	627669.0

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

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