PREVIEW / etf_daily / 2021-03-08

all etf daily files

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

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-08	SPY	ETF	384.66	387.68	381.42	381.72	123149200.0
2021-03-08	QQQ	ETF	308.12	310.06	299.51	299.94	88409781.0
2021-03-08	IWM	ETF	219.36	222.27	217.67	218.74	40619700.0
2021-03-08	DIA	ETF	316.75	321.73	315.83	318.25	8230700.0
2021-03-08	GLD	ETF	158.58	158.74	157.13	157.49	12134900.0
2021-03-08	TLT	ETF	138.83	138.9	137.83	137.83	15236600.0
2021-03-08	AAA	ETF	25.1	25.1	25.065	25.065	13087.0
2021-03-08	AAAU	ETF	16.84	16.85	16.69	16.72	593100.0
2021-03-08	AADR	ETF	61.58	61.74	60.63	60.76	4700.0
2021-03-08	AAXJ	ETF	92.72	92.8	91.59	91.61	1053100.0
2021-03-08	ABEQ	ETF	25.93	26.15	25.93	25.96	5900.0
2021-03-08	ACES	ETF	72.61	74.65	70.78	70.86	132500.0
2021-03-08	ACIO	ETF	27.45	27.47	27.19	27.19	18200.0
2021-03-08	ACSI	ETF	44.7118	44.7118	44.7118	44.7118	188.0
2021-03-08	ACTV	ETF	35.6	36.0999	35.6	35.7714	6719.0
2021-03-08	ACTX	ETF	3.55	3.73	3.55	3.73	376.0
2021-03-08	ACVF	ETF	28.645	28.907	28.504	28.504	1000.0
2021-03-08	ACWF	ETF	34.94	35.155	34.7694	34.7694	3458.0
2021-03-08	ACWI	ETF	92.77	93.42	92.14	92.14	5031100.0
2021-03-08	ACWV	ETF	94.84	95.96	94.83	95.25	164900.0
2021-03-08	ACWX	ETF	54.28	54.62	54.12	54.17	2096978.0
2021-03-08	ADFI	ETF	9.617	9.617	9.617	9.617	200.0
2021-03-08	ADME	ETF	35.56	35.57	35.13	35.13	16500.0
2021-03-08	ADRE	ETF	58.0	58.24	56.08	56.08	18682.0
2021-03-08	AESR	ETF	12.21	12.27	12.08	12.08	26700.0
2021-03-08	AFIF	ETF	9.71	9.71	9.66	9.67	29232.0
2021-03-08	AFK	ETF	21.15	21.24	20.7301	20.75	12120.0
2021-03-08	AFLG	ETF	23.2	23.2	22.925	22.925	300.0
2021-03-08	AFMC	ETF	23.469	23.469	23.469	23.469	100.0
2021-03-08	AFTY	ETF	22.51	22.51	22.26	22.319	26300.0
2021-03-08	AGG	ETF	114.2	114.23	113.83	113.83	5639400.0
2021-03-08	AGGY	ETF	51.54	51.54	51.36	51.375	456900.0
2021-03-08	AGNG	ETF	26.97	27.27	26.89	26.94	8900.0
2021-03-08	AGQ	ETF	44.09	44.61	43.57	43.68	589800.0
2021-03-08	AGZ	ETF	118.08	118.08	117.89	117.89	48546.0
2021-03-08	AGZD	ETF	23.66	23.735	23.625	23.655	149400.0
2021-03-08	AIA	ETF	92.68	92.88	91.63	92.41	4956046.0
2021-03-08	AIEQ	ETF	37.59	37.875	36.52	36.58	61000.0
2021-03-08	AIQ	ETF	27.78	27.99	27.16	27.16	52994.0
2021-03-08	AIRR	ETF	39.83	40.584	39.775	40.182	156900.0
2021-03-08	AIVI	ETF	42.08	42.27	42.01	42.03	11500.0
2021-03-08	ALTL	ETF	39.43	39.98	39.35	39.4066	13194.0
2021-03-08	ALTY	ETF	12.36	12.45	12.31	12.428	22800.0
2021-03-08	AMJ	ETF	17.02	17.41	16.93	17.04	707139.0
2021-03-08	AMLP	ETF	31.91	32.19	31.28	31.59	3111200.0
2021-03-08	AMNA	ETF	30.0477	30.0477	30.0477	30.0477	0.0
2021-03-08	AMND	ETF	31.9859	31.9859	31.9859	31.9859	0.0
2021-03-08	AMOM	ETF	31.24	31.48	30.807	30.807	2700.0
2021-03-08	AMPS	ETF	9.95	10.01	9.93	10.0	236486.0
2021-03-08	AMTR	ETF	34.5748	34.5748	34.5748	34.5748	15.0

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

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