PREVIEW / etf_daily / 2022-11-18

all etf daily files

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

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-18	SPY	ETF	397.74	397.81	393.04	396.03	92922500.0
2022-11-18	QQQ	ETF	287.89	287.99	282.3211	284.82	53588631.0
2022-11-18	IWM	ETF	184.59	185.31	182.57	183.72	27269100.0
2022-11-18	DIA	ETF	337.46	338.15	335.26	337.37	3659100.0
2022-11-18	GLD	ETF	163.38	163.69	162.68	162.79	4321100.0
2022-11-18	TLT	ETF	100.6	100.89	99.55	99.64	14941300.0
2022-11-18	AAA	ETF	24.26	24.26	24.26	24.26	0.0
2022-11-18	AAAU	ETF	17.43	17.45	17.35	17.35	1968700.0
2022-11-18	AADR	ETF	48.06	48.06	47.8	48.0	2500.0
2022-11-18	AAPB	ETF	20.55	20.63	20.36	20.4351	1973.0
2022-11-18	AAPD	ETF	26.0	26.4217	26.0	26.28	144234.0
2022-11-18	AAPU	ETF	21.61	21.61	21.13	21.34	23935.0
2022-11-18	AAXJ	ETF	64.02	64.02	63.5	63.75	307000.0
2022-11-18	ABEQ	ETF	27.74	27.84	27.67	27.784	6800.0
2022-11-18	ACES	ETF	56.13	56.13	54.576	55.07	125900.0
2022-11-18	ACIO	ETF	30.04	30.04	29.72	29.86	118200.0
2022-11-18	ACSI	ETF	44.118	44.118	44.118	44.118	123.0
2022-11-18	ACT	ETF	24.27	24.27	23.9	24.01	164123.0
2022-11-18	ACTV	ETF	30.18	30.2897	29.9792	30.08	15314.0
2022-11-18	ACTX	ETF	0.2628	0.2704	0.2628	0.2704	1151.0
2022-11-18	ACVF	ETF	30.385	30.385	30.251	30.361	2200.0
2022-11-18	ACWF	ETF	32.98	32.98	32.73	32.9164	12300.0
2022-11-18	ACWI	ETF	87.31	87.4	86.45	86.94	4623400.0
2022-11-18	ACWV	ETF	95.84	96.05	95.46	95.92	95000.0
2022-11-18	ACWX	ETF	45.58	45.6289	45.3121	45.45	1820908.0
2022-11-18	ADFI	ETF	8.37	8.37	8.35	8.355	9900.0
2022-11-18	ADIV	ETF	12.726	12.735	12.726	12.735	700.0
2022-11-18	ADME	ETF	35.11	35.11	34.86	34.98	57900.0
2022-11-18	ADPV	ETF	25.09	25.09	25.055	25.055	20328.0
2022-11-18	ADRE	ETF	37.95	37.95	37.45	37.62	4045.0
2022-11-18	AEMB	ETF	37.035	37.035	37.035	37.035	100.0
2022-11-18	AESR	ETF	11.74	11.805	11.71	11.79	20200.0
2022-11-18	AFIF	ETF	8.72	8.75	8.7001	8.7001	37220.0
2022-11-18	AFK	ETF	16.72	16.88	16.72	16.83	2507.0
2022-11-18	AFLG	ETF	24.0	24.025	23.92	24.025	2100.0
2022-11-18	AFMC	ETF	22.88	22.92	22.88	22.92	100.0
2022-11-18	AFSM	ETF	23.587	23.587	23.587	23.587	100.0
2022-11-18	AFTY	ETF	14.81	14.81	14.805	14.805	100.0
2022-11-18	AGG	ETF	97.22	97.33	96.91	97.0	4714900.0
2022-11-18	AGGH	ETF	22.41	22.41	22.3845	22.3845	7350.0
2022-11-18	AGGY	ETF	42.74	42.79	42.62	42.7	138700.0
2022-11-18	AGNG	ETF	25.84	25.9	25.84	25.9	300.0
2022-11-18	AGOV	ETF	80.15	80.36	79.815	80.3483	10232.0
2022-11-18	AGOX	ETF	21.17	21.18	21.04	21.124	27400.0
2022-11-18	AGQ	ETF	24.9	25.31	24.6	24.75	884800.0
2022-11-18	AGZ	ETF	106.62	106.6278	106.395	106.44	22860.0
2022-11-18	AGZD	ETF	23.07	23.18	22.945	23.065	103200.0
2022-11-18	AHHX	ETF	8.5284	8.5539	8.51	8.5402	4392.0
2022-11-18	AHYB	ETF	43.229	43.305	43.229	43.305	200.0
2022-11-18	AIA	ETF	56.14	56.14	55.65	55.75	14421.0

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

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