PREVIEW / etf_daily / 2021-05-11

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-11.parquet
  size:    88 KB
  rows:    2,338

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-05-11	SPY	ETF	413.1	415.27	410.06	414.21	116888000.0
2021-05-11	QQQ	ETF	319.7	326.1299	319.02	325.31	71963612.0
2021-05-11	IWM	ETF	214.92	220.39	214.42	218.96	39519500.0
2021-05-11	DIA	ETF	344.99	345.22	340.89	342.91	8396400.0
2021-05-11	GLD	ETF	170.56	172.17	170.27	172.14	8348200.0
2021-05-11	TLT	ETF	137.23	137.48	136.77	137.04	15158600.0
2021-05-11	AAA	ETF	25.02	25.02	25.01	25.01	152.0
2021-05-11	AAAU	ETF	18.12	18.3	18.1	18.3	264100.0
2021-05-11	AADR	ETF	65.16	65.27	64.9	65.27	10200.0
2021-05-11	AAXJ	ETF	90.44	91.93	90.4	91.74	2109900.0
2021-05-11	ABEQ	ETF	28.05	28.05	28.05	28.05	500.0
2021-05-11	ACES	ETF	61.98	65.33	61.77	65.0	117600.0
2021-05-11	ACIO	ETF	29.43	29.53	29.33	29.474	50200.0
2021-05-11	ACSI	ETF	48.7884	48.7884	48.7884	48.7884	340.0
2021-05-11	ACTV	ETF	37.65	37.94	37.2316	37.825	11120.0
2021-05-11	ACVF	ETF	30.72	30.945	30.72	30.896	10100.0
2021-05-11	ACWF	ETF	37.41	37.689	37.41	37.6049	8961.0
2021-05-11	ACWI	ETF	98.09	98.93	97.78	98.8	2581000.0
2021-05-11	ACWV	ETF	102.17	102.51	102.01	102.36	165800.0
2021-05-11	ACWX	ETF	56.38	56.985	56.37	56.91	2293614.0
2021-05-11	ADFI	ETF	9.68	9.689	9.68	9.689	300.0
2021-05-11	ADIV	ETF	18.356	18.356	18.356	18.356	100.0
2021-05-11	ADME	ETF	38.28	38.425	38.201	38.367	25300.0
2021-05-11	ADRE	ETF	54.15	55.71	53.9	55.71	18480.0
2021-05-11	AESR	ETF	13.085	13.16	13.07	13.112	21100.0
2021-05-11	AFIF	ETF	9.729	9.73	9.7	9.72	114085.0
2021-05-11	AFK	ETF	22.29	22.29	22.04	22.07	36539.0
2021-05-11	AFLG	ETF	24.95	24.98	24.89	24.959	3100.0
2021-05-11	AFMC	ETF	25.338	25.338	25.338	25.338	100.0
2021-05-11	AFSM	ETF	25.504	25.504	25.504	25.504	100.0
2021-05-11	AFTY	ETF	22.3	22.54	22.3	22.506	4000.0
2021-05-11	AGG	ETF	114.23	114.38	114.13	114.18	6161400.0
2021-05-11	AGGY	ETF	51.6	51.619	51.55	51.57	65000.0
2021-05-11	AGNG	ETF	28.3	28.75	28.3	28.449	35000.0
2021-05-11	AGOX	ETF	24.74	25.85	22.27	25.301	20600.0
2021-05-11	AGQ	ETF	50.53	52.41	50.4	52.39	857600.0
2021-05-11	AGZ	ETF	118.15	118.15	118.03	118.13	51665.0
2021-05-11	AGZD	ETF	23.52	23.525	23.46	23.47	81400.0
2021-05-11	AIA	ETF	88.04	89.6	87.78	89.57	310424.0
2021-05-11	AIEQ	ETF	35.75	36.764	35.26	36.54	45300.0
2021-05-11	AIQ	ETF	27.33	27.999	27.29	27.95	34732.0
2021-05-11	AIRR	ETF	41.58	42.056	41.0	41.78	98900.0
2021-05-11	AIVI	ETF	43.94	44.24	43.86	44.16	7600.0
2021-05-11	ALTL	ETF	41.89	41.89	41.31	41.4244	221241.0
2021-05-11	ALTY	ETF	13.45	13.45	13.23	13.36	19800.0
2021-05-11	AMJ	ETF	18.66	18.705	18.24	18.63	533082.0
2021-05-11	AMLP	ETF	33.96	34.57	33.69	34.35	2726100.0
2021-05-11	AMNA	ETF	32.4934	32.4934	32.4934	32.4934	1.0
2021-05-11	AMND	ETF	34.4926	34.4926	34.4926	34.4926	10.0
2021-05-11	AMOM	ETF	33.49	34.2	33.38	34.11	19600.0

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

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