PREVIEW / etf_1hour / 2023-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-06.parquet
  size:    498 KB
  rows:    18,416

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-06 04:00:00	SPY	ETF	435.02	435.67	435.02	435.56	71701.0
2023-11-06 05:00:00	SPY	ETF	435.74	435.77	435.44	435.6	12627.0
2023-11-06 06:00:00	SPY	ETF	435.56	435.91	435.47	435.66	36507.0
2023-11-06 07:00:00	SPY	ETF	435.66	435.72	435.29	435.54	113129.0
2023-11-06 08:00:00	SPY	ETF	435.53	435.8596	434.96	435.37	307446.0
2023-11-06 09:00:00	SPY	ETF	435.42	436.1498	435.01	435.45	5936362.0
2023-11-06 10:00:00	SPY	ETF	435.46	435.8801	434.74	435.42	7570296.0
2023-11-06 11:00:00	SPY	ETF	435.43	435.81	435.04	435.565	4935803.0
2023-11-06 12:00:00	SPY	ETF	435.57	435.64	434.4796	434.98	4427891.0
2023-11-06 13:00:00	SPY	ETF	434.99	434.995	433.68	434.2912	6700998.0
2023-11-06 14:00:00	SPY	ETF	434.3	435.17	433.71	435.09	6629685.0
2023-11-06 15:00:00	SPY	ETF	435.09	435.74	434.7	435.65	12961676.0
2023-11-06 16:00:00	SPY	ETF	435.65	435.73	435.0	435.27	4236254.0
2023-11-06 17:00:00	SPY	ETF	435.33	435.45	435.26	435.27	33652.0
2023-11-06 18:00:00	SPY	ETF	435.27	435.27	434.78	434.9	82268.0
2023-11-06 19:00:00	SPY	ETF	434.89	434.92	434.74	434.75	53198.0
2023-11-06 04:00:00	QQQ	ETF	367.99	368.8	367.99	368.74	76652.0
2023-11-06 05:00:00	QQQ	ETF	368.82	369.0	368.6	368.83	102999.0
2023-11-06 06:00:00	QQQ	ETF	368.81	368.91	368.58	368.74	13627.0
2023-11-06 07:00:00	QQQ	ETF	368.75	368.83	368.36	368.59	108916.0
2023-11-06 08:00:00	QQQ	ETF	368.71	368.9796	367.87	368.5	232630.0
2023-11-06 09:00:00	QQQ	ETF	368.53	369.78	368.33	368.8	4522120.0
2023-11-06 10:00:00	QQQ	ETF	368.83	369.5	368.02	368.92	4674696.0
2023-11-06 11:00:00	QQQ	ETF	368.91	369.38	368.25	368.97	3760680.0
2023-11-06 12:00:00	QQQ	ETF	368.97	369.0	367.95	368.54	2977901.0
2023-11-06 13:00:00	QQQ	ETF	368.54	368.5487	366.91	367.65	4327830.0
2023-11-06 14:00:00	QQQ	ETF	367.67	368.66	367.02	368.58	3844982.0
2023-11-06 15:00:00	QQQ	ETF	368.585	369.29	368.27	369.22	5130388.0
2023-11-06 16:00:00	QQQ	ETF	369.21	369.25	368.81	368.96	1320359.0
2023-11-06 17:00:00	QQQ	ETF	369.01	369.01	368.81	368.81	29741.0
2023-11-06 18:00:00	QQQ	ETF	368.75	368.82	368.51	368.64	48211.0
2023-11-06 19:00:00	QQQ	ETF	368.65	368.73	368.47	368.52	53109.0
2023-11-06 04:00:00	IWM	ETF	174.68	174.7	174.48	174.52	15061.0
2023-11-06 05:00:00	IWM	ETF	174.58	174.69	174.43	174.52	6142.0
2023-11-06 06:00:00	IWM	ETF	174.56	174.8	174.56	174.6	43992.0
2023-11-06 07:00:00	IWM	ETF	174.62	174.65	174.3	174.43	62173.0
2023-11-06 08:00:00	IWM	ETF	174.54	174.75	174.34	174.6	125606.0
2023-11-06 09:00:00	IWM	ETF	174.67	174.99	172.8105	173.08	4258934.0
2023-11-06 10:00:00	IWM	ETF	173.08	173.26	172.34	172.61	4820060.0
2023-11-06 11:00:00	IWM	ETF	172.61	172.865	172.26	172.72	2971505.0
2023-11-06 12:00:00	IWM	ETF	172.72	172.84	172.14	172.33	1798551.0
2023-11-06 13:00:00	IWM	ETF	172.33	172.35	171.39	171.98	3193464.0
2023-11-06 14:00:00	IWM	ETF	171.99	172.39	171.63	172.365	3016002.0
2023-11-06 15:00:00	IWM	ETF	172.36	172.45	172.02	172.36	4888915.0
2023-11-06 16:00:00	IWM	ETF	172.36	172.45	172.1	172.21	1925531.0
2023-11-06 17:00:00	IWM	ETF	172.21	172.28	172.07	172.07	20522.0
2023-11-06 18:00:00	IWM	ETF	172.16	172.16	171.86	172.0	18172.0
2023-11-06 19:00:00	IWM	ETF	171.99	172.09	171.97	171.99	45554.0
2023-11-06 04:00:00	DIA	ETF	341.22	341.22	340.95	340.95	350.0
2023-11-06 05:00:00	DIA	ETF	340.84	340.84	340.84	340.84	100.0

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

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