PREVIEW / etf_daily / 2021-11-18

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-18.parquet
  size:    96 KB
  rows:    2,576

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-11-18	SPY	ETF	469.24	470.01	466.34	469.73	50625600.0
2021-11-18	QQQ	ETF	399.73	402.27	397.45	401.75	45721515.0
2021-11-18	IWM	ETF	236.92	237.07	233.05	234.86	30637300.0
2021-11-18	DIA	ETF	360.03	360.05	357.13	359.35	3438100.0
2021-11-18	GLD	ETF	173.96	174.36	173.53	173.94	6252000.0
2021-11-18	TLT	ETF	145.99	146.9	145.95	146.81	11054600.0
2021-11-18	AAA	ETF	25.02	25.0392	25.02	25.0392	210.0
2021-11-18	AAAU	ETF	18.51	18.55	18.46	18.5	230000.0
2021-11-18	AADR	ETF	64.62	64.84	64.39	64.79	3200.0
2021-11-18	AAXJ	ETF	86.68	86.82	86.17	86.6	946900.0
2021-11-18	ABEQ	ETF	28.015	28.14	28.015	28.136	63300.0
2021-11-18	ACES	ETF	79.05	79.196	76.5	77.29	57800.0
2021-11-18	ACIO	ETF	31.79	32.06	31.79	32.03	35400.0
2021-11-18	ACSI	ETF	53.7778	53.7778	53.7778	53.7778	36.0
2021-11-18	ACT	ETF	23.06	23.3	22.57	23.16	93830.0
2021-11-18	ACTV	ETF	38.285	38.285	38.085	38.1399	13274.0
2021-11-18	ACTX	ETF	1.4	1.4	0.755	0.82	1970.0
2021-11-18	ACVF	ETF	35.26	35.26	35.031	35.22	3700.0
2021-11-18	ACWF	ETF	38.87	38.87	38.57	38.755	25561.0
2021-11-18	ACWI	ETF	106.96	107.07	106.33	106.96	1730900.0
2021-11-18	ACWV	ETF	107.03	107.24	106.74	107.11	679300.0
2021-11-18	ACWX	ETF	57.42	57.48	57.14	57.44	1040098.0
2021-11-18	ADFI	ETF	9.62	9.625	9.62	9.625	1900.0
2021-11-18	ADIV	ETF	17.915	17.915	17.915	17.915	100.0
2021-11-18	ADME	ETF	42.645	42.75	42.64	42.69	63400.0
2021-11-18	ADRE	ETF	49.38	49.5779	49.0134	49.3	29872.0
2021-11-18	AESR	ETF	14.83	14.89	14.83	14.89	3300.0
2021-11-18	AFIF	ETF	9.595	9.6111	9.595	9.605	18896.0
2021-11-18	AFK	ETF	21.52	21.52	21.1001	21.23	5525.0
2021-11-18	AFLG	ETF	27.525	27.525	27.511	27.511	300.0
2021-11-18	AFSM	ETF	28.599	28.599	28.599	28.599	100.0
2021-11-18	AFTY	ETF	20.76	20.764	20.76	20.764	1600.0
2021-11-18	AGG	ETF	114.05	114.28	114.03	114.23	4226900.0
2021-11-18	AGGY	ETF	51.72	51.8	51.706	51.774	41300.0
2021-11-18	AGNG	ETF	29.6	29.6	29.34	29.4	7800.0
2021-11-18	AGOV	ETF	98.4816	98.4816	98.475	98.475	1570.0
2021-11-18	AGOX	ETF	26.27	26.304	26.18	26.27	64100.0
2021-11-18	AGQ	ETF	40.2	40.54	39.87	40.04	530700.0
2021-11-18	AGZ	ETF	117.66	117.8561	117.66	117.84	25424.0
2021-11-18	AGZD	ETF	23.395	23.445	23.395	23.415	63400.0
2021-11-18	AHHX	ETF	10.37	10.52	10.29	10.395	14846.0
2021-11-18	AHYB	ETF	50.09	50.1	50.065	50.065	289.0
2021-11-18	AIA	ETF	80.74	80.86	80.1	80.49	118361.0
2021-11-18	AIEQ	ETF	44.363	44.363	44.0	44.34	11500.0
2021-11-18	AIQ	ETF	33.15	33.15	32.79	33.07	32139.0
2021-11-18	AIRR	ETF	47.42	47.56	46.8	47.05	44700.0
2021-11-18	AIVI	ETF	41.1	41.24	41.04	41.2	9400.0
2021-11-18	ALTL	ETF	44.8	44.835	44.67	44.78	62731.0
2021-11-18	ALTY	ETF	13.41	13.479	13.41	13.45	27500.0
2021-11-18	AMAX	ETF	9.75	9.835	9.75	9.835	200.0

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

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