PREVIEW / etf_daily / 2020-03-05

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-05.parquet
  size:    75 KB
  rows:    1,962

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-03-05	SPY	ETF	304.98	308.47	300.01	302.46	186366800.0
2020-03-05	QQQ	ETF	212.69	216.36	210.1	211.59	78705458.0
2020-03-05	IWM	ETF	148.84	152.48	145.49	147.32	32729400.0
2020-03-05	DIA	ETF	264.27	266.53	259.56	261.46	5872900.0
2020-03-05	GLD	ETF	156.06	157.62	155.72	157.49	17973500.0
2020-03-05	TLT	ETF	157.13	158.82	156.81	158.52	17786200.0
2020-03-05	AAAU	ETF	16.56	16.71	16.51	16.69	181100.0
2020-03-05	AADR	ETF	51.44	51.59	50.61	50.91	6900.0
2020-03-05	AAXJ	ETF	69.81	70.11	68.98	69.0	1652900.0
2020-03-05	ABEQ	ETF	23.46	23.5	23.2	23.302	111500.0
2020-03-05	ACES	ETF	38.97	39.67	38.68	39.35	29000.0
2020-03-05	ACIO	ETF	24.38	24.78	24.38	24.78	47000.0
2020-03-05	ACSI	ETF	33.807	33.807	33.43	33.4461	960.0
2020-03-05	ACTX	ETF	6.4901	6.4901	6.4901	6.4901	38.0
2020-03-05	ACWF	ETF	28.79	29.0	28.57	28.64	17785.0
2020-03-05	ACWI	ETF	73.99	74.79	73.12	73.54	3210100.0
2020-03-05	ACWV	ETF	93.98	94.85	93.34	93.84	424500.0
2020-03-05	ACWX	ETF	44.92	45.2	44.5	44.67	1178831.0
2020-03-05	ADME	ETF	30.5	30.583	30.325	30.51	20300.0
2020-03-05	ADRE	ETF	40.54	40.8402	40.27	40.3669	3892.0
2020-03-05	AESR	ETF	9.61	9.61	9.515	9.515	100.0
2020-03-05	AFIF	ETF	10.005	10.005	10.005	10.005	131.0
2020-03-05	AFK	ETF	17.76	17.76	17.4011	17.46	17986.0
2020-03-05	AFLG	ETF	19.12	19.13	19.12	19.12	1900.0
2020-03-05	AFTY	ETF	17.01	17.135	16.95	16.961	5600.0
2020-03-05	AGG	ETF	116.99	117.23	116.93	117.0	6802800.0
2020-03-05	AGGY	ETF	54.28	54.33	54.2	54.27	719300.0
2020-03-05	AGNG	ETF	23.04	23.29	22.949	23.037	1600.0
2020-03-05	AGQ	ETF	28.79	29.4	28.71	29.35	198000.0
2020-03-05	AGZ	ETF	120.1	120.19	119.9985	120.13	43444.0
2020-03-05	AGZD	ETF	23.785	23.825	23.785	23.82	13600.0
2020-03-05	AIA	ETF	63.2	63.53	62.6591	62.83	63660.0
2020-03-05	AIEQ	ETF	26.91	27.445	26.784	26.939	37800.0
2020-03-05	AIQ	ETF	17.74	18.0	17.45	17.56	19774.0
2020-03-05	AIRR	ETF	25.955	26.01	25.334	25.512	3900.0
2020-03-05	AIVI	ETF	38.36	38.42	37.96	38.07	7400.0
2020-03-05	ALTY	ETF	13.855	13.855	13.66	13.7	13900.0
2020-03-05	AMJ	ETF	17.03	17.09	16.59	16.78	4376625.0
2020-03-05	AMLP	ETF	32.9	33.1	32.1	32.5	6915360.0
2020-03-05	AMOM	ETF	25.365	25.365	25.365	25.365	100.0
2020-03-05	AMUB	ETF	10.6618	10.729	10.55	10.5603	2394.0
2020-03-05	AMZA	ETF	30.9	30.9	29.5	29.8	137790.0
2020-03-05	ANGL	ETF	29.79	29.9	29.7	29.73	751700.0
2020-03-05	AOA	ETF	55.11	55.36	54.43	54.75	93200.0
2020-03-05	AOK	ETF	36.28	36.5018	36.16	36.26	86551.0
2020-03-05	AOM	ETF	39.75	39.95	39.59	39.68	197259.0
2020-03-05	AOR	ETF	46.46	46.6372	46.0505	46.26	251078.0
2020-03-05	ARCM	ETF	100.095	100.095	100.095	100.095	100.0
2020-03-05	ARGT	ETF	23.9	24.04	23.62	23.73	25700.0
2020-03-05	ARKF	ETF	24.73	25.02	24.4	24.503	35500.0

> showing 50 of 1,962 rows — these rows as CSV

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