PREVIEW / etf_daily / 2020-12-16

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-16.parquet
  size:    83 KB
  rows:    2,180

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-12-16	SPY	ETF	369.82	371.16	368.87	370.17	58420500.0
2020-12-16	QQQ	ETF	307.7	309.785	306.621	308.98	25461890.0
2020-12-16	IWM	ETF	195.13	195.21	192.96	193.98	25494600.0
2020-12-16	DIA	ETF	302.54	302.87	301.32	302.15	1977300.0
2020-12-16	GLD	ETF	174.13	175.02	173.02	174.9	8174700.0
2020-12-16	TLT	ETF	156.58	157.89	156.39	157.38	9954200.0
2020-12-16	AAA	ETF	25.07	25.07	25.07	25.07	86.0
2020-12-16	AAAU	ETF	18.49	18.58	18.37	18.57	708900.0
2020-12-16	AADR	ETF	59.2	59.22	58.98	59.05	1700.0
2020-12-16	AAXJ	ETF	87.55	87.75	87.35	87.51	1073400.0
2020-12-16	ABEQ	ETF	25.25	25.31	25.217	25.278	19400.0
2020-12-16	ACES	ETF	73.47	73.52	71.12	72.68	99900.0
2020-12-16	ACIO	ETF	27.505	27.52	27.42	27.42	49800.0
2020-12-16	ACSI	ETF	43.1975	43.1975	43.1975	43.1975	110.0
2020-12-16	ACTV	ETF	31.04	31.11	31.02	31.084	3338.0
2020-12-16	ACTX	ETF	2.45	2.45	2.45	2.45	1357.0
2020-12-16	ACVF	ETF	27.426	27.461	27.426	27.461	600.0
2020-12-16	ACWF	ETF	32.97	33.05	32.83	33.0068	24295.0
2020-12-16	ACWI	ETF	89.46	89.73	89.23	89.55	2613900.0
2020-12-16	ACWV	ETF	95.81	96.21	95.59	95.88	310000.0
2020-12-16	ACWX	ETF	52.39	52.59	52.28	52.53	916831.0
2020-12-16	ADFI	ETF	9.96	9.96	9.93	9.95	1100.0
2020-12-16	ADME	ETF	35.47	35.52	35.339	35.471	43000.0
2020-12-16	ADRE	ETF	55.56	55.95	55.3097	55.84	7641.0
2020-12-16	AESR	ETF	11.75	11.791	11.75	11.79	3700.0
2020-12-16	AFIF	ETF	9.79	9.79	9.76	9.77	12745.0
2020-12-16	AFK	ETF	21.05	21.355	21.0	21.2	45212.0
2020-12-16	AFLG	ETF	22.17	22.17	22.13	22.14	600.0
2020-12-16	AFMC	ETF	21.2	21.2	21.17	21.198	1200.0
2020-12-16	AFSM	ETF	21.8	21.8	21.78	21.792	1200.0
2020-12-16	AFTY	ETF	22.2	22.2	22.168	22.168	500.0
2020-12-16	AGG	ETF	117.83	118.03	117.76	117.98	4467900.0
2020-12-16	AGGY	ETF	53.46	53.596	53.46	53.58	89900.0
2020-12-16	AGNG	ETF	27.4	27.5	27.341	27.469	2900.0
2020-12-16	AGQ	ETF	46.2	47.76	45.06	47.67	1804900.0
2020-12-16	AGZ	ETF	119.53	119.739	119.53	119.66	37035.0
2020-12-16	AGZD	ETF	23.52	23.62	23.515	23.58	15000.0
2020-12-16	AIA	ETF	84.23	84.29	83.89	84.22	99249.0
2020-12-16	AIEQ	ETF	35.69	35.69	35.371	35.56	9800.0
2020-12-16	AIQ	ETF	26.86	26.98	26.781	26.95	35437.0
2020-12-16	AIRR	ETF	33.851	33.851	33.5	33.569	4500.0
2020-12-16	AIVI	ETF	40.68	40.74	40.58	40.74	4500.0
2020-12-16	ALTL	ETF	32.0037	32.0449	31.905	31.99	4549.0
2020-12-16	ALTY	ETF	11.89	11.9	11.85	11.9	14100.0
2020-12-16	AMJ	ETF	15.02	15.02	14.7	14.83	957023.0
2020-12-16	AMLP	ETF	27.86	27.96	27.23	27.43	2819300.0
2020-12-16	AMNA	ETF	26.8259	26.8259	26.8259	26.8259	7.0
2020-12-16	AMND	ETF	28.6692	28.6692	28.6692	28.6692	10.0
2020-12-16	AMOM	ETF	39.28	39.35	39.2	39.306	3200.0
2020-12-16	AMTR	ETF	30.36	30.42	30.24	30.28	17449.0

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

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