PREVIEW / etf_daily / 2021-10-28

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-28.parquet
  size:    95 KB
  rows:    2,549

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-10-28	SPY	ETF	455.46	458.4	455.45	458.32	51437900.0
2021-10-28	QQQ	ETF	381.95	384.48	381.155	384.22	38007005.0
2021-10-28	IWM	ETF	224.8	228.26	224.77	228.11	22890600.0
2021-10-28	DIA	ETF	355.75	357.38	355.75	357.3	2490500.0
2021-10-28	GLD	ETF	168.98	169.25	167.53	168.08	7000700.0
2021-10-28	TLT	ETF	147.79	148.33	146.84	147.24	17497600.0
2021-10-28	AAA	ETF	25.0	25.0	25.0	25.0	1106.0
2021-10-28	AAAU	ETF	17.96	18.0	17.82	17.87	183600.0
2021-10-28	AADR	ETF	64.82	65.28	64.82	65.19	2900.0
2021-10-28	AAXJ	ETF	86.86	87.45	86.75	87.41	502700.0
2021-10-28	ABEQ	ETF	27.64	27.72	27.64	27.714	1200.0
2021-10-28	ACES	ETF	75.44	77.92	75.09	77.88	78200.0
2021-10-28	ACIO	ETF	31.6	31.61	31.48	31.6	47000.0
2021-10-28	ACSI	ETF	52.0498	52.0498	52.0498	52.0498	99.0
2021-10-28	ACT	ETF	23.04	23.25	22.91	23.06	104367.0
2021-10-28	ACTV	ETF	38.46	38.59	38.395	38.5896	8114.0
2021-10-28	ACTX	ETF	1.0	1.0	0.9	0.9	601.0
2021-10-28	ACVF	ETF	34.01	34.19	34.01	34.19	5900.0
2021-10-28	ACWF	ETF	37.87	38.118	37.87	38.06	15353.0
2021-10-28	ACWI	ETF	104.87	105.6	104.87	105.6	2209200.0
2021-10-28	ACWV	ETF	105.25	105.88	105.25	105.86	112100.0
2021-10-28	ACWX	ETF	57.22	57.59	57.22	57.58	540907.0
2021-10-28	ADFI	ETF	9.65	9.68	9.65	9.665	700.0
2021-10-28	ADIV	ETF	17.61	17.709	17.54	17.67	1700.0
2021-10-28	ADME	ETF	41.55	41.8	41.55	41.754	17400.0
2021-10-28	ADRE	ETF	50.3	50.6884	50.1302	50.58	8851.0
2021-10-28	AESR	ETF	14.42	14.55	14.42	14.54	39300.0
2021-10-28	AFIF	ETF	9.62	9.63	9.61	9.62	7093.0
2021-10-28	AFK	ETF	21.37	21.738	21.37	21.5944	4204.0
2021-10-28	AFLG	ETF	26.813	26.813	26.813	26.813	100.0
2021-10-28	AFMC	ETF	25.953	25.953	25.953	25.953	100.0
2021-10-28	AFSM	ETF	26.86	26.986	26.86	26.986	100.0
2021-10-28	AFTY	ETF	21.4	21.4	21.4	21.4	4200.0
2021-10-28	AGG	ETF	114.71	114.83	114.57	114.67	5916000.0
2021-10-28	AGGY	ETF	51.97	51.99	51.867	51.9	69300.0
2021-10-28	AGNG	ETF	29.43	29.76	29.43	29.76	2900.0
2021-10-28	AGOV	ETF	99.08	99.15	99.07	99.07	2988.0
2021-10-28	AGOX	ETF	27.17	27.17	26.993	27.15	75800.0
2021-10-28	AGQ	ETF	38.11	38.36	37.49	37.73	699200.0
2021-10-28	AGZ	ETF	117.97	118.09	117.94	117.97	25926.0
2021-10-28	AGZD	ETF	23.455	23.46	23.41	23.45	38800.0
2021-10-28	AIA	ETF	81.31	81.68	80.98	81.67	33604.0
2021-10-28	AIEQ	ETF	42.92	43.197	42.838	43.197	6200.0
2021-10-28	AIQ	ETF	31.43	31.71	31.41	31.71	20178.0
2021-10-28	AIRR	ETF	42.79	43.79	42.79	43.79	16900.0
2021-10-28	AIVI	ETF	41.51	41.69	41.51	41.68	3000.0
2021-10-28	ALTL	ETF	43.01	43.41	42.9675	43.41	53403.0
2021-10-28	ALTY	ETF	13.705	13.72	13.65	13.72	48300.0
2021-10-28	AMJ	ETF	19.43	19.465	19.1801	19.37	456375.0
2021-10-28	AMLP	ETF	35.73	35.92	35.36	35.59	2294000.0

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

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