PREVIEW / etf_30min / 2023-10-19

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-19.parquet
  size:    723 KB
  rows:    29,177

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
2023-10-19 04:00:00	SPY	ETF	429.0	429.36	428.81	429.31	32662.0
2023-10-19 04:30:00	SPY	ETF	429.19	429.43	428.93	429.02	47405.0
2023-10-19 05:00:00	SPY	ETF	429.0	429.42	428.89	429.36	11206.0
2023-10-19 05:30:00	SPY	ETF	429.39	430.21	429.39	430.18	45356.0
2023-10-19 06:00:00	SPY	ETF	430.12	430.43	430.04	430.43	12550.0
2023-10-19 06:30:00	SPY	ETF	430.53	430.97	430.53	430.87	31277.0
2023-10-19 07:00:00	SPY	ETF	430.84	430.91	429.91	429.98	152352.0
2023-10-19 07:30:00	SPY	ETF	430.029	430.03	429.61	429.86	121106.0
2023-10-19 08:00:00	SPY	ETF	430.47	430.91	428.62	430.45	287688.0
2023-10-19 08:30:00	SPY	ETF	430.51	431.29	429.89	431.15	372281.0
2023-10-19 09:00:00	SPY	ETF	431.16	431.42	430.66	430.93	350412.0
2023-10-19 09:30:00	SPY	ETF	430.95	431.39	430.173	430.74	5012904.0
2023-10-19 10:00:00	SPY	ETF	430.74	431.1	428.9	429.0	5254729.0
2023-10-19 10:30:00	SPY	ETF	429.01	429.63	428.67	428.9425	4878550.0
2023-10-19 11:00:00	SPY	ETF	428.95	429.585	428.46	429.48	3730577.0
2023-10-19 11:30:00	SPY	ETF	429.48	430.72	429.3248	430.0	3439390.0
2023-10-19 12:00:00	SPY	ETF	430.005	432.82	428.71	430.1099	11592973.0
2023-10-19 12:30:00	SPY	ETF	430.12	431.47	427.72	431.04	12846688.0
2023-10-19 13:00:00	SPY	ETF	431.06	432.39	430.61	431.21	6831634.0
2023-10-19 13:30:00	SPY	ETF	431.23	431.745	429.01	429.47	5925825.0
2023-10-19 14:00:00	SPY	ETF	429.47	430.02	428.74	429.03	5059459.0
2023-10-19 14:30:00	SPY	ETF	429.04	429.04	426.64	426.9504	8027037.0
2023-10-19 15:00:00	SPY	ETF	426.95	427.59	426.33	426.78	7152513.0
2023-10-19 15:30:00	SPY	ETF	426.78	427.415	425.725	426.43	16599973.0
2023-10-19 16:00:00	SPY	ETF	426.44	431.6977	425.58	426.0101	4659039.0
2023-10-19 16:30:00	SPY	ETF	426.05	426.06	425.82	425.92	151002.0
2023-10-19 17:00:00	SPY	ETF	425.91	425.99	425.6	425.72	64100.0
2023-10-19 17:30:00	SPY	ETF	425.71	425.8	425.7	425.72	16532.0
2023-10-19 18:00:00	SPY	ETF	425.74	426.0198	425.55	425.68	42778.0
2023-10-19 18:30:00	SPY	ETF	425.67	425.86	425.58	425.6	35920.0
2023-10-19 19:00:00	SPY	ETF	425.6	425.6	425.32	425.59	48283.0
2023-10-19 19:30:00	SPY	ETF	425.57	425.75	425.48	425.75	29106.0
2023-10-19 04:00:00	QQQ	ETF	362.09	362.63	362.09	362.47	27693.0
2023-10-19 04:30:00	QQQ	ETF	362.57	362.86	362.36	362.48	32451.0
2023-10-19 05:00:00	QQQ	ETF	362.4	362.83	362.36	362.77	32779.0
2023-10-19 05:30:00	QQQ	ETF	362.85	363.75	362.85	363.7	18255.0
2023-10-19 06:00:00	QQQ	ETF	363.7	363.9	363.55	363.86	19859.0
2023-10-19 06:30:00	QQQ	ETF	363.9	364.36	363.9	364.2	36121.0
2023-10-19 07:00:00	QQQ	ETF	364.18	364.24	363.45	363.581	96934.0
2023-10-19 07:30:00	QQQ	ETF	363.62	363.68	363.24	363.54	120070.0
2023-10-19 08:00:00	QQQ	ETF	363.5	364.22	361.4	363.9	201308.0
2023-10-19 08:30:00	QQQ	ETF	364.07	364.86	363.19	364.72	349042.0
2023-10-19 09:00:00	QQQ	ETF	364.84	365.25	364.59	364.77	315307.0
2023-10-19 09:30:00	QQQ	ETF	364.81	365.335	363.21	364.09	6410073.0
2023-10-19 10:00:00	QQQ	ETF	364.1	365.28	362.75	362.79	3553257.0
2023-10-19 10:30:00	QQQ	ETF	362.79	363.94	362.63	363.04	2990424.0
2023-10-19 11:00:00	QQQ	ETF	363.07	363.57	361.87	363.0383	2515549.0
2023-10-19 11:30:00	QQQ	ETF	363.0101	364.23	362.82	363.57	2105068.0
2023-10-19 12:00:00	QQQ	ETF	363.59	366.02	362.76	363.55	8022922.0
2023-10-19 12:30:00	QQQ	ETF	363.6	364.42	360.92	364.03	7358948.0

> showing 50 of 29,177 rows — these rows as CSV

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