PREVIEW / etf_1hour / 2023-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-10.parquet
  size:    488 KB
  rows:    17,608

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-10 04:00:00	SPY	ETF	432.64	433.43	432.32	433.32	76394.0
2023-10-10 05:00:00	SPY	ETF	433.34	433.34	432.87	433.09	40182.0
2023-10-10 06:00:00	SPY	ETF	433.07	433.44	432.98	433.0	29247.0
2023-10-10 07:00:00	SPY	ETF	432.97	433.1	432.07	432.16	251995.0
2023-10-10 08:00:00	SPY	ETF	433.04	433.28	432.02	432.82	436898.0
2023-10-10 09:00:00	SPY	ETF	432.82	433.65	432.5	433.64	5705643.0
2023-10-10 10:00:00	SPY	ETF	433.64	435.7	433.63	435.3076	11799803.0
2023-10-10 11:00:00	SPY	ETF	435.33	437.1	435.14	436.98	8818868.0
2023-10-10 12:00:00	SPY	ETF	437.0	437.22	436.5762	436.825	4859001.0
2023-10-10 13:00:00	SPY	ETF	436.83	436.835	434.66	435.43	10226210.0
2023-10-10 14:00:00	SPY	ETF	435.4399	435.73	434.29	434.6022	7041723.0
2023-10-10 15:00:00	SPY	ETF	434.61	435.16	434.325	434.48	13459739.0
2023-10-10 16:00:00	SPY	ETF	434.48	436.8409	433.6264	434.48	2272661.0
2023-10-10 17:00:00	SPY	ETF	434.45	434.57	434.36	434.47	41780.0
2023-10-10 18:00:00	SPY	ETF	434.45	434.5899	434.31	434.5	28577.0
2023-10-10 19:00:00	SPY	ETF	434.55	434.69	434.55	434.65	42503.0
2023-10-10 04:00:00	QQQ	ETF	367.2	367.79	366.75	367.58	68251.0
2023-10-10 05:00:00	QQQ	ETF	367.52	367.52	367.16	367.39	19274.0
2023-10-10 06:00:00	QQQ	ETF	367.29	367.77	367.26	367.33	29006.0
2023-10-10 07:00:00	QQQ	ETF	367.31	367.42	366.24	366.4	170130.0
2023-10-10 08:00:00	QQQ	ETF	367.29	367.72	366.35	366.729	329756.0
2023-10-10 09:00:00	QQQ	ETF	366.7	367.88	366.39	367.86	3764219.0
2023-10-10 10:00:00	QQQ	ETF	367.86	369.91	367.7988	369.678	7031546.0
2023-10-10 11:00:00	QQQ	ETF	369.68	371.28	369.5	371.0099	5393204.0
2023-10-10 12:00:00	QQQ	ETF	371.0	371.09	370.4903	370.715	3285573.0
2023-10-10 13:00:00	QQQ	ETF	370.72	370.72	368.181	369.06	6630984.0
2023-10-10 14:00:00	QQQ	ETF	369.07	369.55	368.34	368.7	4482516.0
2023-10-10 15:00:00	QQQ	ETF	368.71	369.27	368.39	368.54	5681459.0
2023-10-10 16:00:00	QQQ	ETF	368.54	368.96	368.53	368.84	1385952.0
2023-10-10 17:00:00	QQQ	ETF	368.85	368.85	368.72	368.77	33643.0
2023-10-10 18:00:00	QQQ	ETF	368.78	368.9296	368.66	368.89	47933.0
2023-10-10 19:00:00	QQQ	ETF	368.92	369.02	368.92	368.97	49796.0
2023-10-10 04:00:00	IWM	ETF	174.23	174.87	174.06	174.86	19869.0
2023-10-10 05:00:00	IWM	ETF	174.68	174.81	174.57	174.72	11520.0
2023-10-10 06:00:00	IWM	ETF	174.66	174.76	174.58	174.67	36913.0
2023-10-10 07:00:00	IWM	ETF	174.5	174.55	173.87	173.9	23799.0
2023-10-10 08:00:00	IWM	ETF	174.5	174.6996	173.75	174.15	150694.0
2023-10-10 09:00:00	IWM	ETF	174.13	175.56	173.96	175.55	3497410.0
2023-10-10 10:00:00	IWM	ETF	175.55	176.682	175.52	176.48	5331936.0
2023-10-10 11:00:00	IWM	ETF	176.49	177.04	176.36	176.83	3427398.0
2023-10-10 12:00:00	IWM	ETF	176.8409	176.92	176.63	176.88	1950803.0
2023-10-10 13:00:00	IWM	ETF	176.88	176.88	176.005	176.6295	3152877.0
2023-10-10 14:00:00	IWM	ETF	176.63	176.8	176.2209	176.49	2755658.0
2023-10-10 15:00:00	IWM	ETF	176.48	176.58	175.88	175.95	4411177.0
2023-10-10 16:00:00	IWM	ETF	175.97	176.23	175.91	175.96	929470.0
2023-10-10 17:00:00	IWM	ETF	175.97	176.03	175.93	175.93	470351.0
2023-10-10 18:00:00	IWM	ETF	175.93	175.98	175.87	175.97	6260.0
2023-10-10 19:00:00	IWM	ETF	175.97	176.02	175.9	175.97	36876.0
2023-10-10 05:00:00	DIA	ETF	336.69	336.84	336.69	336.82	1250.0
2023-10-10 07:00:00	DIA	ETF	336.78	336.78	336.32	336.32	4390.0

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

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