PREVIEW / etf_daily / 2021-02-02

all etf daily files

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

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-02	SPY	ETF	379.65	383.22	376.32	381.55	64450700.0
2021-02-02	QQQ	ETF	325.48	328.87	325.31	327.68	33930844.0
2021-02-02	IWM	ETF	213.15	214.05	210.89	213.61	22773100.0
2021-02-02	DIA	ETF	304.54	308.43	304.52	306.82	3090500.0
2021-02-02	GLD	ETF	172.49	172.53	171.51	172.11	7221700.0
2021-02-02	TLT	ETF	150.74	151.09	150.52	151.02	9177500.0
2021-02-02	AAA	ETF	25.13	25.13	25.13	25.13	10.0
2021-02-02	AAAU	ETF	18.31	18.32	18.22	18.27	353500.0
2021-02-02	AADR	ETF	62.63	62.94	62.61	62.92	4000.0
2021-02-02	AAXJ	ETF	97.67	97.73	97.14	97.5	1417500.0
2021-02-02	ABEQ	ETF	25.74	25.74	25.47	25.565	3200.0
2021-02-02	ACES	ETF	95.56	95.92	93.245	94.84	480400.0
2021-02-02	ACIO	ETF	27.55	27.78	27.55	27.67	61000.0
2021-02-02	ACSI	ETF	44.06	44.06	43.9271	43.9271	263.0
2021-02-02	ACTV	ETF	33.8557	33.9598	33.85	33.85	5897.0
2021-02-02	ACTX	ETF	4.25	4.25	4.25	4.25	304.0
2021-02-02	ACVF	ETF	28.0	28.3	28.0	28.275	2900.0
2021-02-02	ACWF	ETF	34.73	34.895	34.73	34.85	11491.0
2021-02-02	ACWI	ETF	92.79	93.4	92.76	93.15	2432600.0
2021-02-02	ACWV	ETF	96.62	97.1	96.33	96.78	256900.0
2021-02-02	ACWX	ETF	54.54	54.805	54.42	54.73	740300.0
2021-02-02	ADFI	ETF	9.88	9.88	9.88	9.88	100.0
2021-02-02	ADME	ETF	35.99	36.37	35.99	36.2	72300.0
2021-02-02	ADRE	ETF	62.33	62.33	61.4326	61.65	19987.0
2021-02-02	AESR	ETF	12.11	12.154	12.11	12.114	600.0
2021-02-02	AFIF	ETF	9.74	9.76	9.7371	9.745	38242.0
2021-02-02	AFK	ETF	20.73	21.0	20.67	20.99	40439.0
2021-02-02	AFLG	ETF	22.94	22.94	22.889	22.889	300.0
2021-02-02	AFSM	ETF	24.006	24.159	23.96	24.159	600.0
2021-02-02	AFTY	ETF	24.53	24.67	24.53	24.63	4700.0
2021-02-02	AGG	ETF	116.99	117.09	116.97	117.05	7323400.0
2021-02-02	AGGY	ETF	53.21	53.23	53.18	53.19	76600.0
2021-02-02	AGNG	ETF	28.74	28.93	28.707	28.88	3200.0
2021-02-02	AGQ	ETF	53.67	53.69	48.5	49.18	4108600.0
2021-02-02	AGZ	ETF	119.29	119.38	119.29	119.31	33336.0
2021-02-02	AGZD	ETF	23.635	23.665	23.635	23.665	7000.0
2021-02-02	AIA	ETF	97.83	98.4	97.59	98.23	513255.0
2021-02-02	AIEQ	ETF	39.52	39.61	39.03	39.61	94100.0
2021-02-02	AIQ	ETF	28.73	29.02	28.65	29.0	115485.0
2021-02-02	AIRR	ETF	35.59	36.175	35.535	36.17	3100.0
2021-02-02	AIVI	ETF	41.18	41.42	41.18	41.42	5900.0
2021-02-02	ALTL	ETF	32.84	33.08	32.7383	32.91	14269.0
2021-02-02	ALTY	ETF	12.0	12.14	12.0	12.05	21700.0
2021-02-02	AMJ	ETF	14.96	15.05	14.78	14.87	971773.0
2021-02-02	AMLP	ETF	27.49	27.82	27.28	27.36	2069000.0
2021-02-02	AMNA	ETF	26.5123	26.5123	26.5123	26.5123	0.0
2021-02-02	AMND	ETF	28.136	28.136	28.136	28.136	0.0
2021-02-02	AMOM	ETF	32.931	33.2	32.931	33.176	1600.0
2021-02-02	AMPS	ETF	10.49	10.8699	10.22	10.37	25740.0
2021-02-02	AMTR	ETF	30.4654	30.4654	30.4654	30.4654	3.0

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

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