PREVIEW / etf_daily / 2021-04-09

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-09.parquet
  size:    89 KB
  rows:    2,324

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-04-09	SPY	ETF	408.39	411.67	408.26	411.49	61104600.0
2021-04-09	QQQ	ETF	333.68	337.32	332.92	337.11	36664892.0
2021-04-09	IWM	ETF	222.49	223.09	221.24	222.59	23267400.0
2021-04-09	DIA	ETF	335.72	338.08	335.36	337.86	3034700.0
2021-04-09	GLD	ETF	162.75	163.66	162.48	163.27	6657900.0
2021-04-09	TLT	ETF	137.5	138.19	137.09	137.51	8717800.0
2021-04-09	AAA	ETF	25.06	25.06	25.05	25.05	103.0
2021-04-09	AAAU	ETF	17.3	17.38	17.26	17.34	828100.0
2021-04-09	AADR	ETF	63.32	63.78	63.32	63.7	3500.0
2021-04-09	AAXJ	ETF	93.04	93.25	92.83	93.25	1276500.0
2021-04-09	ABEQ	ETF	26.655	26.764	26.655	26.764	800.0
2021-04-09	ACES	ETF	76.0	76.14	75.12	75.96	87900.0
2021-04-09	ACIO	ETF	29.14	29.23	29.02	29.16	17800.0
2021-04-09	ACSI	ETF	48.1041	48.1041	48.1041	48.1041	248.0
2021-04-09	ACTV	ETF	36.34	36.34	36.11	36.27	3835.0
2021-04-09	ACTX	ETF	4.83	4.83	4.83	4.83	339.0
2021-04-09	ACVF	ETF	30.4	30.56	30.4	30.56	5700.0
2021-04-09	ACWF	ETF	37.28	37.53	37.28	37.53	13402.0
2021-04-09	ACWI	ETF	97.66	98.23	97.6	98.23	1636300.0
2021-04-09	ACWV	ETF	99.66	100.09	99.6	99.91	1364000.0
2021-04-09	ACWX	ETF	56.05	56.39	55.88	56.39	1777034.0
2021-04-09	ADFI	ETF	9.674	9.68	9.674	9.676	1200.0
2021-04-09	ADIV	ETF	18.74	18.74	18.715	18.715	200.0
2021-04-09	ADME	ETF	37.71	38.03	37.71	38.03	11100.0
2021-04-09	ADRE	ETF	56.35	56.39	56.05	56.39	13354.0
2021-04-09	AESR	ETF	12.96	13.068	12.96	13.068	8900.0
2021-04-09	AFIF	ETF	9.71	9.72	9.69	9.7151	27086.0
2021-04-09	AFK	ETF	21.24	21.42	21.24	21.42	6792.0
2021-04-09	AFLG	ETF	24.51	24.687	24.506	24.687	100200.0
2021-04-09	AFMC	ETF	24.68	24.766	24.68	24.766	200.0
2021-04-09	AFSM	ETF	25.608	25.608	25.608	25.608	100.0
2021-04-09	AFTY	ETF	22.23	22.23	22.19	22.23	2400.0
2021-04-09	AGG	ETF	114.11	114.33	114.04	114.18	7467100.0
2021-04-09	AGGY	ETF	51.6	51.66	51.535	51.6	78700.0
2021-04-09	AGNG	ETF	27.99	28.085	27.93	28.085	2300.0
2021-04-09	AGQ	ETF	43.27	44.08	43.13	43.93	476800.0
2021-04-09	AGZ	ETF	118.0	118.05	117.915	117.95	23849.0
2021-04-09	AGZD	ETF	23.565	23.58	23.525	23.545	30600.0
2021-04-09	AIA	ETF	93.01	93.01	92.55	92.89	115895.0
2021-04-09	AIEQ	ETF	39.2	39.48	39.1	39.48	15900.0
2021-04-09	AIQ	ETF	29.71	29.9	29.56	29.85	52013.0
2021-04-09	AIRR	ETF	40.94	41.405	40.818	41.346	34300.0
2021-04-09	AIVI	ETF	42.84	42.96	42.83	42.96	3600.0
2021-04-09	ALTL	ETF	39.794	39.8704	39.6709	39.8704	22042.0
2021-04-09	ALTY	ETF	12.95	12.99	12.89	12.91	12000.0
2021-04-09	AMJ	ETF	17.05	17.24	16.74	16.8	859970.0
2021-04-09	AMLP	ETF	31.4	31.82	30.84	30.99	4329400.0
2021-04-09	AMNA	ETF	30.1674	30.1674	30.1674	30.1674	0.0
2021-04-09	AMND	ETF	32.1735	32.1735	32.1735	32.1735	37.0
2021-04-09	AMOM	ETF	34.45	34.755	34.45	34.755	3400.0

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

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