PREVIEW / etf_daily / 2021-06-25

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-25.parquet
  size:    90 KB
  rows:    2,375

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-06-25	SPY	ETF	425.9	427.09	425.55	426.61	58129500.0
2021-06-25	QQQ	ETF	350.47	350.72	348.84	349.46	28682801.0
2021-06-25	IWM	ETF	232.29	233.41	231.75	232.28	27619000.0
2021-06-25	DIA	ETF	343.69	344.98	343.09	344.45	3638000.0
2021-06-25	GLD	ETF	167.45	167.53	166.29	166.59	7473700.0
2021-06-25	TLT	ETF	143.26	143.4	141.37	142.01	15562200.0
2021-06-25	AAA	ETF	25.0267	25.04	25.015	25.015	1232.0
2021-06-25	AAAU	ETF	17.81	17.81	17.67	17.71	248000.0
2021-06-25	AADR	ETF	67.22	67.22	66.86	66.86	1200.0
2021-06-25	AAXJ	ETF	94.85	94.96	94.53	94.88	1986200.0
2021-06-25	ABEQ	ETF	27.44	27.499	27.44	27.466	10200.0
2021-06-25	ACES	ETF	74.09	75.1	73.973	74.19	322700.0
2021-06-25	ACIO	ETF	30.06	30.08	30.02	30.06	35400.0
2021-06-25	ACSI	ETF	49.9428	49.9428	49.9428	49.9428	206.0
2021-06-25	ACTV	ETF	39.55	39.55	39.33	39.394	2700.0
2021-06-25	ACVF	ETF	31.9	31.91	31.812	31.897	8100.0
2021-06-25	ACWF	ETF	38.03	38.08	38.03	38.0371	7447.0
2021-06-25	ACWI	ETF	101.51	101.64	101.36	101.58	3247400.0
2021-06-25	ACWV	ETF	102.65	103.09	102.65	103.09	538100.0
2021-06-25	ACWX	ETF	58.19	58.19	58.01	58.14	875189.0
2021-06-25	ADFI	ETF	9.75	9.75	9.72	9.72	700.0
2021-06-25	ADIV	ETF	18.72	18.73	18.719	18.719	300.0
2021-06-25	ADME	ETF	39.59	39.59	39.44	39.525	30600.0
2021-06-25	ADRE	ETF	57.62	57.78	57.4213	57.6414	5698.0
2021-06-25	AESR	ETF	13.54	13.6	13.53	13.57	22900.0
2021-06-25	AFIF	ETF	9.67	9.69	9.67	9.685	60022.0
2021-06-25	AFK	ETF	22.0	22.0	21.968	21.99	8901.0
2021-06-25	AFLG	ETF	25.28	25.299	25.28	25.299	200.0
2021-06-25	AFMC	ETF	25.43	25.536	25.43	25.536	200.0
2021-06-25	AFSM	ETF	26.877	26.877	26.727	26.727	200.0
2021-06-25	AFTY	ETF	23.49	23.49	23.382	23.44	7400.0
2021-06-25	AGG	ETF	115.11	115.13	114.75	114.86	6496600.0
2021-06-25	AGGY	ETF	52.13	52.13	51.93	51.99	69200.0
2021-06-25	AGNG	ETF	30.91	30.92	30.81	30.91	3400.0
2021-06-25	AGOX	ETF	26.14	26.24	26.14	26.179	67000.0
2021-06-25	AGQ	ETF	46.56	46.58	45.63	45.95	390800.0
2021-06-25	AGZ	ETF	118.13	118.21	118.03	118.11	20495.0
2021-06-25	AGZD	ETF	23.485	23.58	23.485	23.5	51800.0
2021-06-25	AIA	ETF	91.99	92.43	91.88	92.35	110649.0
2021-06-25	AIEQ	ETF	41.65	41.79	41.32	41.575	16200.0
2021-06-25	AIQ	ETF	30.5	30.5	30.3352	30.5	263353.0
2021-06-25	AIRR	ETF	41.23	41.6	41.22	41.31	28400.0
2021-06-25	AIVI	ETF	43.79	43.79	43.69	43.76	2500.0
2021-06-25	ALTL	ETF	41.0	41.27	40.93	41.27	37469.0
2021-06-25	ALTY	ETF	13.71	13.71	13.64	13.685	15300.0
2021-06-25	AMJ	ETF	19.86	19.86	19.47	19.53	446701.0
2021-06-25	AMLP	ETF	36.77	36.88	36.11	36.26	1951900.0
2021-06-25	AMNA	ETF	34.3674	34.3674	34.3674	34.3674	0.0
2021-06-25	AMND	ETF	36.3594	36.3594	36.3594	36.3594	0.0
2021-06-25	AMOM	ETF	36.376	36.42	36.31	36.41	6600.0

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

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