PREVIEW / etf_1hour / 2023-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-10.parquet
  size:    475 KB
  rows:    17,411

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-10 04:00:00	SPY	ETF	448.51	448.68	448.13	448.5	36076.0
2023-08-10 05:00:00	SPY	ETF	448.4	448.65	448.24	448.41	15621.0
2023-08-10 06:00:00	SPY	ETF	448.41	448.42	447.93	448.13	36187.0
2023-08-10 07:00:00	SPY	ETF	448.14	448.35	447.73	447.88	236233.0
2023-08-10 08:00:00	SPY	ETF	448.2797	449.72	446.76	449.03	1980573.0
2023-08-10 09:00:00	SPY	ETF	449.03	451.23	447.99	451.21	8226100.0
2023-08-10 10:00:00	SPY	ETF	451.22	451.7	448.72	449.54	12882226.0
2023-08-10 11:00:00	SPY	ETF	449.54	449.64	446.8611	447.62	10752741.0
2023-08-10 12:00:00	SPY	ETF	447.62	447.95	445.94	446.31	8323330.0
2023-08-10 13:00:00	SPY	ETF	446.29	446.825	444.7	444.8623	8541778.0
2023-08-10 14:00:00	SPY	ETF	444.875	447.48	444.82	447.44	7908624.0
2023-08-10 15:00:00	SPY	ETF	447.46	447.48	445.025	445.93	14205121.0
2023-08-10 16:00:00	SPY	ETF	445.92	446.15	445.55	446.03	3872882.0
2023-08-10 17:00:00	SPY	ETF	446.11	446.11	445.92	446.05	45805.0
2023-08-10 18:00:00	SPY	ETF	446.08	446.44	446.08	446.32	37839.0
2023-08-10 19:00:00	SPY	ETF	446.31	446.56	446.2	446.46	29404.0
2023-08-10 04:00:00	QQQ	ETF	370.43	370.75	370.08	370.52	137293.0
2023-08-10 05:00:00	QQQ	ETF	370.4	370.63	370.21	370.51	24955.0
2023-08-10 06:00:00	QQQ	ETF	370.51	370.51	369.98	370.25	69144.0
2023-08-10 07:00:00	QQQ	ETF	370.21	370.56	369.901	370.08	226856.0
2023-08-10 08:00:00	QQQ	ETF	370.3909	372.31	368.185	371.67	2293141.0
2023-08-10 09:00:00	QQQ	ETF	371.73	373.98	370.3214	373.91	7207521.0
2023-08-10 10:00:00	QQQ	ETF	373.93	374.36	371.14	371.75	8601085.0
2023-08-10 11:00:00	QQQ	ETF	371.76	371.91	368.76	369.495	7323226.0
2023-08-10 12:00:00	QQQ	ETF	369.49	370.52	368.47	368.89	4752065.0
2023-08-10 13:00:00	QQQ	ETF	368.89	369.37	367.035	367.24	5176862.0
2023-08-10 14:00:00	QQQ	ETF	367.235	369.71	367.165	369.66	5124931.0
2023-08-10 15:00:00	QQQ	ETF	369.66	369.73	367.94	368.56	6852685.0
2023-08-10 16:00:00	QQQ	ETF	368.57	369.08	368.39	368.96	1261086.0
2023-08-10 17:00:00	QQQ	ETF	368.98	369.2	368.87	369.18	39085.0
2023-08-10 18:00:00	QQQ	ETF	369.12	369.49	368.99	369.39	138617.0
2023-08-10 19:00:00	QQQ	ETF	369.4	369.61	369.18	369.56	40753.0
2023-08-10 04:00:00	IWM	ETF	192.91	192.91	192.69	192.8	9023.0
2023-08-10 05:00:00	IWM	ETF	192.72	192.8	192.58	192.72	6651.0
2023-08-10 06:00:00	IWM	ETF	192.6	192.83	192.59	192.6	4862.0
2023-08-10 07:00:00	IWM	ETF	192.65	192.7	192.34	192.47	35478.0
2023-08-10 08:00:00	IWM	ETF	192.45	193.7	191.94	193.25	339788.0
2023-08-10 09:00:00	IWM	ETF	193.36	193.38	192.07	193.34	2857027.0
2023-08-10 10:00:00	IWM	ETF	193.345	194.12	191.87	192.17	5330336.0
2023-08-10 11:00:00	IWM	ETF	192.18	192.35	191.1607	191.68	2979856.0
2023-08-10 12:00:00	IWM	ETF	191.68	191.8	190.62	190.78	2366451.0
2023-08-10 13:00:00	IWM	ETF	190.7631	190.97	189.89	189.99	2891858.0
2023-08-10 14:00:00	IWM	ETF	189.98	191.15	189.965	191.13	2991579.0
2023-08-10 15:00:00	IWM	ETF	191.14	191.1793	190.305	190.71	4198303.0
2023-08-10 16:00:00	IWM	ETF	190.72	190.86	190.56	190.85	1250360.0
2023-08-10 17:00:00	IWM	ETF	190.83	190.96	190.77	190.88	2755.0
2023-08-10 18:00:00	IWM	ETF	190.87	190.99	190.87	190.92	19177.0
2023-08-10 19:00:00	IWM	ETF	190.93	191.04	190.89	190.95	27674.0
2023-08-10 04:00:00	DIA	ETF	353.33	353.33	353.13	353.13	225.0
2023-08-10 05:00:00	DIA	ETF	353.15	353.21	353.15	353.21	943.0

> showing 50 of 17,411 rows — these rows as CSV

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