PREVIEW / etf_1hour / 2023-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-11.parquet
  size:    481 KB
  rows:    17,376

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-11 04:00:00	SPY	ETF	439.68	439.87	439.13	439.44	28148.0
2023-07-11 05:00:00	SPY	ETF	439.42	440.27	439.38	440.24	27011.0
2023-07-11 06:00:00	SPY	ETF	440.21	440.3	439.93	440.01	27264.0
2023-07-11 07:00:00	SPY	ETF	439.96	440.57	439.93	440.55	108675.0
2023-07-11 08:00:00	SPY	ETF	440.07	440.86	439.83	440.77	222605.0
2023-07-11 09:00:00	SPY	ETF	440.78	441.0471	439.65	440.39	5084003.0
2023-07-11 10:00:00	SPY	ETF	440.385	440.78	439.44	440.61	5994412.0
2023-07-11 11:00:00	SPY	ETF	440.62	441.48	440.375	441.46	5625258.0
2023-07-11 12:00:00	SPY	ETF	441.45	441.7	440.45	441.14	5174638.0
2023-07-11 13:00:00	SPY	ETF	441.145	441.33	440.525	441.01	3182831.0
2023-07-11 14:00:00	SPY	ETF	441.0	441.44	440.27	441.38	4534807.0
2023-07-11 15:00:00	SPY	ETF	441.385	442.97	441.1	442.48	15970123.0
2023-07-11 16:00:00	SPY	ETF	442.485	442.54	442.2099	442.36	2960644.0
2023-07-11 17:00:00	SPY	ETF	442.31	442.44	442.28	442.32	55046.0
2023-07-11 18:00:00	SPY	ETF	442.3	442.61	442.22	442.61	83863.0
2023-07-11 19:00:00	SPY	ETF	442.62	442.74	442.33	442.41	66191.0
2023-07-11 04:00:00	QQQ	ETF	366.81	366.82	366.26	366.61	34199.0
2023-07-11 05:00:00	QQQ	ETF	366.55	367.3	366.5	367.3	20144.0
2023-07-11 06:00:00	QQQ	ETF	367.24	367.24	366.83	366.83	24944.0
2023-07-11 07:00:00	QQQ	ETF	366.81	367.46	366.8	367.42	67393.0
2023-07-11 08:00:00	QQQ	ETF	367.05	367.67	366.5604	367.43	230524.0
2023-07-11 09:00:00	QQQ	ETF	367.4301	367.55	365.3799	365.96	5239954.0
2023-07-11 10:00:00	QQQ	ETF	365.96	367.06	364.62	366.665	5274680.0
2023-07-11 11:00:00	QQQ	ETF	366.68	367.63	365.89	367.63	4094188.0
2023-07-11 12:00:00	QQQ	ETF	367.62	367.95	366.31	367.1168	4156776.0
2023-07-11 13:00:00	QQQ	ETF	367.12	367.33	366.17	366.85	2165141.0
2023-07-11 14:00:00	QQQ	ETF	366.84	367.11	365.72	367.01	2943931.0
2023-07-11 15:00:00	QQQ	ETF	367.0	368.632	366.69	368.165	5770703.0
2023-07-11 16:00:00	QQQ	ETF	368.16	368.34	367.96	368.26	1508714.0
2023-07-11 17:00:00	QQQ	ETF	368.2	368.32	368.17	368.27	39579.0
2023-07-11 18:00:00	QQQ	ETF	368.22	368.5	368.14	368.49	27325.0
2023-07-11 19:00:00	QQQ	ETF	368.6	368.69	368.2699	368.29	42959.0
2023-07-11 04:00:00	IWM	ETF	188.1	188.24	187.73	187.9	48813.0
2023-07-11 05:00:00	IWM	ETF	187.8	188.45	187.8	188.36	10503.0
2023-07-11 06:00:00	IWM	ETF	188.46	188.5	188.27	188.31	6023.0
2023-07-11 07:00:00	IWM	ETF	188.26	188.6	188.25	188.6	51903.0
2023-07-11 08:00:00	IWM	ETF	188.2799	188.8	187.8704	188.73	94208.0
2023-07-11 09:00:00	IWM	ETF	188.74	189.09	187.69	188.99	4051043.0
2023-07-11 10:00:00	IWM	ETF	189.0	189.5	188.525	188.973	3450247.0
2023-07-11 11:00:00	IWM	ETF	188.98	189.17	188.32	188.4523	2441103.0
2023-07-11 12:00:00	IWM	ETF	188.46	188.985	188.37	188.9	1268566.0
2023-07-11 13:00:00	IWM	ETF	188.905	189.01	188.6603	188.96	1191221.0
2023-07-11 14:00:00	IWM	ETF	188.96	189.44	188.731	189.44	1225693.0
2023-07-11 15:00:00	IWM	ETF	189.44	190.08	189.2901	189.76	6040506.0
2023-07-11 16:00:00	IWM	ETF	189.8	189.89	189.69	189.78	1395237.0
2023-07-11 17:00:00	IWM	ETF	189.79	189.79	189.62	189.69	51998.0
2023-07-11 18:00:00	IWM	ETF	189.65	189.98	189.62	189.98	102926.0
2023-07-11 19:00:00	IWM	ETF	189.98	190.0396	189.82	189.86	12656.0
2023-07-11 04:00:00	DIA	ETF	338.78	339.0	338.78	339.0	250.0
2023-07-11 05:00:00	DIA	ETF	339.07	339.07	339.02	339.07	332.0

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

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