PREVIEW / etf_daily / 2021-04-06

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-06.parquet
  size:    87 KB
  rows:    2,294

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-06	SPY	ETF	405.76	407.24	405.4	406.12	62021000.0
2021-04-06	QQQ	ETF	330.73	332.83	330.02	330.82	33537210.0
2021-04-06	IWM	ETF	225.0	226.69	223.84	224.31	24907800.0
2021-04-06	DIA	ETF	334.69	335.42	333.78	334.37	2987500.0
2021-04-06	GLD	ETF	162.79	163.53	162.75	163.22	6761200.0
2021-04-06	TLT	ETF	137.16	137.98	137.01	137.84	9282400.0
2021-04-06	AAA	ETF	25.05	25.055	25.05	25.055	5236.0
2021-04-06	AAAU	ETF	17.28	17.38	17.28	17.33	686000.0
2021-04-06	AADR	ETF	64.35	64.43	63.94	64.03	5200.0
2021-04-06	AAXJ	ETF	94.01	94.98	93.81	94.56	1054600.0
2021-04-06	ABEQ	ETF	26.7	26.75	26.675	26.675	4800.0
2021-04-06	ACES	ETF	77.11	78.364	76.97	77.82	80600.0
2021-04-06	ACIO	ETF	28.86	28.918	28.83	28.87	12700.0
2021-04-06	ACSI	ETF	47.4098	47.4098	47.4098	47.4098	444.0
2021-04-06	ACTV	ETF	36.64	36.64	36.4409	36.4409	9275.0
2021-04-06	ACTX	ETF	5.0	5.0	5.0	5.0	502.0
2021-04-06	ACVF	ETF	30.38	30.38	30.17	30.226	4000.0
2021-04-06	ACWF	ETF	37.11	37.285	37.11	37.1638	6035.0
2021-04-06	ACWI	ETF	97.15	97.58	97.07	97.35	2061800.0
2021-04-06	ACWV	ETF	99.63	100.06	99.5	99.86	201300.0
2021-04-06	ACWX	ETF	56.08	56.33	56.03	56.22	1164422.0
2021-04-06	ADFI	ETF	9.67	9.7	9.669	9.68	772700.0
2021-04-06	ADIV	ETF	18.74	18.85	18.74	18.76	1000.0
2021-04-06	ADME	ETF	37.365	37.54	37.365	37.39	10400.0
2021-04-06	ADRE	ETF	57.16	57.6773	57.0	57.45	15153.0
2021-04-06	AESR	ETF	12.925	12.95	12.896	12.896	1227600.0
2021-04-06	AFIF	ETF	9.81	9.81	9.73	9.76	107251.0
2021-04-06	AFK	ETF	21.48	21.53	21.4	21.53	8630.0
2021-04-06	AFSM	ETF	25.615	25.615	25.615	25.615	1600.0
2021-04-06	AFTY	ETF	22.95	22.95	22.923	22.923	800.0
2021-04-06	AGG	ETF	113.98	114.22	113.95	114.21	4864100.0
2021-04-06	AGGY	ETF	51.41	51.59	51.41	51.55	217500.0
2021-04-06	AGNG	ETF	28.05	28.05	27.92	27.92	1400.0
2021-04-06	AGQ	ETF	43.38	44.1	43.26	43.56	568900.0
2021-04-06	AGZ	ETF	117.92	118.0	117.88	118.0	59404.0
2021-04-06	AGZD	ETF	23.57	23.65	23.57	23.62	52200.0
2021-04-06	AIA	ETF	94.3	95.13	94.09	94.72	186750.0
2021-04-06	AIEQ	ETF	38.98	39.36	38.98	39.07	30800.0
2021-04-06	AIQ	ETF	29.44	29.63	29.38	29.45	23419.0
2021-04-06	AIRR	ETF	41.44	41.818	41.289	41.347	77900.0
2021-04-06	AIVI	ETF	42.75	42.82	42.7	42.77	6500.0
2021-04-06	ALTL	ETF	39.94	40.15	39.7324	39.7982	5501.0
2021-04-06	ALTY	ETF	12.81	12.88	12.79	12.83	16800.0
2021-04-06	AMJ	ETF	16.78	16.96	16.76	16.91	419692.0
2021-04-06	AMLP	ETF	31.18	31.32	30.88	31.17	1956400.0
2021-04-06	AMNA	ETF	30.202	30.202	30.202	30.202	0.0
2021-04-06	AMND	ETF	32.2687	32.2687	32.2687	32.2687	0.0
2021-04-06	AMOM	ETF	34.37	34.41	34.35	34.35	1800.0
2021-04-06	AMPS	ETF	9.9	9.99	9.89	9.91	120806.0
2021-04-06	AMTR	ETF	34.755	34.755	34.755	34.755	5.0

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

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