PREVIEW / etf_daily / 2020-07-22

all etf daily files

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

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-22	SPY	ETF	324.62	327.2	324.5	326.86	57792900.0
2020-07-22	QQQ	ETF	264.46	265.89	262.55	264.93	29865519.0
2020-07-22	IWM	ETF	147.09	148.67	147.03	148.11	24424800.0
2020-07-22	DIA	ETF	267.82	270.35	267.77	269.98	2039300.0
2020-07-22	GLD	ETF	174.05	175.77	173.76	175.63	18712500.0
2020-07-22	TLT	ETF	168.26	168.46	167.69	167.79	6592100.0
2020-07-22	AAAU	ETF	18.47	18.65	18.43	18.64	500300.0
2020-07-22	AADR	ETF	57.9	57.9	57.48	57.68	21100.0
2020-07-22	AAXJ	ETF	75.17	75.19	74.44	74.76	635700.0
2020-07-22	ABEQ	ETF	23.075	23.13	23.05	23.125	5000.0
2020-07-22	ACES	ETF	46.48	46.53	45.986	46.4	38900.0
2020-07-22	ACIO	ETF	25.86	26.09	25.83	26.062	41700.0
2020-07-22	ACSI	ETF	35.2	35.3865	35.2	35.3865	651.0
2020-07-22	ACTX	ETF	2.9471	2.95	2.1594	2.6255	1337.0
2020-07-22	ACWF	ETF	29.465	29.61	29.4301	29.5949	7273.0
2020-07-22	ACWI	ETF	78.09	78.56	78.02	78.43	2292700.0
2020-07-22	ACWV	ETF	90.77	91.52	90.77	91.37	959400.0
2020-07-22	ACWX	ETF	45.94	46.01	45.77	45.95	821866.0
2020-07-22	ADME	ETF	33.48	33.72	33.48	33.609	49000.0
2020-07-22	ADRE	ETF	44.49	44.505	44.1313	44.2915	13410.0
2020-07-22	AESR	ETF	10.495	10.527	10.483	10.527	5000.0
2020-07-22	AFIF	ETF	9.855	9.87	9.84	9.845	29145.0
2020-07-22	AFK	ETF	17.62	17.62	17.34	17.3485	5733.0
2020-07-22	AFMC	ETF	17.735	17.758	17.735	17.758	600.0
2020-07-22	AFTY	ETF	18.94	18.94	18.76	18.868	6700.0
2020-07-22	AGG	ETF	119.22	119.27	119.11	119.18	6296600.0
2020-07-22	AGGY	ETF	54.43	54.45	54.31	54.38	460400.0
2020-07-22	AGNG	ETF	25.775	25.99	25.775	25.89	3400.0
2020-07-22	AGQ	ETF	42.58	45.7	41.93	45.6	4623400.0
2020-07-22	AGZ	ETF	121.3	121.51	121.3	121.49	54932.0
2020-07-22	AGZD	ETF	23.625	23.7	23.625	23.675	91600.0
2020-07-22	AIA	ETF	69.48	69.51	68.9361	69.25	69406.0
2020-07-22	AIEQ	ETF	30.16	30.25	30.04	30.235	11600.0
2020-07-22	AIQ	ETF	21.93	22.1392	21.89	21.97	25390.0
2020-07-22	AIRR	ETF	24.801	24.801	24.62	24.62	4800.0
2020-07-22	AIVI	ETF	37.07	37.07	36.94	37.07	4300.0
2020-07-22	ALTL	ETF	25.05	25.19	25.0392	25.1811	2131.0
2020-07-22	ALTY	ETF	10.72	10.81	10.64	10.795	4100.0
2020-07-22	AMJ	ETF	13.2	13.27	13.015	13.18	770278.0
2020-07-22	AMLP	ETF	24.58	24.68	24.18	24.47	1859600.0
2020-07-22	AMNA	ETF	24.03	24.038	24.03	24.038	403.0
2020-07-22	AMND	ETF	25.33	25.3716	25.31	25.3716	1403.0
2020-07-22	AMOM	ETF	32.827	32.84	32.58	32.768	500.0
2020-07-22	AMUB	ETF	8.32	8.32	8.22	8.2864	50575.0
2020-07-22	AMZA	ETF	17.61	17.79	17.38	17.48	55600.0
2020-07-22	ANGL	ETF	29.98	30.01	29.85	29.99	1874700.0
2020-07-22	AOA	ETF	57.07	57.29	57.05	57.29	41300.0
2020-07-22	AOK	ETF	37.19	37.24	37.15	37.16	119422.0
2020-07-22	AOM	ETF	40.86	40.94	40.76	40.94	128837.0
2020-07-22	AOR	ETF	47.83	48.0	47.82	48.0	76760.0

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

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