PREVIEW / etf_daily / 2021-02-09

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-09.parquet
  size:    85 KB
  rows:    2,255

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-02-09	SPY	ETF	389.61	390.89	389.17	390.25	35551100.0
2021-02-09	QQQ	ETF	332.62	334.81	332.61	333.51	17597478.0
2021-02-09	IWM	ETF	227.13	229.62	226.31	228.38	19510900.0
2021-02-09	DIA	ETF	313.26	314.5	312.57	313.92	1798700.0
2021-02-09	GLD	ETF	172.57	173.03	171.75	172.08	5131800.0
2021-02-09	TLT	ETF	149.22	149.67	148.66	148.79	5218300.0
2021-02-09	AAA	ETF	25.13	25.13	25.13	25.13	1035.0
2021-02-09	AAAU	ETF	18.32	18.38	18.25	18.27	582300.0
2021-02-09	AADR	ETF	65.91	66.11	65.77	65.85	6000.0
2021-02-09	AAXJ	ETF	99.28	100.18	99.08	100.08	802200.0
2021-02-09	ABEQ	ETF	26.008	26.14	25.95	26.13	3400.0
2021-02-09	ACES	ETF	99.7	101.1	99.68	100.32	131600.0
2021-02-09	ACIO	ETF	27.915	28.01	27.915	27.94	62700.0
2021-02-09	ACSI	ETF	45.39	45.39	45.15	45.2299	1204.0
2021-02-09	ACTV	ETF	35.14	35.43	35.14	35.2455	757.0
2021-02-09	ACTX	ETF	4.66	4.7	4.66	4.7	1183.0
2021-02-09	ACVF	ETF	28.97	28.99	28.89	28.926	6700.0
2021-02-09	ACWF	ETF	35.451	35.69	35.451	35.64	6275.0
2021-02-09	ACWI	ETF	95.1	95.59	95.04	95.39	4538000.0
2021-02-09	ACWV	ETF	97.5	97.98	97.5	97.87	193700.0
2021-02-09	ACWX	ETF	55.71	56.1211	55.71	56.06	342413.0
2021-02-09	ADFI	ETF	9.885	9.885	9.885	9.885	100.0
2021-02-09	ADME	ETF	36.85	36.97	36.7	36.71	34400.0
2021-02-09	ADRE	ETF	63.79	64.81	63.79	64.2965	81350.0
2021-02-09	AESR	ETF	12.36	12.38	12.36	12.375	1500.0
2021-02-09	AFIF	ETF	9.75	9.7756	9.75	9.7609	17192.0
2021-02-09	AFK	ETF	21.54	21.6995	21.345	21.68	23026.0
2021-02-09	AFLG	ETF	23.455	23.455	23.455	23.455	100.0
2021-02-09	AFSM	ETF	25.801	25.801	25.801	25.801	100.0
2021-02-09	AFTY	ETF	25.89	26.2	25.89	26.159	13200.0
2021-02-09	AGG	ETF	116.94	116.97	116.82	116.88	4533400.0
2021-02-09	AGGY	ETF	53.08	53.13	53.04	53.056	317400.0
2021-02-09	AGNG	ETF	29.32	29.35	29.275	29.278	6200.0
2021-02-09	AGQ	ETF	53.1	53.3	51.39	51.97	871700.0
2021-02-09	AGZ	ETF	119.21	119.32	119.2	119.21	35611.0
2021-02-09	AGZD	ETF	23.66	23.715	23.66	23.66	4800.0
2021-02-09	AIA	ETF	98.87	99.82	98.87	99.7	398240.0
2021-02-09	AIEQ	ETF	41.55	41.99	41.36	41.68	69600.0
2021-02-09	AIQ	ETF	29.81	30.0899	29.81	29.985	53900.0
2021-02-09	AIRR	ETF	37.75	37.986	37.559	37.754	26100.0
2021-02-09	AIVI	ETF	41.85	41.99	41.8	41.94	4700.0
2021-02-09	ALTL	ETF	34.95	35.22	34.95	35.078	7088.0
2021-02-09	ALTY	ETF	12.3	12.3	12.222	12.24	5700.0
2021-02-09	AMJ	ETF	15.45	15.5	15.25	15.32	421253.0
2021-02-09	AMLP	ETF	28.61	28.61	28.16	28.38	1805100.0
2021-02-09	AMNA	ETF	27.4452	27.4452	27.4452	27.4452	4.0
2021-02-09	AMND	ETF	29.0959	29.0959	29.0959	29.0959	0.0
2021-02-09	AMOM	ETF	34.205	34.28	34.205	34.265	1900.0
2021-02-09	AMPS	ETF	10.59	10.96	10.59	10.7	34067.0
2021-02-09	AMTR	ETF	31.54	31.54	31.53	31.5345	200.0

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

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