PREVIEW / etf_daily / 2021-02-17

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-17.parquet
  size:    86 KB
  rows:    2,261

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-02-17	SPY	ETF	390.42	392.66	389.33	392.39	52290600.0
2021-02-17	QQQ	ETF	332.47	335.657	330.17	333.93	31467456.0
2021-02-17	IWM	ETF	223.61	224.74	220.96	224.06	25042300.0
2021-02-17	DIA	ETF	314.69	316.91	313.87	316.6	2007400.0
2021-02-17	GLD	ETF	166.92	167.34	165.85	166.33	11400700.0
2021-02-17	TLT	ETF	145.95	146.38	144.98	145.79	11199100.0
2021-02-17	AAA	ETF	25.14	25.14	25.13	25.13	397.0
2021-02-17	AAAU	ETF	17.74	17.77	17.62	17.66	1029000.0
2021-02-17	AADR	ETF	65.71	66.67	65.67	66.44	3600.0
2021-02-17	AAXJ	ETF	101.89	102.1	101.4	102.08	882200.0
2021-02-17	ABEQ	ETF	25.64	25.64	25.615	25.615	5500.0
2021-02-17	ACES	ETF	94.94	94.94	90.731	92.55	152200.0
2021-02-17	ACIO	ETF	28.02	28.14	28.02	28.14	7400.0
2021-02-17	ACSI	ETF	45.4545	45.4545	45.4545	45.4545	149.0
2021-02-17	ACTV	ETF	35.23	35.3595	35.17	35.3172	1883.0
2021-02-17	ACTX	ETF	6.0	6.0	6.0	6.0	518.0
2021-02-17	ACVF	ETF	29.11	29.155	28.99	29.155	1500.0
2021-02-17	ACWF	ETF	35.99	36.12	35.825	36.096	35022.0
2021-02-17	ACWI	ETF	96.01	96.34	95.56	96.33	3662600.0
2021-02-17	ACWV	ETF	96.96	97.39	96.92	97.33	238000.0
2021-02-17	ACWX	ETF	56.74	56.85	56.45	56.82	671670.0
2021-02-17	ADFI	ETF	9.85	9.85	9.821	9.821	13200.0
2021-02-17	ADME	ETF	36.64	36.84	36.64	36.84	12600.0
2021-02-17	ADRE	ETF	66.42	66.42	65.05	65.71	16243.0
2021-02-17	AESR	ETF	12.36	12.45	12.36	12.45	13500.0
2021-02-17	AFIF	ETF	9.74	9.765	9.74	9.7551	10217.0
2021-02-17	AFK	ETF	21.99	22.1353	21.6238	21.97	12352.0
2021-02-17	AFLG	ETF	23.509	23.609	23.509	23.609	2400.0
2021-02-17	AFSM	ETF	25.535	25.554	25.535	25.554	100.0
2021-02-17	AFTY	ETF	27.2	27.32	27.18	27.312	6800.0
2021-02-17	AGG	ETF	116.22	116.29	116.15	116.26	6304100.0
2021-02-17	AGGY	ETF	52.63	52.709	52.61	52.67	135800.0
2021-02-17	AGNG	ETF	29.12	29.12	28.85	29.0	9100.0
2021-02-17	AGQ	ETF	51.34	52.48	50.45	52.44	848700.0
2021-02-17	AGZ	ETF	118.98	118.99	118.904	118.95	35627.0
2021-02-17	AGZD	ETF	23.835	23.835	23.63	23.67	63600.0
2021-02-17	AIA	ETF	101.97	102.18	101.343	102.07	391908.0
2021-02-17	AIEQ	ETF	41.7	41.7	40.55	41.4	67600.0
2021-02-17	AIQ	ETF	30.39	30.44	30.02	30.43	46384.0
2021-02-17	AIRR	ETF	38.02	38.02	37.625	37.93	29200.0
2021-02-17	AIVI	ETF	42.34	42.47	42.2	42.37	15800.0
2021-02-17	ALTL	ETF	36.37	36.37	36.08	36.3673	2931.0
2021-02-17	ALTY	ETF	12.45	12.45	12.35	12.42	26700.0
2021-02-17	AMJ	ETF	15.82	15.9	15.49	15.61	394726.0
2021-02-17	AMLP	ETF	28.61	28.71	27.9	28.53	2463600.0
2021-02-17	AMNA	ETF	28.3398	28.3398	28.3398	28.3398	0.0
2021-02-17	AMND	ETF	30.0796	30.0796	30.0796	30.0796	0.0
2021-02-17	AMOM	ETF	34.83	34.83	34.1	34.328	1300.0
2021-02-17	AMPS	ETF	10.64	10.64	10.52	10.64	6999.0
2021-02-17	AMTR	ETF	32.5868	32.5868	32.5868	32.5868	1.0

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

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