PREVIEW / etf_daily / 2022-03-23

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-23.parquet
  size:    100 KB
  rows:    2,662

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-23	SPY	ETF	446.91	448.49	443.71	443.8	79426100.0
2022-03-23	QQQ	ETF	354.01	357.66	351.77	351.83	70615457.0
2022-03-23	IWM	ETF	206.15	207.2	203.75	203.9	19775000.0
2022-03-23	DIA	ETF	345.75	346.44	343.35	343.41	4098700.0
2022-03-23	GLD	ETF	180.29	181.89	179.76	181.81	12557300.0
2022-03-23	TLT	ETF	129.37	131.6	128.86	131.5	21266100.0
2022-03-23	AAA	ETF	24.83	24.83	24.775	24.775	682.0
2022-03-23	AAAU	ETF	19.2	19.36	19.14	19.34	238800.0
2022-03-23	AADR	ETF	59.04	59.04	59.04	59.04	500.0
2022-03-23	AAXJ	ETF	75.57	76.48	75.22	75.52	1127800.0
2022-03-23	ABEQ	ETF	30.02	30.02	29.63	29.81	29300.0
2022-03-23	ACES	ETF	61.78	63.28	61.395	62.03	71300.0
2022-03-23	ACIO	ETF	31.11	31.26	31.065	31.09	53000.0
2022-03-23	ACSI	ETF	50.17	50.17	49.8198	49.8198	146.0
2022-03-23	ACT	ETF	22.4	22.63	22.05	22.13	75066.0
2022-03-23	ACTV	ETF	35.95	35.97	35.6525	35.6525	5707.0
2022-03-23	ACTX	ETF	1.0	1.0	0.9999	0.9999	476.0
2022-03-23	ACVF	ETF	33.5	33.52	33.267	33.267	2600.0
2022-03-23	ACWF	ETF	36.9094	36.9094	36.7276	36.7276	2161.0
2022-03-23	ACWI	ETF	99.14	99.57	98.62	98.65	2655100.0
2022-03-23	ACWV	ETF	103.68	103.68	102.85	102.9	2449000.0
2022-03-23	ACWX	ETF	52.05	52.42	51.99	52.05	1945986.0
2022-03-23	ADFI	ETF	9.02	9.03	9.02	9.03	10400.0
2022-03-23	ADIV	ETF	15.571	15.571	15.537	15.537	700.0
2022-03-23	ADME	ETF	40.67	40.705	40.46	40.46	35400.0
2022-03-23	ADRE	ETF	45.0571	45.59	44.87	44.87	5434.0
2022-03-23	AEMB	ETF	42.515	42.515	42.515	42.515	100.0
2022-03-23	AESR	ETF	13.34	13.35	13.24	13.24	9400.0
2022-03-23	AFIF	ETF	9.24	9.25	9.235	9.24	22855.0
2022-03-23	AFK	ETF	21.37	21.37	21.21	21.2328	13955.0
2022-03-23	AFLG	ETF	26.57	26.57	26.411	26.411	200.0
2022-03-23	AFMC	ETF	25.05	25.05	24.792	24.792	500.0
2022-03-23	AFSM	ETF	26.13	26.13	25.808	25.808	1900.0
2022-03-23	AFTY	ETF	18.2	18.24	18.2	18.203	800.0
2022-03-23	AGG	ETF	106.96	107.21	106.71	107.19	9060700.0
2022-03-23	AGGY	ETF	47.77	47.98	47.72	47.95	134500.0
2022-03-23	AGNG	ETF	27.87	27.87	27.34	27.6	5100.0
2022-03-23	AGOV	ETF	83.05	84.9	82.54	84.185	2307.0
2022-03-23	AGOX	ETF	23.97	24.323	23.81	23.99	131300.0
2022-03-23	AGQ	ETF	39.27	39.91	38.77	39.79	790100.0
2022-03-23	AGZ	ETF	112.69	112.9385	112.58	112.91	34509.0
2022-03-23	AGZD	ETF	23.175	23.195	23.105	23.14	61800.0
2022-03-23	AHHX	ETF	9.46	9.51	9.401	9.4598	7978.0
2022-03-23	AHYB	ETF	47.261	47.261	47.261	47.261	100.0
2022-03-23	AIA	ETF	69.4	70.6	69.01	69.81	690781.0
2022-03-23	AIEQ	ETF	37.01	37.01	36.61	36.622	6600.0
2022-03-23	AIQ	ETF	26.87	27.1	26.73	26.75	10185.0
2022-03-23	AIRR	ETF	43.61	43.678	42.85	42.94	14900.0
2022-03-23	AIVI	ETF	40.3	40.38	40.15	40.15	3600.0
2022-03-23	AIVL	ETF	98.36	98.4	97.79	97.79	6500.0

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

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