PREVIEW / etf_daily / 2023-08-17

all etf daily files

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

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-08-17	SPY	ETF	441.16	441.43	435.75	436.29	95711300.0
2023-08-17	QQQ	ETF	363.96	364.31	358.16	358.58	62604338.0
2023-08-17	IWM	ETF	186.34	186.74	183.63	183.65	26715100.0
2023-08-17	DIA	ETF	348.95	349.32	344.82	345.06	4804100.0
2023-08-17	GLD	ETF	176.53	176.56	174.93	175.3	7937700.0
2023-08-17	TLT	ETF	93.5	93.61	93.02	93.44	32244900.0
2023-08-17	AAA	ETF	24.83	24.84	24.81	24.81	4800.0
2023-08-17	AAAU	ETF	18.85	18.86	18.68	18.71	4161200.0
2023-08-17	AADR	ETF	50.0	50.94	50.0	50.18	1300.0
2023-08-17	AAPB	ETF	24.47	24.47	23.83	23.97	30149.0
2023-08-17	AAPD	ETF	22.07	22.51	22.01	22.46	255430.0
2023-08-17	AAPU	ETF	25.2	25.27	24.44	24.55	193643.0
2023-08-17	AAXJ	ETF	65.19	65.33	64.61	64.68	1401400.0
2023-08-17	ABEQ	ETF	27.92	27.93	27.77	27.791	8500.0
2023-08-17	ACES	ETF	40.88	40.88	40.02	40.02	26500.0
2023-08-17	ACIO	ETF	31.0	31.088	30.868	30.899	59700.0
2023-08-17	ACSI	ETF	46.1	46.1	45.604	45.604	700.0
2023-08-17	ACT	ETF	28.49	28.55	28.19	28.51	173082.0
2023-08-17	ACTV	ETF	31.62	31.73	31.401	31.401	7800.0
2023-08-17	ACVF	ETF	34.26	34.26	33.63	33.63	5400.0
2023-08-17	ACWF	ETF	35.03	35.03	34.65	34.6553	16823.0
2023-08-17	ACWI	ETF	94.75	94.83	93.66	93.77	2662700.0
2023-08-17	ACWV	ETF	97.64	97.64	96.67	96.67	179400.0
2023-08-17	ACWX	ETF	48.2	48.26	47.67	47.74	918900.0
2023-08-17	ADFI	ETF	8.29	8.3	8.28	8.285	15800.0
2023-08-17	ADIV	ETF	13.338	13.338	13.338	13.338	100.0
2023-08-17	ADME	ETF	36.17	36.2	35.839	35.921	16800.0
2023-08-17	ADPV	ETF	24.3	24.335	23.9753	23.9753	596.0
2023-08-17	AEMB	ETF	36.76	36.76	36.73	36.73	500.0
2023-08-17	AESR	ETF	12.58	12.61	12.49	12.49	17100.0
2023-08-17	AFIF	ETF	8.83	8.88	8.83	8.84	12800.0
2023-08-17	AFK	ETF	14.7	15.0	14.66	14.67	9800.0
2023-08-17	AFLG	ETF	25.02	25.02	25.02	25.02	100.0
2023-08-17	AFMC	ETF	24.707	24.707	24.37	24.427	1900.0
2023-08-17	AFSM	ETF	24.457	24.457	24.457	24.457	100.0
2023-08-17	AFTY	ETF	15.01	15.01	14.976	14.976	1100.0
2023-08-17	AGG	ETF	95.5	95.55	95.21	95.41	8162300.0
2023-08-17	AGGH	ETF	21.89	21.98	21.88	21.95	22620.0
2023-08-17	AGGY	ETF	42.2	42.22	42.08	42.17	79500.0
2023-08-17	AGNG	ETF	27.27	27.27	27.025	27.025	1500.0
2023-08-17	AGOV	ETF	74.58	76.71	74.34	74.34	3535.0
2023-08-17	AGOX	ETF	23.175	23.23	22.93	22.947	15400.0
2023-08-17	AGQ	ETF	26.87	26.88	26.0	26.24	626200.0
2023-08-17	AGZ	ETF	106.19	106.34	106.13	106.34	799500.0
2023-08-17	AGZD	ETF	22.15	22.24	22.11	22.17	66500.0
2023-08-17	AHOY	ETF	20.32	20.32	20.1711	20.1711	181.0
2023-08-17	AHYB	ETF	43.728	43.728	43.575	43.575	700.0
2023-08-17	AIA	ETF	57.66	57.68	56.93	57.01	48000.0
2023-08-17	AIEQ	ETF	31.17	31.17	30.765	30.806	7500.0
2023-08-17	AIQ	ETF	27.36	27.42	26.92	26.95	347200.0

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

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