PREVIEW / etf_daily / 2021-03-25

all etf daily files

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

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-25	SPY	ETF	385.98	390.55	383.9	389.7	116128600.0
2021-03-25	QQQ	ETF	309.968	312.885	307.3899	311.33	78729008.0
2021-03-25	IWM	ETF	209.34	217.52	208.03	216.66	59244600.0
2021-03-25	DIA	ETF	322.71	326.62	320.62	326.19	5557900.0
2021-03-25	GLD	ETF	163.06	163.58	161.32	161.78	8398600.0
2021-03-25	TLT	ETF	138.39	138.66	137.09	137.14	20782000.0
2021-03-25	AAA	ETF	25.06	25.06	25.06	25.06	84.0
2021-03-25	AAAU	ETF	17.31	17.37	17.14	17.2	968800.0
2021-03-25	AADR	ETF	59.96	61.16	59.96	60.95	5900.0
2021-03-25	AAXJ	ETF	89.99	90.79	89.9	90.43	896500.0
2021-03-25	ABEQ	ETF	26.37	26.37	25.97	26.147	94100.0
2021-03-25	ACES	ETF	70.01	73.08	69.467	72.91	591600.0
2021-03-25	ACIO	ETF	28.08	28.08	27.78	27.92	11500.0
2021-03-25	ACSI	ETF	44.63	45.5205	44.63	45.5205	663.0
2021-03-25	ACTV	ETF	34.62	35.5	34.62	35.4968	5517.0
2021-03-25	ACVF	ETF	28.5	29.141	28.5	29.141	1400.0
2021-03-25	ACWF	ETF	35.41	35.69	35.3	35.69	31284.0
2021-03-25	ACWI	ETF	93.08	93.99	92.7	93.77	4317700.0
2021-03-25	ACWV	ETF	97.3	97.85	97.09	97.79	259700.0
2021-03-25	ACWX	ETF	54.31	54.68	54.14	54.61	1156317.0
2021-03-25	ADFI	ETF	9.641	9.641	9.641	9.641	200.0
2021-03-25	ADME	ETF	35.72	35.87	35.64	35.86	7900.0
2021-03-25	ADRE	ETF	54.29	55.3	54.04	54.48	21797.0
2021-03-25	AESR	ETF	12.21	12.42	12.21	12.35	9200.0
2021-03-25	AFIF	ETF	9.705	9.73	9.69	9.71	31040.0
2021-03-25	AFK	ETF	20.55	20.79	20.291	20.73	16553.0
2021-03-25	AFLG	ETF	23.39	23.39	23.39	23.39	200.0
2021-03-25	AFMC	ETF	23.761	23.761	23.761	23.761	1200.0
2021-03-25	AFSM	ETF	24.544	24.544	24.544	24.544	100.0
2021-03-25	AFTY	ETF	21.84	21.938	21.81	21.938	4800.0
2021-03-25	AGG	ETF	114.24	114.29	113.99	114.1	5178000.0
2021-03-25	AGGY	ETF	51.45	51.5	51.356	51.38	203100.0
2021-03-25	AGNG	ETF	26.811	27.196	26.8	27.196	1900.0
2021-03-25	AGQ	ETF	42.63	43.86	42.47	43.48	900300.0
2021-03-25	AGZ	ETF	118.12	118.2206	118.08	118.115	81045.0
2021-03-25	AGZD	ETF	23.605	23.605	23.47	23.475	18600.0
2021-03-25	AIA	ETF	89.29	90.11	89.29	89.78	172650.0
2021-03-25	AIEQ	ETF	36.51	37.482	36.111	37.38	39300.0
2021-03-25	AIQ	ETF	27.5	27.685	27.33	27.6	27817.0
2021-03-25	AIRR	ETF	38.11	39.333	37.662	39.193	89400.0
2021-03-25	AIVI	ETF	41.94	42.26	41.9	42.23	55400.0
2021-03-25	ALTL	ETF	36.96	38.375	36.72	38.2786	14539.0
2021-03-25	ALTY	ETF	12.506	12.58	12.41	12.58	9100.0
2021-03-25	AMJ	ETF	15.96	16.22	15.665	16.22	703845.0
2021-03-25	AMLP	ETF	29.26	29.88	28.85	29.78	3242000.0
2021-03-25	AMNA	ETF	29.7241	29.7241	29.7241	29.7241	0.0
2021-03-25	AMND	ETF	31.503	31.503	31.503	31.503	180.0
2021-03-25	AMOM	ETF	32.1	32.435	31.96	32.419	1700.0
2021-03-25	AMPS	ETF	9.38	9.82	9.32	9.8	184213.0
2021-03-25	AMTR	ETF	34.1951	34.1951	34.1951	34.1951	76.0

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

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