PREVIEW / etf_daily / 2021-03-10

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-10.parquet
  size:    86 KB
  rows:    2,284

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-10	SPY	ETF	389.69	391.4	388.17	389.58	109899400.0
2021-03-10	QQQ	ETF	316.16	316.47	310.17	310.88	76798065.0
2021-03-10	IWM	ETF	225.6	228.97	225.2	227.22	36812000.0
2021-03-10	DIA	ETF	320.53	324.31	320.47	323.33	6472200.0
2021-03-10	GLD	ETF	161.06	161.78	160.66	161.66	7962000.0
2021-03-10	TLT	ETF	139.8	140.15	139.28	140.02	12387600.0
2021-03-10	AAA	ETF	25.09	25.09	25.075	25.075	1954.0
2021-03-10	AAAU	ETF	17.1	17.18	17.06	17.16	346700.0
2021-03-10	AADR	ETF	63.31	63.31	62.08	62.5	4500.0
2021-03-10	AAXJ	ETF	94.22	94.22	92.79	93.18	1387000.0
2021-03-10	ABEQ	ETF	26.38	26.38	26.07	26.224	18700.0
2021-03-10	ACES	ETF	79.17	79.73	75.79	76.99	157900.0
2021-03-10	ACIO	ETF	27.66	27.69	27.61	27.64	17400.0
2021-03-10	ACSI	ETF	45.319	45.45	45.28	45.3484	4735.0
2021-03-10	ACTV	ETF	36.39	36.44	36.3009	36.3882	3643.0
2021-03-10	ACTX	ETF	3.5	3.5	3.41	3.41	878.0
2021-03-10	ACVF	ETF	29.13	29.15	29.07	29.08	1500.0
2021-03-10	ACWF	ETF	35.46	35.46	35.4	35.4	2699.0
2021-03-10	ACWI	ETF	94.29	94.45	93.75	94.13	2851400.0
2021-03-10	ACWV	ETF	96.23	96.71	96.03	96.59	203400.0
2021-03-10	ACWX	ETF	55.28	55.28	54.9	55.16	1948619.0
2021-03-10	ADFI	ETF	9.69	9.69	9.668	9.668	700.0
2021-03-10	ADME	ETF	35.824	35.824	35.68	35.71	27000.0
2021-03-10	ADRE	ETF	59.27	59.32	57.53	57.54	38810.0
2021-03-10	AESR	ETF	12.32	12.38	12.32	12.347	29200.0
2021-03-10	AFIF	ETF	9.73	9.74	9.69	9.72	386952.0
2021-03-10	AFK	ETF	21.22	22.02	21.22	21.37	174138.0
2021-03-10	AFLG	ETF	23.41	23.41	23.389	23.389	300.0
2021-03-10	AFSM	ETF	25.408	25.408	25.408	25.408	1000.0
2021-03-10	AFTY	ETF	22.58	22.59	22.46	22.52	2200.0
2021-03-10	AGG	ETF	114.3	114.5	114.28	114.45	6936900.0
2021-03-10	AGGY	ETF	51.54	51.68	51.54	51.6	240600.0
2021-03-10	AGNG	ETF	27.39	27.49	27.35	27.35	1900.0
2021-03-10	AGQ	ETF	47.06	47.7	46.43	47.68	637500.0
2021-03-10	AGZ	ETF	118.06	118.2132	118.06	118.19	22711.0
2021-03-10	AGZD	ETF	23.685	23.69	23.625	23.64	211800.0
2021-03-10	AIA	ETF	93.8	93.8	92.5813	92.84	174820.0
2021-03-10	AIEQ	ETF	38.82	38.93	38.2	38.47	26500.0
2021-03-10	AIQ	ETF	28.64	28.64	28.1	28.2	34257.0
2021-03-10	AIRR	ETF	40.479	41.309	40.479	41.094	219500.0
2021-03-10	AIVI	ETF	42.44	42.64	42.41	42.61	4200.0
2021-03-10	ALTL	ETF	39.4	39.695	39.27	39.68	13752.0
2021-03-10	ALTY	ETF	12.54	12.63	12.521	12.605	16000.0
2021-03-10	AMJ	ETF	16.89	17.485	16.87	17.47	745111.0
2021-03-10	AMLP	ETF	31.14	32.3	31.06	32.29	4193500.0
2021-03-10	AMNA	ETF	30.5022	30.5022	30.5022	30.5022	0.0
2021-03-10	AMND	ETF	32.5435	32.5435	32.5435	32.5435	7.0
2021-03-10	AMOM	ETF	31.83	32.0	31.75	31.788	2000.0
2021-03-10	AMPS	ETF	10.0	10.065	10.0	10.02	5696.0
2021-03-10	AMTR	ETF	35.1048	35.1048	35.1048	35.1048	0.0

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

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