PREVIEW / etf_30min / 2023-08-09

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-09.parquet
  size:    694 KB
  rows:    27,839

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-08-09 04:00:00	SPY	ETF	449.96	450.3	449.62	450.26	13623.0
2023-08-09 04:30:00	SPY	ETF	450.34	450.6	450.34	450.52	12782.0
2023-08-09 05:00:00	SPY	ETF	450.48	450.63	450.31	450.32	4321.0
2023-08-09 05:30:00	SPY	ETF	450.32	450.32	449.98	450.12	6417.0
2023-08-09 06:00:00	SPY	ETF	450.19	450.25	449.99	450.25	2360.0
2023-08-09 06:30:00	SPY	ETF	450.36	450.4	449.8	449.8	7798.0
2023-08-09 07:00:00	SPY	ETF	449.78	449.89	449.45	449.45	77078.0
2023-08-09 07:30:00	SPY	ETF	449.44	450.3	449.43	450.19	114032.0
2023-08-09 08:00:00	SPY	ETF	449.47	450.6204	449.26	449.7	208298.0
2023-08-09 08:30:00	SPY	ETF	449.7	450.15	449.42	449.5	140612.0
2023-08-09 09:00:00	SPY	ETF	449.43	449.61	448.92	449.03	126520.0
2023-08-09 09:30:00	SPY	ETF	449.03	449.1999	448.03	448.3405	4183415.0
2023-08-09 10:00:00	SPY	ETF	448.35	448.805	448.035	448.47	3163333.0
2023-08-09 10:30:00	SPY	ETF	448.45	448.66	447.26	447.39	3457756.0
2023-08-09 11:00:00	SPY	ETF	447.395	447.7	445.85	446.02	4843030.0
2023-08-09 11:30:00	SPY	ETF	446.02	446.3999	444.96	445.395	4439808.0
2023-08-09 12:00:00	SPY	ETF	445.39	446.205	445.255	445.965	2902411.0
2023-08-09 12:30:00	SPY	ETF	445.965	446.64	445.94	446.26	2570980.0
2023-08-09 13:00:00	SPY	ETF	446.2501	447.56	446.05	447.419	3607045.0
2023-08-09 13:30:00	SPY	ETF	447.415	447.86	447.3628	447.5205	2361176.0
2023-08-09 14:00:00	SPY	ETF	447.525	448.58	447.36	448.51	3290602.0
2023-08-09 14:30:00	SPY	ETF	448.515	448.8864	448.15	448.21	3279488.0
2023-08-09 15:00:00	SPY	ETF	448.21	448.28	447.43	447.8	3960480.0
2023-08-09 15:30:00	SPY	ETF	447.805	447.86	445.43	445.75	15581639.0
2023-08-09 16:00:00	SPY	ETF	445.74	446.47	445.6775	446.42	4693796.0
2023-08-09 16:30:00	SPY	ETF	446.41	446.43	446.29	446.43	141147.0
2023-08-09 17:00:00	SPY	ETF	446.44	446.49	446.2	446.27	65700.0
2023-08-09 17:30:00	SPY	ETF	446.34	446.4	446.2	446.36	16733.0
2023-08-09 18:00:00	SPY	ETF	446.4	446.61	446.4	446.6	49003.0
2023-08-09 18:30:00	SPY	ETF	446.61	446.73	446.55	446.65	6899.0
2023-08-09 19:00:00	SPY	ETF	446.66	446.7	446.58	446.65	7102.0
2023-08-09 19:30:00	SPY	ETF	446.69	446.91	446.68	446.81	25056.0
2023-08-09 04:00:00	QQQ	ETF	373.24	373.56	373.1	373.56	26321.0
2023-08-09 04:30:00	QQQ	ETF	373.6	373.88	373.6	373.75	10925.0
2023-08-09 05:00:00	QQQ	ETF	373.74	373.76	373.48	373.56	9154.0
2023-08-09 05:30:00	QQQ	ETF	373.52	373.52	373.13	373.26	15380.0
2023-08-09 06:00:00	QQQ	ETF	373.21	373.33	373.01	373.24	5120.0
2023-08-09 06:30:00	QQQ	ETF	373.31	373.36	372.81	372.81	11616.0
2023-08-09 07:00:00	QQQ	ETF	372.86	372.95	372.4	372.44	79641.0
2023-08-09 07:30:00	QQQ	ETF	372.43	373.3	372.4	373.17	86014.0
2023-08-09 08:00:00	QQQ	ETF	372.8	373.7104	372.279	372.67	203198.0
2023-08-09 08:30:00	QQQ	ETF	372.64	373.12	372.44	372.51	65270.0
2023-08-09 09:00:00	QQQ	ETF	372.52	372.65	372.19	372.21	138144.0
2023-08-09 09:30:00	QQQ	ETF	372.29	372.45	369.93	370.3117	4112700.0
2023-08-09 10:00:00	QQQ	ETF	370.34	370.855	369.8	370.4	2508450.0
2023-08-09 10:30:00	QQQ	ETF	370.38	370.58	368.52	368.5412	3016393.0
2023-08-09 11:00:00	QQQ	ETF	368.54	369.04	367.195	367.69	3603188.0
2023-08-09 11:30:00	QQQ	ETF	367.69	368.25	367.14	367.61	2774037.0
2023-08-09 12:00:00	QQQ	ETF	367.61	368.6	367.5	368.31	2053849.0
2023-08-09 12:30:00	QQQ	ETF	368.31	368.86	368.1	368.15	1639642.0

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

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