PREVIEW / etf_1hour / 2023-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-28.parquet
  size:    467 KB
  rows:    16,958

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-28 04:00:00	SPY	ETF	437.3	440.93	437.3	440.64	9166.0
2023-08-28 05:00:00	SPY	ETF	440.54	440.82	440.26	440.57	9242.0
2023-08-28 06:00:00	SPY	ETF	440.58	440.61	440.15	440.53	22212.0
2023-08-28 07:00:00	SPY	ETF	440.5	440.91	440.43	440.901	73439.0
2023-08-28 08:00:00	SPY	ETF	440.7787	442.15	440.15	442.09	290534.0
2023-08-28 09:00:00	SPY	ETF	442.1	443.209	441.785	442.58	6109888.0
2023-08-28 10:00:00	SPY	ETF	442.6	443.23	441.36	442.07	7398379.0
2023-08-28 11:00:00	SPY	ETF	442.07	442.08	440.9	441.489	6295661.0
2023-08-28 12:00:00	SPY	ETF	441.49	442.62	440.955	442.58	4582148.0
2023-08-28 13:00:00	SPY	ETF	442.58	443.26	440.86	441.14	6814234.0
2023-08-28 14:00:00	SPY	ETF	441.13	441.96	440.89	441.85	5674953.0
2023-08-28 15:00:00	SPY	ETF	441.86	443.4	441.38	442.72	10957921.0
2023-08-28 16:00:00	SPY	ETF	442.71	442.96	442.58	442.94	2565505.0
2023-08-28 17:00:00	SPY	ETF	442.95	442.99	439.97	442.95	1479286.0
2023-08-28 18:00:00	SPY	ETF	442.97	443.17	442.97	443.04	45570.0
2023-08-28 19:00:00	SPY	ETF	443.01	443.01	442.77	442.84	47663.0
2023-08-28 04:00:00	QQQ	ETF	364.5	365.35	364.5	365.13	27383.0
2023-08-28 05:00:00	QQQ	ETF	365.07	365.12	364.54	364.88	16446.0
2023-08-28 06:00:00	QQQ	ETF	364.78	365.1	364.54	364.9	16818.0
2023-08-28 07:00:00	QQQ	ETF	364.9	365.5	364.88	365.35	80559.0
2023-08-28 08:00:00	QQQ	ETF	365.15	366.87	364.27	366.86	285264.0
2023-08-28 09:00:00	QQQ	ETF	366.81	367.71	364.71	365.89	5984774.0
2023-08-28 10:00:00	QQQ	ETF	365.91	366.97	364.63	365.4401	5657860.0
2023-08-28 11:00:00	QQQ	ETF	365.44	365.6	364.25	365.0401	4311359.0
2023-08-28 12:00:00	QQQ	ETF	365.03	366.45	364.49	366.4	3268743.0
2023-08-28 13:00:00	QQQ	ETF	366.4	367.18	364.62	364.88	4275928.0
2023-08-28 14:00:00	QQQ	ETF	364.89	365.98	364.76	365.85	3456775.0
2023-08-28 15:00:00	QQQ	ETF	365.86	367.3	365.365	366.85	6271063.0
2023-08-28 16:00:00	QQQ	ETF	366.85	367.07	366.71	367.05	869411.0
2023-08-28 17:00:00	QQQ	ETF	367.04	367.04	366.76	367.01	64146.0
2023-08-28 18:00:00	QQQ	ETF	367.04	367.34	367.04	367.21	51029.0
2023-08-28 19:00:00	QQQ	ETF	367.23	367.23	366.93	367.02	38218.0
2023-08-28 04:00:00	IWM	ETF	184.17	184.38	184.16	184.16	3900.0
2023-08-28 05:00:00	IWM	ETF	184.09	184.35	184.09	184.31	3618.0
2023-08-28 06:00:00	IWM	ETF	184.26	184.31	184.09	184.23	4783.0
2023-08-28 07:00:00	IWM	ETF	184.28	184.47	184.24	184.46	8613.0
2023-08-28 08:00:00	IWM	ETF	184.4106	185.02	184.32	184.98	54845.0
2023-08-28 09:00:00	IWM	ETF	184.93	186.59	184.8	186.59	3005453.0
2023-08-28 10:00:00	IWM	ETF	186.589	186.75	185.83	186.24	3206122.0
2023-08-28 11:00:00	IWM	ETF	186.24	186.27	185.515	185.77	1582985.0
2023-08-28 12:00:00	IWM	ETF	185.77	186.095	185.48	186.08	1183633.0
2023-08-28 13:00:00	IWM	ETF	186.08	186.26	185.23	185.35	2033959.0
2023-08-28 14:00:00	IWM	ETF	185.34	185.65	185.205	185.6	2391844.0
2023-08-28 15:00:00	IWM	ETF	185.61	186.02	185.29	185.61	3529996.0
2023-08-28 16:00:00	IWM	ETF	185.64	185.75	185.58	185.75	557724.0
2023-08-28 17:00:00	IWM	ETF	185.77	185.88	185.76	185.84	5472.0
2023-08-28 18:00:00	IWM	ETF	185.78	185.87	185.77	185.79	7011.0
2023-08-28 19:00:00	IWM	ETF	185.84	185.84	185.64	185.64	14110.0
2023-08-28 04:00:00	DIA	ETF	344.27	344.32	344.23	344.32	398.0
2023-08-28 07:00:00	DIA	ETF	344.28	344.5	344.28	344.5	2019.0

> showing 50 of 16,958 rows — these rows as CSV

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