PREVIEW / etf_1hour / 2023-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-18.parquet
  size:    486 KB
  rows:    17,773

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-10-18 04:00:00	SPY	ETF	435.18	435.6	434.72	435.39	20456.0
2023-10-18 05:00:00	SPY	ETF	435.33	435.6	434.53	434.59	40485.0
2023-10-18 06:00:00	SPY	ETF	434.53	434.7	433.81	434.08	67298.0
2023-10-18 07:00:00	SPY	ETF	434.1	434.54	434.01	434.36	177758.0
2023-10-18 08:00:00	SPY	ETF	434.24	435.57	433.69	433.8	390249.0
2023-10-18 09:00:00	SPY	ETF	433.72	434.78	433.52	433.99	5827706.0
2023-10-18 10:00:00	SPY	ETF	433.99	435.18	432.21	432.55	12165326.0
2023-10-18 11:00:00	SPY	ETF	432.572	433.58	432.23	432.51	8079534.0
2023-10-18 12:00:00	SPY	ETF	432.52	433.49	431.4	431.53	8025731.0
2023-10-18 13:00:00	SPY	ETF	431.51	433.81	431.09	432.49	11993759.0
2023-10-18 14:00:00	SPY	ETF	432.49	433.28	430.815	431.21	7860121.0
2023-10-18 15:00:00	SPY	ETF	431.21	431.215	429.09	430.25	19815742.0
2023-10-18 16:00:00	SPY	ETF	430.24	435.0607	430.21	430.73	3741211.0
2023-10-18 17:00:00	SPY	ETF	430.79	431.0	430.7	430.7	85826.0
2023-10-18 18:00:00	SPY	ETF	430.7	430.75	430.1	430.1	109019.0
2023-10-18 19:00:00	SPY	ETF	430.14	430.41	430.03	430.4	66037.0
2023-10-18 04:00:00	QQQ	ETF	367.3	367.65	366.83	367.45	36524.0
2023-10-18 05:00:00	QQQ	ETF	367.34	367.64	366.24	366.49	68962.0
2023-10-18 06:00:00	QQQ	ETF	366.56	366.76	365.87	366.0	212608.0
2023-10-18 07:00:00	QQQ	ETF	366.04	366.57	365.97	366.25	207499.0
2023-10-18 08:00:00	QQQ	ETF	366.22	368.476	365.55	365.6	662743.0
2023-10-18 09:00:00	QQQ	ETF	365.63	367.33	365.48	366.5	4756340.0
2023-10-18 10:00:00	QQQ	ETF	366.51	367.91	364.7799	364.95	7325899.0
2023-10-18 11:00:00	QQQ	ETF	364.96	366.33	364.905	365.62	4578303.0
2023-10-18 12:00:00	QQQ	ETF	365.65	366.78	364.465	364.66	4949995.0
2023-10-18 13:00:00	QQQ	ETF	364.64	366.68	364.09	365.26	6146491.0
2023-10-18 14:00:00	QQQ	ETF	365.26	365.85	363.61	364.01	4830581.0
2023-10-18 15:00:00	QQQ	ETF	364.01	364.03	362.02	363.09	9675666.0
2023-10-18 16:00:00	QQQ	ETF	363.11	364.3	363.11	364.0	1891453.0
2023-10-18 17:00:00	QQQ	ETF	364.0	364.44	363.93	363.95	169789.0
2023-10-18 18:00:00	QQQ	ETF	363.93	363.93	363.26	363.27	124991.0
2023-10-18 19:00:00	QQQ	ETF	363.37	363.4799	363.16	363.44	69300.0
2023-10-18 04:00:00	IWM	ETF	174.58	174.85	174.42	174.85	17822.0
2023-10-18 05:00:00	IWM	ETF	174.7	174.73	174.26	174.4	6495.0
2023-10-18 06:00:00	IWM	ETF	174.32	174.35	173.7	173.85	46239.0
2023-10-18 07:00:00	IWM	ETF	173.9	174.12	173.78	174.01	179061.0
2023-10-18 08:00:00	IWM	ETF	173.96	175.1	173.65	173.71	139161.0
2023-10-18 09:00:00	IWM	ETF	173.6	173.88	172.29	172.52	5005294.0
2023-10-18 10:00:00	IWM	ETF	172.52	173.395	172.11	172.24	4172973.0
2023-10-18 11:00:00	IWM	ETF	172.24	172.735	172.01	172.15	2916141.0
2023-10-18 12:00:00	IWM	ETF	172.15	172.48	171.75	171.98	2873049.0
2023-10-18 13:00:00	IWM	ETF	171.98	173.0	171.81	172.39	3803003.0
2023-10-18 14:00:00	IWM	ETF	172.39	172.7	171.68	171.77	2955808.0
2023-10-18 15:00:00	IWM	ETF	171.76	171.76	170.995	171.29	7431103.0
2023-10-18 16:00:00	IWM	ETF	171.29	171.59	171.21	171.24	1482596.0
2023-10-18 17:00:00	IWM	ETF	171.26	171.6	171.26	171.4	63317.0
2023-10-18 18:00:00	IWM	ETF	171.4	171.43	171.16	171.16	44283.0
2023-10-18 19:00:00	IWM	ETF	171.2	171.27	171.09	171.27	49036.0
2023-10-18 04:00:00	DIA	ETF	339.44	339.9	339.44	339.9	833.0
2023-10-18 05:00:00	DIA	ETF	339.38	339.38	339.38	339.38	400.0

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

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