PREVIEW / etf_daily / 2021-12-15

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-15.parquet
  size:    98 KB
  rows:    2,604

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-15	SPY	ETF	463.42	470.86	460.74	470.6	116899300.0
2021-12-15	QQQ	ETF	387.94	397.4198	383.88	397.05	73858028.0
2021-12-15	IWM	ETF	214.21	218.16	211.08	217.58	51261000.0
2021-12-15	DIA	ETF	355.83	359.97	354.44	359.81	9274900.0
2021-12-15	GLD	ETF	165.27	166.4	163.8	166.15	14231200.0
2021-12-15	TLT	ETF	149.61	150.79	149.13	149.25	25383900.0
2021-12-15	AAA	ETF	25.04	25.04	25.02	25.02	355.0
2021-12-15	AAAU	ETF	17.59	17.7	17.45	17.68	203800.0
2021-12-15	AADR	ETF	61.31	61.5	61.31	61.5	1200.0
2021-12-15	AAXJ	ETF	81.94	82.04	80.88	81.95	1061700.0
2021-12-15	ABEQ	ETF	27.63	27.778	27.6	27.769	3300.0
2021-12-15	ACES	ETF	64.65	65.84	62.89	65.64	96000.0
2021-12-15	ACIO	ETF	31.866	32.11	31.764	32.11	16500.0
2021-12-15	ACSI	ETF	51.12	52.1183	51.12	52.1183	309.0
2021-12-15	ACT	ETF	20.64	21.55	20.59	21.25	204945.0
2021-12-15	ACTV	ETF	37.54	38.05	37.235	38.0081	3784.0
2021-12-15	ACTX	ETF	1.1	1.1001	1.1	1.1001	265.0
2021-12-15	ACVF	ETF	34.38	35.43	34.38	35.25	19700.0
2021-12-15	ACWF	ETF	37.68	38.17	37.6	38.17	9590.0
2021-12-15	ACWI	ETF	102.94	104.38	102.42	104.29	3676900.0
2021-12-15	ACWV	ETF	105.7	106.62	105.5	106.55	255000.0
2021-12-15	ACWX	ETF	54.4	54.84	54.01	54.83	2865605.0
2021-12-15	ADFI	ETF	9.5	9.58	9.5	9.568	2000.0
2021-12-15	ADIV	ETF	15.894	16.01	15.894	16.01	300.0
2021-12-15	ADME	ETF	42.085	42.62	41.905	42.62	17700.0
2021-12-15	ADRE	ETF	45.65	45.9199	44.85	45.845	6996.0
2021-12-15	AEMB	ETF	48.46	48.46	48.46	48.46	100.0
2021-12-15	AESR	ETF	13.65	13.84	13.54	13.83	56700.0
2021-12-15	AFIF	ETF	9.5301	9.55	9.5301	9.54	10051.0
2021-12-15	AFK	ETF	20.68	20.68	20.0	20.3386	16558.0
2021-12-15	AFLG	ETF	27.55	27.81	27.55	27.81	2000.0
2021-12-15	AFMC	ETF	25.675	26.13	25.675	26.119	900.0
2021-12-15	AFSM	ETF	26.21	26.969	26.21	26.969	5300.0
2021-12-15	AFTY	ETF	21.74	21.74	21.63	21.723	5100.0
2021-12-15	AGG	ETF	114.23	114.45	114.11	114.32	7459100.0
2021-12-15	AGGY	ETF	51.72	51.83	51.72	51.79	125800.0
2021-12-15	AGNG	ETF	27.53	28.23	27.53	28.23	5500.0
2021-12-15	AGOV	ETF	98.25	98.375	98.24	98.375	2056.0
2021-12-15	AGOX	ETF	24.75	25.21	24.66	25.14	44900.0
2021-12-15	AGQ	ETF	30.45	31.36	29.36	31.23	1379600.0
2021-12-15	AGZ	ETF	117.43	117.4861	117.29	117.39	28767.0
2021-12-15	AGZD	ETF	23.405	23.405	23.325	23.365	7800.0
2021-12-15	AHHX	ETF	10.305	10.305	10.305	10.305	120.0
2021-12-15	AHYB	ETF	50.039	50.039	50.039	50.039	100.0
2021-12-15	AIA	ETF	76.13	76.43	75.234	76.33	92970.0
2021-12-15	AIEQ	ETF	41.0	41.42	40.61	41.34	91700.0
2021-12-15	AIQ	ETF	31.07	31.82	30.78	31.79	25527.0
2021-12-15	AIRR	ETF	43.93	44.5	43.375	44.46	55500.0
2021-12-15	AIVI	ETF	41.09	41.48	40.92	41.47	24900.0
2021-12-15	ALTL	ETF	44.18	44.68	43.279	44.68	641614.0

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

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