PREVIEW / etf_daily / 2023-03-17

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-17.parquet
  size:    109 KB
  rows:    2,927

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2023-03-17	SPY	ETF	393.22	394.4	388.55	389.99	140553400.0
2023-03-17	QQQ	ETF	306.72	309.15	303.37	305.36	89923732.0
2023-03-17	IWM	ETF	174.04	174.76	170.86	171.23	70239900.0
2023-03-17	DIA	ETF	320.72	321.09	317.16	318.5	5314900.0
2023-03-17	GLD	ETF	181.02	184.81	180.77	183.77	24156300.0
2023-03-17	TLT	ETF	106.65	107.73	106.46	106.85	38129000.0
2023-03-17	AAA	ETF	24.49	24.49	24.49	24.49	124.0
2023-03-17	AAAU	ETF	19.31	19.72	19.29	19.6	2316900.0
2023-03-17	AADR	ETF	44.95	45.1	44.95	45.1	200.0
2023-03-17	AAPB	ETF	20.62	20.7117	20.4408	20.4408	1102.0
2023-03-17	AAPD	ETF	25.14	25.41	25.05	25.2991	99596.0
2023-03-17	AAPU	ETF	21.58	21.73	21.23	21.4	90302.0
2023-03-17	AAXJ	ETF	64.94	65.15	64.56	64.77	324100.0
2023-03-17	ABEQ	ETF	27.15	27.15	26.975	26.997	3300.0
2023-03-17	ACES	ETF	43.9	43.9	42.17	42.88	129500.0
2023-03-17	ACIO	ETF	29.57	29.57	29.28	29.367	32100.0
2023-03-17	ACSI	ETF	42.6107	42.6107	42.6107	42.6107	4.0
2023-03-17	ACT	ETF	22.08	22.3	21.5	21.7	234684.0
2023-03-17	ACTV	ETF	28.38	28.5685	28.1	28.1707	6205.0
2023-03-17	ACVF	ETF	30.45	30.45	30.07	30.086	3100.0
2023-03-17	ACWF	ETF	32.1	32.2012	32.042	32.1145	21194.0
2023-03-17	ACWI	ETF	87.16	87.32	86.23	86.57	2466800.0
2023-03-17	ACWV	ETF	93.69	93.82	93.22	93.37	95900.0
2023-03-17	ACWX	ETF	46.24	46.27	45.85	46.04	989903.0
2023-03-17	ADFI	ETF	8.441	8.467	8.441	8.467	4400.0
2023-03-17	ADIV	ETF	13.479	13.479	13.479	13.479	100.0
2023-03-17	ADME	ETF	34.1	34.1	33.66	33.81	11600.0
2023-03-17	ADPV	ETF	22.77	22.79	22.7083	22.7083	17887.0
2023-03-17	ADRE	ETF	38.19	38.25	38.0042	38.12	4261.0
2023-03-17	AEMB	ETF	37.3	37.3	37.274	37.274	100.0
2023-03-17	AESR	ETF	11.4	11.49	11.39	11.46	14600.0
2023-03-17	AFIF	ETF	8.8103	8.84	8.79	8.8047	27056.0
2023-03-17	AFK	ETF	14.92	15.1	14.92	15.02	7333.0
2023-03-17	AFLG	ETF	22.96	22.984	22.96	22.984	100.0
2023-03-17	AFMC	ETF	22.31	22.35	21.99	21.99	1000.0
2023-03-17	AFSM	ETF	22.56	22.56	22.317	22.317	200.0
2023-03-17	AFTY	ETF	15.84	15.84	15.817	15.817	1300.0
2023-03-17	AGG	ETF	99.29	99.8	99.21	99.5	8277500.0
2023-03-17	AGGY	ETF	43.59	43.92	43.48	43.89	324400.0
2023-03-17	AGNG	ETF	25.82	25.86	25.811	25.811	1200.0
2023-03-17	AGOV	ETF	75.9831	75.9831	75.9831	75.9831	250.0
2023-03-17	AGOX	ETF	20.83	20.925	20.75	20.817	21000.0
2023-03-17	AGQ	ETF	26.1	27.62	26.0	27.24	1436900.0
2023-03-17	AGRH	ETF	25.32	25.3881	25.32	25.3881	1800.0
2023-03-17	AGZ	ETF	108.1	108.5226	108.1	108.28	25660.0
2023-03-17	AGZD	ETF	21.7	21.775	21.59	21.645	84600.0
2023-03-17	AHHX	ETF	8.425	8.425	8.425	8.425	5.0
2023-03-17	AHYB	ETF	43.01	43.01	42.965	43.007	800.0
2023-03-17	AIA	ETF	58.18	58.18	57.62	57.67	23379.0
2023-03-17	AIEQ	ETF	28.65	28.69	28.085	28.33	15200.0

> showing 50 of 2,927 rows — these rows as CSV

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