PREVIEW / etf_daily / 2021-03-24

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-24.parquet
  size:    87 KB
  rows:    2,296

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-03-24	SPY	ETF	391.0	392.75	387.47	387.52	97588600.0
2021-03-24	QQQ	ETF	318.63	318.67	311.72	311.87	64803729.0
2021-03-24	IWM	ETF	219.86	221.33	212.04	212.04	47270200.0
2021-03-24	DIA	ETF	325.28	327.73	324.08	324.08	6099000.0
2021-03-24	GLD	ETF	162.21	162.89	161.94	162.37	6183700.0
2021-03-24	TLT	ETF	137.06	138.28	136.95	138.23	13863000.0
2021-03-24	AAA	ETF	25.07	25.07	25.06	25.06	622.0
2021-03-24	AAAU	ETF	17.24	17.3	17.2	17.24	722300.0
2021-03-24	AADR	ETF	61.78	61.78	60.41	60.41	8600.0
2021-03-24	AAXJ	ETF	91.78	91.78	90.0	90.01	1461400.0
2021-03-24	ABEQ	ETF	26.11	26.17	26.043	26.043	1600.0
2021-03-24	ACES	ETF	75.2	75.2	71.7	71.79	77600.0
2021-03-24	ACIO	ETF	28.01	28.06	27.895	27.9	15600.0
2021-03-24	ACSI	ETF	45.0866	45.0866	45.0866	45.0866	238.0
2021-03-24	ACTV	ETF	35.5799	35.7077	34.8274	34.8274	8135.0
2021-03-24	ACTX	ETF	3.86	3.86	3.86	3.86	160.0
2021-03-24	ACVF	ETF	29.3	29.3	29.026	29.026	1700.0
2021-03-24	ACWF	ETF	35.66	35.88	35.45	35.45	12619.0
2021-03-24	ACWI	ETF	94.18	94.48	93.35	93.35	5616000.0
2021-03-24	ACWV	ETF	97.41	97.8	97.25	97.25	104800.0
2021-03-24	ACWX	ETF	54.69	54.805	54.32	54.34	2358260.0
2021-03-24	ADFI	ETF	9.641	9.641	9.641	9.641	100.0
2021-03-24	ADME	ETF	36.05	36.16	35.85	35.86	15100.0
2021-03-24	ADRE	ETF	57.01	57.01	54.94	54.94	60218.0
2021-03-24	AESR	ETF	12.416	12.45	12.29	12.29	7700.0
2021-03-24	AFIF	ETF	9.67	9.73	9.67	9.71	35351.0
2021-03-24	AFK	ETF	20.92	21.18	20.73	20.73	7981.0
2021-03-24	AFLG	ETF	23.59	23.59	23.268	23.268	1700.0
2021-03-24	AFMC	ETF	23.279	23.279	23.279	23.279	1200.0
2021-03-24	AFSM	ETF	24.97	24.97	24.082	24.082	300.0
2021-03-24	AFTY	ETF	22.1	22.16	22.0	22.0	7200.0
2021-03-24	AGG	ETF	113.9	114.2	113.86	114.16	6352600.0
2021-03-24	AGGY	ETF	51.4	51.55	51.375	51.53	126700.0
2021-03-24	AGNG	ETF	27.2	27.225	26.987	26.987	2100.0
2021-03-24	AGQ	ETF	44.23	44.35	43.32	43.44	571800.0
2021-03-24	AGZ	ETF	118.11	118.1817	118.05	118.12	30017.0
2021-03-24	AGZD	ETF	23.565	23.58	23.505	23.565	14400.0
2021-03-24	AIA	ETF	91.02	91.02	89.02	89.15	292658.0
2021-03-24	AIEQ	ETF	38.49	38.49	37.12	37.12	23000.0
2021-03-24	AIQ	ETF	28.48	28.57	27.61	27.61	24385.0
2021-03-24	AIRR	ETF	38.74	39.48	38.34	38.34	88400.0
2021-03-24	AIVI	ETF	42.45	42.55	42.37	42.39	5200.0
2021-03-24	ALTL	ETF	38.19	38.415	37.5354	37.5354	2168.0
2021-03-24	ALTY	ETF	12.61	12.67	12.543	12.544	11200.0
2021-03-24	AMJ	ETF	16.1	16.41	16.03	16.04	1006391.0
2021-03-24	AMLP	ETF	29.75	30.22	29.54	29.56	3401400.0
2021-03-24	AMNA	ETF	29.5204	29.5204	29.5204	29.5204	0.0
2021-03-24	AMND	ETF	31.3016	31.3016	31.3016	31.3016	0.0
2021-03-24	AMOM	ETF	32.77	32.78	32.302	32.302	4300.0
2021-03-24	AMPS	ETF	9.85	9.85	9.65	9.65	63494.0

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

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