PREVIEW / etf_daily / 2020-05-29

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-29.parquet
  size:    76 KB
  rows:    2,007

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-05-29	SPY	ETF	302.46	304.96	299.47	304.32	119090800.0
2020-05-29	QQQ	ETF	230.43	233.6	228.76	233.36	50878596.0
2020-05-29	IWM	ETF	138.3	139.28	136.41	138.9	41536400.0
2020-05-29	DIA	ETF	253.27	255.32	250.68	254.29	5082300.0
2020-05-29	GLD	ETF	162.58	163.4	162.32	162.91	12581800.0
2020-05-29	TLT	ETF	162.71	164.09	162.35	163.59	14632700.0
2020-05-29	AAAU	ETF	17.25	17.32	17.22	17.27	426100.0
2020-05-29	AADR	ETF	48.8	49.09	48.22	49.09	13400.0
2020-05-29	AAXJ	ETF	63.9	64.76	63.53	64.67	982600.0
2020-05-29	ABEQ	ETF	22.35	22.44	22.266	22.44	5800.0
2020-05-29	ACES	ETF	35.99	36.14	35.685	36.14	14200.0
2020-05-29	ACIO	ETF	24.57	24.682	24.508	24.682	1400.0
2020-05-29	ACSI	ETF	32.4858	32.4858	32.4858	32.4858	102.0
2020-05-29	ACTX	ETF	5.4398	5.546	4.248	4.2834	183.0
2020-05-29	ACWF	ETF	27.3899	27.6663	27.29	27.6663	16507.0
2020-05-29	ACWI	ETF	71.89	72.36	71.25	72.22	7392600.0
2020-05-29	ACWV	ETF	88.6	88.96	88.01	88.74	349600.0
2020-05-29	ACWX	ETF	41.84	41.96	41.38	41.89	2288653.0
2020-05-29	ADME	ETF	31.63	31.9	31.63	31.9	6300.0
2020-05-29	ADRE	ETF	36.08	36.8087	35.83	36.8087	4902.0
2020-05-29	AESR	ETF	9.63	9.718	9.63	9.718	10800.0
2020-05-29	AFIF	ETF	9.821	9.85	9.82	9.83	176918.0
2020-05-29	AFK	ETF	15.35	15.36	15.26	15.33	4725.0
2020-05-29	AFLG	ETF	18.69	18.69	18.69	18.69	200.0
2020-05-29	AFSM	ETF	16.483	16.483	16.483	16.483	300.0
2020-05-29	AFTY	ETF	15.56	15.77	15.56	15.75	13600.0
2020-05-29	AGG	ETF	117.43	117.71	117.32	117.65	9228700.0
2020-05-29	AGGY	ETF	53.35	53.53	53.22	53.48	257800.0
2020-05-29	AGNG	ETF	23.99	24.255	23.97	24.255	2100.0
2020-05-29	AGQ	ETF	29.5	30.14	29.33	29.88	597200.0
2020-05-29	AGZ	ETF	120.97	121.17	120.9652	121.17	20774.0
2020-05-29	AGZD	ETF	23.375	23.375	23.32	23.345	6200.0
2020-05-29	AIA	ETF	58.61	59.43	58.5	59.4	69387.0
2020-05-29	AIEQ	ETF	27.1	27.595	27.1	27.53	24400.0
2020-05-29	AIQ	ETF	19.2	19.5323	19.15	19.491	10974.0
2020-05-29	AIRR	ETF	23.1	23.31	22.915	23.244	9600.0
2020-05-29	AIVI	ETF	34.59	34.66	34.36	34.66	7700.0
2020-05-29	ALTY	ETF	10.75	10.82	10.64	10.8	11000.0
2020-05-29	AMJ	ETF	14.28	14.48	13.94	14.42	1359048.0
2020-05-29	AMLP	ETF	26.62	26.95	25.94	26.82	4799200.0
2020-05-29	AMOM	ETF	28.326	28.326	28.326	28.326	200.0
2020-05-29	AMUB	ETF	9.02	9.0855	8.78	9.0855	11316.0
2020-05-29	AMZA	ETF	20.4	20.4	19.51	20.29	39800.0
2020-05-29	ANGL	ETF	27.99	28.36	27.91	28.18	1102800.0
2020-05-29	AOA	ETF	53.29	53.54	52.98	53.5	67200.0
2020-05-29	AOK	ETF	35.75	35.94	35.7172	35.92	130135.0
2020-05-29	AOM	ETF	39.18	39.32	38.97	39.26	185477.0
2020-05-29	AOR	ETF	45.33	45.52	45.07	45.41	97423.0
2020-05-29	ARB	ETF	24.6	24.6	24.55	24.55	2700.0
2020-05-29	ARCM	ETF	100.515	100.515	100.33	100.33	200.0

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

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