PREVIEW / etf_1hour / 2022-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-26.parquet
  size:    472 KB
  rows:    17,611

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
2022-09-26 04:00:00	SPY	ETF	367.17	368.22	365.9	367.6	59488.0
2022-09-26 05:00:00	SPY	ETF	367.54	367.76	364.44	364.82	90388.0
2022-09-26 06:00:00	SPY	ETF	365.08	366.0	364.43	365.4	180715.0
2022-09-26 07:00:00	SPY	ETF	365.32	366.0	364.81	365.76	327511.0
2022-09-26 08:00:00	SPY	ETF	365.8	368.7	364.7396	367.27	847344.0
2022-09-26 09:00:00	SPY	ETF	367.17	368.67	366.06	368.43	6919022.0
2022-09-26 10:00:00	SPY	ETF	368.48	370.21	367.38	368.48	9025715.0
2022-09-26 11:00:00	SPY	ETF	368.5	368.84	365.34	366.85	8228720.0
2022-09-26 12:00:00	SPY	ETF	366.86	366.89	363.89	365.57	7914556.0
2022-09-26 13:00:00	SPY	ETF	365.57	365.59	363.0299	363.31	8104155.0
2022-09-26 14:00:00	SPY	ETF	363.29	365.98	363.1619	365.5297	8204366.0
2022-09-26 15:00:00	SPY	ETF	365.52	366.86	363.94	364.31	17293487.0
2022-09-26 16:00:00	SPY	ETF	364.31	364.71	363.37	363.93	3551375.0
2022-09-26 17:00:00	SPY	ETF	363.9	364.31	363.75	363.91	427018.0
2022-09-26 18:00:00	SPY	ETF	363.94	364.49	363.4	364.38	177612.0
2022-09-26 19:00:00	SPY	ETF	364.43	365.31	364.43	365.1	112057.0
2022-09-26 04:00:00	QQQ	ETF	275.51	276.33	274.8	275.75	136787.0
2022-09-26 05:00:00	QQQ	ETF	275.81	275.91	273.25	273.82	174814.0
2022-09-26 06:00:00	QQQ	ETF	274.0	274.68	273.54	274.05	162906.0
2022-09-26 07:00:00	QQQ	ETF	274.03	274.36	273.37	274.1	285934.0
2022-09-26 08:00:00	QQQ	ETF	274.06	276.2796	273.15	275.76	727338.0
2022-09-26 09:00:00	QQQ	ETF	275.76	278.53	274.75	278.36	8164798.0
2022-09-26 10:00:00	QQQ	ETF	278.38	279.49	277.01	277.58	8930515.0
2022-09-26 11:00:00	QQQ	ETF	277.605	277.9	275.0504	276.47	6707314.0
2022-09-26 12:00:00	QQQ	ETF	276.5	276.505	273.96	275.4738	5820533.0
2022-09-26 13:00:00	QQQ	ETF	275.48	275.5456	273.57	273.69	5925315.0
2022-09-26 14:00:00	QQQ	ETF	273.675	276.0964	273.58	275.73	5577506.0
2022-09-26 15:00:00	QQQ	ETF	275.73	276.3	273.89	274.16	8916232.0
2022-09-26 16:00:00	QQQ	ETF	274.14	274.52	273.46	274.01	1431435.0
2022-09-26 17:00:00	QQQ	ETF	274.05	274.37	273.81	274.0	302225.0
2022-09-26 18:00:00	QQQ	ETF	274.02	274.31	273.68	274.24	230038.0
2022-09-26 19:00:00	QQQ	ETF	274.24	275.03	274.24	274.84	182353.0
2022-09-26 04:00:00	IWM	ETF	166.29	166.43	165.82	166.26	8461.0
2022-09-26 05:00:00	IWM	ETF	166.28	166.31	164.54	164.77	54127.0
2022-09-26 06:00:00	IWM	ETF	164.86	165.37	164.5	165.07	23450.0
2022-09-26 07:00:00	IWM	ETF	165.02	165.42	164.78	165.32	30320.0
2022-09-26 08:00:00	IWM	ETF	164.86	166.18	164.86	165.9	89605.0
2022-09-26 09:00:00	IWM	ETF	165.88	167.83	165.2	167.49	3495985.0
2022-09-26 10:00:00	IWM	ETF	167.5	168.97	166.84	167.21	3811062.0
2022-09-26 11:00:00	IWM	ETF	167.21	167.32	165.22	165.46	2669774.0
2022-09-26 12:00:00	IWM	ETF	165.47	165.47	164.0	164.83	2594004.0
2022-09-26 13:00:00	IWM	ETF	164.84	164.91	163.58	163.85	2127182.0
2022-09-26 14:00:00	IWM	ETF	163.82	165.36	163.775	165.04	2194022.0
2022-09-26 15:00:00	IWM	ETF	165.04	165.41	164.06	164.12	4364651.0
2022-09-26 16:00:00	IWM	ETF	164.17	164.28	163.2857	164.17	1049002.0
2022-09-26 17:00:00	IWM	ETF	164.11	164.17	163.83	163.86	253795.0
2022-09-26 18:00:00	IWM	ETF	163.97	164.35	163.65	164.28	71432.0
2022-09-26 19:00:00	IWM	ETF	164.31	164.86	164.31	164.75	46224.0
2022-09-26 04:00:00	DIA	ETF	295.39	295.69	294.8	295.35	4160.0
2022-09-26 05:00:00	DIA	ETF	295.0	295.0	293.39	293.39	10033.0

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

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