PREVIEW / etf_daily / 2023-01-04

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-04.parquet
  size:    108 KB
  rows:    2,921

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-01-04	SPY	ETF	383.18	385.88	380.0	383.76	85934100.0
2023-01-04	QQQ	ETF	266.64	267.45	262.53	265.74	47754861.0
2023-01-04	IWM	ETF	174.62	176.67	174.28	175.56	22973500.0
2023-01-04	DIA	ETF	332.56	334.04	330.2	332.56	4137300.0
2023-01-04	GLD	ETF	172.86	173.09	171.85	172.67	7574600.0
2023-01-04	TLT	ETF	103.22	103.48	102.21	102.85	21678200.0
2023-01-04	AAA	ETF	24.37	24.37	24.37	24.37	19.0
2023-01-04	AAAU	ETF	18.43	18.45	18.34	18.41	185100.0
2023-01-04	AADR	ETF	47.32	47.53	47.31	47.53	700.0
2023-01-04	AAPB	ETF	14.84	14.84	14.44	14.6413	5574.0
2023-01-04	AAPD	ETF	30.93	31.35	30.5	31.0839	200657.0
2023-01-04	AAPU	ETF	16.07	16.3604	15.71	15.98	101869.0
2023-01-04	AAXJ	ETF	67.05	67.97	66.71	67.92	515200.0
2023-01-04	ABEQ	ETF	28.15	28.49	28.15	28.356	11200.0
2023-01-04	ACES	ETF	44.91	45.7	44.695	45.56	34900.0
2023-01-04	ACIO	ETF	28.95	28.95	28.68	28.76	44100.0
2023-01-04	ACSI	ETF	41.67	42.01	41.67	41.67	1869.0
2023-01-04	ACT	ETF	24.42	24.78	24.11	24.33	117647.0
2023-01-04	ACTV	ETF	29.53	30.1	29.5299	30.1	12611.0
2023-01-04	ACTX	ETF	0.4	0.4	0.4	0.4	200.0
2023-01-04	ACVF	ETF	29.894	29.894	29.68	29.807	300.0
2023-01-04	ACWF	ETF	31.92	32.15	31.81	32.065	25950.0
2023-01-04	ACWI	ETF	85.82	86.28	85.11	85.98	5696300.0
2023-01-04	ACWV	ETF	95.87	96.25	95.54	95.96	207400.0
2023-01-04	ACWX	ETF	46.51	46.77	46.24	46.7	1685560.0
2023-01-04	ADFI	ETF	8.39	8.405	8.38	8.4	4900.0
2023-01-04	ADIV	ETF	13.594	13.594	13.594	13.594	100.0
2023-01-04	ADME	ETF	33.46	33.48	33.36	33.397	34100.0
2023-01-04	ADPV	ETF	25.25	25.25	25.07	25.125	24103.0
2023-01-04	ADRE	ETF	38.29	39.16	38.27	39.005	5322.0
2023-01-04	AEMB	ETF	37.97	37.97	37.97	37.97	100.0
2023-01-04	AESR	ETF	11.37	11.48	11.34	11.44	6400.0
2023-01-04	AFIF	ETF	8.794	8.794	8.77	8.7873	14050.0
2023-01-04	AFK	ETF	16.4	16.54	16.205	16.5	6942.0
2023-01-04	AFLG	ETF	23.19	23.19	23.06	23.142	200.0
2023-01-04	AFMC	ETF	22.42	22.46	22.33	22.396	700.0
2023-01-04	AFSM	ETF	22.79	22.83	22.598	22.651	56200.0
2023-01-04	AFTY	ETF	16.142	16.142	16.142	16.142	100.0
2023-01-04	AGG	ETF	98.17	98.25	97.89	98.1	10080100.0
2023-01-04	AGGY	ETF	43.13	43.17	43.005	43.1	272700.0
2023-01-04	AGNG	ETF	26.38	26.587	26.38	26.531	1400.0
2023-01-04	AGOV	ETF	78.9053	78.9053	78.9053	78.9053	41.0
2023-01-04	AGOX	ETF	20.41	20.76	20.41	20.645	51900.0
2023-01-04	AGQ	ETF	32.7	32.92	30.93	31.45	1211400.0
2023-01-04	AGRH	ETF	25.36	25.36	25.3508	25.3508	296.0
2023-01-04	AGZ	ETF	107.06	107.11	106.91	106.91	9038.0
2023-01-04	AGZD	ETF	21.73	21.83	21.72	21.74	18000.0
2023-01-04	AHHX	ETF	8.43	8.4799	8.4012	8.432	2996.0
2023-01-04	AHYB	ETF	43.26	43.441	43.26	43.441	700.0
2023-01-04	AIA	ETF	59.89	61.0156	59.6	60.99	43247.0

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

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