PREVIEW / etf_daily / 2022-11-22

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-22.parquet
  size:    107 KB
  rows:    2,876

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-11-22	SPY	ETF	396.63	400.07	395.15	399.9	60429000.0
2022-11-22	QQQ	ETF	282.64	286.11	280.46	285.95	41873444.0
2022-11-22	IWM	ETF	183.74	184.94	182.33	184.71	16869700.0
2022-11-22	DIA	ETF	338.89	341.12	338.39	340.96	4389400.0
2022-11-22	GLD	ETF	162.3	162.6	161.72	162.07	3203800.0
2022-11-22	TLT	ETF	100.65	101.62	100.53	101.48	18103100.0
2022-11-22	AAA	ETF	24.33	24.33	24.31	24.31	500.0
2022-11-22	AAAU	ETF	17.3	17.34	17.24	17.27	1722600.0
2022-11-22	AADR	ETF	48.5	48.91	48.5	48.91	2300.0
2022-11-22	AAPB	ETF	19.522	20.2	19.48	20.2	2395.0
2022-11-22	AAPD	ETF	26.78	26.98	26.39	26.4042	61969.0
2022-11-22	AAPU	ETF	20.65	21.08	20.409	21.08	24907.0
2022-11-22	AAXJ	ETF	62.5	62.93	62.47	62.89	473800.0
2022-11-22	ABEQ	ETF	28.01	28.2	27.92	28.156	12300.0
2022-11-22	ACES	ETF	54.06	54.5	53.361	54.46	44200.0
2022-11-22	ACIO	ETF	29.91	30.03	29.82	30.03	45600.0
2022-11-22	ACSI	ETF	44.5333	44.5333	44.5333	44.5333	106.0
2022-11-22	ACT	ETF	24.47	24.727	24.06	24.5	121232.0
2022-11-22	ACTV	ETF	29.8602	30.18	29.8602	30.18	24752.0
2022-11-22	ACTX	ETF	0.3948	0.4	0.284	0.284	2800.0
2022-11-22	ACVF	ETF	30.66	30.811	30.52	30.811	7600.0
2022-11-22	ACWF	ETF	32.98	33.35	32.98	33.35	10666.0
2022-11-22	ACWI	ETF	86.86	87.58	86.6	87.54	4189400.0
2022-11-22	ACWV	ETF	96.51	97.02	96.19	97.02	127000.0
2022-11-22	ACWX	ETF	45.28	45.62	45.22	45.6	2624038.0
2022-11-22	ADFI	ETF	8.38	8.38	8.375	8.38	15800.0
2022-11-22	ADIV	ETF	12.61	12.615	12.61	12.615	200.0
2022-11-22	ADME	ETF	34.96	35.17	34.96	35.162	43100.0
2022-11-22	ADPV	ETF	25.08	25.09	25.02	25.0284	24692.0
2022-11-22	ADRE	ETF	37.14	37.17	36.865	37.17	27976.0
2022-11-22	AESR	ETF	11.84	11.9	11.83	11.89	19600.0
2022-11-22	AFIF	ETF	8.77	8.77	8.685	8.725	145426.0
2022-11-22	AFK	ETF	16.92	16.99	16.9	16.99	3288.0
2022-11-22	AFLG	ETF	24.24	24.38	24.24	24.38	300.0
2022-11-22	AFMC	ETF	23.16	23.33	23.16	23.33	100.0
2022-11-22	AFSM	ETF	23.895	23.95	23.895	23.95	200.0
2022-11-22	AFTY	ETF	14.71	14.71	14.71	14.71	100.0
2022-11-22	AGG	ETF	97.18	97.5	97.18	97.44	8039000.0
2022-11-22	AGGY	ETF	42.76	42.89	42.76	42.85	172900.0
2022-11-22	AGNG	ETF	25.764	25.835	25.764	25.835	500.0
2022-11-22	AGOV	ETF	81.055	81.055	79.57	80.8489	814.0
2022-11-22	AGOX	ETF	21.08	21.29	21.08	21.28	28800.0
2022-11-22	AGQ	ETF	25.22	25.44	24.77	25.17	1844800.0
2022-11-22	AGZ	ETF	106.53	106.61	106.48	106.61	14437.0
2022-11-22	AGZD	ETF	22.98	23.06	22.96	23.03	172400.0
2022-11-22	AHHX	ETF	8.555	8.61	8.555	8.6041	4166.0
2022-11-22	AHYB	ETF	43.419	43.573	43.419	43.573	400.0
2022-11-22	AIA	ETF	54.12	54.58	54.06	54.53	78240.0
2022-11-22	AIEQ	ETF	30.8	31.046	30.54	30.97	1800.0
2022-11-22	AIQ	ETF	20.47	20.7299	20.45	20.7299	17153.0

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

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