PREVIEW / etf_daily / 2021-09-27

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-27.parquet
  size:    93 KB
  rows:    2,490

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-09-27	SPY	ETF	442.81	444.05	441.9	442.64	61371100.0
2021-09-27	QQQ	ETF	370.2	371.2516	367.73	370.35	43338079.0
2021-09-27	IWM	ETF	223.62	227.68	223.53	226.44	29743200.0
2021-09-27	DIA	ETF	348.29	350.5	348.17	348.61	3426000.0
2021-09-27	GLD	ETF	163.85	164.36	163.51	163.64	4943000.0
2021-09-27	TLT	ETF	146.06	146.87	145.88	146.37	13464300.0
2021-09-27	AAA	ETF	25.02	25.02	25.01	25.01	805.0
2021-09-27	AAAU	ETF	17.42	17.47	17.39	17.4	131100.0
2021-09-27	AADR	ETF	65.99	65.99	65.51	65.51	1500.0
2021-09-27	AAXJ	ETF	85.82	86.33	85.43	86.15	544300.0
2021-09-27	ABEQ	ETF	27.2	27.3	27.2	27.223	900.0
2021-09-27	ACES	ETF	66.83	69.0	66.52	68.59	76000.0
2021-09-27	ACIO	ETF	30.649	30.67	30.55	30.61	91600.0
2021-09-27	ACSI	ETF	50.7293	50.7293	50.7293	50.7293	18.0
2021-09-27	ACT	ETF	22.22	22.22	21.63	21.79	262693.0
2021-09-27	ACTV	ETF	38.67	38.7783	38.5733	38.5733	3970.0
2021-09-27	ACTX	ETF	0.9499	0.9499	0.785	0.91	3629.0
2021-09-27	ACVF	ETF	33.02	33.025	32.92	32.92	18800.0
2021-09-27	ACWF	ETF	38.01	38.095	37.97	38.0234	19473.0
2021-09-27	ACWI	ETF	102.72	103.06	102.5	102.84	6260400.0
2021-09-27	ACWV	ETF	104.76	105.01	104.41	104.43	110600.0
2021-09-27	ACWX	ETF	56.57	56.8256	56.465	56.77	957633.0
2021-09-27	ADFI	ETF	9.71	9.72	9.71	9.715	1300.0
2021-09-27	ADIV	ETF	17.149	17.149	17.149	17.149	100.0
2021-09-27	ADME	ETF	40.44	40.649	40.44	40.55	17100.0
2021-09-27	ADRE	ETF	48.74	49.5607	48.74	49.37	8128.0
2021-09-27	AEMB	ETF	49.334	49.334	49.334	49.334	100.0
2021-09-27	AESR	ETF	14.04	14.11	14.04	14.09	9200.0
2021-09-27	AFIF	ETF	9.65	9.65	9.64	9.64	8177.0
2021-09-27	AFK	ETF	20.65	20.84	20.64	20.8095	10952.0
2021-09-27	AFLG	ETF	26.23	26.23	26.146	26.146	600.0
2021-09-27	AFMC	ETF	25.746	25.746	25.746	25.746	1400.0
2021-09-27	AFSM	ETF	26.83	26.86	26.726	26.726	300.0
2021-09-27	AFTY	ETF	20.67	20.67	20.67	20.67	6000.0
2021-09-27	AGG	ETF	115.21	115.38	115.19	115.25	5630600.0
2021-09-27	AGGY	ETF	52.21	52.25	52.165	52.22	183500.0
2021-09-27	AGNG	ETF	30.14	30.14	29.722	29.77	25800.0
2021-09-27	AGOV	ETF	99.72	99.72	99.585	99.585	100.0
2021-09-27	AGOX	ETF	26.67	26.67	26.49	26.5	22100.0
2021-09-27	AGQ	ETF	33.53	34.18	33.3	33.55	1012200.0
2021-09-27	AGZ	ETF	118.38	118.51	118.38	118.435	39792.0
2021-09-27	AGZD	ETF	23.47	23.485	23.45	23.47	21400.0
2021-09-27	AIA	ETF	78.87	79.79	78.73	79.61	346604.0
2021-09-27	AIEQ	ETF	42.7	42.946	42.51	42.836	11600.0
2021-09-27	AIQ	ETF	31.27	31.31	31.062	31.22	12045.0
2021-09-27	AIRR	ETF	41.48	42.422	41.48	42.18	16300.0
2021-09-27	AIVI	ETF	41.62	41.63	41.54	41.56	900.0
2021-09-27	ALTL	ETF	42.07	42.255	41.81	41.87	79108.0
2021-09-27	ALTY	ETF	13.44	13.58	13.44	13.54	16200.0
2021-09-27	AMJ	ETF	18.15	18.625	18.11	18.51	512055.0

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

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