PREVIEW / etf_1hour / 2023-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-07.parquet
  size:    495 KB
  rows:    18,245

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-11-07 04:00:00	SPY	ETF	434.96	435.0	434.49	434.52	15012.0
2023-11-07 05:00:00	SPY	ETF	434.44	434.98	434.41	434.73	13947.0
2023-11-07 06:00:00	SPY	ETF	434.71	434.72	433.94	434.36	153400.0
2023-11-07 07:00:00	SPY	ETF	434.4	434.77	434.34	434.76	253556.0
2023-11-07 08:00:00	SPY	ETF	434.6	435.35	434.15	435.34	269660.0
2023-11-07 09:00:00	SPY	ETF	435.35	435.8	434.51	435.555	5776408.0
2023-11-07 10:00:00	SPY	ETF	435.55	437.44	435.39	437.17	8801189.0
2023-11-07 11:00:00	SPY	ETF	437.17	437.51	436.62	436.87	5910450.0
2023-11-07 12:00:00	SPY	ETF	436.885	436.8899	435.86	436.7	5167608.0
2023-11-07 13:00:00	SPY	ETF	436.7	437.47	436.56	437.225	5189241.0
2023-11-07 14:00:00	SPY	ETF	437.22	437.46	436.81	436.88	4237433.0
2023-11-07 15:00:00	SPY	ETF	436.9	437.585	436.21	436.87	12516880.0
2023-11-07 16:00:00	SPY	ETF	436.86	437.0467	436.7576	437.02	2402146.0
2023-11-07 17:00:00	SPY	ETF	437.02	437.05	436.96	437.0	73728.0
2023-11-07 18:00:00	SPY	ETF	437.0	437.0	436.75	436.7705	44669.0
2023-11-07 19:00:00	SPY	ETF	436.79	436.91	436.68	436.71	25248.0
2023-11-07 04:00:00	QQQ	ETF	369.0	369.02	368.29	368.29	20710.0
2023-11-07 05:00:00	QQQ	ETF	368.32	368.8	368.2	368.5	31813.0
2023-11-07 06:00:00	QQQ	ETF	368.58	368.58	367.99	368.3	34020.0
2023-11-07 07:00:00	QQQ	ETF	368.31	369.05	368.31	369.0	167454.0
2023-11-07 08:00:00	QQQ	ETF	368.89	369.75	367.9196	369.75	368757.0
2023-11-07 09:00:00	QQQ	ETF	369.74	370.945	369.045	370.8101	5381274.0
2023-11-07 10:00:00	QQQ	ETF	370.82	373.1872	370.225	372.9709	7555455.0
2023-11-07 11:00:00	QQQ	ETF	372.98	373.35	372.21	372.68	5104134.0
2023-11-07 12:00:00	QQQ	ETF	372.68	372.73	371.6	372.6205	4389727.0
2023-11-07 13:00:00	QQQ	ETF	372.63	373.48	372.465	373.3099	4149061.0
2023-11-07 14:00:00	QQQ	ETF	373.3	373.58	372.82	372.95	3159103.0
2023-11-07 15:00:00	QQQ	ETF	372.96	373.4709	372.19	372.67	7318921.0
2023-11-07 16:00:00	QQQ	ETF	372.67	372.82	372.4364	372.73	1042392.0
2023-11-07 17:00:00	QQQ	ETF	372.74	372.7892	372.6	372.69	24742.0
2023-11-07 18:00:00	QQQ	ETF	372.62	372.66	372.45	372.55	47529.0
2023-11-07 19:00:00	QQQ	ETF	372.51	372.7	372.38	372.46	33444.0
2023-11-07 04:00:00	IWM	ETF	172.23	172.24	171.92	171.92	20856.0
2023-11-07 05:00:00	IWM	ETF	171.89	172.19	171.87	172.14	6698.0
2023-11-07 06:00:00	IWM	ETF	172.01	172.01	171.45	171.62	15318.0
2023-11-07 07:00:00	IWM	ETF	171.63	171.76	171.47	171.69	70433.0
2023-11-07 08:00:00	IWM	ETF	171.65	172.23	171.46	172.16	302104.0
2023-11-07 09:00:00	IWM	ETF	172.16	172.21	170.57	171.76	4670500.0
2023-11-07 10:00:00	IWM	ETF	171.76	172.51	171.43	172.19	4887911.0
2023-11-07 11:00:00	IWM	ETF	172.185	172.185	171.7	171.87	2526941.0
2023-11-07 12:00:00	IWM	ETF	171.87	171.871	171.07	171.41	2117949.0
2023-11-07 13:00:00	IWM	ETF	171.41	171.86	171.32	171.665	2440337.0
2023-11-07 14:00:00	IWM	ETF	171.67	171.915	171.61	171.82	1350943.0
2023-11-07 15:00:00	IWM	ETF	171.815	172.275	171.68	171.85	5003001.0
2023-11-07 16:00:00	IWM	ETF	171.7	171.9	171.7	171.8	1597447.0
2023-11-07 17:00:00	IWM	ETF	171.75	171.76	171.69	171.69	35418.0
2023-11-07 18:00:00	IWM	ETF	171.71	171.79	171.65	171.67	40127.0
2023-11-07 19:00:00	IWM	ETF	171.64	171.719	171.59	171.6001	45632.0
2023-11-07 06:00:00	DIA	ETF	340.09	340.09	340.09	340.09	100.0
2023-11-07 07:00:00	DIA	ETF	340.11	340.11	339.96	339.99	3800.0

> showing 50 of 18,245 rows — these rows as CSV

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