PREVIEW / etf_daily / 2021-04-29

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-29.parquet
  size:    88 KB
  rows:    2,331

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-29	SPY	ETF	420.32	420.72	416.44	420.06	78544300.0
2021-04-29	QQQ	ETF	342.37	342.8	336.9001	340.22	37708884.0
2021-04-29	IWM	ETF	230.85	230.95	225.79	227.99	25500300.0
2021-04-29	DIA	ETF	339.89	340.86	337.37	340.57	3688400.0
2021-04-29	GLD	ETF	165.58	166.26	164.47	166.22	9067600.0
2021-04-29	TLT	ETF	137.45	138.36	137.13	138.32	17178200.0
2021-04-29	AAA	ETF	25.05	25.05	25.04	25.04	564.0
2021-04-29	AAAU	ETF	17.6	17.67	17.49	17.67	562700.0
2021-04-29	AADR	ETF	66.1	66.41	66.1	66.41	1200.0
2021-04-29	AAXJ	ETF	95.81	95.81	94.43	95.21	750800.0
2021-04-29	ABEQ	ETF	27.43	27.487	27.395	27.487	400.0
2021-04-29	ACES	ETF	76.47	76.5	73.922	74.74	65400.0
2021-04-29	ACIO	ETF	29.92	29.97	29.68	29.86	19000.0
2021-04-29	ACSI	ETF	49.07	49.07	48.845	49.062	422.0
2021-04-29	ACTV	ETF	37.85	37.85	37.665	37.6869	3078.0
2021-04-29	ACVF	ETF	31.22	31.36	30.95	31.16	11500.0
2021-04-29	ACWF	ETF	38.03	38.11	37.83	38.09	6710.0
2021-04-29	ACWI	ETF	100.47	100.49	99.37	100.12	4661200.0
2021-04-29	ACWV	ETF	101.67	101.71	101.19	101.65	270100.0
2021-04-29	ACWX	ETF	57.58	57.6482	57.01	57.36	992729.0
2021-04-29	ADFI	ETF	9.675	9.7	9.6	9.673	13300.0
2021-04-29	ADIV	ETF	19.025	19.025	19.025	19.025	100.0
2021-04-29	ADME	ETF	38.893	39.023	38.81	39.02	24600.0
2021-04-29	ADRE	ETF	58.87	58.87	57.5	57.89	12924.0
2021-04-29	AESR	ETF	13.32	13.35	13.271	13.323	18600.0
2021-04-29	AFIF	ETF	9.51	9.6899	9.51	9.65	37195.0
2021-04-29	AFK	ETF	22.09	22.09	21.88	21.94	9180.0
2021-04-29	AFLG	ETF	24.919	25.083	24.907	25.083	1900.0
2021-04-29	AFMC	ETF	25.607	25.607	25.607	25.607	2000.0
2021-04-29	AFSM	ETF	26.199	26.199	26.199	26.199	1600.0
2021-04-29	AFTY	ETF	23.16	23.16	22.99	23.07	1100.0
2021-04-29	AGG	ETF	114.14	114.37	114.09	114.37	6254100.0
2021-04-29	AGGY	ETF	51.57	51.62	51.49	51.62	107600.0
2021-04-29	AGNG	ETF	29.26	29.26	29.08	29.165	900.0
2021-04-29	AGQ	ETF	46.64	46.8	45.2	46.78	828000.0
2021-04-29	AGZ	ETF	117.96	118.0146	117.89	117.99	59206.0
2021-04-29	AGZD	ETF	23.49	23.575	23.49	23.545	9800.0
2021-04-29	AIA	ETF	94.76	94.76	93.31	94.15	276460.0
2021-04-29	AIEQ	ETF	40.06	40.06	39.081	39.45	12400.0
2021-04-29	AIQ	ETF	30.09	30.09	29.565	29.83	23998.0
2021-04-29	AIRR	ETF	42.18	42.185	41.741	42.105	35000.0
2021-04-29	AIVI	ETF	43.64	43.64	43.34	43.63	3500.0
2021-04-29	ALTL	ETF	41.56	41.56	41.0	41.2273	13446.0
2021-04-29	ALTY	ETF	13.34	13.43	13.316	13.39	13700.0
2021-04-29	AMJ	ETF	18.0	18.23	17.93	18.16	353788.0
2021-04-29	AMLP	ETF	33.51	33.72	33.14	33.66	2919200.0
2021-04-29	AMNA	ETF	31.4572	31.4572	31.4572	31.4572	1.0
2021-04-29	AMND	ETF	33.5429	33.5429	33.5429	33.5429	11.0
2021-04-29	AMOM	ETF	35.58	35.58	35.33	35.49	25600.0
2021-04-29	AMPS	ETF	9.96	9.96	9.94	9.94	5449.0

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

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