PREVIEW / etf_daily / 2021-08-09

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-09.parquet
  size:    92 KB
  rows:    2,437

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-09	SPY	ETF	442.46	442.8	441.31	442.13	41222600.0
2021-08-09	QQQ	ETF	368.52	369.27	367.39	368.73	25960245.0
2021-08-09	IWM	ETF	222.92	223.19	221.21	222.16	17225600.0
2021-08-09	DIA	ETF	351.6	352.06	350.55	351.15	2322500.0
2021-08-09	GLD	ETF	163.01	163.29	161.26	161.72	11547000.0
2021-08-09	TLT	ETF	148.15	148.56	147.23	147.25	12942400.0
2021-08-09	AAA	ETF	25.0	25.01	25.0	25.01	1312.0
2021-08-09	AAAU	ETF	17.34	17.36	17.16	17.2	379300.0
2021-08-09	AADR	ETF	68.43	68.43	68.43	68.43	600.0
2021-08-09	AAXJ	ETF	88.48	88.95	88.13	88.56	1080000.0
2021-08-09	ABEQ	ETF	27.73	27.753	27.72	27.753	1200.0
2021-08-09	ACES	ETF	70.79	72.27	70.6	71.91	38900.0
2021-08-09	ACIO	ETF	30.73	30.803	30.73	30.73	47500.0
2021-08-09	ACSI	ETF	51.0334	51.0334	51.0334	51.0334	174.0
2021-08-09	ACTV	ETF	38.27	38.4	38.16	38.2172	6782.0
2021-08-09	ACTX	ETF	1.66	1.94	1.45	1.94	4331.0
2021-08-09	ACVF	ETF	33.03	33.03	32.77	32.78	2700.0
2021-08-09	ACWF	ETF	38.5576	38.61	38.5576	38.5697	2720.0
2021-08-09	ACWI	ETF	103.06	103.15	102.79	103.0	805700.0
2021-08-09	ACWV	ETF	105.08	105.3	105.08	105.11	79200.0
2021-08-09	ACWX	ETF	57.15	57.22	57.05	57.12	278801.0
2021-08-09	ADFI	ETF	9.73	9.73	9.71	9.725	8100.0
2021-08-09	ADIV	ETF	18.299	18.299	18.285	18.285	500.0
2021-08-09	ADME	ETF	40.76	40.76	40.645	40.68	45200.0
2021-08-09	ADRE	ETF	52.99	53.4204	52.88	53.2862	10914.0
2021-08-09	AEMB	ETF	49.67	49.67	49.67	49.67	100.0
2021-08-09	AESR	ETF	13.99	14.04	13.98	14.015	28000.0
2021-08-09	AFIF	ETF	9.69	9.7	9.66	9.6847	56389.0
2021-08-09	AFK	ETF	21.72	21.72	21.521	21.5638	5462.0
2021-08-09	AFLG	ETF	26.167	26.167	26.167	26.167	100.0
2021-08-09	AFMC	ETF	25.606	25.606	25.606	25.606	100.0
2021-08-09	AFSM	ETF	26.32	26.41	26.276	26.276	3100.0
2021-08-09	AFTY	ETF	20.92	20.92	20.81	20.85	1100.0
2021-08-09	AGG	ETF	115.89	115.96	115.58	115.58	5298600.0
2021-08-09	AGGY	ETF	52.57	52.607	52.46	52.47	45600.0
2021-08-09	AGNG	ETF	30.6	30.6	30.47	30.49	2400.0
2021-08-09	AGOV	ETF	99.71	99.9847	99.71	99.9847	382.0
2021-08-09	AGOX	ETF	26.31	26.44	26.27	26.366	77800.0
2021-08-09	AGQ	ETF	37.78	38.05	35.82	36.54	1859400.0
2021-08-09	AGZ	ETF	119.07	119.08	118.85	118.9	20779.0
2021-08-09	AGZD	ETF	23.5	23.515	23.475	23.485	30800.0
2021-08-09	AIA	ETF	84.63	85.19	84.58	84.94	111115.0
2021-08-09	AIEQ	ETF	41.76	42.0	41.482	41.87	15300.0
2021-08-09	AIQ	ETF	30.95	31.0	30.84	30.94	8946.0
2021-08-09	AIRR	ETF	41.435	41.637	41.35	41.412	13800.0
2021-08-09	AIVI	ETF	43.62	43.68	43.55	43.6	7500.0
2021-08-09	ALTL	ETF	42.79	42.96	42.75	42.88	33198.0
2021-08-09	ALTY	ETF	13.68	13.68	13.58	13.62	16700.0
2021-08-09	AMJ	ETF	17.64	17.68	17.415	17.68	491447.0
2021-08-09	AMLP	ETF	32.37	32.48	32.03	32.35	2659100.0

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

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