PREVIEW / etf_daily / 2022-10-07

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-07.parquet
  size:    104 KB
  rows:    2,831

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-10-07	SPY	ETF	368.97	373.29	360.94	362.79	107789500.0
2022-10-07	QQQ	ETF	275.02	275.15	267.74	269.1	71354674.0
2022-10-07	IWM	ETF	171.93	172.47	167.92	168.61	26536100.0
2022-10-07	DIA	ETF	296.73	296.89	291.44	292.97	3029300.0
2022-10-07	GLD	ETF	158.46	158.98	157.68	157.88	5030000.0
2022-10-07	TLT	ETF	100.81	101.62	100.47	100.99	14814800.0
2022-10-07	AAA	ETF	24.0813	24.11	24.0813	24.11	312.0
2022-10-07	AAAU	ETF	16.88	16.94	16.81	16.83	79800.0
2022-10-07	AADR	ETF	45.68	45.68	45.34	45.34	5200.0
2022-10-07	AAPB	ETF	18.7999	18.8	18.32	18.35	3739.0
2022-10-07	AAPD	ETF	28.54	29.0885	28.41	28.98	122298.0
2022-10-07	AAPU	ETF	19.75	19.8	19.14	19.25	61935.0
2022-10-07	AAXJ	ETF	60.21	60.3	59.33	59.39	314800.0
2022-10-07	ABEQ	ETF	25.536	25.56	25.37	25.43	10600.0
2022-10-07	ACES	ETF	54.38	54.62	52.69	52.99	144700.0
2022-10-07	ACIO	ETF	28.65	28.666	28.39	28.46	36000.0
2022-10-07	ACSI	ETF	41.4142	41.4142	41.4142	41.4142	27.0
2022-10-07	ACT	ETF	23.31	23.34	22.98	23.15	114221.0
2022-10-07	ACTV	ETF	27.46	27.47	27.18	27.2994	7947.0
2022-10-07	ACTX	ETF	0.5	0.5	0.5	0.5	300.0
2022-10-07	ACVF	ETF	27.92	27.92	27.32	27.35	3500.0
2022-10-07	ACWF	ETF	30.1	30.1	29.8549	29.9516	17646.0
2022-10-07	ACWI	ETF	80.33	80.35	78.69	79.02	7158700.0
2022-10-07	ACWV	ETF	89.56	89.8	88.43	88.82	251800.0
2022-10-07	ACWX	ETF	41.1	41.18	40.525	40.65	2042515.0
2022-10-07	ADFI	ETF	8.216	8.238	8.21	8.215	3200.0
2022-10-07	ADIV	ETF	11.982	12.009	11.943	11.943	1200.0
2022-10-07	ADME	ETF	33.21	33.51	33.21	33.34	21100.0
2022-10-07	ADRE	ETF	35.99	36.1	35.35	35.35	7067.0
2022-10-07	AEMB	ETF	35.485	35.485	35.485	35.485	100.0
2022-10-07	AESR	ETF	10.93	10.93	10.75	10.8	53400.0
2022-10-07	AFIF	ETF	8.69	8.69	8.65	8.655	54399.0
2022-10-07	AFK	ETF	15.5283	15.5283	15.226	15.31	7818.0
2022-10-07	AFLG	ETF	21.946	21.946	21.946	21.946	100.0
2022-10-07	AFSM	ETF	21.58	21.6	21.34	21.366	13700.0
2022-10-07	AGG	ETF	95.81	96.01	95.68	95.77	6149600.0
2022-10-07	AGGH	ETF	22.49	22.49	22.4	22.4002	286.0
2022-10-07	AGGY	ETF	42.11	42.18	41.93	42.07	819100.0
2022-10-07	AGNG	ETF	23.95	23.95	23.719	23.719	300.0
2022-10-07	AGOV	ETF	78.04	78.37	77.55	78.37	2995.0
2022-10-07	AGOX	ETF	19.81	19.9	19.63	19.69	15200.0
2022-10-07	AGQ	ETF	23.89	24.1	22.87	23.09	1370900.0
2022-10-07	AGZ	ETF	106.0	106.14	106.0	106.01	15548.0
2022-10-07	AGZD	ETF	22.855	22.885	22.745	22.85	95200.0
2022-10-07	AHHX	ETF	8.19	8.216	8.13	8.1931	12176.0
2022-10-07	AHYB	ETF	42.2	42.2	41.99	42.005	400.0
2022-10-07	AIA	ETF	52.08	52.25	51.28	51.33	45667.0
2022-10-07	AIEQ	ETF	30.46	30.46	29.61	29.734	4300.0
2022-10-07	AIQ	ETF	19.89	19.89	19.35	19.35	8194.0
2022-10-07	AIRR	ETF	40.32	40.32	39.49	39.61	10700.0

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

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