PREVIEW / etf_daily / 2020-06-23

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-23.parquet
  size:    76 KB
  rows:    2,034

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-06-23	SPY	ETF	313.49	314.5	311.61	312.05	68471200.0
2020-06-23	QQQ	ETF	248.39	251.15	247.82	248.84	32767370.0
2020-06-23	IWM	ETF	144.32	144.66	142.65	143.0	20344200.0
2020-06-23	DIA	ETF	262.83	263.15	261.02	261.5	2948000.0
2020-06-23	GLD	ETF	165.63	166.52	165.52	166.48	12137300.0
2020-06-23	TLT	ETF	161.48	162.06	161.12	161.3	9088600.0
2020-06-23	AAAU	ETF	17.55	17.66	17.55	17.66	351800.0
2020-06-23	AADR	ETF	53.59	54.21	53.5	53.77	3900.0
2020-06-23	AAXJ	ETF	70.37	70.69	70.28	70.35	830800.0
2020-06-23	ABEQ	ETF	22.47	22.5	22.42	22.441	2400.0
2020-06-23	ACES	ETF	38.68	38.84	38.409	38.47	23600.0
2020-06-23	ACIO	ETF	25.32	25.342	25.26	25.26	11100.0
2020-06-23	ACSI	ETF	33.83	33.83	33.8	33.8093	412.0
2020-06-23	ACTX	ETF	2.9559	4.071	2.95	4.0061	783.0
2020-06-23	ACWF	ETF	28.23	28.2537	28.0593	28.0593	14063.0
2020-06-23	ACWI	ETF	75.16	75.35	74.74	74.82	1623700.0
2020-06-23	ACWV	ETF	88.85	88.96	88.14	88.16	203500.0
2020-06-23	ACWX	ETF	44.24	44.36	44.01	44.06	1445780.0
2020-06-23	ADME	ETF	32.36	32.54	32.355	32.373	10000.0
2020-06-23	ADRE	ETF	40.37	40.68	40.37	40.535	2242.0
2020-06-23	AESR	ETF	10.04	10.065	10.022	10.022	2500.0
2020-06-23	AFIF	ETF	9.8216	9.8216	9.7901	9.805	43441.0
2020-06-23	AFK	ETF	16.3	16.6399	16.3	16.46	3583.0
2020-06-23	AFMC	ETF	17.09	17.108	17.077	17.077	300.0
2020-06-23	AFSM	ETF	16.82	16.846	16.82	16.846	300.0
2020-06-23	AFTY	ETF	16.89	16.89	16.703	16.703	400.0
2020-06-23	AGG	ETF	117.79	117.83	117.69	117.75	3991400.0
2020-06-23	AGGY	ETF	53.63	53.63	53.53	53.62	442900.0
2020-06-23	AGNG	ETF	24.82	25.06	24.82	25.06	15400.0
2020-06-23	AGQ	ETF	28.42	28.53	28.12	28.51	550300.0
2020-06-23	AGZ	ETF	120.99	121.0	120.7527	120.98	32179.0
2020-06-23	AGZD	ETF	23.49	23.565	23.45	23.45	17200.0
2020-06-23	AIA	ETF	65.61	65.87	65.44	65.48	40360.0
2020-06-23	AIEQ	ETF	28.17	28.432	28.111	28.13	21000.0
2020-06-23	AIQ	ETF	20.91	21.0451	20.81	20.81	18608.0
2020-06-23	AIRR	ETF	23.93	23.96	23.58	23.688	24900.0
2020-06-23	AIVI	ETF	36.48	36.6	36.29	36.29	18300.0
2020-06-23	ALTY	ETF	11.16	11.16	11.01	11.025	18600.0
2020-06-23	AMJ	ETF	14.95	14.99	14.485	14.5	1001241.0
2020-06-23	AMLP	ETF	27.77	27.91	26.93	26.96	1779700.0
2020-06-23	AMNA	ETF	24.9345	24.9345	24.9345	24.9345	0.0
2020-06-23	AMOM	ETF	29.74	29.74	29.74	29.74	100.0
2020-06-23	AMUB	ETF	8.39	9.36	8.39	9.11	9353.0
2020-06-23	AMZA	ETF	20.7	20.95	19.95	20.06	47800.0
2020-06-23	ANGL	ETF	29.18	29.2	29.05	29.13	484800.0
2020-06-23	AOA	ETF	55.59	55.78	55.4	55.46	31700.0
2020-06-23	AOK	ETF	36.58	36.58	36.43	36.48	314998.0
2020-06-23	AOM	ETF	40.17	40.23	40.0601	40.1	194880.0
2020-06-23	AOR	ETF	46.88	46.965	46.6887	46.75	100689.0
2020-06-23	ARB	ETF	24.63	24.63	24.6236	24.6236	206.0

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

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