PREVIEW / etf_daily / 2021-07-06

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-06.parquet
  size:    90 KB
  rows:    2,406

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-07-06	SPY	ETF	433.78	434.01	430.01	432.93	68710400.0
2021-07-06	QQQ	ETF	359.26	360.48	356.49	360.19	38842397.0
2021-07-06	IWM	ETF	229.36	229.46	223.87	225.86	27771300.0
2021-07-06	DIA	ETF	347.75	348.11	343.6	345.82	3910600.0
2021-07-06	GLD	ETF	169.27	169.65	167.54	168.12	7932100.0
2021-07-06	TLT	ETF	145.72	146.99	145.72	146.74	20037200.0
2021-07-06	AAA	ETF	25.005	25.005	25.005	25.005	493.0
2021-07-06	AAAU	ETF	17.99	18.03	17.81	17.87	510300.0
2021-07-06	AADR	ETF	65.77	65.77	65.27	65.27	1200.0
2021-07-06	AAXJ	ETF	92.87	92.87	91.94	92.26	811600.0
2021-07-06	ABEQ	ETF	27.29	27.42	27.29	27.42	1700.0
2021-07-06	ACES	ETF	75.02	75.314	74.24	75.0	40300.0
2021-07-06	ACIO	ETF	30.48	30.57	30.411	30.56	214700.0
2021-07-06	ACSI	ETF	50.6379	50.6379	50.6379	50.6379	211.0
2021-07-06	ACTV	ETF	39.2	39.2	38.22	38.48	5835.0
2021-07-06	ACVF	ETF	32.5	32.5	31.95	32.124	7800.0
2021-07-06	ACWF	ETF	38.19	38.19	37.765	37.9546	30820.0
2021-07-06	ACWI	ETF	102.06	102.06	101.06	101.65	1564800.0
2021-07-06	ACWV	ETF	103.73	103.73	103.07	103.52	145300.0
2021-07-06	ACWX	ETF	57.47	57.47	56.85	57.06	893285.0
2021-07-06	ADFI	ETF	9.77	9.77	9.74	9.76	1700.0
2021-07-06	ADIV	ETF	18.57	18.57	18.45	18.5	1900.0
2021-07-06	ADME	ETF	40.4	40.4	40.06	40.277	67800.0
2021-07-06	ADRE	ETF	56.26	56.26	55.4	55.8352	11912.0
2021-07-06	AEMB	ETF	49.98	49.98	49.98	49.98	100.0
2021-07-06	AESR	ETF	13.85	13.85	13.66	13.74	2500.0
2021-07-06	AFIF	ETF	9.75	9.7649	9.7477	9.7649	9345.0
2021-07-06	AFK	ETF	21.94	22.0221	21.74	21.76	51800.0
2021-07-06	AFLG	ETF	25.514	25.57	25.514	25.548	5600.0
2021-07-06	AFMC	ETF	25.23	25.23	25.195	25.195	2700.0
2021-07-06	AFSM	ETF	26.21	26.21	26.16	26.16	1800.0
2021-07-06	AFTY	ETF	22.42	22.45	22.331	22.353	700.0
2021-07-06	AGG	ETF	115.51	115.83	115.51	115.73	7372900.0
2021-07-06	AGGY	ETF	52.38	52.53	52.37	52.53	79900.0
2021-07-06	AGNG	ETF	31.0	31.0	30.535	30.54	3700.0
2021-07-06	AGOX	ETF	26.57	26.57	25.916	26.041	18800.0
2021-07-06	AGQ	ETF	47.83	47.92	45.62	46.15	1130800.0
2021-07-06	AGZ	ETF	118.4	118.62	118.4	118.62	28947.0
2021-07-06	AGZD	ETF	23.57	23.57	23.505	23.53	78600.0
2021-07-06	AIA	ETF	89.38	89.61	88.7008	89.1	216696.0
2021-07-06	AIEQ	ETF	41.41	41.604	41.251	41.589	20400.0
2021-07-06	AIQ	ETF	30.74	30.85	30.52	30.79	29003.0
2021-07-06	AIRR	ETF	40.67	40.67	39.43	40.05	64800.0
2021-07-06	AIVI	ETF	43.39	43.39	42.99	43.19	1400.0
2021-07-06	ALTL	ETF	41.61	41.76	41.39	41.64	8433.0
2021-07-06	ALTY	ETF	13.6	13.64	13.53	13.61	33700.0
2021-07-06	AMJ	ETF	19.99	19.99	19.39	19.6	943282.0
2021-07-06	AMLP	ETF	37.04	37.1	35.92	36.47	2194700.0
2021-07-06	AMNA	ETF	34.1974	34.1974	34.1974	34.1974	56.0
2021-07-06	AMND	ETF	36.2688	36.2688	36.2688	36.2688	74.0

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

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