PREVIEW / etf_daily / 2023-07-27

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-27.parquet
  size:    107 KB
  rows:    2,991

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-27	SPY	ETF	459.02	459.44	451.55	452.49	92194400.0
2023-07-27	QQQ	ETF	383.07	384.71	375.31	376.62	63940225.0
2023-07-27	IWM	ETF	197.63	197.9	193.18	193.92	31159300.0
2023-07-27	DIA	ETF	355.86	356.36	352.04	352.77	4771000.0
2023-07-27	GLD	ETF	181.64	181.64	180.32	180.42	7592800.0
2023-07-27	TLT	ETF	100.71	100.93	98.91	99.3	44794400.0
2023-07-27	AAA	ETF	24.745	24.745	24.745	24.745	100.0
2023-07-27	AAAU	ETF	19.4	19.4	19.25	19.27	1485100.0
2023-07-27	AADR	ETF	52.51	52.52	51.67	51.67	1800.0
2023-07-27	AAPB	ETF	29.75	29.9099	28.8	28.93	6099.0
2023-07-27	AAPD	ETF	19.88	20.2797	19.815	20.22	134984.0
2023-07-27	AAPU	ETF	29.48	29.73	28.68	28.84	112558.0
2023-07-27	AAXJ	ETF	69.5	69.5	68.56	68.66	243100.0
2023-07-27	ABEQ	ETF	28.74	28.75	28.54	28.54	7500.0
2023-07-27	ACES	ETF	48.61	48.61	46.6	46.755	21300.0
2023-07-27	ACIO	ETF	31.86	31.885	31.49	31.55	54400.0
2023-07-27	ACSI	ETF	48.31	48.31	47.583	47.583	200.0
2023-07-27	ACT	ETF	27.68	27.68	27.21	27.31	407508.0
2023-07-27	ACTV	ETF	33.4	33.44	32.82	32.9	3400.0
2023-07-27	ACVF	ETF	35.0	35.0	34.5	34.502	9100.0
2023-07-27	ACWF	ETF	36.65	36.65	36.19	36.2195	7138.0
2023-07-27	ACWI	ETF	99.53	99.53	97.99	98.17	3035900.0
2023-07-27	ACWV	ETF	100.37	100.49	99.3	99.36	77700.0
2023-07-27	ACWX	ETF	51.13	51.13	50.49	50.53	982700.0
2023-07-27	ADFI	ETF	8.46	8.46	8.42	8.435	1900.0
2023-07-27	ADIV	ETF	13.977	13.977	13.977	13.977	100.0
2023-07-27	ADME	ETF	37.36	37.37	36.88	36.94	33200.0
2023-07-27	ADPV	ETF	25.88	25.93	25.4	25.4551	7548.0
2023-07-27	AEMB	ETF	37.8	37.8	37.6	37.6	100.0
2023-07-27	AESR	ETF	13.14	13.18	13.01	13.02	9400.0
2023-07-27	AFIF	ETF	8.9	8.9	8.85	8.86	30900.0
2023-07-27	AFK	ETF	15.72	15.72	15.6	15.6	10300.0
2023-07-27	AFLG	ETF	26.25	26.25	25.905	25.905	400.0
2023-07-27	AFMC	ETF	25.48	25.48	25.403	25.403	1200.0
2023-07-27	AFSM	ETF	25.616	25.616	25.616	25.616	100.0
2023-07-27	AFTY	ETF	15.48	15.48	15.48	15.48	100.0
2023-07-27	AGG	ETF	97.84	97.93	97.11	97.18	6937900.0
2023-07-27	AGGH	ETF	22.4	22.4	22.21	22.21	13709.0
2023-07-27	AGGY	ETF	43.04	43.05	42.72	42.75	421700.0
2023-07-27	AGNG	ETF	27.88	27.88	27.771	27.771	600.0
2023-07-27	AGOV	ETF	76.04	77.07	75.56	75.79	5742.0
2023-07-27	AGOX	ETF	24.235	24.235	23.78	23.82	29700.0
2023-07-27	AGQ	ETF	30.97	31.01	29.74	29.91	1228000.0
2023-07-27	AGRH	ETF	25.76	25.76	25.76	25.76	155.0
2023-07-27	AGZ	ETF	106.87	106.91	106.58	106.63	18100.0
2023-07-27	AGZD	ETF	22.16	22.19	22.12	22.16	137600.0
2023-07-27	AHYB	ETF	44.37	44.37	44.029	44.029	1000.0
2023-07-27	AIA	ETF	62.18	62.27	61.3	61.41	79400.0
2023-07-27	AIEQ	ETF	32.94	32.94	32.37	32.37	14900.0
2023-07-27	AIQ	ETF	29.46	29.48	28.721	28.85	396000.0

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

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