PREVIEW / etf_daily / 2021-08-06

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-06.parquet
  size:    91 KB
  rows:    2,426

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-08-06	SPY	ETF	442.1	442.94	441.8	442.49	46930000.0
2021-08-06	QQQ	ETF	368.37	369.37	366.905	368.05	33332107.0
2021-08-06	IWM	ETF	223.75	225.21	222.14	223.39	24429200.0
2021-08-06	DIA	ETF	351.62	352.49	351.46	352.09	2123700.0
2021-08-06	GLD	ETF	165.84	165.93	164.55	164.64	13547600.0
2021-08-06	TLT	ETF	148.32	148.76	147.69	147.78	21144300.0
2021-08-06	AAA	ETF	25.0	25.01	25.0	25.01	461.0
2021-08-06	AAAU	ETF	17.64	17.64	17.49	17.5	420900.0
2021-08-06	AADR	ETF	68.21	68.43	68.21	68.43	3700.0
2021-08-06	AAXJ	ETF	88.73	88.73	87.95	88.17	1312400.0
2021-08-06	ABEQ	ETF	27.786	27.786	27.786	27.786	1000.0
2021-08-06	ACES	ETF	72.15	72.15	70.5	70.71	43600.0
2021-08-06	ACIO	ETF	30.826	30.884	30.82	30.84	49300.0
2021-08-06	ACSI	ETF	51.1	51.1	50.9801	51.0035	1844.0
2021-08-06	ACTV	ETF	38.4	38.62	38.4	38.4881	5611.0
2021-08-06	ACVF	ETF	33.02	33.02	32.772	32.835	1400.0
2021-08-06	ACWF	ETF	38.58	38.5874	38.5012	38.57	8830.0
2021-08-06	ACWI	ETF	103.07	103.2	102.85	102.95	3360000.0
2021-08-06	ACWV	ETF	105.02	105.21	104.96	105.08	218600.0
2021-08-06	ACWX	ETF	57.23	57.245	57.0	57.09	422947.0
2021-08-06	ADFI	ETF	9.75	9.76	9.74	9.742	80800.0
2021-08-06	ADIV	ETF	18.2	18.217	18.2	18.217	500.0
2021-08-06	ADME	ETF	40.766	40.8	40.72	40.762	46700.0
2021-08-06	ADRE	ETF	53.47	53.59	52.952	53.17	9979.0
2021-08-06	AEMB	ETF	49.806	49.806	49.806	49.806	100.0
2021-08-06	AESR	ETF	14.01	14.038	14.01	14.038	1500.0
2021-08-06	AFIF	ETF	9.6825	9.6825	9.669	9.669	11069.0
2021-08-06	AFK	ETF	21.69	21.69	21.45	21.5898	6935.0
2021-08-06	AFLG	ETF	26.22	26.22	26.175	26.175	400.0
2021-08-06	AFMC	ETF	25.711	25.711	25.711	25.711	100.0
2021-08-06	AFSM	ETF	26.327	26.327	26.327	26.327	800.0
2021-08-06	AFTY	ETF	20.53	20.53	20.44	20.44	2500.0
2021-08-06	AGG	ETF	115.93	116.02	115.78	115.79	3812000.0
2021-08-06	AGGY	ETF	52.7	52.72	52.605	52.61	51800.0
2021-08-06	AGNG	ETF	30.94	30.94	30.455	30.57	4400.0
2021-08-06	AGOV	ETF	100.26	100.26	100.26	100.26	50.0
2021-08-06	AGOX	ETF	26.41	26.43	26.34	26.387	26800.0
2021-08-06	AGQ	ETF	39.93	39.93	38.98	39.34	1889300.0
2021-08-06	AGZ	ETF	118.91	119.02	118.91	118.98	18299.0
2021-08-06	AGZD	ETF	23.485	23.485	23.465	23.475	54400.0
2021-08-06	AIA	ETF	84.78	84.78	83.8217	84.11	156092.0
2021-08-06	AIEQ	ETF	41.9	42.0	41.675	41.7	6600.0
2021-08-06	AIQ	ETF	30.96	31.04	30.83	30.87	8786.0
2021-08-06	AIRR	ETF	41.87	41.95	41.617	41.72	11800.0
2021-08-06	AIVI	ETF	43.64	43.64	43.59	43.61	3800.0
2021-08-06	ALTL	ETF	43.25	43.25	42.8473	42.88	20327.0
2021-08-06	ALTY	ETF	13.69	13.69	13.61	13.641	17000.0
2021-08-06	AMJ	ETF	17.79	17.91	17.69	17.76	490896.0
2021-08-06	AMLP	ETF	32.79	33.03	32.54	32.56	2702800.0
2021-08-06	AMNA	ETF	31.968	31.968	31.968	31.968	30.0

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

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