PREVIEW / etf_daily / 2020-08-14

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-14.parquet
  size:    77 KB
  rows:    2,045

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-08-14	SPY	ETF	336.41	337.42	335.62	336.84	47260400.0
2020-08-14	QQQ	ETF	273.01	273.4	270.72	272.16	30799494.0
2020-08-14	IWM	ETF	156.28	157.76	155.87	157.09	13360900.0
2020-08-14	DIA	ETF	278.23	280.16	277.9	279.8	2247000.0
2020-08-14	GLD	ETF	183.44	183.72	181.49	182.54	11792000.0
2020-08-14	TLT	ETF	163.81	164.15	163.16	163.18	6398100.0
2020-08-14	AAAU	ETF	19.47	19.49	19.26	19.36	333100.0
2020-08-14	AADR	ETF	57.88	57.88	57.1	57.23	4300.0
2020-08-14	AAXJ	ETF	76.62	76.74	76.48	76.69	1305800.0
2020-08-14	ABEQ	ETF	23.52	23.62	23.52	23.522	3300.0
2020-08-14	ACES	ETF	50.47	50.735	49.883	50.07	50300.0
2020-08-14	ACIO	ETF	26.88	26.88	26.62	26.651	7600.0
2020-08-14	ACSI	ETF	37.7541	37.82	37.7378	37.7378	1111.0
2020-08-14	ACTX	ETF	2.8851	2.8851	2.3541	2.5901	1671.0
2020-08-14	ACWF	ETF	30.17	30.33	30.14	30.17	11760.0
2020-08-14	ACWI	ETF	80.11	80.31	79.96	80.18	976100.0
2020-08-14	ACWV	ETF	92.46	92.63	92.2	92.42	125900.0
2020-08-14	ACWX	ETF	46.56	46.685	46.49	46.62	659464.0
2020-08-14	ADME	ETF	34.15	34.15	33.9	33.919	6300.0
2020-08-14	ADRE	ETF	45.5778	45.5778	45.3301	45.4006	2762.0
2020-08-14	AESR	ETF	10.815	10.85	10.8	10.825	13000.0
2020-08-14	AFIF	ETF	9.81	9.85	9.8	9.815	6321.0
2020-08-14	AFK	ETF	17.5	17.56	17.2707	17.46	6921.0
2020-08-14	AFLG	ETF	20.465	20.48	20.441	20.441	3300.0
2020-08-14	AFSM	ETF	18.49	18.515	18.49	18.515	200.0
2020-08-14	AFTY	ETF	18.94	19.04	18.94	19.03	6300.0
2020-08-14	AGG	ETF	118.43	118.49	118.2	118.2	4556500.0
2020-08-14	AGGY	ETF	54.11	54.11	53.96	54.02	90200.0
2020-08-14	AGNG	ETF	25.63	25.65	25.459	25.57	7100.0
2020-08-14	AGQ	ETF	58.83	59.39	53.24	56.19	3256400.0
2020-08-14	AGZ	ETF	121.18	121.26	121.019	121.1995	42669.0
2020-08-14	AGZD	ETF	23.6	23.6	23.525	23.56	17800.0
2020-08-14	AIA	ETF	71.38	71.51	71.251	71.42	27076.0
2020-08-14	AIEQ	ETF	30.51	30.69	30.345	30.403	10100.0
2020-08-14	AIQ	ETF	22.39	22.43	22.31	22.35	32580.0
2020-08-14	AIRR	ETF	27.09	27.51	27.04	27.325	21000.0
2020-08-14	AIVI	ETF	37.28	37.46	37.26	37.34	12300.0
2020-08-14	ALTL	ETF	25.23	25.345	25.23	25.2552	2340.0
2020-08-14	ALTY	ETF	11.15	11.15	11.08	11.123	13300.0
2020-08-14	AMJ	ETF	13.83	14.09	13.83	13.88	394013.0
2020-08-14	AMLP	ETF	24.88	25.35	24.88	24.99	1153100.0
2020-08-14	AMNA	ETF	25.63	25.63	25.5501	25.5501	200.0
2020-08-14	AMND	ETF	26.959	26.959	26.959	26.959	0.0
2020-08-14	AMOM	ETF	35.43	35.43	34.086	34.086	2900.0
2020-08-14	AMUB	ETF	8.81	8.86	8.7	8.72	36883.0
2020-08-14	AMZA	ETF	18.7	19.061	18.7	18.88	59800.0
2020-08-14	ANGL	ETF	30.18	30.2	30.05	30.11	1579300.0
2020-08-14	AOA	ETF	58.37	58.46	58.21	58.38	27700.0
2020-08-14	AOK	ETF	37.39	37.42	37.2701	37.38	278068.0
2020-08-14	AOM	ETF	41.13	41.4171	41.13	41.21	79289.0

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

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