PREVIEW / etf_daily / 2020-09-14

all etf daily files

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

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-14	SPY	ETF	337.49	340.38	334.22	338.46	65605700.0
2020-09-14	QQQ	ETF	274.28	277.22	272.96	275.16	38525194.0
2020-09-14	IWM	ETF	150.59	153.43	150.37	153.08	21991300.0
2020-09-14	DIA	ETF	278.92	281.43	278.67	280.53	2371700.0
2020-09-14	GLD	ETF	183.57	184.3	183.39	183.89	9709500.0
2020-09-14	TLT	ETF	164.79	165.08	164.23	164.47	4274900.0
2020-09-14	AAA	ETF	25.01	25.06	25.01	25.02	13347.0
2020-09-14	AAAU	ETF	19.48	19.54	19.46	19.51	701500.0
2020-09-14	AADR	ETF	55.89	56.46	55.89	56.4	4000.0
2020-09-14	AAXJ	ETF	77.44	77.76	77.39	77.64	634700.0
2020-09-14	ABEQ	ETF	24.04	24.049	23.85	24.005	4500.0
2020-09-14	ACES	ETF	49.96	51.31	49.96	51.31	27000.0
2020-09-14	ACIO	ETF	26.68	26.7	26.645	26.67	1700.0
2020-09-14	ACSI	ETF	37.43	37.43	37.2785	37.2785	202.0
2020-09-14	ACTX	ETF	2.245	2.3954	2.1594	2.3954	664.0
2020-09-14	ACWF	ETF	29.79	30.02	29.79	29.9	15807.0
2020-09-14	ACWI	ETF	80.62	81.11	80.48	80.78	2086900.0
2020-09-14	ACWV	ETF	92.2	92.86	92.19	92.67	104300.0
2020-09-14	ACWX	ETF	46.9813	47.055	46.86	46.93	469251.0
2020-09-14	ADME	ETF	33.64	33.7	33.56	33.609	43700.0
2020-09-14	ADRE	ETF	46.64	46.91	46.64	46.91	4411.0
2020-09-14	AESR	ETF	10.97	10.98	10.885	10.927	19800.0
2020-09-14	AFIF	ETF	9.835	9.85	9.81	9.825	43746.0
2020-09-14	AFK	ETF	17.93	18.298	17.93	18.22	4199.0
2020-09-14	AFMC	ETF	17.87	17.969	17.87	17.969	100.0
2020-09-14	AFSM	ETF	17.88	18.021	17.88	18.021	100.0
2020-09-14	AFTY	ETF	19.38	19.53	19.38	19.53	2200.0
2020-09-14	AGG	ETF	118.47	118.49	118.31	118.38	6394200.0
2020-09-14	AGGY	ETF	54.08	54.113	54.03	54.09	96500.0
2020-09-14	AGNG	ETF	25.6	25.67	25.58	25.648	700.0
2020-09-14	AGQ	ETF	57.95	59.3	57.9	58.74	1004000.0
2020-09-14	AGZ	ETF	121.35	121.35	121.19	121.23	27856.0
2020-09-14	AGZD	ETF	23.53	23.53	23.48	23.515	7000.0
2020-09-14	AIA	ETF	72.79	73.19	72.79	73.06	72431.0
2020-09-14	AIEQ	ETF	29.6	30.12	29.6	29.95	22600.0
2020-09-14	AIQ	ETF	23.06	23.28	22.97	23.09	24975.0
2020-09-14	AIRR	ETF	26.107	26.319	26.107	26.319	4400.0
2020-09-14	AIVI	ETF	37.31	37.31	37.11	37.17	138400.0
2020-09-14	ALTL	ETF	25.11	25.2059	25.11	25.15	6866.0
2020-09-14	ALTY	ETF	10.8	10.99	10.765	10.86	68100.0
2020-09-14	AMJ	ETF	11.65	11.9	11.565	11.83	538101.0
2020-09-14	AMLP	ETF	21.39	21.95	21.29	21.78	2957600.0
2020-09-14	AMNA	ETF	23.18	23.47	23.17	23.3517	2716.0
2020-09-14	AMND	ETF	24.5038	24.5038	24.5038	24.5038	0.0
2020-09-14	AMOM	ETF	34.604	34.61	34.46	34.516	3900.0
2020-09-14	AMUB	ETF	7.32	7.47	7.32	7.4409	21955.0
2020-09-14	AMZA	ETF	14.98	15.449	14.901	15.32	117100.0
2020-09-14	ANGL	ETF	30.13	30.13	29.87	29.95	2061900.0
2020-09-14	AOA	ETF	58.53	58.81	58.5	58.59	46900.0
2020-09-14	AOK	ETF	37.33	37.4799	37.33	37.44	83675.0

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

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