PREVIEW / etf_daily / 2021-07-09

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-09.parquet
  size:    90 KB
  rows:    2,395

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-07-09	SPY	ETF	432.53	435.84	430.71	435.52	76238600.0
2021-07-09	QQQ	ETF	358.17	361.5	357.57	361.01	35184534.0
2021-07-09	IWM	ETF	224.16	226.45	223.34	226.38	23976400.0
2021-07-09	DIA	ETF	346.57	349.07	345.84	348.73	5063100.0
2021-07-09	GLD	ETF	168.84	169.62	168.66	169.21	4997400.0
2021-07-09	TLT	ETF	146.87	146.99	146.49	146.53	14483600.0
2021-07-09	AAA	ETF	24.99	25.005	24.99	25.005	662.0
2021-07-09	AAAU	ETF	17.95	18.03	17.93	17.99	317400.0
2021-07-09	AADR	ETF	64.33	65.69	64.33	65.55	2500.0
2021-07-09	AAXJ	ETF	91.12	91.72	90.91	91.65	483700.0
2021-07-09	ABEQ	ETF	27.52	27.548	27.52	27.548	3300.0
2021-07-09	ACES	ETF	73.01	73.09	72.18	73.09	38500.0
2021-07-09	ACIO	ETF	30.31	30.74	30.31	30.74	29600.0
2021-07-09	ACSI	ETF	50.9119	50.9119	50.9119	50.9119	248.0
2021-07-09	ACTV	ETF	38.7899	38.85	38.74	38.766	7005.0
2021-07-09	ACTX	ETF	2.6	2.6	2.6	2.6	406.0
2021-07-09	ACVF	ETF	32.16	32.255	32.155	32.255	400.0
2021-07-09	ACWF	ETF	37.87	38.205	37.85	38.199	4685.0
2021-07-09	ACWI	ETF	101.36	102.14	101.3	102.08	3636800.0
2021-07-09	ACWV	ETF	103.82	104.26	103.75	104.15	343000.0
2021-07-09	ACWX	ETF	56.87	57.33	56.87	57.32	1021862.0
2021-07-09	ADFI	ETF	9.75	9.79	9.74	9.762	2700.0
2021-07-09	ADIV	ETF	18.32	18.32	18.32	18.32	700.0
2021-07-09	ADME	ETF	40.37	40.51	40.37	40.51	22700.0
2021-07-09	ADRE	ETF	54.82	55.4	54.77	55.4	9248.0
2021-07-09	AEMB	ETF	50.04	50.04	50.01	50.01	300.0
2021-07-09	AESR	ETF	13.76	13.83	13.7	13.827	17600.0
2021-07-09	AFIF	ETF	9.705	9.71	9.7	9.705	13085.0
2021-07-09	AFK	ETF	21.93	21.9462	21.81	21.92	8031.0
2021-07-09	AFLG	ETF	25.71	25.792	25.71	25.792	1200.0
2021-07-09	AFMC	ETF	25.449	25.449	25.449	25.449	100.0
2021-07-09	AFSM	ETF	25.86	26.289	25.86	26.289	800.0
2021-07-09	AFTY	ETF	22.393	22.393	22.393	22.393	900.0
2021-07-09	AGG	ETF	115.74	115.76	115.68	115.68	4750800.0
2021-07-09	AGGY	ETF	52.56	52.566	52.5	52.5	43000.0
2021-07-09	AGNG	ETF	30.63	30.79	30.63	30.68	3700.0
2021-07-09	AGOX	ETF	26.19	26.209	25.89	26.18	9800.0
2021-07-09	AGQ	ETF	45.43	46.26	45.34	45.97	486200.0
2021-07-09	AGZ	ETF	118.8	118.8	118.65	118.65	16584.0
2021-07-09	AGZD	ETF	23.7	24.835	23.5	23.515	24400.0
2021-07-09	AIA	ETF	87.61	88.5079	87.42	88.42	62028.0
2021-07-09	AIEQ	ETF	40.92	41.33	40.75	41.3	39500.0
2021-07-09	AIQ	ETF	30.45	30.76	30.39	30.76	10157.0
2021-07-09	AIRR	ETF	39.93	40.54	39.93	40.41	103100.0
2021-07-09	AIVI	ETF	43.59	43.73	43.59	43.71	1600.0
2021-07-09	ALTL	ETF	42.08	42.0867	41.945	42.0608	12711.0
2021-07-09	ALTY	ETF	13.44	13.6	13.44	13.59	25100.0
2021-07-09	AMJ	ETF	19.44	19.685	19.245	19.51	3733586.0
2021-07-09	AMLP	ETF	35.76	36.5	35.66	36.35	1625500.0
2021-07-09	AMNA	ETF	34.3718	34.3718	34.3718	34.3718	85.0

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

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