PREVIEW / etf_daily / 2023-03-24

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-24.parquet
  size:    109 KB
  rows:    2,942

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-03-24	SPY	ETF	391.84	395.84	389.4	395.75	107682400.0
2023-03-24	QQQ	ETF	309.32	310.99	306.95	310.89	57245803.0
2023-03-24	IWM	ETF	168.75	172.11	167.46	171.79	47519700.0
2023-03-24	DIA	ETF	319.45	322.46	317.91	322.32	4484900.0
2023-03-24	GLD	ETF	185.61	185.99	183.62	183.65	9245900.0
2023-03-24	TLT	ETF	107.09	107.43	106.26	106.85	23652700.0
2023-03-24	AAA	ETF	24.475	24.475	24.475	24.475	4.0
2023-03-24	AAAU	ETF	19.81	19.84	19.6	19.6	2511600.0
2023-03-24	AADR	ETF	45.52	45.94	45.52	45.94	600.0
2023-03-24	AAPB	ETF	21.4103	21.63	21.4103	21.6119	2816.0
2023-03-24	AAPD	ETF	24.55	24.62	24.3	24.3	82171.0
2023-03-24	AAPU	ETF	22.07	22.39	21.88	22.39	97676.0
2023-03-24	AAXJ	ETF	66.53	66.8	66.39	66.78	242000.0
2023-03-24	ABEQ	ETF	27.1	27.32	27.061	27.303	11000.0
2023-03-24	ACES	ETF	43.41	43.81	42.87	43.74	43500.0
2023-03-24	ACIO	ETF	29.38	29.7	29.38	29.7	254500.0
2023-03-24	ACSI	ETF	42.7875	42.7875	42.7875	42.7875	39.0
2023-03-24	ACT	ETF	21.5	22.37	21.455	22.32	92025.0
2023-03-24	ACTV	ETF	28.07	28.41	27.95	28.41	9298.0
2023-03-24	ACTX	ETF	0.337	0.337	0.2935	0.2935	657.0
2023-03-24	ACVF	ETF	30.28	30.428	30.1	30.409	3700.0
2023-03-24	ACWF	ETF	32.37	32.5393	32.25	32.52	3441.0
2023-03-24	ACWI	ETF	87.36	88.11	86.94	88.06	5883400.0
2023-03-24	ACWV	ETF	93.81	94.87	93.8	94.83	150400.0
2023-03-24	ACWX	ETF	46.85	47.17	46.72	47.15	1773142.0
2023-03-24	ADFI	ETF	8.51	8.52	8.481	8.504	20500.0
2023-03-24	ADME	ETF	33.805	33.98	33.805	33.91	10500.0
2023-03-24	ADPV	ETF	22.79	22.79	22.75	22.775	15645.0
2023-03-24	ADRE	ETF	38.11	38.1899	37.3	38.1	159893.0
2023-03-24	AEMB	ETF	37.569	37.569	37.569	37.569	100.0
2023-03-24	AESR	ETF	11.42	11.63	11.42	11.62	37000.0
2023-03-24	AFIF	ETF	8.7701	8.7999	8.73	8.73	20750.0
2023-03-24	AFK	ETF	15.3	15.49	15.28	15.43	18740.0
2023-03-24	AFLG	ETF	23.144	23.144	23.144	23.144	100.0
2023-03-24	AFMC	ETF	21.84	22.185	21.84	22.185	400.0
2023-03-24	AFSM	ETF	22.116	22.483	22.116	22.483	400.0
2023-03-24	AFTY	ETF	16.146	16.146	16.146	16.146	100.0
2023-03-24	AGG	ETF	100.28	100.49	99.95	100.16	6217700.0
2023-03-24	AGGY	ETF	44.02	44.12	43.94	43.95	130100.0
2023-03-24	AGNG	ETF	25.9	26.2	25.9	26.2	1000.0
2023-03-24	AGOV	ETF	78.32	78.32	77.42	77.42	1928.0
2023-03-24	AGOX	ETF	20.9	21.04	20.81	20.999	6600.0
2023-03-24	AGQ	ETF	29.64	29.8	28.75	28.82	783800.0
2023-03-24	AGZ	ETF	109.18	109.18	108.7211	108.76	31685.0
2023-03-24	AGZD	ETF	21.65	21.75	21.63	21.685	85400.0
2023-03-24	AHHX	ETF	8.4	8.41	8.27	8.34	30935.0
2023-03-24	AHYB	ETF	43.199	43.242	43.199	43.242	300.0
2023-03-24	AIA	ETF	60.2	60.59	60.18	60.57	26223.0
2023-03-24	AIEQ	ETF	28.33	28.48	28.16	28.392	7800.0
2023-03-24	AIQ	ETF	23.42	23.56	23.24	23.4381	49539.0

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

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