PREVIEW / etf_30min / 2024-12-05

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-05.parquet
  size:    935 KB
  rows:    36,335

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-12-05 04:00:00	SPY	ETF	607.27	607.33	607.11	607.26	10736.0
2024-12-05 04:30:00	SPY	ETF	607.24	607.31	607.21	607.25	2262.0
2024-12-05 05:00:00	SPY	ETF	607.28	607.53	607.28	607.53	1776.0
2024-12-05 05:30:00	SPY	ETF	607.36	607.36	607.07	607.26	1142.0
2024-12-05 06:00:00	SPY	ETF	607.2	607.34	607.2	607.34	1669.0
2024-12-05 06:30:00	SPY	ETF	607.31	607.43	607.3	607.3	16616.0
2024-12-05 07:00:00	SPY	ETF	607.26	607.51	607.25	607.33	24439.0
2024-12-05 07:30:00	SPY	ETF	607.35	607.57	607.33	607.57	5223.0
2024-12-05 08:00:00	SPY	ETF	607.42	607.57	607.19	607.48	36785.0
2024-12-05 08:30:00	SPY	ETF	607.4	607.6	607.03	607.38	37051.0
2024-12-05 09:00:00	SPY	ETF	607.43	607.67	607.34	607.62	63433.0
2024-12-05 09:30:00	SPY	ETF	607.64	607.85	607.37	607.79	1690112.0
2024-12-05 10:00:00	SPY	ETF	607.805	608.2	607.11	607.11	1265475.0
2024-12-05 10:30:00	SPY	ETF	607.1039	607.27	606.8	606.95	1162889.0
2024-12-05 11:00:00	SPY	ETF	606.95	607.71	606.8301	607.63	917388.0
2024-12-05 11:30:00	SPY	ETF	607.64	607.7677	607.33	607.74	730219.0
2024-12-05 12:00:00	SPY	ETF	607.75	608.17	607.64	608.05	1045358.0
2024-12-05 12:30:00	SPY	ETF	608.045	608.48	607.95	608.4099	691684.0
2024-12-05 13:00:00	SPY	ETF	608.41	608.4152	606.86	607.29	1110858.0
2024-12-05 13:30:00	SPY	ETF	607.32	607.89	607.04	607.36	991764.0
2024-12-05 14:00:00	SPY	ETF	607.37	607.6599	606.91	607.1	1532388.0
2024-12-05 14:30:00	SPY	ETF	607.0999	607.5	607.02	607.185	876209.0
2024-12-05 15:00:00	SPY	ETF	607.18	607.41	606.62	606.745	1322056.0
2024-12-05 15:30:00	SPY	ETF	606.75	607.385	606.305	606.61	4957702.0
2024-12-05 16:00:00	SPY	ETF	606.6	606.66	605.91	606.28	1685145.0
2024-12-05 16:30:00	SPY	ETF	606.29	606.39	606.2606	606.35	78963.0
2024-12-05 17:00:00	SPY	ETF	606.29	606.32	606.15	606.16	31759.0
2024-12-05 17:30:00	SPY	ETF	606.24	606.3	606.24	606.29	10901.0
2024-12-05 18:00:00	SPY	ETF	606.25	606.29	605.76	606.15	58233.0
2024-12-05 18:30:00	SPY	ETF	606.17	606.21	606.0025	606.18	14928.0
2024-12-05 19:00:00	SPY	ETF	606.12	606.14	605.88	606.09	13560.0
2024-12-05 19:30:00	SPY	ETF	606.09	606.22	606.0	606.22	22501.0
2024-12-05 04:00:00	QQQ	ETF	522.42	522.56	522.2	522.55	35133.0
2024-12-05 04:30:00	QQQ	ETF	522.52	522.61	522.48	522.6	6581.0
2024-12-05 05:00:00	QQQ	ETF	522.61	522.83	522.6	522.67	11140.0
2024-12-05 05:30:00	QQQ	ETF	522.78	522.78	522.43	522.6	8541.0
2024-12-05 06:00:00	QQQ	ETF	522.6	522.77	522.6	522.75	9189.0
2024-12-05 06:30:00	QQQ	ETF	522.73	522.94	522.62	522.81	10626.0
2024-12-05 07:00:00	QQQ	ETF	522.88	523.17	522.82	522.91	28737.0
2024-12-05 07:30:00	QQQ	ETF	522.98	523.31	522.96	523.28	24412.0
2024-12-05 08:00:00	QQQ	ETF	523.02	523.28	522.25	523.1	76606.0
2024-12-05 08:30:00	QQQ	ETF	522.93	523.22	522.59	523.0	36785.0
2024-12-05 09:00:00	QQQ	ETF	523.1	523.31	522.97	523.31	42374.0
2024-12-05 09:30:00	QQQ	ETF	523.31	523.65	522.36	522.65	1763637.0
2024-12-05 10:00:00	QQQ	ETF	522.65	523.31	522.48	522.85	797444.0
2024-12-05 10:30:00	QQQ	ETF	522.91	523.18	522.1338	522.5	804819.0
2024-12-05 11:00:00	QQQ	ETF	522.47	523.37	522.37	523.105	544532.0
2024-12-05 11:30:00	QQQ	ETF	523.1299	523.31	522.76	523.16	441486.0
2024-12-05 12:00:00	QQQ	ETF	523.18	523.99	523.025	523.82	521431.0
2024-12-05 12:30:00	QQQ	ETF	523.82	524.0399	523.61	523.8882	389154.0

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

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