PREVIEW / etf_daily / 2022-02-23

all etf daily files

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

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-02-23	SPY	ETF	432.66	433.26	421.35	421.95	132578000.0
2022-02-23	QQQ	ETF	341.32	342.183	329.1	329.42	86215371.0
2022-02-23	IWM	ETF	198.24	198.9	192.55	192.98	31491500.0
2022-02-23	DIA	ETF	338.16	338.26	330.82	331.52	5732600.0
2022-02-23	GLD	ETF	177.39	178.39	177.36	178.29	11772200.0
2022-02-23	TLT	ETF	137.68	137.85	136.57	136.68	17757800.0
2022-02-23	AAA	ETF	25.03	25.03	25.0	25.005	270.0
2022-02-23	AAAU	ETF	18.89	18.99	18.88	18.97	208000.0
2022-02-23	AADR	ETF	60.72	60.72	59.55	59.55	2700.0
2022-02-23	AAXJ	ETF	80.52	80.53	79.1	79.19	1297000.0
2022-02-23	ABEQ	ETF	28.58	28.62	28.37	28.398	7100.0
2022-02-23	ACES	ETF	50.15	50.533	48.67	48.74	60800.0
2022-02-23	ACIO	ETF	30.565	30.565	30.17	30.17	31400.0
2022-02-23	ACSI	ETF	47.72	47.72	47.1107	47.1107	222.0
2022-02-23	ACT	ETF	21.23	21.39	20.76	20.9	149934.0
2022-02-23	ACTV	ETF	35.09	35.09	33.875	33.9202	6963.0
2022-02-23	ACTX	ETF	0.95	0.95	0.95	0.95	801.0
2022-02-23	ACVF	ETF	32.51	32.51	31.521	31.521	4600.0
2022-02-23	ACWF	ETF	36.285	36.285	35.8	35.8	5761.0
2022-02-23	ACWI	ETF	98.28	98.28	95.86	96.03	3629200.0
2022-02-23	ACWV	ETF	101.26	101.41	99.8	99.86	337100.0
2022-02-23	ACWX	ETF	53.71	53.71	52.64	52.75	1975887.0
2022-02-23	ADFI	ETF	9.15	9.16	9.135	9.135	6600.0
2022-02-23	ADIV	ETF	16.21	16.21	16.152	16.152	200.0
2022-02-23	ADME	ETF	40.15	40.15	39.24	39.24	29800.0
2022-02-23	ADRE	ETF	46.01	46.11	45.0	45.0013	4314.0
2022-02-23	AEMB	ETF	44.628	44.628	44.628	44.628	100.0
2022-02-23	AESR	ETF	12.82	12.82	12.55	12.56	19300.0
2022-02-23	AFIF	ETF	9.359	9.36	9.34	9.34	5892.0
2022-02-23	AFK	ETF	21.1	21.1193	20.85	20.85	4199.0
2022-02-23	AFLG	ETF	25.2	25.2	24.897	24.897	200.0
2022-02-23	AFMC	ETF	24.05	24.05	23.727	23.727	300.0
2022-02-23	AFSM	ETF	24.655	24.655	24.26	24.26	300.0
2022-02-23	AFTY	ETF	19.97	19.99	19.826	19.826	1900.0
2022-02-23	AGG	ETF	109.52	109.55	109.23	109.26	11732100.0
2022-02-23	AGGH	ETF	26.35	26.35	25.0182	25.0182	779.0
2022-02-23	AGGY	ETF	49.02	49.043	48.9	48.9	97300.0
2022-02-23	AGNG	ETF	26.54	26.54	26.21	26.21	10300.0
2022-02-23	AGOV	ETF	94.79	94.81	94.39	94.39	3978.0
2022-02-23	AGOX	ETF	23.491	23.491	22.92	22.92	75000.0
2022-02-23	AGQ	ETF	37.11	38.16	37.07	38.16	1189400.0
2022-02-23	AGZ	ETF	114.54	114.6599	114.49	114.49	26433.0
2022-02-23	AGZD	ETF	23.125	23.145	23.115	23.14	98800.0
2022-02-23	AHHX	ETF	9.72	9.72	9.631	9.6797	789.0
2022-02-23	AHYB	ETF	47.965	47.965	47.89	47.89	300.0
2022-02-23	AIA	ETF	74.78	74.81	73.39	73.41	69601.0
2022-02-23	AIEQ	ETF	35.51	35.685	34.52	34.52	15000.0
2022-02-23	AIQ	ETF	26.49	26.52	25.59	25.61	22224.0
2022-02-23	AIRR	ETF	41.4	41.48	40.39	40.42	65800.0
2022-02-23	AIVI	ETF	42.12	42.12	41.46	41.46	14100.0

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

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