PREVIEW / etf_daily / 2021-07-20

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-20.parquet
  size:    92 KB
  rows:    2,425

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-20	SPY	ETF	425.68	432.42	424.83	431.06	99608200.0
2021-07-20	QQQ	ETF	355.63	360.28	353.8	358.79	42183702.0
2021-07-20	IWM	ETF	212.2	219.27	211.26	218.3	40794600.0
2021-07-20	DIA	ETF	340.29	346.12	339.75	345.08	5802200.0
2021-07-20	GLD	ETF	170.51	170.8	168.92	169.39	6540100.0
2021-07-20	TLT	ETF	152.53	152.71	149.76	150.0	25674800.0
2021-07-20	AAA	ETF	25.0209	25.0209	25.015	25.015	1314.0
2021-07-20	AAAU	ETF	18.12	18.15	17.97	18.0	235900.0
2021-07-20	AADR	ETF	63.73	64.02	63.64	63.92	3000.0
2021-07-20	AAXJ	ETF	90.03	90.8	89.75	90.64	522300.0
2021-07-20	ABEQ	ETF	27.168	27.27	27.131	27.131	3800.0
2021-07-20	ACES	ETF	67.78	69.6	67.314	69.4	97800.0
2021-07-20	ACIO	ETF	30.255	30.63	30.255	30.56	67200.0
2021-07-20	ACSI	ETF	50.44	50.4552	50.44	50.4552	273.0
2021-07-20	ACTV	ETF	37.519	37.9	37.519	37.7159	2367.0
2021-07-20	ACTX	ETF	1.36	2.03	1.36	2.03	208.0
2021-07-20	ACVF	ETF	31.58	31.89	31.58	31.887	1000.0
2021-07-20	ACWF	ETF	37.15	37.67	37.12	37.5955	26899.0
2021-07-20	ACWI	ETF	99.41	100.85	99.26	100.54	2012700.0
2021-07-20	ACWV	ETF	103.54	104.33	103.54	103.99	165400.0
2021-07-20	ACWX	ETF	55.46	56.0787	55.37	55.97	845806.0
2021-07-20	ADFI	ETF	9.78	9.8	9.768	9.768	1900.0
2021-07-20	ADIV	ETF	18.152	18.152	18.152	18.152	100.0
2021-07-20	ADME	ETF	39.93	40.34	39.915	40.16	24900.0
2021-07-20	ADRE	ETF	53.74	54.5346	53.74	54.4343	9264.0
2021-07-20	AEMB	ETF	50.235	50.235	50.235	50.235	100.0
2021-07-20	AESR	ETF	13.635	13.71	13.635	13.695	21700.0
2021-07-20	AFIF	ETF	9.71	9.71	9.65	9.65	40980.0
2021-07-20	AFK	ETF	21.27	21.27	21.18	21.25	4408.0
2021-07-20	AFLG	ETF	25.52	25.52	25.46	25.46	4100.0
2021-07-20	AFMC	ETF	24.8	24.8	24.764	24.764	2300.0
2021-07-20	AFSM	ETF	25.43	25.43	25.392	25.392	1500.0
2021-07-20	AFTY	ETF	22.24	22.312	22.231	22.305	21800.0
2021-07-20	AGG	ETF	116.78	116.82	116.32	116.4	8474800.0
2021-07-20	AGGY	ETF	53.07	53.1	52.862	52.88	72200.0
2021-07-20	AGNG	ETF	30.119	30.34	30.119	30.28	7200.0
2021-07-20	AGOX	ETF	25.15	25.61	25.15	25.581	71200.0
2021-07-20	AGQ	ETF	42.18	42.54	41.23	41.77	823100.0
2021-07-20	AGZ	ETF	119.48	119.49	119.142	119.2572	293484.0
2021-07-20	AGZD	ETF	23.43	23.47	23.43	23.46	34400.0
2021-07-20	AIA	ETF	87.09	87.8862	86.83	87.72	77643.0
2021-07-20	AIEQ	ETF	39.45	40.5	39.45	40.382	12100.0
2021-07-20	AIQ	ETF	29.93	30.42	29.88	30.31	15097.0
2021-07-20	AIRR	ETF	38.67	40.16	38.541	39.83	141500.0
2021-07-20	AIVI	ETF	42.44	42.93	42.44	42.92	3500.0
2021-07-20	ALTL	ETF	41.94	42.63	41.94	42.31	64119.0
2021-07-20	ALTY	ETF	13.251	13.46	13.251	13.43	11600.0
2021-07-20	AMJ	ETF	17.54	18.265	17.51	18.17	611632.0
2021-07-20	AMLP	ETF	32.59	33.85	32.37	33.8	4627300.0
2021-07-20	AMNA	ETF	31.8733	31.8733	31.8733	31.8733	0.0

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

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