PREVIEW / etf_1hour / 2023-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-09.parquet
  size:    495 KB
  rows:    18,251

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-09 04:00:00	SPY	ETF	437.58	437.73	437.3	437.59	12249.0
2023-11-09 05:00:00	SPY	ETF	437.6	438.53	437.6	438.45	52473.0
2023-11-09 06:00:00	SPY	ETF	438.4	438.4	437.71	437.74	37982.0
2023-11-09 07:00:00	SPY	ETF	437.74	438.12	437.74	438.12	190431.0
2023-11-09 08:00:00	SPY	ETF	437.9503	438.75	437.12	438.61	275507.0
2023-11-09 09:00:00	SPY	ETF	438.65	438.8	436.98	437.88	5059539.0
2023-11-09 10:00:00	SPY	ETF	437.88	438.1593	436.08	436.98	7523335.0
2023-11-09 11:00:00	SPY	ETF	436.97	438.08	436.95	437.7988	6248150.0
2023-11-09 12:00:00	SPY	ETF	437.81	437.89	437.08	437.605	3957099.0
2023-11-09 13:00:00	SPY	ETF	437.6	437.6709	435.15	435.46	11594086.0
2023-11-09 14:00:00	SPY	ETF	435.44	435.44	433.64	433.85	11415874.0
2023-11-09 15:00:00	SPY	ETF	433.845	434.33	433.4	433.87	14964818.0
2023-11-09 16:00:00	SPY	ETF	433.87	437.6161	433.7684	434.08	4012390.0
2023-11-09 17:00:00	SPY	ETF	434.1	434.17	433.95	434.01	109768.0
2023-11-09 18:00:00	SPY	ETF	434.02	434.02	433.36	433.63	136611.0
2023-11-09 19:00:00	SPY	ETF	433.6	433.64	433.07	433.64	78011.0
2023-11-09 04:00:00	QQQ	ETF	372.84	373.0	372.63	372.88	38276.0
2023-11-09 05:00:00	QQQ	ETF	372.91	373.57	372.91	373.4	84812.0
2023-11-09 06:00:00	QQQ	ETF	373.46	373.46	372.66	372.7	23036.0
2023-11-09 07:00:00	QQQ	ETF	372.75	373.13	372.71	373.12	82185.0
2023-11-09 08:00:00	QQQ	ETF	372.98	373.62	372.7	373.5801	402334.0
2023-11-09 09:00:00	QQQ	ETF	373.61	374.08	372.72	374.07	3704278.0
2023-11-09 10:00:00	QQQ	ETF	374.08	374.32	372.2201	373.26	5183724.0
2023-11-09 11:00:00	QQQ	ETF	373.24	374.8	373.215	374.55	4715729.0
2023-11-09 12:00:00	QQQ	ETF	374.555	374.58	373.08	373.9	3265524.0
2023-11-09 13:00:00	QQQ	ETF	373.91	373.96	371.25	372.15	7561140.0
2023-11-09 14:00:00	QQQ	ETF	372.14	372.1499	370.02	370.2	6913661.0
2023-11-09 15:00:00	QQQ	ETF	370.18	370.4699	369.57	370.085	8313220.0
2023-11-09 16:00:00	QQQ	ETF	370.09	370.24	369.96	370.03	1516628.0
2023-11-09 17:00:00	QQQ	ETF	370.02	370.02	369.75	369.86	62166.0
2023-11-09 18:00:00	QQQ	ETF	369.9	369.92	369.27	369.47	115432.0
2023-11-09 19:00:00	QQQ	ETF	369.49	369.5	368.9	369.46	121078.0
2023-11-09 04:00:00	IWM	ETF	170.32	170.41	170.02	170.27	9158.0
2023-11-09 05:00:00	IWM	ETF	170.43	170.99	170.41	170.99	20276.0
2023-11-09 06:00:00	IWM	ETF	170.97	170.98	170.64	170.8	89260.0
2023-11-09 07:00:00	IWM	ETF	170.73	170.99	170.73	170.97	112510.0
2023-11-09 08:00:00	IWM	ETF	170.79	171.31	170.03	171.17	297214.0
2023-11-09 09:00:00	IWM	ETF	171.18	171.33	170.0	170.74	4018247.0
2023-11-09 10:00:00	IWM	ETF	170.75	170.97	169.29	169.72	3636794.0
2023-11-09 11:00:00	IWM	ETF	169.69	169.95	169.505	169.8	2705391.0
2023-11-09 12:00:00	IWM	ETF	169.81	170.19	169.58	169.7437	1826104.0
2023-11-09 13:00:00	IWM	ETF	169.74	169.785	168.05	168.16	4944233.0
2023-11-09 14:00:00	IWM	ETF	168.16	168.16	167.2	167.245	5512731.0
2023-11-09 15:00:00	IWM	ETF	167.245	167.54	166.98	167.31	6482720.0
2023-11-09 16:00:00	IWM	ETF	167.24	167.58	167.2364	167.47	1159876.0
2023-11-09 17:00:00	IWM	ETF	167.47	167.47	167.2	167.26	49763.0
2023-11-09 18:00:00	IWM	ETF	167.38	167.46	167.1	167.18	95326.0
2023-11-09 19:00:00	IWM	ETF	167.16	167.24	166.97	167.24	69913.0
2023-11-09 04:00:00	DIA	ETF	341.44	341.67	341.39	341.65	1813.0
2023-11-09 05:00:00	DIA	ETF	341.72	342.18	341.72	342.18	2356.0

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

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