PREVIEW / etf_1hour / 2023-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-16.parquet
  size:    480 KB
  rows:    17,679

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-16 04:00:00	SPY	ETF	432.09	432.65	431.3	432.34	42194.0
2023-10-16 05:00:00	SPY	ETF	432.29	432.53	432.18	432.45	5981.0
2023-10-16 06:00:00	SPY	ETF	432.33	432.73	431.89	432.73	45305.0
2023-10-16 07:00:00	SPY	ETF	432.73	433.38	432.35	433.0	297113.0
2023-10-16 08:00:00	SPY	ETF	432.59	434.01	431.95	433.88	562539.0
2023-10-16 09:00:00	SPY	ETF	433.9	434.76	433.57	434.3	6381252.0
2023-10-16 10:00:00	SPY	ETF	434.3	436.85	433.81	436.82	11231121.0
2023-10-16 11:00:00	SPY	ETF	436.82	437.14	435.485	435.955	6824802.0
2023-10-16 12:00:00	SPY	ETF	435.96	436.23	435.47	435.975	4213055.0
2023-10-16 13:00:00	SPY	ETF	435.98	436.86	434.32	436.46	8106666.0
2023-10-16 14:00:00	SPY	ETF	436.47	436.72	435.605	436.51	5013791.0
2023-10-16 15:00:00	SPY	ETF	436.5101	436.96	435.77	436.01	16221907.0
2023-10-16 16:00:00	SPY	ETF	436.01	437.0	434.4177	436.39	3448986.0
2023-10-16 17:00:00	SPY	ETF	436.33	436.53	436.33	436.45	70179.0
2023-10-16 18:00:00	SPY	ETF	436.45	436.45	435.93	435.93	82441.0
2023-10-16 19:00:00	SPY	ETF	435.94	436.1	435.57	436.03	69783.0
2023-10-16 04:00:00	QQQ	ETF	365.0	365.85	364.42	365.6	125435.0
2023-10-16 05:00:00	QQQ	ETF	365.58	365.65	365.29	365.34	107313.0
2023-10-16 06:00:00	QQQ	ETF	365.32	365.52	364.58	365.5	129976.0
2023-10-16 07:00:00	QQQ	ETF	365.49	366.13	365.13	365.86	304258.0
2023-10-16 08:00:00	QQQ	ETF	366.21	366.8	365.1196	366.55	583075.0
2023-10-16 09:00:00	QQQ	ETF	366.57	368.66	366.38	367.87	5767365.0
2023-10-16 10:00:00	QQQ	ETF	367.88	370.22	367.45	369.8092	6514423.0
2023-10-16 11:00:00	QQQ	ETF	369.81	370.135	368.78	368.9	3655368.0
2023-10-16 12:00:00	QQQ	ETF	368.9	369.355	368.57	369.17	2348227.0
2023-10-16 13:00:00	QQQ	ETF	369.18	370.1199	367.5095	369.82	4707533.0
2023-10-16 14:00:00	QQQ	ETF	369.83	370.16	369.243	370.03	3082703.0
2023-10-16 15:00:00	QQQ	ETF	370.05	370.48	369.21	369.48	6438467.0
2023-10-16 16:00:00	QQQ	ETF	369.46	369.79	369.15	369.73	1669973.0
2023-10-16 17:00:00	QQQ	ETF	369.74	369.83	369.41	369.7	41391.0
2023-10-16 18:00:00	QQQ	ETF	369.7	369.7	369.3	369.31	34080.0
2023-10-16 19:00:00	QQQ	ETF	369.36	369.51	368.97	369.41	85385.0
2023-10-16 04:00:00	IWM	ETF	170.83	171.23	170.64	171.13	29759.0
2023-10-16 05:00:00	IWM	ETF	171.14	171.35	171.02	171.3	6508.0
2023-10-16 06:00:00	IWM	ETF	171.26	171.55	171.13	171.53	47210.0
2023-10-16 07:00:00	IWM	ETF	171.47	171.81	171.34	171.68	108722.0
2023-10-16 08:00:00	IWM	ETF	171.47	172.02	170.7504	171.97	174797.0
2023-10-16 09:00:00	IWM	ETF	171.91	172.5	171.02	171.84	4126648.0
2023-10-16 10:00:00	IWM	ETF	171.85	173.075	171.4792	173.03	4381820.0
2023-10-16 11:00:00	IWM	ETF	173.03	173.185	172.58	172.79	3213953.0
2023-10-16 12:00:00	IWM	ETF	172.8	173.18	172.72	173.035	1690419.0
2023-10-16 13:00:00	IWM	ETF	173.032	173.39	172.43	173.2709	2345503.0
2023-10-16 14:00:00	IWM	ETF	173.275	173.28	172.79	173.065	1777399.0
2023-10-16 15:00:00	IWM	ETF	173.07	173.27	172.9018	172.98	5846073.0
2023-10-16 16:00:00	IWM	ETF	173.02	173.14	172.88	173.12	799225.0
2023-10-16 17:00:00	IWM	ETF	173.08	173.15	173.05	173.1	5810.0
2023-10-16 18:00:00	IWM	ETF	173.1	173.1	172.9	172.9	15655.0
2023-10-16 19:00:00	IWM	ETF	172.92	172.93	172.73	172.91	51883.0
2023-10-16 04:00:00	DIA	ETF	337.07	337.09	337.07	337.09	1150.0
2023-10-16 06:00:00	DIA	ETF	337.87	338.11	337.84	338.09	1262.0

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

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