PREVIEW / etf_daily / 2021-12-14

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-14.parquet
  size:    97 KB
  rows:    2,586

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
2021-12-14	SPY	ETF	463.09	465.74	460.25	463.36	97264100.0
2021-12-14	QQQ	ETF	387.3	390.09	383.63	388.2	75199181.0
2021-12-14	IWM	ETF	214.58	217.52	213.31	214.18	36543500.0
2021-12-14	DIA	ETF	355.71	358.41	354.97	356.17	4079700.0
2021-12-14	GLD	ETF	165.34	166.14	165.16	165.44	8637900.0
2021-12-14	TLT	ETF	150.37	150.93	149.31	150.7	14015500.0
2021-12-14	AAA	ETF	25.0	25.04	25.0	25.03	16765.0
2021-12-14	AAAU	ETF	17.58	17.67	17.57	17.61	172600.0
2021-12-14	AADR	ETF	61.91	62.0	61.3	61.6	4200.0
2021-12-14	AAXJ	ETF	82.05	82.47	81.89	82.37	1833300.0
2021-12-14	ABEQ	ETF	27.74	27.74	27.667	27.667	1200.0
2021-12-14	ACES	ETF	66.3	66.57	64.39	64.86	170500.0
2021-12-14	ACIO	ETF	32.13	32.13	31.78	31.95	46100.0
2021-12-14	ACSI	ETF	51.4379	51.4379	51.4379	51.4379	39.0
2021-12-14	ACT	ETF	20.8	21.27	20.62	20.82	154075.0
2021-12-14	ACTV	ETF	37.54	37.96	37.54	37.6084	12656.0
2021-12-14	ACTX	ETF	1.25	1.25	1.25	1.25	1108.0
2021-12-14	ACVF	ETF	34.58	34.644	34.28	34.437	2600.0
2021-12-14	ACWF	ETF	37.73	37.73	37.56	37.7	4817.0
2021-12-14	ACWI	ETF	102.94	103.45	102.42	103.01	5586700.0
2021-12-14	ACWV	ETF	105.5	105.78	105.12	105.44	142900.0
2021-12-14	ACWX	ETF	54.29	54.58	54.14	54.35	3595930.0
2021-12-14	ADFI	ETF	9.59	9.61	9.59	9.596	1400.0
2021-12-14	ADIV	ETF	15.983	15.983	15.983	15.983	100.0
2021-12-14	ADME	ETF	42.07	42.2	41.881	42.1	45100.0
2021-12-14	ADRE	ETF	45.69	46.35	45.69	46.15	12091.0
2021-12-14	AEMB	ETF	48.6	48.611	48.6	48.611	51700.0
2021-12-14	AESR	ETF	14.45	14.57	14.43	14.508	34900.0
2021-12-14	AFIF	ETF	9.59	9.59	9.57	9.59	18464.0
2021-12-14	AFK	ETF	20.3	20.45	20.19	20.19	9070.0
2021-12-14	AFLG	ETF	27.355	27.355	27.355	27.355	100.0
2021-12-14	AFTY	ETF	21.92	21.92	21.862	21.877	3000.0
2021-12-14	AGG	ETF	114.46	114.54	114.26	114.41	7503600.0
2021-12-14	AGGY	ETF	51.84	51.92	51.75	51.85	156300.0
2021-12-14	AGNG	ETF	28.11	28.11	27.93	27.938	2300.0
2021-12-14	AGOV	ETF	98.17	98.265	98.13	98.265	1470.0
2021-12-14	AGOX	ETF	24.8	25.03	24.79	24.92	30100.0
2021-12-14	AGQ	ETF	30.3	31.0	30.19	30.89	911300.0
2021-12-14	AGZ	ETF	117.48	117.56	116.89	117.46	178006.0
2021-12-14	AGZD	ETF	23.34	23.395	23.32	23.35	108000.0
2021-12-14	AHHX	ETF	10.2896	10.42	10.2896	10.315	690.0
2021-12-14	AIA	ETF	76.06	76.88	76.06	76.81	53799.0
2021-12-14	AIEQ	ETF	40.97	41.035	40.58	40.75	31700.0
2021-12-14	AIQ	ETF	31.13	31.285	30.78	31.04	16711.0
2021-12-14	AIRR	ETF	44.22	44.695	43.9	43.963	9600.0
2021-12-14	AIVI	ETF	40.95	41.11	40.9	40.96	12000.0
2021-12-14	ALTL	ETF	44.11	44.56	43.92	44.1	57358.0
2021-12-14	ALTY	ETF	13.26	13.3	13.18	13.223	11600.0
2021-12-14	AMAX	ETF	9.42	9.54	9.42	9.515	500.0
2021-12-14	AMJ	ETF	16.82	17.11	16.815	16.87	530157.0

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

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