PREVIEW / etf_daily / 2021-12-10

all etf daily files

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

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-10	SPY	ETF	469.23	470.9	466.51	470.74	77159800.0
2021-12-10	QQQ	ETF	396.62	398.28	393.36	398.01	52545767.0
2021-12-10	IWM	ETF	222.2	222.85	218.32	219.91	32924600.0
2021-12-10	DIA	ETF	359.59	360.33	357.61	360.23	3855200.0
2021-12-10	GLD	ETF	166.72	166.92	166.18	166.58	6450600.0
2021-12-10	TLT	ETF	149.92	150.24	148.81	148.86	14298700.0
2021-12-10	AAA	ETF	25.0	25.0	24.98	24.985	76587.0
2021-12-10	AAAU	ETF	17.73	17.75	17.68	17.72	127600.0
2021-12-10	AADR	ETF	62.69	62.83	62.6	62.83	1500.0
2021-12-10	AAXJ	ETF	85.3	85.55	85.15	85.37	810300.0
2021-12-10	ABEQ	ETF	27.603	27.647	27.593	27.647	1300.0
2021-12-10	ACES	ETF	68.97	69.63	67.32	67.72	128000.0
2021-12-10	ACIO	ETF	32.35	32.35	32.09	32.29	26100.0
2021-12-10	ACSI	ETF	52.4008	52.4008	52.4008	52.4008	13.0
2021-12-10	ACT	ETF	20.72	21.34	20.71	20.81	64426.0
2021-12-10	ACTV	ETF	38.24	38.25	38.071	38.1666	7082.0
2021-12-10	ACTX	ETF	1.0	1.0	1.0	1.0	128.0
2021-12-10	ACVF	ETF	34.62	35.043	34.62	35.043	14400.0
2021-12-10	ACWF	ETF	38.63	38.689	38.485	38.6863	9744.0
2021-12-10	ACWI	ETF	105.56	105.74	104.97	105.63	3963500.0
2021-12-10	ACWV	ETF	106.45	106.88	106.45	106.85	97500.0
2021-12-10	ACWX	ETF	56.09	56.14	55.87	56.1	2003751.0
2021-12-10	ADFI	ETF	9.61	9.63	9.58	9.595	8600.0
2021-12-10	ADIV	ETF	16.241	16.241	16.241	16.241	100.0
2021-12-10	ADME	ETF	42.601	42.71	42.431	42.71	19700.0
2021-12-10	ADRE	ETF	47.0734	47.0734	46.7638	46.89	9558.0
2021-12-10	AEMB	ETF	48.505	48.505	48.505	48.505	100.0
2021-12-10	AESR	ETF	14.75	14.786	14.71	14.786	34500.0
2021-12-10	AFIF	ETF	9.59	9.61	9.56	9.56	18376.0
2021-12-10	AFK	ETF	20.66	20.66	20.21	20.38	6546.0
2021-12-10	AFLG	ETF	27.68	27.753	27.62	27.753	7100.0
2021-12-10	AFMC	ETF	26.18	26.184	26.18	26.184	200.0
2021-12-10	AFSM	ETF	27.02	27.068	27.02	27.068	200.0
2021-12-10	AFTY	ETF	21.96	22.06	21.96	22.039	2200.0
2021-12-10	AGG	ETF	114.37	114.51	114.22	114.23	6501300.0
2021-12-10	AGGY	ETF	51.82	51.874	51.715	51.75	80300.0
2021-12-10	AGNG	ETF	28.23	28.359	28.11	28.154	3700.0
2021-12-10	AGOV	ETF	98.32	98.37	98.32	98.335	5935.0
2021-12-10	AGOX	ETF	25.83	27.0	25.215	25.41	430500.0
2021-12-10	AGQ	ETF	31.6	31.64	31.26	31.58	530300.0
2021-12-10	AGZ	ETF	117.49	117.5284	117.35	117.3728	11652.0
2021-12-10	AGZD	ETF	23.405	23.405	23.355	23.385	20800.0
2021-12-10	AHHX	ETF	10.37	10.47	10.2	10.325	89492.0
2021-12-10	AHYB	ETF	50.0	50.0	50.0	50.0	100.0
2021-12-10	AIA	ETF	78.67	78.8324	78.36	78.65	71886.0
2021-12-10	AIEQ	ETF	42.12	42.12	41.57	42.06	18100.0
2021-12-10	AIQ	ETF	32.07	32.25	31.81	31.96	34425.0
2021-12-10	AIRR	ETF	45.13	45.14	44.445	44.777	23100.0
2021-12-10	AIVI	ETF	41.41	41.49	41.32	41.45	8900.0
2021-12-10	ALTL	ETF	45.99	46.018	45.07	45.57	72458.0

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

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