PREVIEW / etf_daily / 2022-11-23

all etf daily files

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

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-23	SPY	ETF	399.55	402.93	399.31	402.42	68261600.0
2022-11-23	QQQ	ETF	285.97	289.46	285.79	288.82	46389967.0
2022-11-23	IWM	ETF	184.29	185.78	183.55	185.19	19758800.0
2022-11-23	DIA	ETF	340.61	342.58	339.99	341.95	3108500.0
2022-11-23	GLD	ETF	161.69	163.24	161.56	163.08	4167000.0
2022-11-23	TLT	ETF	102.14	103.25	102.08	103.25	23234600.0
2022-11-23	AAA	ETF	24.29	24.32	24.29	24.32	163.0
2022-11-23	AAAU	ETF	17.23	17.4	17.22	17.38	2783500.0
2022-11-23	AADR	ETF	48.67	49.17	48.67	49.17	2200.0
2022-11-23	AAPB	ETF	20.36	20.44	20.13	20.371	2770.0
2022-11-23	AAPD	ETF	26.57	26.57	26.15	26.2828	59742.0
2022-11-23	AAPU	ETF	20.9708	21.397	20.9708	21.22	13827.0
2022-11-23	AAXJ	ETF	63.03	63.5	63.01	63.44	431400.0
2022-11-23	ABEQ	ETF	28.46	28.46	28.14	28.275	11300.0
2022-11-23	ACES	ETF	54.51	55.38	54.51	55.29	14500.0
2022-11-23	ACIO	ETF	30.15	30.213	30.0	30.16	45800.0
2022-11-23	ACSI	ETF	44.9594	44.9594	44.9594	44.9594	32.0
2022-11-23	ACT	ETF	24.49	24.82	24.4	24.63	100778.0
2022-11-23	ACTV	ETF	30.02	30.38	30.02	30.378	8196.0
2022-11-23	ACVF	ETF	30.945	31.03	30.883	31.0	3800.0
2022-11-23	ACWF	ETF	33.49	33.49	33.3609	33.4449	2432.0
2022-11-23	ACWI	ETF	87.51	88.34	87.51	88.22	1666700.0
2022-11-23	ACWV	ETF	97.0	97.44	96.88	97.34	142100.0
2022-11-23	ACWX	ETF	45.65	46.1	45.65	46.04	2032790.0
2022-11-23	ADFI	ETF	8.411	8.44	8.41	8.44	15400.0
2022-11-23	ADIV	ETF	12.7	12.7	12.7	12.7	100.0
2022-11-23	ADME	ETF	35.318	35.39	35.141	35.351	47600.0
2022-11-23	ADPV	ETF	25.1	25.11	25.07	25.07	25205.0
2022-11-23	ADRE	ETF	37.24	37.49	37.1701	37.49	9181.0
2022-11-23	AESR	ETF	11.94	11.96	11.89	11.93	13200.0
2022-11-23	AFIF	ETF	8.74	8.79	8.73	8.79	12563.0
2022-11-23	AFK	ETF	17.04	17.23	17.01	17.23	6261.0
2022-11-23	AFLG	ETF	24.43	24.44	24.43	24.44	200.0
2022-11-23	AFMC	ETF	23.37	23.37	23.334	23.334	100.0
2022-11-23	AFSM	ETF	23.952	23.952	23.913	23.913	300.0
2022-11-23	AFTY	ETF	14.702	14.702	14.702	14.702	100.0
2022-11-23	AGG	ETF	97.58	98.02	97.58	98.02	5885600.0
2022-11-23	AGGH	ETF	22.6099	22.61	22.5864	22.5864	918.0
2022-11-23	AGGY	ETF	42.82	43.0	42.82	42.97	86600.0
2022-11-23	AGNG	ETF	25.92	26.06	25.92	26.06	800.0
2022-11-23	AGOV	ETF	80.5592	80.9974	80.5592	80.9974	284.0
2022-11-23	AGOX	ETF	21.2	21.41	21.2	21.4	26900.0
2022-11-23	AGQ	ETF	25.45	26.32	25.38	26.24	1530200.0
2022-11-23	AGRH	ETF	25.37	25.37	25.325	25.335	301.0
2022-11-23	AGZ	ETF	106.73	106.837	106.47	106.7	28493.0
2022-11-23	AGZD	ETF	22.995	23.12	22.965	23.035	124000.0
2022-11-23	AHHX	ETF	8.54	8.67	8.54	8.625	4540.0
2022-11-23	AHYB	ETF	43.79	43.8	43.752	43.79	2100.0
2022-11-23	AIA	ETF	54.87	55.26	54.82	55.18	24056.0
2022-11-23	AIEQ	ETF	30.98	31.425	30.98	31.342	4800.0

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

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