PREVIEW / etf_daily / 2021-05-10

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-10.parquet
  size:    88 KB
  rows:    2,339

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-05-10	SPY	ETF	422.5	422.74	417.81	417.94	81852400.0
2021-05-10	QQQ	ETF	332.78	332.96	325.55	325.76	60700462.0
2021-05-10	IWM	ETF	225.23	225.67	219.59	219.66	28109100.0
2021-05-10	DIA	ETF	349.26	351.09	347.59	347.74	6092500.0
2021-05-10	GLD	ETF	172.74	172.84	171.78	172.11	8276600.0
2021-05-10	TLT	ETF	138.95	139.25	137.69	137.82	15146200.0
2021-05-10	AAA	ETF	25.011	25.011	25.01	25.01	130.0
2021-05-10	AAAU	ETF	18.36	18.36	18.26	18.29	157000.0
2021-05-10	AADR	ETF	67.08	67.08	65.59	65.59	3100.0
2021-05-10	AAXJ	ETF	93.73	93.73	92.36	92.41	1879100.0
2021-05-10	ABEQ	ETF	28.8	28.8	28.25	28.254	1900.0
2021-05-10	ACES	ETF	67.61	67.63	64.765	64.86	102100.0
2021-05-10	ACIO	ETF	29.88	29.95	29.71	29.71	58000.0
2021-05-10	ACSI	ETF	49.81	49.81	49.3789	49.3789	528.0
2021-05-10	ACTV	ETF	38.56	38.78	38.14	38.14	8967.0
2021-05-10	ACTX	ETF	3.4	3.4	3.3	3.4	871.0
2021-05-10	ACVF	ETF	31.84	31.84	31.194	31.194	15000.0
2021-05-10	ACWF	ETF	38.32	38.36	38.0206	38.0206	3518.0
2021-05-10	ACWI	ETF	100.65	100.69	99.56	99.62	2500000.0
2021-05-10	ACWV	ETF	103.55	103.97	103.23	103.31	67900.0
2021-05-10	ACWX	ETF	58.02	58.02	57.4	57.45	1140341.0
2021-05-10	ADFI	ETF	9.69	9.72	9.675	9.675	16900.0
2021-05-10	ADIV	ETF	18.64	18.64	18.582	18.582	400.0
2021-05-10	ADME	ETF	38.976	38.99	38.67	38.67	15500.0
2021-05-10	ADRE	ETF	56.44	56.44	55.29	55.31	19637.0
2021-05-10	AESR	ETF	13.28	13.41	13.253	13.253	22100.0
2021-05-10	AFIF	ETF	9.745	9.76	9.72	9.72	27075.0
2021-05-10	AFK	ETF	22.5	22.52	22.31	22.31	14281.0
2021-05-10	AFLG	ETF	25.224	25.224	25.224	25.224	200.0
2021-05-10	AFMC	ETF	25.565	25.565	25.565	25.565	100.0
2021-05-10	AFSM	ETF	25.647	25.647	25.647	25.647	100.0
2021-05-10	AFTY	ETF	22.5	22.5	22.258	22.258	400.0
2021-05-10	AGG	ETF	114.61	114.72	114.4	114.43	5576500.0
2021-05-10	AGGY	ETF	51.76	51.83	51.68	51.68	75800.0
2021-05-10	AGNG	ETF	28.85	28.89	28.55	28.588	9300.0
2021-05-10	AGOX	ETF	24.81	24.93	24.6	24.6038	62846.0
2021-05-10	AGQ	ETF	52.96	53.25	50.75	51.06	998700.0
2021-05-10	AGZ	ETF	118.29	118.2952	118.11	118.13	40739.0
2021-05-10	AGZD	ETF	23.505	23.53	23.475	23.53	119200.0
2021-05-10	AIA	ETF	91.54	91.54	90.19	90.19	275648.0
2021-05-10	AIEQ	ETF	37.81	37.81	36.7	36.86	25000.0
2021-05-10	AIQ	ETF	28.62	28.62	28.01	28.01	24979.0
2021-05-10	AIRR	ETF	43.0	43.06	42.28	42.28	67900.0
2021-05-10	AIVI	ETF	44.87	44.98	44.64	44.64	4200.0
2021-05-10	ALTL	ETF	42.26	42.295	41.95	41.95	45712.0
2021-05-10	ALTY	ETF	13.44	13.56	13.44	13.51	57100.0
2021-05-10	AMJ	ETF	18.5	18.96	18.5	18.75	805140.0
2021-05-10	AMLP	ETF	34.49	35.07	34.48	34.78	2962000.0
2021-05-10	AMNA	ETF	32.7249	32.7249	32.7249	32.7249	11.0
2021-05-10	AMND	ETF	34.7832	34.7832	34.7832	34.7832	15.0

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

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