PREVIEW / etf_daily / 2022-07-29

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-29.parquet
  size:    102 KB
  rows:    2,750

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-07-29	SPY	ETF	407.58	413.03	406.77	411.99	87003700.0
2022-07-29	QQQ	ETF	311.385	316.39	309.931	315.46	57501043.0
2022-07-29	IWM	ETF	186.04	187.73	185.04	187.25	21760600.0
2022-07-29	DIA	ETF	325.52	329.27	324.92	328.66	3225600.0
2022-07-29	GLD	ETF	163.89	164.69	163.28	164.1	7537300.0
2022-07-29	TLT	ETF	117.7	119.31	117.33	117.43	16655900.0
2022-07-29	AAA	ETF	24.3	24.3	24.3	24.3	20.0
2022-07-29	AAAU	ETF	17.46	17.54	17.4	17.49	176600.0
2022-07-29	AADR	ETF	50.8	51.02	50.8	51.02	1100.0
2022-07-29	AAXJ	ETF	67.48	68.03	67.25	68.0	1071700.0
2022-07-29	ABEQ	ETF	27.25	27.35	27.25	27.323	4800.0
2022-07-29	ACES	ETF	57.86	59.76	57.86	59.56	46900.0
2022-07-29	ACIO	ETF	30.15	30.665	30.15	30.618	118200.0
2022-07-29	ACSI	ETF	46.33	46.33	46.2283	46.2283	130.0
2022-07-29	ACT	ETF	22.98	23.16	22.81	23.04	211987.0
2022-07-29	ACTV	ETF	31.1918	31.52	31.1918	31.4551	3268.0
2022-07-29	ACTX	ETF	0.6352	0.7	0.6352	0.7	542.0
2022-07-29	ACVF	ETF	30.799	30.992	30.799	30.992	400.0
2022-07-29	ACWF	ETF	32.9	33.2282	32.9	33.2282	3092.0
2022-07-29	ACWI	ETF	88.77	89.89	88.62	89.82	1623700.0
2022-07-29	ACWV	ETF	97.26	97.68	96.98	97.67	102300.0
2022-07-29	ACWX	ETF	46.01	46.52	45.87	46.52	1967860.0
2022-07-29	ADFI	ETF	8.72	8.735	8.72	8.735	4900.0
2022-07-29	ADIV	ETF	13.72	13.839	13.72	13.839	300.0
2022-07-29	ADME	ETF	36.53	36.77	36.413	36.681	11600.0
2022-07-29	ADRE	ETF	39.3	39.3992	39.07	39.25	5898.0
2022-07-29	AESR	ETF	11.86	12.02	11.855	11.98	10700.0
2022-07-29	AFIF	ETF	8.905	8.91	8.9	8.905	23049.0
2022-07-29	AFK	ETF	17.13	17.28	17.09	17.28	5236.0
2022-07-29	AFLG	ETF	24.13	24.308	24.13	24.308	300.0
2022-07-29	AFMC	ETF	22.84	23.003	22.84	23.003	100.0
2022-07-29	AFSM	ETF	23.92	24.073	23.92	24.073	100.0
2022-07-29	AFTY	ETF	17.36	17.474	17.35	17.474	300.0
2022-07-29	AGG	ETF	103.94	104.4	103.83	104.07	7674600.0
2022-07-29	AGGH	ETF	24.04	24.04	24.0135	24.0135	42407.0
2022-07-29	AGGY	ETF	45.89	46.11	45.84	46.0	65100.0
2022-07-29	AGIH	ETF	26.21	26.21	26.1901	26.1901	153.0
2022-07-29	AGNG	ETF	26.27	26.27	26.12	26.255	1500.0
2022-07-29	AGOV	ETF	82.2505	82.74	82.0974	82.0974	1015.0
2022-07-29	AGOX	ETF	21.41	21.72	21.41	21.71	22000.0
2022-07-29	AGQ	ETF	23.59	24.37	23.37	24.29	647300.0
2022-07-29	AGZ	ETF	110.98	111.235	110.98	111.22	18705.0
2022-07-29	AGZD	ETF	22.985	22.985	22.89	22.91	1060400.0
2022-07-29	AHHX	ETF	8.81	8.86	8.77	8.8172	26603.0
2022-07-29	AHYB	ETF	44.99	45.11	44.99	45.11	300.0
2022-07-29	AIA	ETF	60.25	60.315	59.8041	60.31	33244.0
2022-07-29	AIEQ	ETF	33.84	34.052	33.71	34.052	8600.0
2022-07-29	AIQ	ETF	22.22	22.5	22.13	22.5	99278.0
2022-07-29	AIRR	ETF	42.925	43.415	42.925	43.39	14600.0
2022-07-29	AIVI	ETF	36.17	36.55	36.17	36.55	4000.0

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

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