PREVIEW / etf_daily / 2020-09-02

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-02.parquet
  size:    79 KB
  rows:    2,074

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-09-02	SPY	ETF	354.67	358.75	353.43	357.7	69540000.0
2020-09-02	QQQ	ETF	303.26	303.5	296.89	302.76	50836767.0
2020-09-02	IWM	ETF	157.96	158.98	156.18	158.46	16763400.0
2020-09-02	DIA	ETF	288.08	292.06	287.6	291.21	3464300.0
2020-09-02	GLD	ETF	183.75	183.86	181.5	182.62	11536900.0
2020-09-02	TLT	ETF	163.51	165.56	163.49	165.42	15167700.0
2020-09-02	AAAU	ETF	19.51	19.51	19.27	19.38	769600.0
2020-09-02	AADR	ETF	57.24	57.24	56.71	57.24	4000.0
2020-09-02	AAXJ	ETF	79.17	79.17	78.29	79.07	2595800.0
2020-09-02	ABEQ	ETF	23.88	23.995	23.879	23.995	7900.0
2020-09-02	ACES	ETF	54.57	54.57	52.49	53.55	83200.0
2020-09-02	ACIO	ETF	27.72	27.78	27.369	27.736	62700.0
2020-09-02	ACSI	ETF	39.19	39.5313	39.18	39.5313	404.0
2020-09-02	ACTX	ETF	2.242	2.95	2.242	2.655	640.0
2020-09-02	ACWF	ETF	30.65	30.9599	30.65	30.9402	6962.0
2020-09-02	ACWI	ETF	83.55	84.12	83.1	84.01	1787800.0
2020-09-02	ACWV	ETF	93.01	94.32	92.86	94.21	250100.0
2020-09-02	ACWX	ETF	47.42	47.57	47.14	47.56	1863708.0
2020-09-02	ADFI	ETF	10.055	10.055	10.055	10.055	100.0
2020-09-02	ADME	ETF	36.07	36.16	35.715	36.13	43700.0
2020-09-02	ADRE	ETF	48.54	48.54	47.76	48.4781	4811.0
2020-09-02	AESR	ETF	11.5	11.635	11.5	11.635	300.0
2020-09-02	AFIF	ETF	9.8346	9.86	9.8346	9.86	17791.0
2020-09-02	AFK	ETF	17.85	17.87	17.57	17.8	8230.0
2020-09-02	AFLG	ETF	21.26	21.455	21.26	21.455	200.0
2020-09-02	AFMC	ETF	18.61	18.781	18.61	18.781	100.0
2020-09-02	AFSM	ETF	18.67	18.835	18.67	18.835	100.0
2020-09-02	AFTY	ETF	19.74	19.79	19.7	19.79	2400.0
2020-09-02	AGG	ETF	118.42	118.71	118.34	118.66	4838500.0
2020-09-02	AGGY	ETF	54.13	54.26	54.11	54.26	90800.0
2020-09-02	AGNG	ETF	25.66	26.08	25.66	26.08	9500.0
2020-09-02	AGQ	ETF	60.68	60.8	58.25	59.76	2446100.0
2020-09-02	AGZ	ETF	121.25	121.36	121.2101	121.32	85114.0
2020-09-02	AGZD	ETF	23.475	23.585	23.475	23.57	47400.0
2020-09-02	AIA	ETF	73.0	73.4	72.3801	73.14	3047800.0
2020-09-02	AIEQ	ETF	32.63	32.63	31.88	32.53	22800.0
2020-09-02	AIQ	ETF	24.86	24.87	24.475	24.82	41195.0
2020-09-02	AIRR	ETF	27.39	27.65	27.38	27.59	11500.0
2020-09-02	AIVI	ETF	37.22	37.46	37.22	37.46	3600.0
2020-09-02	ALTL	ETF	25.72	25.941	25.6912	25.941	4308.0
2020-09-02	ALTY	ETF	10.97	11.0	10.95	11.0	10300.0
2020-09-02	AMJ	ETF	12.48	12.52	12.245	12.31	3089072.0
2020-09-02	AMLP	ETF	22.9	23.14	22.6	22.74	2695500.0
2020-09-02	AMNA	ETF	24.43	24.43	24.22	24.2991	3600.0
2020-09-02	AMND	ETF	25.4037	25.4037	25.4037	25.4037	0.0
2020-09-02	AMOM	ETF	38.38	38.38	37.63	38.3	4700.0
2020-09-02	AMUB	ETF	7.725	7.8	7.725	7.7559	2170.0
2020-09-02	AMZA	ETF	16.53	16.7	16.36	16.48	102700.0
2020-09-02	ANGL	ETF	30.59	30.7	30.43	30.61	1542700.0
2020-09-02	AOA	ETF	59.93	60.47	59.87	60.45	31300.0

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

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