PREVIEW / etf_1hour / 2023-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-11.parquet
  size:    464 KB
  rows:    17,067

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-11 04:00:00	SPY	ETF	446.25	446.31	445.19	445.57	24953.0
2023-08-11 05:00:00	SPY	ETF	445.7	446.03	445.05	445.05	15252.0
2023-08-11 06:00:00	SPY	ETF	445.27	446.04	445.27	445.52	48654.0
2023-08-11 07:00:00	SPY	ETF	445.52	446.07	445.47	445.57	232089.0
2023-08-11 08:00:00	SPY	ETF	445.6816	446.27	444.09	444.25	881253.0
2023-08-11 09:00:00	SPY	ETF	444.17	444.84	443.345	444.15	5403700.0
2023-08-11 10:00:00	SPY	ETF	444.17	446.7007	444.17	445.2798	10749450.0
2023-08-11 11:00:00	SPY	ETF	445.28	445.64	444.31	445.3199	6258953.0
2023-08-11 12:00:00	SPY	ETF	445.3115	445.92	444.48	444.7	5016080.0
2023-08-11 13:00:00	SPY	ETF	444.72	445.57	444.44	444.9487	5148096.0
2023-08-11 14:00:00	SPY	ETF	444.95	446.24	444.84	446.05	5914574.0
2023-08-11 15:00:00	SPY	ETF	446.05	446.16	444.99	445.58	12501129.0
2023-08-11 16:00:00	SPY	ETF	445.58	446.0	445.0	445.81	2984488.0
2023-08-11 17:00:00	SPY	ETF	445.8	445.93	445.65	445.77	540825.0
2023-08-11 18:00:00	SPY	ETF	445.85	445.88	445.8	445.88	7662.0
2023-08-11 19:00:00	SPY	ETF	445.8501	445.9	445.77	445.81	15567.0
2023-08-11 04:00:00	QQQ	ETF	368.59	369.05	367.58	367.81	56318.0
2023-08-11 05:00:00	QQQ	ETF	368.06	368.49	367.26	367.63	56345.0
2023-08-11 06:00:00	QQQ	ETF	367.65	368.27	367.59	367.71	58935.0
2023-08-11 07:00:00	QQQ	ETF	367.81	368.42	367.8	368.009	87582.0
2023-08-11 08:00:00	QQQ	ETF	368.25	369.54	365.82	366.17	969329.0
2023-08-11 09:00:00	QQQ	ETF	366.1	366.65	365.05	365.585	4866059.0
2023-08-11 10:00:00	QQQ	ETF	365.51	368.0	365.51	366.23	7206829.0
2023-08-11 11:00:00	QQQ	ETF	366.23	366.6	364.69	365.8063	6203339.0
2023-08-11 12:00:00	QQQ	ETF	365.79	366.665	365.04	365.33	3541166.0
2023-08-11 13:00:00	QQQ	ETF	365.34	366.4	365.07	365.83	3504065.0
2023-08-11 14:00:00	QQQ	ETF	365.84	367.1	365.73	366.91	3864959.0
2023-08-11 15:00:00	QQQ	ETF	366.9	366.9499	365.75	366.21	5671060.0
2023-08-11 16:00:00	QQQ	ETF	366.22	366.55	366.19	366.3	853075.0
2023-08-11 17:00:00	QQQ	ETF	366.28	366.37	366.24	366.35	20413.0
2023-08-11 18:00:00	QQQ	ETF	366.29	366.37	366.29	366.31	9483.0
2023-08-11 19:00:00	QQQ	ETF	366.3201	366.3201	366.1	366.2	9141.0
2023-08-11 04:00:00	IWM	ETF	190.88	190.93	190.45	190.74	5000.0
2023-08-11 05:00:00	IWM	ETF	190.86	191.07	190.55	190.58	6123.0
2023-08-11 06:00:00	IWM	ETF	190.92	191.04	190.84	190.89	4078.0
2023-08-11 07:00:00	IWM	ETF	190.88	191.02	190.67	190.69	30353.0
2023-08-11 08:00:00	IWM	ETF	190.7105	190.98	190.13	190.13	96006.0
2023-08-11 09:00:00	IWM	ETF	190.04	190.7	189.74	190.32	3074658.0
2023-08-11 10:00:00	IWM	ETF	190.35	191.69	190.334	190.98	4151120.0
2023-08-11 11:00:00	IWM	ETF	191.0	191.2	190.49	191.1	1986462.0
2023-08-11 12:00:00	IWM	ETF	191.1	191.475	190.7	190.845	1503737.0
2023-08-11 13:00:00	IWM	ETF	190.835	191.16	190.6	190.86	1562280.0
2023-08-11 14:00:00	IWM	ETF	190.87	191.21	190.8	191.155	1437740.0
2023-08-11 15:00:00	IWM	ETF	191.15	191.2899	190.79	191.02	3271414.0
2023-08-11 16:00:00	IWM	ETF	190.99	191.14	190.99	191.04	1379144.0
2023-08-11 17:00:00	IWM	ETF	191.0	191.09	190.99	191.09	3386.0
2023-08-11 18:00:00	IWM	ETF	191.01	191.09	191.01	191.09	576.0
2023-08-11 19:00:00	IWM	ETF	191.05	191.12	190.92	191.09	4244.0
2023-08-11 04:00:00	DIA	ETF	352.28	352.28	352.05	352.05	875.0
2023-08-11 05:00:00	DIA	ETF	352.26	352.26	351.75	351.75	800.0

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

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