PREVIEW / etf_daily / 2022-07-15

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-15.parquet
  size:    101 KB
  rows:    2,736

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-15	SPY	ETF	382.55	385.25	380.54	385.13	79060400.0
2022-07-15	QQQ	ETF	289.73	291.98	288.08	291.87	63818149.0
2022-07-15	IWM	ETF	171.54	173.35	169.31	173.09	34935900.0
2022-07-15	DIA	ETF	310.81	312.78	309.15	312.66	3027500.0
2022-07-15	GLD	ETF	159.01	159.25	158.35	159.01	6783800.0
2022-07-15	TLT	ETF	115.84	116.82	115.6	116.14	16022600.0
2022-07-15	AAA	ETF	24.265	24.265	24.265	24.265	0.0
2022-07-15	AAAU	ETF	16.95	16.96	16.87	16.94	1280000.0
2022-07-15	AADR	ETF	46.24	47.05	46.24	47.05	900.0
2022-07-15	AAXJ	ETF	66.52	66.77	65.88	66.74	877900.0
2022-07-15	ABEQ	ETF	26.519	26.558	26.48	26.558	4500.0
2022-07-15	ACES	ETF	49.02	49.04	47.23	48.95	75000.0
2022-07-15	ACIO	ETF	29.11	29.11	28.94	29.02	14300.0
2022-07-15	ACSI	ETF	43.3599	43.3599	43.3599	43.3599	34.0
2022-07-15	ACT	ETF	21.86	22.11	21.48	21.98	142634.0
2022-07-15	ACTV	ETF	29.73	31.0899	29.73	30.5156	15693.0
2022-07-15	ACVF	ETF	28.953	28.994	28.91	28.994	2700.0
2022-07-15	ACWF	ETF	30.96	31.1	30.94	31.1	12415.0
2022-07-15	ACWI	ETF	83.7	84.22	83.15	84.22	4734000.0
2022-07-15	ACWV	ETF	94.32	94.9	94.25	94.88	215400.0
2022-07-15	ACWX	ETF	43.51	43.87	43.3	43.87	4647072.0
2022-07-15	ADFI	ETF	8.55	8.55	8.55	8.55	1100.0
2022-07-15	ADIV	ETF	13.48	13.48	13.48	13.48	100.0
2022-07-15	ADME	ETF	34.575	34.788	34.54	34.788	14100.0
2022-07-15	ADRE	ETF	37.73	38.01	37.31	38.01	1742.0
2022-07-15	AEMB	ETF	36.629	36.629	36.629	36.629	20000.0
2022-07-15	AESR	ETF	11.18	11.22	11.18	11.22	9300.0
2022-07-15	AFIF	ETF	8.81	8.82	8.8	8.81	32236.0
2022-07-15	AFK	ETF	16.75	16.75	16.45	16.61	5775.0
2022-07-15	AFLG	ETF	22.84	22.914	22.84	22.914	300.0
2022-07-15	AFMC	ETF	21.26	21.3	21.26	21.3	200.0
2022-07-15	AFSM	ETF	22.151	22.205	22.14	22.205	600.0
2022-07-15	AFTY	ETF	17.82	17.89	17.79	17.865	11800.0
2022-07-15	AGG	ETF	101.94	102.35	101.9	102.25	8640400.0
2022-07-15	AGGY	ETF	44.93	45.145	44.93	45.07	77200.0
2022-07-15	AGNG	ETF	25.75	25.835	25.74	25.835	700.0
2022-07-15	AGOV	ETF	80.77	80.77	79.1223	79.7608	2623.0
2022-07-15	AGOX	ETF	20.1	20.299	20.052	20.24	19400.0
2022-07-15	AGQ	ETF	20.43	20.68	20.04	20.58	911300.0
2022-07-15	AGZ	ETF	109.69	110.01	109.69	109.906	14486.0
2022-07-15	AGZD	ETF	22.905	22.935	22.89	22.915	54600.0
2022-07-15	AHHX	ETF	8.52	8.6	8.48	8.5852	7092.0
2022-07-15	AHYB	ETF	43.586	43.586	43.586	43.586	200.0
2022-07-15	AIA	ETF	60.0	60.09	59.42	60.09	38554.0
2022-07-15	AIEQ	ETF	31.03	31.19	30.5	31.171	4800.0
2022-07-15	AIQ	ETF	20.91	21.1	20.86	21.08	13979.0
2022-07-15	AIRR	ETF	37.4	37.912	36.908	37.834	10000.0
2022-07-15	AIVI	ETF	34.01	34.35	34.01	34.3	1400.0
2022-07-15	AIVL	ETF	88.32	89.32	88.32	89.32	6000.0
2022-07-15	ALTL	ETF	40.7	40.8379	40.543	40.77	149837.0

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

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