PREVIEW / etf_daily / 2022-11-16

all etf daily files

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

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-16	SPY	ETF	396.78	397.78	394.79	395.45	68508500.0
2022-11-16	QQQ	ETF	287.39	289.4838	284.6	285.44	48859804.0
2022-11-16	IWM	ETF	186.6	186.64	183.71	184.25	24802000.0
2022-11-16	DIA	ETF	335.67	337.25	335.55	336.07	3085500.0
2022-11-16	GLD	ETF	165.41	165.71	164.83	165.12	3645800.0
2022-11-16	TLT	ETF	100.02	101.45	99.74	101.4	28507700.0
2022-11-16	AAA	ETF	24.25	24.25	24.25	24.25	18.0
2022-11-16	AAAU	ETF	17.64	17.67	17.58	17.61	2226700.0
2022-11-16	AADR	ETF	48.74	48.74	48.18	48.18	500.0
2022-11-16	AAPB	ETF	19.81	19.98	19.67	19.9614	4578.0
2022-11-16	AAPD	ETF	26.54	26.925	26.49	26.6429	167103.0
2022-11-16	AAPU	ETF	20.86	21.0	20.49	20.84	57064.0
2022-11-16	AAXJ	ETF	64.44	64.55	63.92	64.02	1024600.0
2022-11-16	ABEQ	ETF	27.65	27.75	27.61	27.656	13500.0
2022-11-16	ACES	ETF	56.61	56.925	55.68	56.22	71200.0
2022-11-16	ACIO	ETF	29.785	29.85	29.7	29.78	100000.0
2022-11-16	ACSI	ETF	44.0965	44.0965	44.0965	44.0965	110.0
2022-11-16	ACT	ETF	25.9	26.08	25.41	25.66	218643.0
2022-11-16	ACTV	ETF	30.64	30.64	30.0	30.11	7026.0
2022-11-16	ACTX	ETF	0.3203	0.4499	0.3203	0.4499	13576.0
2022-11-16	ACVF	ETF	30.33	30.365	30.24	30.276	3500.0
2022-11-16	ACWF	ETF	33.1	33.13	32.8497	32.8542	13345.0
2022-11-16	ACWI	ETF	87.35	87.48	86.83	86.98	4502500.0
2022-11-16	ACWV	ETF	95.28	95.69	95.21	95.21	82100.0
2022-11-16	ACWX	ETF	45.73	45.79	45.3945	45.49	2670868.0
2022-11-16	ADFI	ETF	8.38	8.39	8.36	8.38	26800.0
2022-11-16	ADIV	ETF	12.86	12.86	12.813	12.813	600.0
2022-11-16	ADME	ETF	34.84	35.18	34.84	35.042	24200.0
2022-11-16	ADPV	ETF	25.06	25.08	25.04	25.042	22465.0
2022-11-16	ADRE	ETF	37.97	37.97	37.2094	37.2094	2400.0
2022-11-16	AESR	ETF	11.75	11.79	11.71	11.72	28400.0
2022-11-16	AFIF	ETF	8.71	8.735	8.71	8.735	14565.0
2022-11-16	AFK	ETF	16.9	16.91	16.75	16.805	7133.0
2022-11-16	AFLG	ETF	23.98	23.98	23.895	23.895	500.0
2022-11-16	AFMC	ETF	22.75	22.753	22.75	22.753	100.0
2022-11-16	AFSM	ETF	23.516	23.516	23.423	23.423	300.0
2022-11-16	AFTY	ETF	14.956	14.981	14.956	14.981	300.0
2022-11-16	AGG	ETF	97.25	97.63	97.14	97.55	11075000.0
2022-11-16	AGGH	ETF	22.44	22.4796	22.44	22.4796	575.0
2022-11-16	AGGY	ETF	42.81	42.9	42.71	42.88	106000.0
2022-11-16	AGIH	ETF	24.1901	24.26	24.1901	24.26	120.0
2022-11-16	AGNG	ETF	25.98	25.98	25.791	25.791	1500.0
2022-11-16	AGOV	ETF	80.905	80.905	80.905	80.905	51.0
2022-11-16	AGOX	ETF	21.04	21.375	21.03	21.24	100200.0
2022-11-16	AGQ	ETF	26.7	26.81	26.03	26.11	935100.0
2022-11-16	AGZ	ETF	106.82	107.02	106.82	106.88	16131.0
2022-11-16	AGZD	ETF	22.89	22.95	22.89	22.945	57600.0
2022-11-16	AHHX	ETF	8.511	8.5475	8.5101	8.5475	4108.0
2022-11-16	AHYB	ETF	43.331	43.408	43.331	43.392	700.0
2022-11-16	AIA	ETF	56.42	56.47	55.74	55.81	141532.0

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

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