PREVIEW / etf_daily / 2022-09-08

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-08.parquet
  size:    102 KB
  rows:    2,761

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-08	SPY	ETF	395.39	400.86	394.12	400.38	80821700.0
2022-09-08	QQQ	ETF	296.85	301.87	295.45	300.52	55649821.0
2022-09-08	IWM	ETF	180.69	183.79	179.62	183.71	25273200.0
2022-09-08	DIA	ETF	314.69	318.4	313.68	318.24	3301100.0
2022-09-08	GLD	ETF	159.54	159.86	158.71	158.98	4607100.0
2022-09-08	TLT	ETF	108.84	109.52	108.05	108.07	14671400.0
2022-09-08	AAA	ETF	24.33	24.33	24.33	24.33	2.0
2022-09-08	AAAU	ETF	17.01	17.04	16.91	16.95	1238200.0
2022-09-08	AADR	ETF	49.05	49.35	49.05	49.35	800.0
2022-09-08	AAPB	ETF	21.86	22.13	21.86	22.13	2253.0
2022-09-08	AAPD	ETF	26.56	26.9049	26.301	26.653	53573.0
2022-09-08	AAPU	ETF	22.64	22.9	22.1204	22.55	17503.0
2022-09-08	AAXJ	ETF	64.74	65.11	64.51	65.08	452300.0
2022-09-08	ABEQ	ETF	26.52	26.67	26.51	26.67	10900.0
2022-09-08	ACES	ETF	64.28	65.92	64.28	65.9	40700.0
2022-09-08	ACIO	ETF	29.58	29.98	29.58	29.94	28600.0
2022-09-08	ACSI	ETF	45.8115	45.8115	45.8115	45.8115	45.0
2022-09-08	ACT	ETF	24.54	24.98	24.34	24.78	262850.0
2022-09-08	ACTV	ETF	29.57	29.91	29.57	29.8545	2625.0
2022-09-08	ACVF	ETF	30.07	30.13	29.8	30.107	2100.0
2022-09-08	ACWF	ETF	31.79	32.17	31.79	32.1301	10342.0
2022-09-08	ACWI	ETF	85.2	86.21	84.88	86.14	4237600.0
2022-09-08	ACWV	ETF	94.58	95.64	94.58	95.6	200100.0
2022-09-08	ACWX	ETF	43.2	43.665	43.1	43.64	2155393.0
2022-09-08	ADFI	ETF	8.5	8.5	8.48	8.495	23300.0
2022-09-08	ADIV	ETF	13.159	13.159	13.159	13.159	100.0
2022-09-08	ADME	ETF	34.9	35.44	34.9	35.43	15800.0
2022-09-08	ADRE	ETF	38.13	38.6897	38.13	38.63	2885.0
2022-09-08	AEMB	ETF	37.935	37.935	37.935	37.935	100.0
2022-09-08	AESR	ETF	11.58	11.7	11.58	11.68	24500.0
2022-09-08	AFIF	ETF	8.92	8.94	8.91	8.93	46916.0
2022-09-08	AFK	ETF	16.49	16.49	16.29	16.43	9160.0
2022-09-08	AFLG	ETF	23.749	23.749	23.749	23.749	100.0
2022-09-08	AFMC	ETF	22.25	22.25	22.25	22.25	100.0
2022-09-08	AFSM	ETF	22.639	22.639	22.639	22.639	100.0
2022-09-08	AFTY	ETF	16.31	16.346	16.27	16.346	600.0
2022-09-08	AGG	ETF	100.0	100.18	99.79	99.79	5546200.0
2022-09-08	AGGH	ETF	23.27	23.27	23.2388	23.2388	2085.0
2022-09-08	AGGY	ETF	44.09	44.19	44.0	44.0	98900.0
2022-09-08	AGNG	ETF	25.071	25.257	25.01	25.257	4600.0
2022-09-08	AGOV	ETF	80.28	80.6	80.25	80.6	1322.0
2022-09-08	AGOX	ETF	20.97	21.18	20.97	21.18	13000.0
2022-09-08	AGQ	ETF	19.67	19.86	19.29	19.7	897300.0
2022-09-08	AGZ	ETF	108.73	108.87	108.64	108.64	22244.0
2022-09-08	AGZD	ETF	22.915	22.935	22.88	22.91	77000.0
2022-09-08	AHHX	ETF	8.6	8.6142	8.6	8.6142	989.0
2022-09-08	AHYB	ETF	43.655	43.815	43.655	43.815	300.0
2022-09-08	AIA	ETF	55.69	56.19	55.6	56.01	31120.0
2022-09-08	AIEQ	ETF	32.488	33.073	32.488	33.073	2300.0
2022-09-08	AIQ	ETF	20.95	21.34	20.95	21.2	174997.0

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

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