PREVIEW / etf_daily / 2022-03-21

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-21.parquet
  size:    99 KB
  rows:    2,674

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
2022-03-21	SPY	ETF	444.34	446.46	440.68	444.39	88349800.0
2022-03-21	QQQ	ETF	350.2	352.48	345.575	350.08	73799072.0
2022-03-21	IWM	ETF	207.2	208.18	203.94	205.44	26747500.0
2022-03-21	DIA	ETF	346.61	347.93	343.3	345.44	4329900.0
2022-03-21	GLD	ETF	179.33	181.29	179.32	180.67	10582200.0
2022-03-21	TLT	ETF	131.28	131.67	129.75	130.35	26122000.0
2022-03-21	AAA	ETF	24.8541	24.865	24.8541	24.865	129.0
2022-03-21	AAAU	ETF	19.11	19.29	19.1	19.23	1043400.0
2022-03-21	AADR	ETF	58.67	59.0	58.67	58.87	10100.0
2022-03-21	AAXJ	ETF	75.24	75.4	74.36	74.94	1555100.0
2022-03-21	ABEQ	ETF	29.4	29.782	29.4	29.76	18300.0
2022-03-21	ACES	ETF	61.57	62.0	60.3	60.8	45600.0
2022-03-21	ACIO	ETF	31.27	31.27	31.01	31.16	62200.0
2022-03-21	ACSI	ETF	49.5439	49.5439	49.5439	49.5439	12.0
2022-03-21	ACT	ETF	22.18	22.63	21.58	22.36	103448.0
2022-03-21	ACTV	ETF	35.97	36.01	35.61	35.7753	3568.0
2022-03-21	ACTX	ETF	1.0	1.0	1.0	1.0	1846.0
2022-03-21	ACVF	ETF	33.5	33.528	33.38	33.412	4700.0
2022-03-21	ACWF	ETF	37.04	37.0492	36.71	36.9113	9527.0
2022-03-21	ACWI	ETF	98.74	99.06	97.88	98.58	4104200.0
2022-03-21	ACWV	ETF	103.65	104.15	103.2	103.71	236500.0
2022-03-21	ACWX	ETF	52.11	52.19	51.7	51.99	3147536.0
2022-03-21	ADFI	ETF	9.06	9.06	8.965	8.965	2600.0
2022-03-21	ADIV	ETF	15.43	15.52	15.4	15.463	2200.0
2022-03-21	ADME	ETF	40.73	40.73	40.31	40.55	33100.0
2022-03-21	ADRE	ETF	43.4457	43.675	43.11	43.57	7971.0
2022-03-21	AEMB	ETF	42.8	42.8	42.37	42.37	2800.0
2022-03-21	AESR	ETF	13.19	13.27	13.17	13.2	37400.0
2022-03-21	AFIF	ETF	9.23	9.23	9.18	9.18	23774.0
2022-03-21	AFK	ETF	21.1	21.185	20.89	21.155	9148.0
2022-03-21	AFLG	ETF	26.51	26.51	26.37	26.46	600.0
2022-03-21	AFMC	ETF	25.108	25.108	25.108	25.108	100.0
2022-03-21	AFSM	ETF	26.167	26.167	26.167	26.167	200.0
2022-03-21	AFTY	ETF	18.15	18.185	18.15	18.185	1700.0
2022-03-21	AGG	ETF	107.58	107.65	106.98	107.04	8024800.0
2022-03-21	AGGH	ETF	24.61	24.61	24.4687	24.4687	1506.0
2022-03-21	AGGY	ETF	48.18	48.23	47.975	48.02	142500.0
2022-03-21	AGNG	ETF	28.03	28.11	27.69	27.91	3000.0
2022-03-21	AGOV	ETF	87.87	87.87	85.585	85.585	13989.0
2022-03-21	AGOX	ETF	23.84	24.14	23.67	24.14	84500.0
2022-03-21	AGQ	ETF	39.17	40.36	39.17	40.04	780900.0
2022-03-21	AGZ	ETF	113.1299	113.16	112.88	112.88	51634.0
2022-03-21	AGZD	ETF	23.17	23.205	23.125	23.155	80000.0
2022-03-21	AHHX	ETF	9.49	9.58	9.49	9.5245	4812.0
2022-03-21	AHYB	ETF	47.251	47.251	47.228	47.228	400.0
2022-03-21	AIA	ETF	68.78	69.13	67.87	68.42	106132.0
2022-03-21	AIEQ	ETF	37.08	37.08	36.41	36.784	11900.0
2022-03-21	AIQ	ETF	26.6	26.7	26.3	26.5	10566.0
2022-03-21	AIRR	ETF	44.24	44.569	43.55	43.77	22300.0
2022-03-21	AIVI	ETF	40.51	40.51	40.22	40.3	5900.0

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

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