PREVIEW / etf_daily / 2021-08-03

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-03.parquet
  size:    91 KB
  rows:    2,414

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-08-03	SPY	ETF	438.44	441.28	436.1	441.15	58053900.0
2021-08-03	QQQ	ETF	365.28	366.93	362.0	366.81	35558511.0
2021-08-03	IWM	ETF	220.62	221.12	217.1	220.86	27798600.0
2021-08-03	DIA	ETF	349.09	351.19	347.11	351.09	3819300.0
2021-08-03	GLD	ETF	169.42	169.83	169.21	169.49	5402300.0
2021-08-03	TLT	ETF	150.75	151.23	150.39	150.75	13361900.0
2021-08-03	AAA	ETF	25.005	25.005	25.005	25.005	105.0
2021-08-03	AAAU	ETF	18.02	18.05	18.0	18.03	196000.0
2021-08-03	AADR	ETF	67.51	68.05	67.51	68.0	10500.0
2021-08-03	AAXJ	ETF	88.28	88.65	87.9	88.65	1027100.0
2021-08-03	ABEQ	ETF	27.68	27.705	27.61	27.705	3200.0
2021-08-03	ACES	ETF	72.05	72.67	71.713	72.45	33400.0
2021-08-03	ACIO	ETF	30.7	30.85	30.686	30.832	102300.0
2021-08-03	ACSI	ETF	50.5	50.9695	50.5	50.9695	254.0
2021-08-03	ACTV	ETF	38.08	38.29	38.08	38.2426	1878.0
2021-08-03	ACTX	ETF	1.86	2.0	1.86	2.0	3604.0
2021-08-03	ACVF	ETF	32.66	32.753	32.53	32.753	3000.0
2021-08-03	ACWF	ETF	38.46	38.75	38.3976	38.7313	8686.0
2021-08-03	ACWI	ETF	102.4	102.94	101.9	102.89	2426300.0
2021-08-03	ACWV	ETF	104.92	105.57	104.91	105.54	73700.0
2021-08-03	ACWX	ETF	56.99	57.25	56.79	57.25	866161.0
2021-08-03	ADFI	ETF	9.785	9.785	9.785	9.785	100.0
2021-08-03	ADME	ETF	40.595	40.69	40.595	40.679	67900.0
2021-08-03	ADRE	ETF	52.99	53.39	52.73	53.2501	27630.0
2021-08-03	AEMB	ETF	50.045	50.045	50.045	50.045	1400.0
2021-08-03	AESR	ETF	13.83	13.985	13.83	13.985	3800.0
2021-08-03	AFIF	ETF	9.73	9.73	9.71	9.71	4034.0
2021-08-03	AFK	ETF	21.85	21.85	21.79	21.79	4517.0
2021-08-03	AFLG	ETF	26.207	26.207	26.207	26.207	100.0
2021-08-03	AFMC	ETF	25.21	25.604	25.21	25.604	400.0
2021-08-03	AFTY	ETF	20.692	20.692	20.691	20.691	500.0
2021-08-03	AGG	ETF	116.56	116.69	116.53	116.58	3715300.0
2021-08-03	AGGY	ETF	52.99	53.06	52.98	53.0	63800.0
2021-08-03	AGNG	ETF	30.608	30.7	30.608	30.7	1700.0
2021-08-03	AGOV	ETF	100.55	100.55	100.55	100.55	3.0
2021-08-03	AGOX	ETF	25.91	26.27	25.85	26.249	29300.0
2021-08-03	AGQ	ETF	43.68	43.88	43.35	43.73	260500.0
2021-08-03	AGZ	ETF	119.3	119.41	119.3	119.37	35555.0
2021-08-03	AGZD	ETF	23.43	23.465	23.39	23.39	231200.0
2021-08-03	AIA	ETF	83.88	84.25	83.4701	84.15	82663.0
2021-08-03	AIEQ	ETF	41.49	41.599	41.23	41.51	7400.0
2021-08-03	AIQ	ETF	30.59	30.64	30.36	30.64	42996.0
2021-08-03	AIRR	ETF	40.98	41.53	40.772	41.53	25500.0
2021-08-03	AIVI	ETF	43.78	44.08	43.72	44.05	2600.0
2021-08-03	ALTL	ETF	42.94	43.01	42.75	43.01	53320.0
2021-08-03	ALTY	ETF	13.59	13.68	13.56	13.654	27800.0
2021-08-03	AMJ	ETF	18.05	18.23	17.79	18.18	648794.0
2021-08-03	AMLP	ETF	33.45	33.69	32.87	33.53	4128700.0
2021-08-03	AMNA	ETF	32.2894	32.2894	32.2894	32.2894	66.0
2021-08-03	AMND	ETF	33.83	33.8707	33.83	33.8707	203.0

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

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