PREVIEW / etf_30min / 2023-09-11

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-11.parquet
  size:    686 KB
  rows:    27,525

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-11 04:00:00	SPY	ETF	446.61	447.52	446.5	447.27	12530.0
2023-09-11 04:30:00	SPY	ETF	447.5	447.5	446.81	446.81	13167.0
2023-09-11 05:00:00	SPY	ETF	446.93	447.31	446.93	447.31	4862.0
2023-09-11 05:30:00	SPY	ETF	447.22	447.39	447.22	447.37	3983.0
2023-09-11 06:00:00	SPY	ETF	447.37	447.37	447.02	447.23	11309.0
2023-09-11 06:30:00	SPY	ETF	447.26	447.51	447.14	447.51	30034.0
2023-09-11 07:00:00	SPY	ETF	447.46	447.59	447.26	447.4	41987.0
2023-09-11 07:30:00	SPY	ETF	447.48	447.7	447.21	447.3	57780.0
2023-09-11 08:00:00	SPY	ETF	447.44	447.92	446.03	447.86	143116.0
2023-09-11 08:30:00	SPY	ETF	447.8	448.0	447.68	447.98	70602.0
2023-09-11 09:00:00	SPY	ETF	447.98	448.3096	447.95	448.25	348602.0
2023-09-11 09:30:00	SPY	ETF	448.24	448.77	446.93	446.97	6509580.0
2023-09-11 10:00:00	SPY	ETF	446.98	447.86	446.71	447.8	4506814.0
2023-09-11 10:30:00	SPY	ETF	447.8	447.83	446.74	446.9	3145874.0
2023-09-11 11:00:00	SPY	ETF	446.89	447.49	446.4699	447.2601	2829332.0
2023-09-11 11:30:00	SPY	ETF	447.26	447.29	446.72	446.8901	2278554.0
2023-09-11 12:00:00	SPY	ETF	446.9	447.78	446.8601	447.71	2978103.0
2023-09-11 12:30:00	SPY	ETF	447.715	447.775	447.37	447.72	2041068.0
2023-09-11 13:00:00	SPY	ETF	447.72	448.2	447.5	448.1604	2655903.0
2023-09-11 13:30:00	SPY	ETF	448.17	448.48	448.111	448.3799	2818563.0
2023-09-11 14:00:00	SPY	ETF	448.38	448.49	448.0	448.4299	2418402.0
2023-09-11 14:30:00	SPY	ETF	448.43	448.56	448.25	448.4331	2307117.0
2023-09-11 15:00:00	SPY	ETF	448.44	448.7	448.17	448.59	2730542.0
2023-09-11 15:30:00	SPY	ETF	448.59	448.64	448.02	448.48	6156982.0
2023-09-11 16:00:00	SPY	ETF	448.48	448.59	448.28	448.38	1743205.0
2023-09-11 16:30:00	SPY	ETF	448.38	448.43	448.22	448.25	77808.0
2023-09-11 17:00:00	SPY	ETF	448.29	448.29	448.17	448.17	10645.0
2023-09-11 17:30:00	SPY	ETF	448.2484	448.2484	448.01	448.02	27731.0
2023-09-11 18:00:00	SPY	ETF	448.13	448.24	448.0	448.03	27421.0
2023-09-11 18:30:00	SPY	ETF	448.119	448.12	447.9	448.0096	6336.0
2023-09-11 19:00:00	SPY	ETF	448.01	448.11	447.96	448.11	4389.0
2023-09-11 19:30:00	SPY	ETF	448.1299	448.1299	447.94	448.0	15262.0
2023-09-11 04:00:00	QQQ	ETF	374.83	374.93	373.05	374.81	31249.0
2023-09-11 04:30:00	QQQ	ETF	374.89	375.05	374.32	374.36	23363.0
2023-09-11 05:00:00	QQQ	ETF	374.5	374.77	374.5	374.75	27998.0
2023-09-11 05:30:00	QQQ	ETF	374.7	374.75	374.65	374.75	8546.0
2023-09-11 06:00:00	QQQ	ETF	374.69	374.69	374.44	374.63	11141.0
2023-09-11 06:30:00	QQQ	ETF	374.66	374.83	374.64	374.81	9020.0
2023-09-11 07:00:00	QQQ	ETF	374.9	375.04	374.71	374.86	65708.0
2023-09-11 07:30:00	QQQ	ETF	374.97	375.5	374.97	375.11	93722.0
2023-09-11 08:00:00	QQQ	ETF	374.08	375.63	372.859	375.53	203251.0
2023-09-11 08:30:00	QQQ	ETF	375.51	375.77	375.3204	375.73	407962.0
2023-09-11 09:00:00	QQQ	ETF	375.75	376.0	375.58	375.59	227569.0
2023-09-11 09:30:00	QQQ	ETF	375.66	376.31	374.0	374.29	5496308.0
2023-09-11 10:00:00	QQQ	ETF	374.31	374.93	373.66	374.65	2981961.0
2023-09-11 10:30:00	QQQ	ETF	374.66	374.91	373.7403	374.12	2122875.0
2023-09-11 11:00:00	QQQ	ETF	374.1	375.23	373.8703	375.04	2046198.0
2023-09-11 11:30:00	QQQ	ETF	375.04	375.12	374.25	374.37	1284026.0
2023-09-11 12:00:00	QQQ	ETF	374.39	375.17	374.23	375.1031	1463624.0
2023-09-11 12:30:00	QQQ	ETF	375.11	375.2099	374.575	375.0199	1007554.0

> showing 50 of 27,525 rows — these rows as CSV

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