PREVIEW / etf_daily / 2021-05-07

all etf daily files

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

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-07	SPY	ETF	419.89	422.82	419.16	422.12	67733800.0
2021-05-07	QQQ	ETF	334.37	336.65	331.6914	334.2	53324460.0
2021-05-07	IWM	ETF	222.66	225.93	222.16	225.39	26172700.0
2021-05-07	DIA	ETF	345.17	348.29	344.81	347.88	3526500.0
2021-05-07	GLD	ETF	171.53	172.55	171.0	171.59	14748600.0
2021-05-07	TLT	ETF	140.1	140.6	138.91	139.23	18346900.0
2021-05-07	AAA	ETF	24.99	24.99	24.99	24.99	22.0
2021-05-07	AAAU	ETF	18.23	18.33	18.17	18.22	365400.0
2021-05-07	AADR	ETF	65.82	66.68	65.82	66.68	1000.0
2021-05-07	AAXJ	ETF	93.92	94.61	93.8	94.12	1101700.0
2021-05-07	ABEQ	ETF	28.03	28.305	28.03	28.305	700.0
2021-05-07	ACES	ETF	67.36	68.895	67.36	67.63	48700.0
2021-05-07	ACIO	ETF	29.92	30.0	29.87	29.95	54700.0
2021-05-07	ACSI	ETF	49.4	49.6457	49.4	49.6457	717.0
2021-05-07	ACTV	ETF	37.94	38.47	37.94	38.4662	2258.0
2021-05-07	ACTX	ETF	3.7501	3.7501	3.75	3.75	200.0
2021-05-07	ACVF	ETF	31.51	31.51	31.37	31.433	7100.0
2021-05-07	ACWF	ETF	38.4	38.4	38.3269	38.3535	1915.0
2021-05-07	ACWI	ETF	99.96	100.78	99.9	100.61	3491400.0
2021-05-07	ACWV	ETF	102.54	103.38	102.54	103.12	140500.0
2021-05-07	ACWX	ETF	57.51	58.03	57.47	57.98	1014907.0
2021-05-07	ADFI	ETF	9.72	9.72	9.696	9.696	2700.0
2021-05-07	ADIV	ETF	18.9	18.9	18.8	18.8	21700.0
2021-05-07	ADME	ETF	39.15	39.15	38.89	39.07	88000.0
2021-05-07	ADRE	ETF	56.96	57.2938	56.54	56.88	10378.0
2021-05-07	AESR	ETF	13.32	13.41	13.32	13.398	5100.0
2021-05-07	AFIF	ETF	9.75	9.7578	9.72	9.73	18747.0
2021-05-07	AFK	ETF	22.1	22.5	22.1	22.4957	27579.0
2021-05-07	AFLG	ETF	25.21	25.36	25.21	25.36	20500.0
2021-05-07	AFMC	ETF	25.856	25.856	25.856	25.856	100.0
2021-05-07	AFTY	ETF	22.52	22.58	22.52	22.575	1000.0
2021-05-07	AGG	ETF	114.85	114.97	114.57	114.61	7005200.0
2021-05-07	AGGY	ETF	51.89	51.97	51.79	51.84	205000.0
2021-05-07	AGNG	ETF	28.59	29.009	28.59	28.811	14400.0
2021-05-07	AGQ	ETF	50.86	51.73	50.41	51.63	1034400.0
2021-05-07	AGZ	ETF	118.31	118.3994	118.17	118.28	30358.0
2021-05-07	AGZD	ETF	23.515	23.555	23.495	23.535	16200.0
2021-05-07	AIA	ETF	92.09	93.035	92.09	92.64	115862.0
2021-05-07	AIEQ	ETF	37.43	38.0	37.43	37.78	12200.0
2021-05-07	AIQ	ETF	28.75	28.97	28.7201	28.85	26563.0
2021-05-07	AIRR	ETF	42.32	42.81	42.09	42.8	53000.0
2021-05-07	AIVI	ETF	44.15	44.55	44.15	44.55	3100.0
2021-05-07	ALTL	ETF	41.75	42.14	41.61	41.7344	57853.0
2021-05-07	ALTY	ETF	13.33	13.46	13.33	13.46	15100.0
2021-05-07	AMJ	ETF	18.41	18.665	18.31	18.5	316864.0
2021-05-07	AMLP	ETF	33.97	34.49	33.86	34.37	2663600.0
2021-05-07	AMNA	ETF	32.4781	32.4781	32.4781	32.4781	3.0
2021-05-07	AMND	ETF	34.4628	34.4628	34.4628	34.4628	12.0
2021-05-07	AMOM	ETF	34.75	35.25	34.75	35.15	17300.0
2021-05-07	AMPS	ETF	10.04	10.04	9.93	9.93	2319.0

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

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