PREVIEW / etf_daily / 2020-10-23

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-23.parquet
  size:    80 KB
  rows:    2,120

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
2020-10-23	SPY	ETF	345.93	345.99	343.13	345.78	49143900.0
2020-10-23	QQQ	ETF	284.79	284.91	281.7818	284.74	24658542.0
2020-10-23	IWM	ETF	163.07	163.33	161.25	163.07	20889800.0
2020-10-23	DIA	ETF	284.45	284.54	281.51	283.34	2161000.0
2020-10-23	GLD	ETF	179.09	179.2	177.76	178.64	5919300.0
2020-10-23	TLT	ETF	156.81	158.21	156.75	158.01	8783800.0
2020-10-23	AAA	ETF	24.955	24.955	24.955	24.955	495.0
2020-10-23	AAAU	ETF	19.0	19.01	18.87	18.97	274800.0
2020-10-23	AADR	ETF	56.27	56.32	55.84	56.32	4300.0
2020-10-23	AAXJ	ETF	80.34	80.8	80.03	80.79	621000.0
2020-10-23	ABEQ	ETF	23.85	23.85	23.77	23.845	6300.0
2020-10-23	ACES	ETF	58.59	58.83	57.66	58.14	61900.0
2020-10-23	ACIO	ETF	26.905	26.914	26.83	26.914	7800.0
2020-10-23	ACSI	ETF	39.5499	39.5499	39.5499	39.5499	151.0
2020-10-23	ACTX	ETF	2.06	2.16	2.01	2.16	1579.0
2020-10-23	ACWF	ETF	30.78	30.78	30.61	30.73	6659.0
2020-10-23	ACWI	ETF	82.43	82.45	81.89	82.44	1409500.0
2020-10-23	ACWV	ETF	93.17	93.39	92.85	93.26	182200.0
2020-10-23	ACWX	ETF	47.27	47.305	47.035	47.3	2382116.0
2020-10-23	ADFI	ETF	9.93	9.93	9.93	9.93	100.0
2020-10-23	ADME	ETF	34.37	34.37	34.1	34.26	6000.0
2020-10-23	ADRE	ETF	50.19	50.375	50.0279	50.375	5342.0
2020-10-23	AESR	ETF	11.17	11.213	11.17	11.213	800.0
2020-10-23	AFIF	ETF	9.95	9.95	9.77	9.77	3802.0
2020-10-23	AFK	ETF	18.1173	18.4	18.1173	18.4	7546.0
2020-10-23	AFLG	ETF	20.71	20.765	20.71	20.765	700.0
2020-10-23	AFSM	ETF	19.05	19.145	19.02	19.145	1000.0
2020-10-23	AFTY	ETF	20.65	20.79	20.65	20.764	1500.0
2020-10-23	AGG	ETF	117.3	117.52	117.3	117.47	3878700.0
2020-10-23	AGGY	ETF	53.46	53.53	53.449	53.52	65900.0
2020-10-23	AGNG	ETF	26.037	26.06	25.93	26.06	2700.0
2020-10-23	AGQ	ETF	46.83	46.89	45.53	46.34	854600.0
2020-10-23	AGZ	ETF	120.62	120.71	120.57	120.7	35525.0
2020-10-23	AGZD	ETF	23.525	23.525	23.435	23.505	15400.0
2020-10-23	AIA	ETF	75.74	76.07	75.49	76.05	50368.0
2020-10-23	AIEQ	ETF	31.7	31.744	31.47	31.67	8400.0
2020-10-23	AIQ	ETF	24.4	24.59	24.2734	24.59	35142.0
2020-10-23	AIRR	ETF	28.48	28.565	28.38	28.515	32200.0
2020-10-23	AIVI	ETF	36.43	36.54	36.36	36.54	11300.0
2020-10-23	ALTL	ETF	25.56	25.5749	25.4	25.5413	9745.0
2020-10-23	ALTY	ETF	10.77	10.84	10.75	10.78	10400.0
2020-10-23	AMJ	ETF	12.26	12.32	12.015	12.08	818078.0
2020-10-23	AMLP	ETF	22.81	22.9	22.32	22.66	2558400.0
2020-10-23	AMNA	ETF	22.4	22.5278	22.4	22.5278	1100.0
2020-10-23	AMND	ETF	23.9107	23.9107	23.9107	23.9107	0.0
2020-10-23	AMOM	ETF	36.47	36.802	36.433	36.802	1300.0
2020-10-23	AMTR	ETF	25.16	25.35	25.12	25.33	29600.0
2020-10-23	AMUB	ETF	7.645	7.68	7.62	7.6519	3087.0
2020-10-23	AMZA	ETF	15.57	15.7	15.22	15.49	64500.0
2020-10-23	ANEW	ETF	39.19	39.285	39.13	39.284	4500.0

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

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