PREVIEW / etf_daily / 2020-04-09

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-09.parquet
  size:    75 KB
  rows:    1,964

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-04-09	SPY	ETF	277.58	281.2	275.47	278.2	189999200.0
2020-04-09	QQQ	ETF	202.27	203.22	199.0281	200.86	68323929.0
2020-04-09	IWM	ETF	121.92	124.61	121.33	123.72	69528600.0
2020-04-09	DIA	ETF	237.84	240.19	235.11	237.14	9393200.0
2020-04-09	GLD	ETF	158.08	159.08	157.21	158.69	18123000.0
2020-04-09	TLT	ETF	164.28	165.79	163.78	165.39	14259100.0
2020-04-09	AAAU	ETF	16.75	16.85	16.68	16.79	283100.0
2020-04-09	AADR	ETF	43.56	43.58	42.96	43.42	14400.0
2020-04-09	AAXJ	ETF	62.04	62.49	61.35	61.35	1119700.0
2020-04-09	ABEQ	ETF	21.662	21.751	21.572	21.726	17300.0
2020-04-09	ACES	ETF	31.42	31.97	30.811	31.29	51600.0
2020-04-09	ACIO	ETF	23.55	23.69	23.395	23.508	7800.0
2020-04-09	ACSI	ETF	30.1532	30.1532	30.1532	30.1532	149.0
2020-04-09	ACTX	ETF	5.9001	5.9001	3.8645	4.602	294.0
2020-04-09	ACWF	ETF	25.67	25.999	25.63	25.67	15986.0
2020-04-09	ACWI	ETF	66.17	66.93	65.72	66.25	5729500.0
2020-04-09	ACWV	ETF	84.94	86.73	84.94	86.04	415700.0
2020-04-09	ACWX	ETF	39.05	39.37	38.77	39.09	2391222.0
2020-04-09	ADME	ETF	29.44	29.49	29.27	29.388	4000.0
2020-04-09	ADRE	ETF	35.03	35.2143	34.59	34.6605	5624.0
2020-04-09	AESR	ETF	8.92	8.95	8.869	8.869	179600.0
2020-04-09	AFIF	ETF	9.78	9.89	9.78	9.8593	1414763.0
2020-04-09	AFK	ETF	13.64	14.29	13.64	13.98	135540.0
2020-04-09	AFLG	ETF	17.191	17.191	17.103	17.103	1500.0
2020-04-09	AFSM	ETF	14.97	15.0	14.97	15.0	300.0
2020-04-09	AFTY	ETF	15.362	15.45	15.281	15.281	8600.0
2020-04-09	AGG	ETF	116.5	117.25	116.17	117.25	5584100.0
2020-04-09	AGGY	ETF	52.23	53.42	52.23	52.92	691000.0
2020-04-09	AGNG	ETF	21.56	21.75	21.496	21.75	8600.0
2020-04-09	AGQ	ETF	22.55	23.72	22.27	22.74	342500.0
2020-04-09	AGZ	ETF	120.3	120.3	119.94	119.96	178002.0
2020-04-09	AGZD	ETF	23.495	23.495	23.35	23.425	73000.0
2020-04-09	AIA	ETF	58.15	58.68	57.5	57.5	357463.0
2020-04-09	AIEQ	ETF	23.58	23.97	23.58	23.63	19200.0
2020-04-09	AIQ	ETF	16.5	16.57	16.29	16.29	8104.0
2020-04-09	AIRR	ETF	21.21	21.678	21.21	21.678	35400.0
2020-04-09	AIVI	ETF	32.8	33.06	32.74	32.94	35600.0
2020-04-09	ALTY	ETF	9.15	10.06	9.15	9.7	23500.0
2020-04-09	AMJ	ETF	9.99	10.84	9.84	10.35	6034296.0
2020-04-09	AMLP	ETF	19.4	20.85	18.7	19.3	14457320.0
2020-04-09	AMUB	ETF	5.91	6.75	5.91	6.425	6953.0
2020-04-09	AMZA	ETF	12.93	14.15	12.4	12.98	114400.0
2020-04-09	ANGL	ETF	27.59	28.08	26.55	27.18	4282000.0
2020-04-09	AOA	ETF	49.76	50.45	49.61	49.84	213800.0
2020-04-09	AOK	ETF	34.54	34.9293	34.54	34.84	117669.0
2020-04-09	AOM	ETF	37.49	37.85	37.47	37.7	407702.0
2020-04-09	AOR	ETF	42.87	43.24	42.7873	43.04	410653.0
2020-04-09	ARGT	ETF	17.79	18.01	17.28	17.59	19300.0
2020-04-09	ARKF	ETF	21.79	22.32	21.77	21.84	164200.0
2020-04-09	ARKG	ETF	33.29	33.53	32.67	33.3	294500.0

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

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