PREVIEW / etf_daily / 2021-10-18

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-18.parquet
  size:    94 KB
  rows:    2,521

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-10-18	SPY	ETF	443.97	447.55	443.27	447.19	62213200.0
2021-10-18	QQQ	ETF	367.61	372.87	366.99	372.65	34513514.0
2021-10-18	IWM	ETF	223.88	225.68	223.73	225.03	19082600.0
2021-10-18	DIA	ETF	351.34	353.13	350.25	352.5	3310600.0
2021-10-18	GLD	ETF	165.42	165.59	164.81	164.92	4029600.0
2021-10-18	TLT	ETF	145.0	146.0	144.52	145.71	12115900.0
2021-10-18	AAA	ETF	25.0083	25.01	25.0	25.0	662.0
2021-10-18	AAAU	ETF	17.6	17.61	17.53	17.55	105800.0
2021-10-18	AADR	ETF	65.61	65.93	65.56	65.85	1700.0
2021-10-18	AAXJ	ETF	86.84	87.51	86.81	87.26	452100.0
2021-10-18	ABEQ	ETF	27.587	27.587	27.51	27.51	4700.0
2021-10-18	ACES	ETF	70.0	70.61	69.93	70.56	75400.0
2021-10-18	ACIO	ETF	30.731	31.0	30.731	31.0	178900.0
2021-10-18	ACSI	ETF	51.1526	51.1526	51.1526	51.1526	73.0
2021-10-18	ACT	ETF	21.71	21.91	21.57	21.79	127604.0
2021-10-18	ACTV	ETF	39.04	39.1	38.91	38.9573	11292.0
2021-10-18	ACTX	ETF	0.95	0.95	0.95	0.95	296.0
2021-10-18	ACVF	ETF	33.21	33.39	33.061	33.3	14800.0
2021-10-18	ACWF	ETF	37.54	37.84	37.54	37.76	5379.0
2021-10-18	ACWI	ETF	103.09	103.74	102.95	103.69	4443100.0
2021-10-18	ACWV	ETF	104.04	104.6	104.03	104.46	64600.0
2021-10-18	ACWX	ETF	56.76	57.015	56.69	56.94	1679357.0
2021-10-18	ADFI	ETF	9.655	9.66	9.64	9.655	4900.0
2021-10-18	ADIV	ETF	17.285	17.285	17.285	17.285	100.0
2021-10-18	ADME	ETF	40.576	40.94	40.576	40.94	168300.0
2021-10-18	ADRE	ETF	50.57	51.2195	50.57	51.167	35119.0
2021-10-18	AESR	ETF	14.09	14.22	14.09	14.2	20600.0
2021-10-18	AFIF	ETF	9.59	9.61	9.58	9.605	15045.0
2021-10-18	AFK	ETF	22.0	22.0	21.68	21.875	13616.0
2021-10-18	AFLG	ETF	26.248	26.293	26.248	26.293	400.0
2021-10-18	AFSM	ETF	26.75	26.75	26.743	26.743	600.0
2021-10-18	AFTY	ETF	21.13	21.13	21.078	21.094	12000.0
2021-10-18	AGG	ETF	114.33	114.56	114.25	114.49	5575100.0
2021-10-18	AGGY	ETF	51.9	51.909	51.793	51.894	52800.0
2021-10-18	AGNG	ETF	28.89	29.11	28.89	28.98	4600.0
2021-10-18	AGOV	ETF	99.11	99.11	99.07	99.07	2232.0
2021-10-18	AGOX	ETF	26.7	26.78	26.57	26.71	45600.0
2021-10-18	AGQ	ETF	35.49	35.49	34.55	35.11	499600.0
2021-10-18	AGZ	ETF	117.9	118.06	117.9	117.99	31764.0
2021-10-18	AGZD	ETF	23.495	23.495	23.455	23.46	75000.0
2021-10-18	AIA	ETF	80.32	81.095	80.32	80.8	66560.0
2021-10-18	AIEQ	ETF	42.64	43.16	42.63	43.16	56600.0
2021-10-18	AIQ	ETF	31.45	31.76	31.45	31.75	37823.0
2021-10-18	AIRR	ETF	41.95	42.16	41.78	42.16	37600.0
2021-10-18	AIVI	ETF	41.5	41.65	41.5	41.6	2600.0
2021-10-18	ALTL	ETF	42.32	42.71	42.32	42.68	67102.0
2021-10-18	ALTY	ETF	13.56	13.56	13.53	13.545	8400.0
2021-10-18	AMJ	ETF	19.92	20.05	19.68	19.87	845207.0
2021-10-18	AMLP	ETF	36.67	36.95	36.19	36.55	1705000.0
2021-10-18	AMNA	ETF	35.8927	35.8927	35.8927	35.8927	52.0

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

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