PREVIEW / etf_daily / 2021-05-27

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-27.parquet
  size:    89 KB
  rows:    2,343

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
2021-05-27	SPY	ETF	420.17	420.72	418.99	419.29	56707700.0
2021-05-27	QQQ	ETF	333.67	334.54	332.67	332.88	27931747.0
2021-05-27	IWM	ETF	225.04	226.36	224.18	225.65	21225700.0
2021-05-27	DIA	ETF	345.35	346.16	343.87	344.6	3026200.0
2021-05-27	GLD	ETF	177.39	177.82	176.81	177.71	7993000.0
2021-05-27	TLT	ETF	138.5	138.69	137.99	138.66	10695200.0
2021-05-27	AAA	ETF	25.0299	25.03	25.0	25.015	1477.0
2021-05-27	AAAU	ETF	18.85	18.9	18.79	18.89	254300.0
2021-05-27	AADR	ETF	65.45	65.91	65.45	65.91	1500.0
2021-05-27	AAXJ	ETF	94.0	94.13	93.69	93.84	1283500.0
2021-05-27	ABEQ	ETF	28.27	28.27	28.215	28.233	9600.0
2021-05-27	ACES	ETF	69.1	69.48	68.57	69.48	86800.0
2021-05-27	ACIO	ETF	30.3	30.3	29.77	29.8	13400.0
2021-05-27	ACSI	ETF	49.2302	49.2302	49.2302	49.2302	405.0
2021-05-27	ACTV	ETF	38.6	38.69	38.57	38.6036	6407.0
2021-05-27	ACTX	ETF	3.38	3.38	3.38	3.38	180.0
2021-05-27	ACVF	ETF	31.35	31.57	31.29	31.292	9000.0
2021-05-27	ACWF	ETF	38.32	38.42	38.29	38.3774	11942.0
2021-05-27	ACWI	ETF	100.47	100.61	100.3	100.35	2723700.0
2021-05-27	ACWV	ETF	103.12	103.35	102.98	103.06	100500.0
2021-05-27	ACWX	ETF	58.17	58.26	58.03	58.13	1794744.0
2021-05-27	ADFI	ETF	9.7	9.72	9.66	9.71	17300.0
2021-05-27	ADIV	ETF	18.9	19.05	18.9	19.05	1800.0
2021-05-27	ADME	ETF	38.835	38.858	38.719	38.77	13300.0
2021-05-27	ADRE	ETF	55.89	56.067	55.66	56.067	4904.0
2021-05-27	AESR	ETF	13.34	13.34	13.29	13.311	40600.0
2021-05-27	AFIF	ETF	9.69	9.71	9.69	9.7	53196.0
2021-05-27	AFK	ETF	22.56	22.59	22.3601	22.39	95709.0
2021-05-27	AFLG	ETF	25.13	25.13	25.099	25.099	2100.0
2021-05-27	AFMC	ETF	25.513	25.513	25.513	25.513	600.0
2021-05-27	AFTY	ETF	24.63	24.63	24.55	24.594	400.0
2021-05-27	AGG	ETF	114.61	114.62	114.45	114.55	5072300.0
2021-05-27	AGGY	ETF	51.68	51.729	51.63	51.72	81900.0
2021-05-27	AGNG	ETF	29.18	29.18	29.071	29.113	2300.0
2021-05-27	AGOX	ETF	25.685	25.76	25.67	25.751	7800.0
2021-05-27	AGQ	ETF	52.29	53.06	51.67	53.0	449500.0
2021-05-27	AGZ	ETF	118.32	118.33	118.22	118.27	31042.0
2021-05-27	AGZD	ETF	23.48	23.48	23.445	23.47	125000.0
2021-05-27	AIA	ETF	91.01	91.01	90.54	90.82	31687.0
2021-05-27	AIEQ	ETF	37.82	38.02	37.56	38.02	22100.0
2021-05-27	AIQ	ETF	28.83	28.89	28.7	28.76	30587.0
2021-05-27	AIRR	ETF	41.36	41.68	41.36	41.59	38700.0
2021-05-27	AIVI	ETF	44.33	44.33	44.22	44.27	4200.0
2021-05-27	ALTL	ETF	41.3	41.4	41.2	41.21	19957.0
2021-05-27	ALTY	ETF	13.57	13.57	13.43	13.48	21600.0
2021-05-27	AMJ	ETF	18.8	18.995	18.68	18.78	240181.0
2021-05-27	AMLP	ETF	34.78	34.98	34.3	34.54	1912600.0
2021-05-27	AMNA	ETF	33.1158	33.1158	33.1158	33.1158	0.0
2021-05-27	AMND	ETF	35.36	35.36	35.1229	35.1229	301.0
2021-05-27	AMOM	ETF	35.03	35.27	35.02	35.173	18600.0

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

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