PREVIEW / etf_1hour / 2023-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-03.parquet
  size:    501 KB
  rows:    18,551

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-03 04:00:00	SPY	ETF	430.35	430.35	430.08	430.22	34995.0
2023-11-03 05:00:00	SPY	ETF	430.15	430.26	429.84	430.25	22709.0
2023-11-03 06:00:00	SPY	ETF	430.23	430.35	430.04	430.15	64826.0
2023-11-03 07:00:00	SPY	ETF	430.01	430.55	429.9	430.55	107281.0
2023-11-03 08:00:00	SPY	ETF	430.55	433.29	429.9204	432.79	2154883.0
2023-11-03 09:00:00	SPY	ETF	432.79	435.0	432.45	434.64	9164251.0
2023-11-03 10:00:00	SPY	ETF	434.67	435.48	433.21	434.155	13304307.0
2023-11-03 11:00:00	SPY	ETF	434.16	435.2	433.53	434.975	6649593.0
2023-11-03 12:00:00	SPY	ETF	434.98	435.85	434.86	435.75	6801100.0
2023-11-03 13:00:00	SPY	ETF	435.74	435.9	434.841	435.65	6894121.0
2023-11-03 14:00:00	SPY	ETF	435.645	436.175	435.01	436.095	6420895.0
2023-11-03 15:00:00	SPY	ETF	436.1	436.29	434.66	434.67	18874154.0
2023-11-03 16:00:00	SPY	ETF	434.67	435.13	434.0	435.03	3524513.0
2023-11-03 17:00:00	SPY	ETF	435.03	435.07	434.91	434.95	65426.0
2023-11-03 18:00:00	SPY	ETF	434.96	435.14	434.95	435.05	13687.0
2023-11-03 19:00:00	SPY	ETF	435.05	435.29	434.9902	435.29	29350.0
2023-11-03 04:00:00	QQQ	ETF	362.2	362.35	362.05	362.15	101960.0
2023-11-03 05:00:00	QQQ	ETF	362.14	362.33	361.91	362.25	44340.0
2023-11-03 06:00:00	QQQ	ETF	362.25	362.36	362.01	362.13	42008.0
2023-11-03 07:00:00	QQQ	ETF	362.14	362.86	361.87	362.84	120481.0
2023-11-03 08:00:00	QQQ	ETF	362.11	365.12	361.88	364.62	1924339.0
2023-11-03 09:00:00	QQQ	ETF	364.64	366.885	364.0	366.54	6836870.0
2023-11-03 10:00:00	QQQ	ETF	366.55	367.4	364.78	366.22	7723758.0
2023-11-03 11:00:00	QQQ	ETF	366.25	367.28	365.57	366.97	4555903.0
2023-11-03 12:00:00	QQQ	ETF	366.98	368.19	366.79	368.02	4511429.0
2023-11-03 13:00:00	QQQ	ETF	368.01	368.42	367.285	368.128	3792559.0
2023-11-03 14:00:00	QQQ	ETF	368.1123	368.7699	367.6	368.66	3381608.0
2023-11-03 15:00:00	QQQ	ETF	368.67	369.02	367.71	367.73	7618091.0
2023-11-03 16:00:00	QQQ	ETF	367.72	368.07	367.65	367.96	2568434.0
2023-11-03 17:00:00	QQQ	ETF	367.94	368.01	367.85	367.9014	34945.0
2023-11-03 18:00:00	QQQ	ETF	367.95	367.9972	367.9	367.97	20264.0
2023-11-03 19:00:00	QQQ	ETF	367.97	368.12	367.95	368.12	30130.0
2023-11-03 04:00:00	IWM	ETF	170.36	170.36	170.15	170.35	14556.0
2023-11-03 05:00:00	IWM	ETF	170.04	170.24	170.04	170.19	8693.0
2023-11-03 06:00:00	IWM	ETF	170.22	170.22	170.13	170.18	7328.0
2023-11-03 07:00:00	IWM	ETF	170.13	170.55	169.95	170.54	81865.0
2023-11-03 08:00:00	IWM	ETF	170.1103	172.55	170.02	172.5	1064324.0
2023-11-03 09:00:00	IWM	ETF	172.48	175.185	172.35	175.04	8387840.0
2023-11-03 10:00:00	IWM	ETF	175.04	175.36	173.61	173.96	9359685.0
2023-11-03 11:00:00	IWM	ETF	173.96	175.085	173.77	174.765	5394869.0
2023-11-03 12:00:00	IWM	ETF	174.76	174.83	174.42	174.71	3933044.0
2023-11-03 13:00:00	IWM	ETF	174.71	174.85	174.21	174.58	3087580.0
2023-11-03 14:00:00	IWM	ETF	174.58	175.645	174.56	175.61	3973899.0
2023-11-03 15:00:00	IWM	ETF	175.62	175.63	174.34	174.42	8768536.0
2023-11-03 16:00:00	IWM	ETF	174.42	174.66	174.38	174.44	1880766.0
2023-11-03 17:00:00	IWM	ETF	174.49	174.56	174.34	174.36	259913.0
2023-11-03 18:00:00	IWM	ETF	174.42	174.4895	174.34	174.48	2097.0
2023-11-03 19:00:00	IWM	ETF	174.48	174.65	174.47	174.58	10531.0
2023-11-03 04:00:00	DIA	ETF	338.58	338.58	338.53	338.53	289.0
2023-11-03 07:00:00	DIA	ETF	338.41	338.6	338.41	338.6	2820.0

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

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