PREVIEW / etf_daily / 2023-07-17

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-17.parquet
  size:    108 KB
  rows:    2,998

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
2023-07-17	SPY	ETF	449.13	451.93	449.08	450.84	52680200.0
2023-07-17	QQQ	ETF	379.8	383.5	379.31	382.61	40868915.0
2023-07-17	IWM	ETF	191.34	194.36	191.14	193.58	23283700.0
2023-07-17	DIA	ETF	344.56	346.7	344.22	345.85	2860000.0
2023-07-17	GLD	ETF	180.99	181.63	180.64	181.56	4152400.0
2023-07-17	TLT	ETF	101.23	101.49	100.92	101.34	18822000.0
2023-07-17	AAA	ETF	24.66	24.66	24.66	24.66	300.0
2023-07-17	AAAU	ETF	19.32	19.39	19.28	19.38	913100.0
2023-07-17	AADR	ETF	51.0	51.56	51.0	51.56	1200.0
2023-07-17	AAPB	ETF	28.68	29.2655	28.68	29.22	13467.0
2023-07-17	AAPD	ETF	20.3	20.32	20.06	20.09	58469.0
2023-07-17	AAPU	ETF	28.59	29.12	28.59	29.05	263769.0
2023-07-17	AAXJ	ETF	68.51	68.89	68.3	68.88	374200.0
2023-07-17	ABEQ	ETF	28.08	28.128	28.076	28.076	6600.0
2023-07-17	ACES	ETF	47.71	49.377	47.51	49.11	71600.0
2023-07-17	ACIO	ETF	31.374	31.487	31.374	31.42	98200.0
2023-07-17	ACSI	ETF	47.362	47.362	47.362	47.362	100.0
2023-07-17	ACT	ETF	26.41	26.96	26.37	26.79	204327.0
2023-07-17	ACTV	ETF	32.29	32.73	32.29	32.59	21600.0
2023-07-17	ACTX	ETF	0.21	0.21	0.21	0.21	585.0
2023-07-17	ACVF	ETF	34.36	34.47	34.32	34.46	5000.0
2023-07-17	ACWF	ETF	36.12	36.1757	36.1185	36.1757	5234.0
2023-07-17	ACWI	ETF	97.54	98.1	97.46	97.93	4090700.0
2023-07-17	ACWV	ETF	98.61	98.76	98.31	98.62	109200.0
2023-07-17	ACWX	ETF	50.17	50.44	50.11	50.42	1495500.0
2023-07-17	ADFI	ETF	8.48	8.5	8.48	8.485	43800.0
2023-07-17	ADIV	ETF	13.89	13.93	13.89	13.915	1000.0
2023-07-17	ADME	ETF	36.72	36.864	36.72	36.77	15100.0
2023-07-17	ADPV	ETF	25.68	25.855	25.68	25.7986	1932.0
2023-07-17	AEMB	ETF	37.885	37.885	37.885	37.885	100.0
2023-07-17	AESR	ETF	12.99	13.09	12.99	13.02	96200.0
2023-07-17	AFIF	ETF	8.86	8.89	8.83	8.85	384400.0
2023-07-17	AFK	ETF	15.43	15.81	15.43	15.5	17500.0
2023-07-17	AFLG	ETF	25.88	25.88	25.79	25.851	2600.0
2023-07-17	AFSM	ETF	25.401	25.401	25.401	25.401	100.0
2023-07-17	AFTY	ETF	15.16	15.19	15.16	15.171	900.0
2023-07-17	AGG	ETF	97.95	98.1	97.85	98.05	4689500.0
2023-07-17	AGGH	ETF	22.59	22.7	22.59	22.7	225107.0
2023-07-17	AGGY	ETF	43.2	43.259	43.17	43.22	123700.0
2023-07-17	AGNG	ETF	27.69	27.906	27.69	27.85	9600.0
2023-07-17	AGOV	ETF	75.655	75.655	75.655	75.655	1.0
2023-07-17	AGOX	ETF	24.04	24.12	23.86	23.99	25100.0
2023-07-17	AGQ	ETF	31.66	32.01	31.31	31.98	499800.0
2023-07-17	AGRH	ETF	25.65	25.65	25.61	25.615	2000.0
2023-07-17	AGZ	ETF	107.07	107.28	107.01	107.14	39700.0
2023-07-17	AGZD	ETF	22.095	22.175	22.05	22.105	118800.0
2023-07-17	AHYB	ETF	44.13	44.198	44.13	44.198	200.0
2023-07-17	AIA	ETF	61.73	62.18	61.52	62.12	22100.0
2023-07-17	AIEQ	ETF	31.96	32.2	31.902	32.126	15100.0
2023-07-17	AIQ	ETF	29.04	29.37	29.01	29.31	699700.0

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

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