PREVIEW / etf_daily / 2022-09-12

all etf daily files

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

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-12	SPY	ETF	408.78	411.73	408.46	410.97	69256300.0
2022-09-12	QQQ	ETF	308.5	311.08	308.18	310.74	45905737.0
2022-09-12	IWM	ETF	188.6	189.86	187.97	189.67	23134600.0
2022-09-12	DIA	ETF	323.29	325.68	323.21	324.57	2486900.0
2022-09-12	GLD	ETF	161.04	161.62	160.55	160.63	4537500.0
2022-09-12	TLT	ETF	108.63	108.89	106.92	107.42	14806900.0
2022-09-12	AAA	ETF	24.31	24.31	24.31	24.31	84.0
2022-09-12	AAAU	ETF	17.17	17.22	17.11	17.12	1994000.0
2022-09-12	AADR	ETF	50.44	50.44	50.44	50.44	200.0
2022-09-12	AAPB	ETF	23.63	24.51	23.6299	24.31	8310.0
2022-09-12	AAPD	ETF	25.77	25.77	24.98	25.1161	80746.0
2022-09-12	AAPU	ETF	23.62	24.65	23.62	24.49	63923.0
2022-09-12	AAXJ	ETF	66.42	66.95	66.35	66.87	677800.0
2022-09-12	ABEQ	ETF	27.27	27.27	27.179	27.213	12500.0
2022-09-12	ACES	ETF	66.63	66.884	65.43	66.83	63200.0
2022-09-12	ACIO	ETF	30.506	30.506	30.357	30.49	26800.0
2022-09-12	ACSI	ETF	47.1887	47.1887	47.1887	47.1887	59.0
2022-09-12	ACT	ETF	25.3	25.72	25.3	25.39	225697.0
2022-09-12	ACTV	ETF	30.58	30.78	30.56	30.6614	35244.0
2022-09-12	ACVF	ETF	30.81	30.9	30.76	30.798	3000.0
2022-09-12	ACWF	ETF	32.95	33.0615	32.94	33.03	5359.0
2022-09-12	ACWI	ETF	88.33	88.99	88.32	88.81	5561400.0
2022-09-12	ACWV	ETF	97.35	97.61	97.05	97.33	538300.0
2022-09-12	ACWX	ETF	45.13	45.35	45.045	45.24	2156336.0
2022-09-12	ADFI	ETF	8.52	8.52	8.49	8.502	5900.0
2022-09-12	ADIV	ETF	13.521	13.55	13.521	13.55	300.0
2022-09-12	ADME	ETF	35.7	36.13	35.7	36.09	12400.0
2022-09-12	ADRE	ETF	39.69	39.97	39.69	39.91	2826.0
2022-09-12	AEMB	ETF	38.26	38.26	38.157	38.157	100.0
2022-09-12	AESR	ETF	11.93	11.99	11.93	11.96	6600.0
2022-09-12	AFIF	ETF	8.935	8.94	8.92	8.92	6916.0
2022-09-12	AFK	ETF	17.04	17.0599	16.9706	17.05	8950.0
2022-09-12	AFLG	ETF	24.24	24.326	24.24	24.326	500.0
2022-09-12	AFMC	ETF	22.86	22.86	22.86	22.86	100.0
2022-09-12	AFSM	ETF	23.21	23.291	23.21	23.291	100.0
2022-09-12	AFTY	ETF	16.689	16.689	16.689	16.689	100.0
2022-09-12	AGG	ETF	100.0	100.09	99.51	99.63	8535500.0
2022-09-12	AGGH	ETF	23.2099	23.21	23.0863	23.0863	1300.0
2022-09-12	AGGY	ETF	44.08	44.13	43.881	43.94	73600.0
2022-09-12	AGNG	ETF	25.88	25.92	25.73	25.795	2400.0
2022-09-12	AGOV	ETF	81.58	81.6463	81.58	81.6463	100.0
2022-09-12	AGOX	ETF	21.79	21.82	21.66	21.82	9600.0
2022-09-12	AGQ	ETF	22.44	23.08	21.99	22.5	2221000.0
2022-09-12	AGZ	ETF	108.82	108.82	108.425	108.51	24593.0
2022-09-12	AGZD	ETF	22.885	22.97	22.885	22.94	27600.0
2022-09-12	AHHX	ETF	8.745	8.745	8.7	8.7298	582.0
2022-09-12	AHYB	ETF	44.105	44.113	44.105	44.113	200.0
2022-09-12	AIA	ETF	57.46	57.9872	57.452	57.87	22382.0
2022-09-12	AIEQ	ETF	34.38	34.561	34.14	34.545	7100.0
2022-09-12	AIQ	ETF	21.98	22.2	21.98	22.1	15526.0

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

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