PREVIEW / etf_daily / 2022-09-14

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-14.parquet
  size:    103 KB
  rows:    2,780

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-09-14	SPY	ETF	394.47	396.2	391.12	394.6	85023700.0
2022-09-14	QQQ	ETF	294.865	296.93	293.06	296.03	54907198.0
2022-09-14	IWM	ETF	182.57	183.32	180.57	182.96	25278300.0
2022-09-14	DIA	ETF	312.36	313.48	309.53	312.06	2868800.0
2022-09-14	GLD	ETF	158.68	158.98	157.73	157.93	6091100.0
2022-09-14	TLT	ETF	107.34	108.21	107.12	108.04	13077800.0
2022-09-14	AAA	ETF	24.31	24.31	24.31	24.31	41.0
2022-09-14	AAAU	ETF	16.9	16.94	16.81	16.83	430000.0
2022-09-14	AADR	ETF	49.03	49.15	48.91	49.15	700.0
2022-09-14	AAPB	ETF	21.8892	22.5	21.76	22.2168	4609.0
2022-09-14	AAPD	ETF	26.45	26.61	26.031	26.3134	57382.0
2022-09-14	AAPU	ETF	22.55	23.01	22.26	22.69	48979.0
2022-09-14	AAXJ	ETF	65.16	65.32	64.9	65.14	650600.0
2022-09-14	ABEQ	ETF	26.94	26.94	26.57	26.71	24000.0
2022-09-14	ACES	ETF	65.63	66.83	64.57	66.73	47400.0
2022-09-14	ACIO	ETF	29.59	29.655	29.501	29.65	18900.0
2022-09-14	ACSI	ETF	45.3901	45.3901	45.3901	45.3901	140.0
2022-09-14	ACT	ETF	24.84	25.01	24.22	24.4	265010.0
2022-09-14	ACTV	ETF	29.619	29.619	29.2	29.47	4213.0
2022-09-14	ACVF	ETF	29.5	29.584	29.5	29.584	1000.0
2022-09-14	ACWF	ETF	31.83	31.94	31.7092	31.7643	3428.0
2022-09-14	ACWI	ETF	85.6	85.95	84.99	85.64	2181200.0
2022-09-14	ACWV	ETF	94.97	95.18	94.37	94.69	313200.0
2022-09-14	ACWX	ETF	43.86	44.05	43.655	43.89	1984135.0
2022-09-14	ADFI	ETF	8.45	8.45	8.43	8.445	7800.0
2022-09-14	ADIV	ETF	13.22	13.22	13.18	13.2	2000.0
2022-09-14	ADME	ETF	34.89	35.03	34.75	34.92	23600.0
2022-09-14	ADRE	ETF	38.86	38.9676	38.736	38.82	2598.0
2022-09-14	AEMB	ETF	37.65	37.65	37.65	37.65	100.0
2022-09-14	AESR	ETF	11.6	11.63	11.52	11.587	16400.0
2022-09-14	AFIF	ETF	8.88	8.89	8.88	8.88	5667.0
2022-09-14	AFK	ETF	16.73	16.73	16.48	16.627	3098.0
2022-09-14	AFLG	ETF	23.38	23.38	23.357	23.357	100.0
2022-09-14	AFMC	ETF	21.889	21.889	21.889	21.889	100.0
2022-09-14	AFSM	ETF	22.467	22.467	22.467	22.467	100.0
2022-09-14	AFTY	ETF	16.48	16.5	16.465	16.488	1900.0
2022-09-14	AGG	ETF	99.0	99.35	98.97	99.2	7557300.0
2022-09-14	AGGH	ETF	23.23	23.27	22.96	22.96	6281.0
2022-09-14	AGGY	ETF	43.68	43.82	43.68	43.76	72500.0
2022-09-14	AGNG	ETF	24.93	24.967	24.81	24.967	3400.0
2022-09-14	AGOV	ETF	81.35	81.69	80.02	80.7556	1796.0
2022-09-14	AGOX	ETF	20.96	21.17	20.92	21.14	30100.0
2022-09-14	AGQ	ETF	22.15	22.36	21.78	21.99	1191100.0
2022-09-14	AGZ	ETF	108.05	108.22	108.03	108.22	10733.0
2022-09-14	AGZD	ETF	22.97	22.985	22.92	22.93	34800.0
2022-09-14	AHHX	ETF	8.53	8.58	8.5116	8.5601	25098.0
2022-09-14	AHYB	ETF	43.47	43.47	43.285	43.285	200.0
2022-09-14	AIA	ETF	55.86	56.049	55.6206	55.84	23658.0
2022-09-14	AIEQ	ETF	33.32	33.848	33.19	33.54	9300.0
2022-09-14	AIQ	ETF	21.13	21.24	21.0	21.1	19388.0

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

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