PREVIEW / etf_daily / 2023-03-22

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-22.parquet
  size:    110 KB
  rows:    2,946

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-22	SPY	ETF	398.73	402.49	392.07	392.11	111746600.0
2023-03-22	QQQ	ETF	310.27	315.25	305.95	306.12	75791914.0
2023-03-22	IWM	ETF	176.52	177.35	171.53	171.64	56098200.0
2023-03-22	DIA	ETF	325.65	327.56	320.06	320.18	4378700.0
2023-03-22	GLD	ETF	180.4	183.94	180.28	183.44	11969600.0
2023-03-22	TLT	ETF	104.66	106.45	104.44	106.4	26388500.0
2023-03-22	AAA	ETF	24.46	24.46	24.46	24.46	706.0
2023-03-22	AAAU	ETF	19.25	19.63	19.24	19.57	2997300.0
2023-03-22	AADR	ETF	46.54	47.01	46.3	46.3	7400.0
2023-03-22	AAPB	ETF	21.456	21.88	21.2174	21.2174	3738.0
2023-03-22	AAPD	ETF	24.43	24.67	24.02	24.58	217444.0
2023-03-22	AAPU	ETF	22.16	22.78	21.87	21.9	196279.0
2023-03-22	AAXJ	ETF	66.18	66.9	65.88	65.92	1494800.0
2023-03-22	ABEQ	ETF	27.5	27.58	27.23	27.23	13900.0
2023-03-22	ACES	ETF	45.06	45.13	43.84	43.84	14800.0
2023-03-22	ACIO	ETF	29.61	29.905	29.577	29.577	21600.0
2023-03-22	ACSI	ETF	43.0019	43.0019	43.0019	43.0019	42.0
2023-03-22	ACT	ETF	22.4	22.635	21.93	21.93	68736.0
2023-03-22	ACTV	ETF	29.1	29.1599	28.48	28.48	11280.0
2023-03-22	ACVF	ETF	30.87	30.87	30.293	30.293	3600.0
2023-03-22	ACWF	ETF	32.81	33.0912	32.51	32.5397	8695.0
2023-03-22	ACWI	ETF	88.65	89.58	87.59	87.62	3106200.0
2023-03-22	ACWV	ETF	94.27	94.83	93.66	93.66	117300.0
2023-03-22	ACWX	ETF	47.35	47.9	47.095	47.11	1478442.0
2023-03-22	ADFI	ETF	8.43	8.54	8.43	8.53	21100.0
2023-03-22	ADIV	ETF	13.687	13.687	13.687	13.687	100.0
2023-03-22	ADME	ETF	34.1	34.16	33.74	33.74	10900.0
2023-03-22	ADPV	ETF	22.8	22.83	22.78	22.83	13576.0
2023-03-22	ADRE	ETF	38.2	38.29	38.11	38.15	7877.0
2023-03-22	AEMB	ETF	37.736	37.736	37.736	37.736	100.0
2023-03-22	AESR	ETF	11.66	11.71	11.51	11.51	25200.0
2023-03-22	AFIF	ETF	8.73	8.809	8.71	8.7947	14805.0
2023-03-22	AFK	ETF	15.47	15.47	15.12	15.26	17355.0
2023-03-22	AFLG	ETF	23.5	23.5	23.172	23.172	100.0
2023-03-22	AFMC	ETF	22.69	22.77	22.211	22.211	4000.0
2023-03-22	AGG	ETF	98.8	99.82	98.64	99.75	7585400.0
2023-03-22	AGGH	ETF	21.2	22.9489	21.2	22.9489	415.0
2023-03-22	AGGY	ETF	43.41	43.88	43.38	43.73	528700.0
2023-03-22	AGOV	ETF	73.43	75.245	73.43	75.245	222.0
2023-03-22	AGOX	ETF	21.2	21.3	20.982	20.982	14100.0
2023-03-22	AGQ	ETF	26.96	28.76	26.91	28.38	1107900.0
2023-03-22	AGZ	ETF	107.65	108.33	107.605	108.08	158415.0
2023-03-22	AGZD	ETF	21.8	21.925	21.7	21.775	205200.0
2023-03-22	AHHX	ETF	8.39	8.39	8.3	8.33	3936.0
2023-03-22	AHYB	ETF	43.31	43.52	43.31	43.383	1000.0
2023-03-22	AIA	ETF	59.3	60.14	59.19	59.24	47599.0
2023-03-22	AIEQ	ETF	28.99	29.036	28.26	28.261	13200.0
2023-03-22	AIQ	ETF	23.38	23.67	23.12	23.12	44938.0
2023-03-22	AIRR	ETF	47.56	47.7	46.29	46.32	179600.0
2023-03-22	AIVI	ETF	38.27	38.65	38.15	38.15	1900.0

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

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