PREVIEW / etf_daily / 2023-07-18

all etf daily files

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

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-18	SPY	ETF	450.5	454.86	450.05	454.19	80744400.0
2023-07-18	QQQ	ETF	381.96	387.13	380.0	385.74	55343438.0
2023-07-18	IWM	ETF	193.7	196.39	193.49	195.97	28551500.0
2023-07-18	DIA	ETF	345.65	349.91	345.25	349.58	4626600.0
2023-07-18	GLD	ETF	182.79	184.23	182.32	183.64	8242600.0
2023-07-18	TLT	ETF	101.8	102.07	101.57	101.8	15412800.0
2023-07-18	AAA	ETF	24.64	24.64	24.64	24.64	100.0
2023-07-18	AAAU	ETF	19.51	19.67	19.46	19.61	708300.0
2023-07-18	AADR	ETF	51.36	51.42	51.36	51.42	8700.0
2023-07-18	AAPB	ETF	28.939	29.169	28.8	29.16	4972.0
2023-07-18	AAPD	ETF	20.15	20.2599	20.085	20.14	45572.0
2023-07-18	AAPU	ETF	28.94	29.11	28.71	28.97	132716.0
2023-07-18	AAXJ	ETF	68.46	68.53	68.02	68.22	212600.0
2023-07-18	ABEQ	ETF	28.22	28.355	28.205	28.266	3000.0
2023-07-18	ACES	ETF	49.31	50.187	49.31	49.41	85500.0
2023-07-18	ACIO	ETF	31.29	31.6	31.29	31.55	115700.0
2023-07-18	ACSI	ETF	47.84	47.889	47.84	47.889	1100.0
2023-07-18	ACT	ETF	26.89	27.135	26.5	26.95	344530.0
2023-07-18	ACTV	ETF	32.61	33.04	32.61	33.0	14500.0
2023-07-18	ACVF	ETF	34.53	34.85	34.519	34.81	34800.0
2023-07-18	ACWF	ETF	36.29	36.4	36.28	36.365	4874.0
2023-07-18	ACWI	ETF	97.85	98.57	97.75	98.48	3427400.0
2023-07-18	ACWV	ETF	98.57	99.06	98.41	98.71	559300.0
2023-07-18	ACWX	ETF	50.39	50.63	50.31	50.54	320200.0
2023-07-18	ADFI	ETF	8.495	8.5	8.49	8.495	9400.0
2023-07-18	ADIV	ETF	13.84	13.894	13.84	13.894	300.0
2023-07-18	ADME	ETF	36.6	37.04	36.6	37.001	101400.0
2023-07-18	ADPV	ETF	25.92	26.05	25.92	26.0453	19675.0
2023-07-18	AEMB	ETF	38.05	38.05	38.03	38.03	5500.0
2023-07-18	AESR	ETF	13.08	13.15	13.08	13.136	25300.0
2023-07-18	AFIF	ETF	8.84	8.84	8.8	8.82	19600.0
2023-07-18	AFK	ETF	15.5	15.75	15.5	15.7	9200.0
2023-07-18	AFLG	ETF	26.055	26.055	26.023	26.023	300.0
2023-07-18	AFMC	ETF	25.807	25.807	25.807	25.807	100.0
2023-07-18	AFSM	ETF	25.758	25.772	25.665	25.772	1500.0
2023-07-18	AFTY	ETF	15.13	15.13	15.02	15.03	4500.0
2023-07-18	AGG	ETF	98.33	98.41	98.13	98.13	5593200.0
2023-07-18	AGGH	ETF	23.93	23.93	22.5701	22.68	337973.0
2023-07-18	AGGY	ETF	43.34	43.385	43.27	43.27	148700.0
2023-07-18	AGNG	ETF	27.85	27.98	27.81	27.9	2300.0
2023-07-18	AGOV	ETF	77.71	79.11	76.4	77.08	5718.0
2023-07-18	AGOX	ETF	24.12	24.245	23.97	24.12	126500.0
2023-07-18	AGQ	ETF	31.99	32.82	31.76	32.47	632100.0
2023-07-18	AGRH	ETF	25.68	25.6899	25.635	25.635	1325.0
2023-07-18	AGZ	ETF	107.18	107.3	107.08	107.1	13800.0
2023-07-18	AGZD	ETF	22.13	22.17	22.085	22.13	31400.0
2023-07-18	AHOY	ETF	20.94	21.02	20.94	21.0021	757.0
2023-07-18	AHYB	ETF	44.34	44.34	44.31	44.31	200.0
2023-07-18	AIA	ETF	61.34	61.52	61.01	61.07	43500.0
2023-07-18	AIEQ	ETF	32.05	32.31	32.0	32.09	15200.0

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

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