PREVIEW / etf_daily / 2022-05-18

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-18.parquet
  size:    102 KB
  rows:    2,721

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
2022-05-18	SPY	ETF	403.5	403.8	390.55	391.86	117674500.0
2022-05-18	QQQ	ETF	301.54	302.25	289.85	291.14	79477109.0
2022-05-18	IWM	ETF	180.47	181.41	175.1	176.24	36093800.0
2022-05-18	DIA	ETF	324.21	324.39	314.43	315.55	3659000.0
2022-05-18	GLD	ETF	169.01	170.21	168.81	169.42	7472900.0
2022-05-18	TLT	ETF	114.72	117.0	114.61	116.9	21337300.0
2022-05-18	AAA	ETF	24.46	24.46	24.45	24.45	492.0
2022-05-18	AAAU	ETF	18.01	18.13	17.99	18.04	229200.0
2022-05-18	AADR	ETF	54.23	54.23	52.97	53.22	1900.0
2022-05-18	AAXJ	ETF	69.13	69.35	67.87	67.99	1737600.0
2022-05-18	ABEQ	ETF	28.53	28.53	28.226	28.226	17000.0
2022-05-18	ACES	ETF	48.41	50.185	48.03	48.43	147700.0
2022-05-18	ACIO	ETF	29.38	29.426	28.851	28.95	29700.0
2022-05-18	ACSI	ETF	43.05	43.05	42.7789	42.7789	184.0
2022-05-18	ACT	ETF	23.79	23.94	23.22	23.3	192338.0
2022-05-18	ACTV	ETF	32.55	32.664	31.82	31.8239	5820.0
2022-05-18	ACTX	ETF	0.7518	0.85	0.7511	0.85	4890.0
2022-05-18	ACVF	ETF	30.305	30.305	29.561	29.569	1900.0
2022-05-18	ACWF	ETF	33.93	33.94	32.901	32.9872	10198.0
2022-05-18	ACWI	ETF	89.77	89.85	87.35	87.62	3497500.0
2022-05-18	ACWV	ETF	97.82	97.82	95.64	95.88	226400.0
2022-05-18	ACWX	ETF	47.93	47.9823	47.05	47.14	2525956.0
2022-05-18	ADFI	ETF	8.62	8.63	8.6	8.625	5300.0
2022-05-18	ADIV	ETF	14.308	14.308	14.308	14.308	100.0
2022-05-18	ADME	ETF	36.625	36.68	35.9	35.99	34400.0
2022-05-18	ADRE	ETF	39.3092	39.3092	38.45	38.45	11284.0
2022-05-18	AEMB	ETF	39.74	39.74	39.74	39.74	100.0
2022-05-18	AESR	ETF	11.87	11.87	11.59	11.67	15500.0
2022-05-18	AFIF	ETF	8.9891	9.009	8.9891	8.9947	20350.0
2022-05-18	AFK	ETF	18.92	18.92	18.36	18.48	7403.0
2022-05-18	AFLG	ETF	23.6	23.6	23.6	23.6	100.0
2022-05-18	AFMC	ETF	22.388	22.388	22.388	22.388	100.0
2022-05-18	AFTY	ETF	16.62	16.62	16.409	16.409	300.0
2022-05-18	AGG	ETF	102.11	102.64	102.08	102.59	6093800.0
2022-05-18	AGGY	ETF	45.19	45.39	45.19	45.33	549400.0
2022-05-18	AGNG	ETF	25.583	25.615	25.33	25.33	1400.0
2022-05-18	AGOV	ETF	79.0	79.0	79.0	79.0	1.0
2022-05-18	AGOX	ETF	21.73	21.73	21.145	21.22	51100.0
2022-05-18	AGQ	ETF	28.36	28.49	27.77	27.81	654400.0
2022-05-18	AGZ	ETF	110.14	110.5455	110.14	110.31	50342.0
2022-05-18	AGZD	ETF	22.975	23.035	22.92	22.945	93200.0
2022-05-18	AHHX	ETF	8.95	8.96	8.9	8.9537	14998.0
2022-05-18	AHYB	ETF	44.116	44.116	44.04	44.085	800.0
2022-05-18	AIA	ETF	62.9	63.1322	61.55	61.55	39677.0
2022-05-18	AIEQ	ETF	33.35	33.49	32.41	32.632	53600.0
2022-05-18	AIQ	ETF	22.18	22.25	21.45	21.5	23619.0
2022-05-18	AIRR	ETF	38.48	39.293	38.03	38.118	14200.0
2022-05-18	AIVI	ETF	38.75	38.78	38.28	38.28	6400.0
2022-05-18	AIVL	ETF	95.28	95.29	92.79	92.96	6700.0
2022-05-18	ALTL	ETF	42.78	42.78	41.52	41.6	87175.0

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

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