PREVIEW / etf_daily / 2020-07-24

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-24.parquet
  size:    77 KB
  rows:    2,042

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-07-24	SPY	ETF	320.95	321.99	319.25	320.88	73766600.0
2020-07-24	QQQ	ETF	254.12	256.93	251.32	255.56	54054536.0
2020-07-24	IWM	ETF	147.29	147.67	145.56	146.08	20015500.0
2020-07-24	DIA	ETF	265.15	266.34	264.05	264.69	2637700.0
2020-07-24	GLD	ETF	179.14	179.16	178.2	178.7	15601300.0
2020-07-24	TLT	ETF	169.01	169.92	168.87	169.74	7520700.0
2020-07-24	AAAU	ETF	19.03	19.03	18.92	18.98	706500.0
2020-07-24	AADR	ETF	56.57	56.58	56.03	56.38	11500.0
2020-07-24	AAXJ	ETF	73.48	74.18	73.41	74.18	1450300.0
2020-07-24	ABEQ	ETF	23.1	23.132	23.03	23.132	5200.0
2020-07-24	ACES	ETF	46.11	46.11	44.565	45.25	51800.0
2020-07-24	ACIO	ETF	25.803	25.81	25.72	25.766	6000.0
2020-07-24	ACSI	ETF	34.9	34.9375	34.9	34.9375	501.0
2020-07-24	ACTX	ETF	3.422	3.422	2.36	2.7966	85.0
2020-07-24	ACWF	ETF	29.2	29.2	29.01	29.0479	2321.0
2020-07-24	ACWI	ETF	77.06	77.39	76.8	77.16	1128700.0
2020-07-24	ACWV	ETF	90.74	91.0	90.5	90.75	195500.0
2020-07-24	ACWX	ETF	45.27	45.47	45.17	45.4	888728.0
2020-07-24	ADME	ETF	33.075	33.075	33.02	33.042	3200.0
2020-07-24	ADRE	ETF	43.73	44.745	43.73	44.5134	77819.0
2020-07-24	AESR	ETF	10.33	10.33	10.292	10.292	3300.0
2020-07-24	AFIF	ETF	9.84	9.86	9.8398	9.8398	15553.0
2020-07-24	AFK	ETF	17.31	17.84	16.82	17.13	11427.0
2020-07-24	AFLG	ETF	19.55	19.558	19.52	19.52	900.0
2020-07-24	AFMC	ETF	17.7	17.7	17.647	17.647	1000.0
2020-07-24	AFSM	ETF	17.272	17.272	17.272	17.272	100.0
2020-07-24	AFTY	ETF	18.19	18.315	18.19	18.315	3200.0
2020-07-24	AGG	ETF	119.26	119.41	119.19	119.28	11071700.0
2020-07-24	AGGY	ETF	54.48	54.55	54.43	54.54	169800.0
2020-07-24	AGNG	ETF	25.285	25.47	25.285	25.375	1500.0
2020-07-24	AGQ	ETF	45.04	45.12	43.35	44.4	1988700.0
2020-07-24	AGZ	ETF	121.74	121.79	121.6577	121.69	52120.0
2020-07-24	AGZD	ETF	23.67	23.7	23.535	23.62	43000.0
2020-07-24	AIA	ETF	68.47	69.14	68.43	69.11	263937.0
2020-07-24	AIEQ	ETF	29.58	29.625	29.362	29.58	8600.0
2020-07-24	AIQ	ETF	21.29	21.6	21.19	21.45	55901.0
2020-07-24	AIRR	ETF	24.56	24.611	24.36	24.405	2200.0
2020-07-24	AIVI	ETF	36.8	36.87	36.66	36.73	15500.0
2020-07-24	ALTL	ETF	25.0281	25.065	24.9145	24.9145	12567.0
2020-07-24	ALTY	ETF	10.707	10.726	10.635	10.635	11600.0
2020-07-24	AMJ	ETF	12.99	13.13	12.87	12.9	685218.0
2020-07-24	AMLP	ETF	24.18	24.39	23.91	23.99	1365400.0
2020-07-24	AMNA	ETF	23.75	23.75	23.6707	23.6707	202.0
2020-07-24	AMND	ETF	25.19	25.19	24.96	24.9839	706.0
2020-07-24	AMOM	ETF	31.16	31.95	31.16	31.702	2000.0
2020-07-24	AMUB	ETF	8.29	8.29	8.14	8.19	18082.0
2020-07-24	AMZA	ETF	17.16	17.34	16.92	17.04	39400.0
2020-07-24	ANGL	ETF	29.97	30.09	29.9	30.04	523500.0
2020-07-24	AOA	ETF	56.64	56.73	56.4	56.59	51300.0
2020-07-24	AOK	ETF	37.09	37.0967	36.97	37.06	106435.0

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

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