PREVIEW / etf_30min / 2023-09-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-13.parquet
  size:    675 KB
  rows:    26,909

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-09-13 04:00:00	SPY	ETF	446.06	446.2	445.79	445.94	9651.0
2023-09-13 04:30:00	SPY	ETF	445.8	445.84	445.52	445.55	8399.0
2023-09-13 05:00:00	SPY	ETF	445.55	445.9	445.48	445.78	5241.0
2023-09-13 05:30:00	SPY	ETF	445.82	446.0	445.58	445.84	9565.0
2023-09-13 06:00:00	SPY	ETF	445.65	445.65	445.19	445.24	25628.0
2023-09-13 06:30:00	SPY	ETF	445.21	445.64	445.21	445.61	14895.0
2023-09-13 07:00:00	SPY	ETF	445.75	445.75	445.26	445.62	83681.0
2023-09-13 07:30:00	SPY	ETF	445.7	446.18	445.62	446.18	95481.0
2023-09-13 08:00:00	SPY	ETF	445.5	446.4	445.25	446.07	176594.0
2023-09-13 08:30:00	SPY	ETF	445.98	446.58	444.2	446.17	1233226.0
2023-09-13 09:00:00	SPY	ETF	446.11	446.46	445.56	446.22	364583.0
2023-09-13 09:30:00	SPY	ETF	446.22	447.26	445.99	446.94	4830988.0
2023-09-13 10:00:00	SPY	ETF	446.945	446.99	445.0793	446.11	4486614.0
2023-09-13 10:30:00	SPY	ETF	446.115	447.23	446.06	447.0577	3612035.0
2023-09-13 11:00:00	SPY	ETF	447.07	447.58	446.85	447.475	3428321.0
2023-09-13 11:30:00	SPY	ETF	447.48	447.6	446.525	447.2417	2524935.0
2023-09-13 12:00:00	SPY	ETF	447.25	447.48	446.72	447.37	1805151.0
2023-09-13 12:30:00	SPY	ETF	447.375	447.55	446.78	447.27	2039467.0
2023-09-13 13:00:00	SPY	ETF	447.27	447.57	447.1235	447.2726	1543841.0
2023-09-13 13:30:00	SPY	ETF	447.28	447.71	447.13	447.375	1805637.0
2023-09-13 14:00:00	SPY	ETF	447.38	447.51	446.79	447.1113	2066715.0
2023-09-13 14:30:00	SPY	ETF	447.12	447.155	445.51	446.2	4160831.0
2023-09-13 15:00:00	SPY	ETF	446.21	446.285	445.32	445.975	4481454.0
2023-09-13 15:30:00	SPY	ETF	445.98	446.78	445.975	446.51	7917832.0
2023-09-13 16:00:00	SPY	ETF	446.5	446.82	446.35	446.74	2762442.0
2023-09-13 16:30:00	SPY	ETF	446.74	446.89	446.7	446.86	181847.0
2023-09-13 17:00:00	SPY	ETF	446.82	446.89	446.77	446.81	46345.0
2023-09-13 17:30:00	SPY	ETF	446.78	446.85	446.78	446.81	5257.0
2023-09-13 18:00:00	SPY	ETF	446.78	446.85	446.6	446.73	45718.0
2023-09-13 18:30:00	SPY	ETF	446.73	446.73	446.64	446.66	4637.0
2023-09-13 19:00:00	SPY	ETF	446.7599	446.94	446.71	446.88	9041.0
2023-09-13 19:30:00	SPY	ETF	446.92	447.0	446.83	447.0	11875.0
2023-09-13 04:00:00	QQQ	ETF	372.92	373.17	372.72	373.01	33096.0
2023-09-13 04:30:00	QQQ	ETF	372.88	372.89	372.47	372.5	17096.0
2023-09-13 05:00:00	QQQ	ETF	372.46	372.84	372.39	372.84	7002.0
2023-09-13 05:30:00	QQQ	ETF	372.77	372.81	372.45	372.6	7477.0
2023-09-13 06:00:00	QQQ	ETF	372.54	372.54	371.92	371.95	24788.0
2023-09-13 06:30:00	QQQ	ETF	372.0	372.4	371.97	372.4	8951.0
2023-09-13 07:00:00	QQQ	ETF	372.45	372.54	372.04	372.54	25642.0
2023-09-13 07:30:00	QQQ	ETF	372.53	373.17	372.53	373.16	53227.0
2023-09-13 08:00:00	QQQ	ETF	373.09	373.5	372.06	372.76	131496.0
2023-09-13 08:30:00	QQQ	ETF	372.75	373.53	370.68	372.81	2216610.0
2023-09-13 09:00:00	QQQ	ETF	372.84	373.19	372.4	373.01	237687.0
2023-09-13 09:30:00	QQQ	ETF	373.03	374.44	372.78	374.0906	4755037.0
2023-09-13 10:00:00	QQQ	ETF	374.12	374.21	371.88	373.5182	3488234.0
2023-09-13 10:30:00	QQQ	ETF	373.54	374.68	373.52	374.3225	2529706.0
2023-09-13 11:00:00	QQQ	ETF	374.33	375.25	374.3	375.17	2253263.0
2023-09-13 11:30:00	QQQ	ETF	375.19	375.4462	373.87	374.91	1927434.0
2023-09-13 12:00:00	QQQ	ETF	374.905	375.2101	374.26	375.18	1408567.0
2023-09-13 12:30:00	QQQ	ETF	375.18	375.52	374.6529	375.16	1582108.0

> showing 50 of 26,909 rows — these rows as CSV

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