PREVIEW / etf_daily / 2021-03-19

all etf daily files

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

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-19	SPY	ETF	389.88	391.57	387.15	389.48	113624500.0
2021-03-19	QQQ	ETF	311.87	314.73	309.6601	313.14	78446204.0
2021-03-19	IWM	ETF	224.57	228.6	222.95	226.94	40855600.0
2021-03-19	DIA	ETF	328.09	328.18	324.98	326.01	5628800.0
2021-03-19	GLD	ETF	162.56	163.43	162.43	163.24	6868900.0
2021-03-19	TLT	ETF	134.08	134.83	133.8	134.75	18685000.0
2021-03-19	AAA	ETF	25.09	25.09	25.09	25.09	650.0
2021-03-19	AAAU	ETF	17.26	17.36	17.26	17.33	239700.0
2021-03-19	AADR	ETF	63.02	63.62	63.02	63.53	3800.0
2021-03-19	AAXJ	ETF	93.48	94.37	93.12	94.3	450000.0
2021-03-19	ABEQ	ETF	26.37	26.42	26.33	26.33	9500.0
2021-03-19	ACES	ETF	74.4	75.18	72.55	74.85	99200.0
2021-03-19	ACIO	ETF	27.78	27.79	27.61	27.729	12900.0
2021-03-19	ACSI	ETF	45.58	46.0261	45.58	46.0261	1601.0
2021-03-19	ACTV	ETF	35.9	36.43	35.9	36.2802	9925.0
2021-03-19	ACVF	ETF	29.23	29.232	29.22	29.22	800.0
2021-03-19	ACWF	ETF	35.78	36.2	35.78	36.08	8582.0
2021-03-19	ACWI	ETF	94.62	95.09	94.06	94.73	5386000.0
2021-03-19	ACWV	ETF	97.36	97.8	97.18	97.35	189100.0
2021-03-19	ACWX	ETF	55.53	55.825	55.26	55.75	1162056.0
2021-03-19	ADFI	ETF	9.6	9.6	9.59	9.59	300.0
2021-03-19	ADME	ETF	36.0	36.0	35.7	35.78	8900.0
2021-03-19	ADRE	ETF	57.93	58.25	57.42	58.1	9470.0
2021-03-19	AESR	ETF	12.4	12.46	12.34	12.45	23500.0
2021-03-19	AFIF	ETF	9.73	9.73	9.69	9.72	39423.0
2021-03-19	AFK	ETF	21.46	21.5	21.415	21.47	25466.0
2021-03-19	AFLG	ETF	23.59	23.601	23.546	23.546	600.0
2021-03-19	AFMC	ETF	24.329	24.329	24.329	24.329	1400.0
2021-03-19	AFSM	ETF	25.688	25.688	25.688	25.688	100.0
2021-03-19	AFTY	ETF	22.485	22.58	22.485	22.575	1400.0
2021-03-19	AGG	ETF	113.4	113.54	113.33	113.51	4701400.0
2021-03-19	AGGY	ETF	51.14	51.19	51.08	51.18	216900.0
2021-03-19	AGNG	ETF	27.175	27.49	27.175	27.435	1000.0
2021-03-19	AGQ	ETF	47.29	47.79	46.83	47.54	369500.0
2021-03-19	AGZ	ETF	117.61	117.8352	117.61	117.69	49225.0
2021-03-19	AGZD	ETF	23.59	23.59	23.5	23.575	165400.0
2021-03-19	AIA	ETF	92.92	93.56	92.26	93.5	146918.0
2021-03-19	AIEQ	ETF	38.47	39.085	38.08	38.81	74200.0
2021-03-19	AIQ	ETF	28.42	28.59	28.2	28.4639	228855.0
2021-03-19	AIRR	ETF	40.66	40.84	40.17	40.52	70800.0
2021-03-19	AIVI	ETF	42.76	42.8	42.5	42.8	4100.0
2021-03-19	ALTL	ETF	39.54	39.71	38.98	39.4881	14337.0
2021-03-19	ALTY	ETF	12.575	12.69	12.575	12.68	3100.0
2021-03-19	AMJ	ETF	16.87	16.97	16.47	16.81	866271.0
2021-03-19	AMLP	ETF	30.5	31.24	30.31	30.85	2782400.0
2021-03-19	AMNA	ETF	29.7439	29.7439	29.7439	29.7439	0.0
2021-03-19	AMND	ETF	31.7445	31.7445	31.7445	31.7445	0.0
2021-03-19	AMOM	ETF	32.5	32.609	32.5	32.609	1700.0
2021-03-19	AMPS	ETF	9.93	10.0	9.9	9.99	6575.0
2021-03-19	AMTR	ETF	34.2158	34.2158	34.2158	34.2158	0.0

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

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