PREVIEW / etf_daily / 2022-11-21

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-21.parquet
  size:    106 KB
  rows:    2,862

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
2022-11-21	SPY	ETF	394.64	395.82	392.66	394.59	51243200.0
2022-11-21	QQQ	ETF	283.4	284.58	281.04	281.89	40083527.0
2022-11-21	IWM	ETF	182.78	183.19	181.43	182.76	19038900.0
2022-11-21	DIA	ETF	337.66	338.65	335.53	337.05	2304100.0
2022-11-21	GLD	ETF	162.44	162.5	161.28	161.88	4766500.0
2022-11-21	TLT	ETF	100.69	100.82	99.8	100.06	15534000.0
2022-11-21	AAA	ETF	24.3	24.3	24.3	24.3	71.0
2022-11-21	AAAU	ETF	17.32	17.32	17.19	17.26	1035600.0
2022-11-21	AADR	ETF	48.17	48.61	48.17	48.61	1500.0
2022-11-21	AAPB	ETF	20.19	20.19	19.74	19.76	2102.0
2022-11-21	AAPD	ETF	26.47	26.8689	26.46	26.806	90719.0
2022-11-21	AAPU	ETF	21.07	21.08	20.6	20.65	36388.0
2022-11-21	AAXJ	ETF	62.92	63.02	62.58	62.74	377000.0
2022-11-21	ABEQ	ETF	27.77	27.855	27.72	27.831	21200.0
2022-11-21	ACES	ETF	54.37	54.37	53.451	53.94	73500.0
2022-11-21	ACIO	ETF	29.673	29.76	29.63	29.74	81300.0
2022-11-21	ACSI	ETF	44.0235	44.0235	44.0235	44.0235	17.0
2022-11-21	ACT	ETF	23.98	24.58	23.97	24.4	159335.0
2022-11-21	ACTV	ETF	29.78	30.08	29.78	29.95	27440.0
2022-11-21	ACTX	ETF	0.3948	0.3948	0.271	0.3895	412.0
2022-11-21	ACVF	ETF	30.3	30.42	30.3	30.37	1500.0
2022-11-21	ACWF	ETF	32.755	32.869	32.695	32.8221	12691.0
2022-11-21	ACWI	ETF	86.4	86.65	86.04	86.46	5248600.0
2022-11-21	ACWV	ETF	95.46	96.07	95.46	95.96	119700.0
2022-11-21	ACWX	ETF	45.11	45.14	44.85	45.11	5410545.0
2022-11-21	ADFI	ETF	8.36	8.36	8.33	8.35	10200.0
2022-11-21	ADIV	ETF	12.57	12.57	12.55	12.55	400.0
2022-11-21	ADME	ETF	34.81	34.91	34.79	34.845	89100.0
2022-11-21	ADPV	ETF	25.07	25.07	25.055	25.055	20889.0
2022-11-21	ADRE	ETF	37.07	37.07	36.6601	36.9666	9780.0
2022-11-21	AEMB	ETF	37.16	37.16	37.16	37.16	100.0
2022-11-21	AESR	ETF	11.715	11.775	11.7	11.76	17200.0
2022-11-21	AFIF	ETF	8.71	8.75	8.69	8.71	185968.0
2022-11-21	AFK	ETF	16.95	16.95	16.715	16.73	5007.0
2022-11-21	AFLG	ETF	23.96	24.02	23.96	24.02	200.0
2022-11-21	AFMC	ETF	22.92	22.928	22.92	22.928	100.0
2022-11-21	AFSM	ETF	23.578	23.578	23.578	23.578	100.0
2022-11-21	AGG	ETF	97.27	97.34	96.91	96.94	6829100.0
2022-11-21	AGGY	ETF	42.77	42.81	42.64	42.65	126900.0
2022-11-21	AGNG	ETF	25.77	25.81	25.73	25.73	2300.0
2022-11-21	AGOV	ETF	80.25	80.25	80.25	80.25	22.0
2022-11-21	AGOX	ETF	20.96	21.08	20.911	21.037	49900.0
2022-11-21	AGQ	ETF	24.67	24.75	24.18	24.65	1196100.0
2022-11-21	AGZ	ETF	106.73	106.73	106.37	106.4	21490.0
2022-11-21	AGZD	ETF	23.005	23.07	22.985	23.025	194200.0
2022-11-21	AHHX	ETF	8.5056	8.56	8.4937	8.525	22531.0
2022-11-21	AHYB	ETF	43.22	43.297	43.22	43.297	200.0
2022-11-21	AIA	ETF	54.65	54.7746	54.44	54.64	42998.0
2022-11-21	AIEQ	ETF	30.7	30.7	30.459	30.62	5400.0
2022-11-21	AIQ	ETF	20.68	20.785	20.38	20.455	70077.0

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

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