PREVIEW / etf_daily / 2021-05-12

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-12.parquet
  size:    89 KB
  rows:    2,348

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-12	SPY	ETF	411.23	412.59	404.0	405.41	134811000.0
2021-05-12	QQQ	ETF	320.23	322.62	316.0	316.89	91164855.0
2021-05-12	IWM	ETF	217.1	218.77	211.54	211.85	42113400.0
2021-05-12	DIA	ETF	341.55	342.23	335.71	336.0	7034100.0
2021-05-12	GLD	ETF	171.43	171.84	170.35	170.43	12666300.0
2021-05-12	TLT	ETF	136.67	136.8	135.36	135.6	20859400.0
2021-05-12	AAA	ETF	25.02	25.02	24.999	25.0	2053.0
2021-05-12	AAAU	ETF	18.21	18.26	18.1	18.12	655200.0
2021-05-12	AADR	ETF	64.92	64.92	63.25	63.25	8600.0
2021-05-12	AAXJ	ETF	90.4	90.65	89.28	89.35	3942400.0
2021-05-12	ABEQ	ETF	28.01	28.01	27.75	27.752	3200.0
2021-05-12	ACES	ETF	64.08	64.25	61.775	61.84	86900.0
2021-05-12	ACIO	ETF	29.41	29.41	29.0	29.006	30800.0
2021-05-12	ACSI	ETF	48.35	48.35	47.6302	47.6302	813.0
2021-05-12	ACTV	ETF	39.7	39.7	36.9164	36.9164	2967.0
2021-05-12	ACTX	ETF	3.49	4.55	3.49	4.46	993.0
2021-05-12	ACVF	ETF	30.62	30.62	30.26	30.29	4600.0
2021-05-12	ACWF	ETF	37.24	37.24	36.69	36.729	4142.0
2021-05-12	ACWI	ETF	97.94	98.27	96.53	96.76	4579500.0
2021-05-12	ACWV	ETF	101.45	101.76	100.51	100.63	212800.0
2021-05-12	ACWX	ETF	56.36	56.59	55.72	55.79	2282970.0
2021-05-12	ADFI	ETF	9.66	9.66	9.63	9.63	4500.0
2021-05-12	ADIV	ETF	17.99	17.99	17.957	17.957	300.0
2021-05-12	ADME	ETF	38.25	38.25	37.677	37.677	18000.0
2021-05-12	ADRE	ETF	55.0	55.0	54.0357	54.095	9652.0
2021-05-12	AESR	ETF	13.05	13.05	12.827	12.827	16200.0
2021-05-12	AFIF	ETF	9.69	9.69	9.68	9.685	10470.0
2021-05-12	AFK	ETF	22.01	22.16	21.555	21.8	28006.0
2021-05-12	AFLG	ETF	24.64	24.64	24.336	24.336	900.0
2021-05-12	AFMC	ETF	24.53	24.53	24.53	24.53	100.0
2021-05-12	AFSM	ETF	25.305	25.305	24.659	24.659	500.0
2021-05-12	AFTY	ETF	22.62	22.62	22.38	22.389	4600.0
2021-05-12	AGG	ETF	113.98	114.01	113.78	113.78	7000800.0
2021-05-12	AGGY	ETF	51.42	51.465	51.34	51.34	136300.0
2021-05-12	AGNG	ETF	28.28	28.31	28.007	28.033	7500.0
2021-05-12	AGOX	ETF	25.52	25.52	24.59	24.602	130800.0
2021-05-12	AGQ	ETF	51.36	51.98	49.76	49.91	1514500.0
2021-05-12	AGZ	ETF	117.95	117.9771	117.841	117.87	29517.0
2021-05-12	AGZD	ETF	23.46	23.665	23.46	23.505	85400.0
2021-05-12	AIA	ETF	88.28	88.54	86.87	87.18	602248.0
2021-05-12	AIEQ	ETF	36.06	36.43	35.2	35.24	27000.0
2021-05-12	AIQ	ETF	27.66	27.67	27.11	27.17	25266.0
2021-05-12	AIRR	ETF	41.6	41.6	40.054	40.18	57700.0
2021-05-12	AIVI	ETF	43.89	44.11	43.55	43.6	22800.0
2021-05-12	ALTL	ETF	41.48	41.48	40.75	40.7723	69591.0
2021-05-12	ALTY	ETF	13.33	13.33	12.95	12.98	33400.0
2021-05-12	AMJ	ETF	18.55	19.045	18.39	18.47	1509178.0
2021-05-12	AMLP	ETF	34.53	35.24	33.95	34.14	3948100.0
2021-05-12	AMNA	ETF	32.3599	32.3599	32.3599	32.3599	10.0
2021-05-12	AMND	ETF	34.2992	34.2992	34.2992	34.2992	9.0

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

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