PREVIEW / etf_daily / 2022-09-15

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-15.parquet
  size:    104 KB
  rows:    2,799

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-09-15	SPY	ETF	392.96	395.96	388.78	390.12	87633800.0
2022-09-15	QQQ	ETF	294.07	296.53	289.46	291.1	65299411.0
2022-09-15	IWM	ETF	181.92	184.69	180.86	181.63	25378700.0
2022-09-15	DIA	ETF	311.63	313.52	309.53	310.36	3294600.0
2022-09-15	GLD	ETF	156.76	157.49	154.62	154.98	13181200.0
2022-09-15	TLT	ETF	107.85	108.19	107.58	107.97	10260200.0
2022-09-15	AAA	ETF	24.31	24.31	24.31	24.31	0.0
2022-09-15	AAAU	ETF	16.71	16.79	16.48	16.52	999500.0
2022-09-15	AADR	ETF	49.09	49.21	48.69	48.69	1700.0
2022-09-15	AAPB	ETF	22.01	22.01	21.3466	21.45	3357.0
2022-09-15	AAPD	ETF	26.41	26.99	26.37	26.8152	24925.0
2022-09-15	AAPU	ETF	22.4387	22.59	21.8	22.01	50206.0
2022-09-15	AAXJ	ETF	64.83	65.11	64.39	64.51	651400.0
2022-09-15	ABEQ	ETF	26.51	26.64	26.4	26.454	4500.0
2022-09-15	ACES	ETF	66.0	67.16	65.38	65.62	45300.0
2022-09-15	ACIO	ETF	29.53	29.65	29.31	29.39	43300.0
2022-09-15	ACSI	ETF	45.3399	45.3399	45.3399	45.3399	44.0
2022-09-15	ACT	ETF	24.46	24.52	23.59	23.61	299773.0
2022-09-15	ACTV	ETF	29.59	29.72	29.4424	29.4424	9149.0
2022-09-15	ACTX	ETF	0.645	0.645	0.64	0.64	1152.0
2022-09-15	ACVF	ETF	29.56	29.56	29.278	29.278	2300.0
2022-09-15	ACWF	ETF	31.65	31.8049	31.49	31.5204	2855.0
2022-09-15	ACWI	ETF	85.16	85.83	84.49	84.75	6209600.0
2022-09-15	ACWV	ETF	94.59	94.74	93.84	93.95	115200.0
2022-09-15	ACWX	ETF	43.57	43.945	43.42	43.49	3471428.0
2022-09-15	ADFI	ETF	8.41	8.43	8.4	8.405	6500.0
2022-09-15	ADIV	ETF	13.13	13.13	13.1	13.1	1100.0
2022-09-15	ADME	ETF	34.91	34.91	34.48	34.54	21800.0
2022-09-15	ADRE	ETF	38.56	38.795	38.47	38.53	4073.0
2022-09-15	AEMB	ETF	37.62	37.76	37.609	37.609	1000.0
2022-09-15	AESR	ETF	11.51	11.53	11.38	11.45	15000.0
2022-09-15	AFIF	ETF	8.8	8.85	8.8	8.82	12297.0
2022-09-15	AFK	ETF	16.6	16.6	16.15	16.3493	4435.0
2022-09-15	AFLG	ETF	23.21	23.21	23.174	23.174	300.0
2022-09-15	AFSM	ETF	22.282	22.282	22.282	22.282	100.0
2022-09-15	AFTY	ETF	16.33	16.33	16.326	16.326	800.0
2022-09-15	AGG	ETF	99.04	99.11	98.84	98.9	6016600.0
2022-09-15	AGGH	ETF	22.9901	23.08	22.97	23.0219	2357.0
2022-09-15	AGGY	ETF	43.68	43.714	43.591	43.62	92300.0
2022-09-15	AGNG	ETF	24.93	24.96	24.91	24.91	800.0
2022-09-15	AGOV	ETF	81.03	82.03	81.03	81.4412	202.0
2022-09-15	AGOX	ETF	21.08	21.08	20.75	20.91	16600.0
2022-09-15	AGQ	ETF	21.71	22.16	21.07	21.15	1150100.0
2022-09-15	AGZ	ETF	107.87	107.9501	107.7933	107.86	11969.0
2022-09-15	AGZD	ETF	22.955	22.98	22.935	22.97	54600.0
2022-09-15	AHHX	ETF	8.51	8.52	8.4881	8.4982	1275.0
2022-09-15	AHYB	ETF	43.077	43.077	43.077	43.077	200.0
2022-09-15	AIA	ETF	55.54	55.86	55.24	55.27	29820.0
2022-09-15	AIEQ	ETF	33.22	33.691	32.97	33.077	4400.0
2022-09-15	AIQ	ETF	20.97	21.23	20.76	20.76	14850.0

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

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