PREVIEW / etf_1hour / 2023-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-13.parquet
  size:    492 KB
  rows:    17,901

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-07-13 04:00:00	SPY	ETF	447.32	447.7	447.27	447.58	48812.0
2023-07-13 05:00:00	SPY	ETF	447.63	447.88	447.33	447.4	232869.0
2023-07-13 06:00:00	SPY	ETF	447.44	447.62	447.16	447.56	24308.0
2023-07-13 07:00:00	SPY	ETF	447.51	447.71	447.28	447.71	236237.0
2023-07-13 08:00:00	SPY	ETF	447.73	447.96	447.07	447.74	488984.0
2023-07-13 09:00:00	SPY	ETF	447.71	448.51	447.45	448.39	6203604.0
2023-07-13 10:00:00	SPY	ETF	448.39	448.46	447.815	448.37	7244889.0
2023-07-13 11:00:00	SPY	ETF	448.38	448.51	447.8821	448.46	4361573.0
2023-07-13 12:00:00	SPY	ETF	448.46	448.91	448.37	448.62	4848672.0
2023-07-13 13:00:00	SPY	ETF	448.63	448.845	448.16	448.69	3493904.0
2023-07-13 14:00:00	SPY	ETF	448.685	449.28	448.63	449.28	4667553.0
2023-07-13 15:00:00	SPY	ETF	449.275	450.38	449.205	449.53	14007390.0
2023-07-13 16:00:00	SPY	ETF	449.53	449.65	449.1	449.16	3007306.0
2023-07-13 17:00:00	SPY	ETF	449.14	449.29	449.14	449.24	32555.0
2023-07-13 18:00:00	SPY	ETF	449.24	449.51	449.16	449.41	78676.0
2023-07-13 19:00:00	SPY	ETF	449.42	449.54	449.17	449.37	54825.0
2023-07-13 04:00:00	QQQ	ETF	374.81	375.35	373.57	375.32	41395.0
2023-07-13 05:00:00	QQQ	ETF	375.33	375.59	375.06	375.26	47371.0
2023-07-13 06:00:00	QQQ	ETF	375.28	375.61	375.11	375.41	35529.0
2023-07-13 07:00:00	QQQ	ETF	375.41	375.47	375.07	375.45	211977.0
2023-07-13 08:00:00	QQQ	ETF	375.3813	376.1	373.099	375.6	615100.0
2023-07-13 09:00:00	QQQ	ETF	375.64	377.0968	375.4	376.72	5857752.0
2023-07-13 10:00:00	QQQ	ETF	376.74	376.8895	375.6	376.81	6247960.0
2023-07-13 11:00:00	QQQ	ETF	376.82	377.41	376.18	377.325	3674718.0
2023-07-13 12:00:00	QQQ	ETF	377.32	378.05	377.18	377.795	4034586.0
2023-07-13 13:00:00	QQQ	ETF	377.8	378.28	377.45	378.02	3079231.0
2023-07-13 14:00:00	QQQ	ETF	378.02	378.642	377.93	378.56	3600556.0
2023-07-13 15:00:00	QQQ	ETF	378.56	379.99	378.48	379.16	8652260.0
2023-07-13 16:00:00	QQQ	ETF	379.15	379.33	378.87	378.98	1515145.0
2023-07-13 17:00:00	QQQ	ETF	379.01	379.08	378.92	379.08	50609.0
2023-07-13 18:00:00	QQQ	ETF	379.05	379.37	378.96	379.19	68981.0
2023-07-13 19:00:00	QQQ	ETF	379.18	379.46	379.14	379.31	77481.0
2023-07-13 04:00:00	IWM	ETF	192.57	192.68	192.51	192.65	9098.0
2023-07-13 05:00:00	IWM	ETF	192.53	192.71	192.42	192.43	12367.0
2023-07-13 06:00:00	IWM	ETF	192.45	192.49	192.14	192.41	13749.0
2023-07-13 07:00:00	IWM	ETF	192.37	192.66	192.31	192.65	37032.0
2023-07-13 08:00:00	IWM	ETF	192.5103	192.74	192.15	192.62	129324.0
2023-07-13 09:00:00	IWM	ETF	192.57	193.59	191.8	193.535	3546898.0
2023-07-13 10:00:00	IWM	ETF	193.55	193.66	192.6701	192.97	2741459.0
2023-07-13 11:00:00	IWM	ETF	192.99	193.2794	192.64	193.215	2144243.0
2023-07-13 12:00:00	IWM	ETF	193.22	193.49	192.99	193.345	1695331.0
2023-07-13 13:00:00	IWM	ETF	193.35	193.5	193.14	193.48	1079396.0
2023-07-13 14:00:00	IWM	ETF	193.48	193.62	193.18	193.51	1834762.0
2023-07-13 15:00:00	IWM	ETF	193.52	193.685	193.23	193.43	4007245.0
2023-07-13 16:00:00	IWM	ETF	193.43	193.53	193.0495	193.16	768577.0
2023-07-13 17:00:00	IWM	ETF	193.13	193.27	193.13	193.27	2471.0
2023-07-13 18:00:00	IWM	ETF	193.16	193.34	193.04	193.26	14705.0
2023-07-13 19:00:00	IWM	ETF	193.25	193.35	193.11	193.23	9194.0
2023-07-13 04:00:00	DIA	ETF	344.2	344.44	344.19	344.43	14280.0
2023-07-13 05:00:00	DIA	ETF	344.53	344.53	344.17	344.17	1100.0

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

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