PREVIEW / etf_daily / 2021-05-14

all etf daily files

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

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-14	SPY	ETF	413.21	417.49	413.18	416.58	82201600.0
2021-05-14	QQQ	ETF	322.6	327.33	322.08	326.39	44370015.0
2021-05-14	IWM	ETF	217.94	221.41	215.68	221.02	25070400.0
2021-05-14	DIA	ETF	342.31	344.93	341.88	344.26	4677300.0
2021-05-14	GLD	ETF	172.05	172.7	171.82	172.69	9686800.0
2021-05-14	TLT	ETF	136.53	137.08	136.22	137.08	17566700.0
2021-05-14	AAA	ETF	25.02	25.02	25.005	25.005	290.0
2021-05-14	AAAU	ETF	18.29	18.35	18.26	18.34	209300.0
2021-05-14	AADR	ETF	63.43	64.75	63.43	64.75	2000.0
2021-05-14	AAXJ	ETF	90.33	90.94	90.06	90.77	2823100.0
2021-05-14	ABEQ	ETF	28.174	28.33	28.17	28.29	2400.0
2021-05-14	ACES	ETF	63.05	64.3	62.91	64.23	44700.0
2021-05-14	ACIO	ETF	29.59	29.65	29.56	29.6	34200.0
2021-05-14	ACSI	ETF	49.3552	49.3552	49.3552	49.3552	305.0
2021-05-14	ACTV	ETF	38.08	38.2	37.865	38.14	14173.0
2021-05-14	ACTX	ETF	3.27	4.0	3.27	4.0	1033.0
2021-05-14	ACVF	ETF	30.95	31.15	30.86	31.1	9800.0
2021-05-14	ACWF	ETF	37.67	37.719	37.64	37.64	963.0
2021-05-14	ACWI	ETF	98.39	99.26	98.38	99.08	16310500.0
2021-05-14	ACWV	ETF	102.08	102.68	102.08	102.67	125200.0
2021-05-14	ACWX	ETF	56.61	57.11	56.61	57.07	2452032.0
2021-05-14	ADFI	ETF	9.65	9.68	9.65	9.66	2500.0
2021-05-14	ADIV	ETF	18.34	18.34	18.34	18.34	1000.0
2021-05-14	ADME	ETF	38.05	38.56	38.05	38.55	25900.0
2021-05-14	ADRE	ETF	53.82	54.38	53.57	54.38	12144.0
2021-05-14	AESR	ETF	13.113	13.19	13.105	13.17	3100.0
2021-05-14	AFIF	ETF	9.715	9.729	9.7	9.72	13834.0
2021-05-14	AFK	ETF	21.58	21.8	21.58	21.8	3699.0
2021-05-14	AFLG	ETF	24.99	25.08	24.99	25.071	2500.0
2021-05-14	AFMC	ETF	25.448	25.448	25.448	25.448	100.0
2021-05-14	AFSM	ETF	25.68	25.72	25.68	25.72	300.0
2021-05-14	AFTY	ETF	22.97	23.09	22.93	23.067	600.0
2021-05-14	AGG	ETF	114.22	114.3	114.12	114.3	3985500.0
2021-05-14	AGGY	ETF	51.53	51.58	51.51	51.58	98000.0
2021-05-14	AGNG	ETF	28.48	28.7	28.46	28.66	12400.0
2021-05-14	AGOX	ETF	25.05	25.3	25.05	25.263	29900.0
2021-05-14	AGQ	ETF	51.23	51.67	50.8	51.4	948900.0
2021-05-14	AGZ	ETF	118.0	118.0347	117.9409	117.99	19047.0
2021-05-14	AGZD	ETF	23.53	23.585	23.49	23.5	96400.0
2021-05-14	AIA	ETF	87.7	88.34	87.37	88.19	159996.0
2021-05-14	AIEQ	ETF	35.64	36.56	35.64	36.43	11700.0
2021-05-14	AIQ	ETF	27.57	28.0	27.56	27.99	25010.0
2021-05-14	AIRR	ETF	41.51	41.86	41.4	41.85	26800.0
2021-05-14	AIVI	ETF	44.1	44.26	44.1	44.26	5500.0
2021-05-14	ALTL	ETF	41.85	41.85	41.5	41.53	25135.0
2021-05-14	ALTY	ETF	13.16	13.35	13.16	13.32	22600.0
2021-05-14	AMJ	ETF	18.88	19.27	18.88	19.27	745540.0
2021-05-14	AMLP	ETF	34.41	34.91	34.39	34.56	3440300.0
2021-05-14	AMNA	ETF	33.0953	33.0953	33.0953	33.0953	90.0
2021-05-14	AMND	ETF	35.1481	35.1481	35.1481	35.1481	63.0

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

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