PREVIEW / etf_daily / 2021-03-31

all etf daily files

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

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-31	SPY	ETF	395.34	398.0	395.31	396.33	112734200.0
2021-03-31	QQQ	ETF	316.16	320.74	315.81	319.13	55032535.0
2021-03-31	IWM	ETF	219.17	222.4	219.12	220.94	34800100.0
2021-03-31	DIA	ETF	330.61	331.62	329.94	330.18	3763700.0
2021-03-31	GLD	ETF	158.06	160.68	158.05	159.96	10623800.0
2021-03-31	TLT	ETF	136.34	136.59	134.98	135.45	19271300.0
2021-03-31	AAA	ETF	25.04	25.04	25.04	25.04	45.0
2021-03-31	AAAU	ETF	16.78	17.07	16.78	16.99	280800.0
2021-03-31	AADR	ETF	62.56	62.69	62.21	62.33	3200.0
2021-03-31	AAXJ	ETF	92.01	92.97	92.01	92.66	269400.0
2021-03-31	ABEQ	ETF	26.34	26.38	26.233	26.233	3500.0
2021-03-31	ACES	ETF	76.48	78.5	76.48	78.03	157700.0
2021-03-31	ACIO	ETF	28.455	28.455	28.26	28.33	10200.0
2021-03-31	ACSI	ETF	46.2525	46.2525	46.2525	46.2525	188.0
2021-03-31	ACTV	ETF	36.02	36.06	35.82	35.82	19765.0
2021-03-31	ACTX	ETF	4.0	4.0	4.0	4.0	2614.0
2021-03-31	ACVF	ETF	29.66	29.672	29.66	29.672	200.0
2021-03-31	ACWF	ETF	36.3	36.544	36.3	36.4776	14242.0
2021-03-31	ACWI	ETF	94.87	95.6	94.87	95.15	2264700.0
2021-03-31	ACWV	ETF	98.81	99.09	98.64	98.66	147700.0
2021-03-31	ACWX	ETF	55.13	55.39	55.0992	55.18	2600863.0
2021-03-31	ADFI	ETF	9.65	9.65	9.641	9.641	1000.0
2021-03-31	ADIV	ETF	18.49	18.92	18.49	18.494	700.0
2021-03-31	ADME	ETF	36.405	36.56	36.405	36.449	8500.0
2021-03-31	ADRE	ETF	56.05	56.4187	56.05	56.29	17837.0
2021-03-31	AESR	ETF	12.6	12.61	12.585	12.589	12800.0
2021-03-31	AFIF	ETF	9.79	9.79	9.7	9.715	16122.0
2021-03-31	AFK	ETF	21.08	21.13	20.95	21.02	32191.0
2021-03-31	AFLG	ETF	23.812	23.812	23.812	23.812	1000.0
2021-03-31	AFMC	ETF	24.243	24.243	24.243	24.243	400.0
2021-03-31	AFSM	ETF	25.0	25.054	25.0	25.054	100.0
2021-03-31	AFTY	ETF	22.54	22.54	22.54	22.54	100.0
2021-03-31	AGG	ETF	113.84	113.98	113.71	113.83	6309200.0
2021-03-31	AGGY	ETF	51.23	51.34	51.2	51.2	214700.0
2021-03-31	AGNG	ETF	27.669	27.85	27.65	27.75	2800.0
2021-03-31	AGQ	ETF	39.8	41.43	39.58	41.1	811900.0
2021-03-31	AGZ	ETF	117.8	117.868	117.71	117.73	100453.0
2021-03-31	AGZD	ETF	23.465	23.555	23.465	23.505	54600.0
2021-03-31	AIA	ETF	91.3	92.33	91.3	92.18	210470.0
2021-03-31	AIEQ	ETF	37.64	38.5	37.64	38.3	14700.0
2021-03-31	AIQ	ETF	28.12	28.55	28.12	28.46	23807.0
2021-03-31	AIRR	ETF	40.48	40.879	40.1	40.58	83500.0
2021-03-31	AIVI	ETF	42.42	42.64	42.42	42.45	4800.0
2021-03-31	ALTL	ETF	39.1445	39.1445	38.8312	38.925	4650.0
2021-03-31	ALTY	ETF	12.73	12.73	12.68	12.7	7800.0
2021-03-31	AMJ	ETF	16.31	16.71	16.28	16.59	552396.0
2021-03-31	AMLP	ETF	30.06	30.83	29.95	30.5	2822900.0
2021-03-31	AMNA	ETF	29.9097	29.9097	29.9097	29.9097	0.0
2021-03-31	AMND	ETF	31.8577	31.8577	31.8577	31.8577	0.0
2021-03-31	AMOM	ETF	33.346	33.346	33.346	33.346	600.0

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

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