PREVIEW / etf_daily / 2022-11-17

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-17.parquet
  size:    106 KB
  rows:    2,869

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-17	SPY	ETF	390.46	394.95	390.14	394.24	74496300.0
2022-11-17	QQQ	ETF	280.88	286.3189	280.72	284.81	55462076.0
2022-11-17	IWM	ETF	181.62	182.95	180.51	182.54	20835700.0
2022-11-17	DIA	ETF	332.73	336.78	332.73	336.1	3606500.0
2022-11-17	GLD	ETF	163.79	164.11	163.4	163.92	4574400.0
2022-11-17	TLT	ETF	100.2	100.57	99.78	100.33	24528900.0
2022-11-17	AAA	ETF	24.23	24.23	24.23	24.23	274.0
2022-11-17	AAAU	ETF	17.47	17.5	17.42	17.48	1521200.0
2022-11-17	AADR	ETF	47.71	48.22	47.68	48.22	2000.0
2022-11-17	AAPB	ETF	19.51	20.545	19.51	20.3431	6002.0
2022-11-17	AAPD	ETF	27.12	27.12	26.1976	26.3559	158645.0
2022-11-17	AAPU	ETF	20.35	21.3598	20.35	21.23	50530.0
2022-11-17	AAXJ	ETF	62.87	64.44	62.87	64.37	654400.0
2022-11-17	ABEQ	ETF	27.58	27.624	27.552	27.624	1800.0
2022-11-17	ACES	ETF	54.7	55.63	54.28	55.46	82100.0
2022-11-17	ACIO	ETF	29.39	29.79	29.39	29.79	28900.0
2022-11-17	ACSI	ETF	43.7991	43.7991	43.7991	43.7991	56.0
2022-11-17	ACT	ETF	24.37	24.37	23.64	23.76	119728.0
2022-11-17	ACTV	ETF	29.63	30.0999	29.53	29.92	5289.0
2022-11-17	ACTX	ETF	0.4499	0.4499	0.4499	0.4499	102.0
2022-11-17	ACVF	ETF	30.08	30.25	30.0	30.179	2400.0
2022-11-17	ACWF	ETF	32.44	32.8338	32.35	32.8338	30676.0
2022-11-17	ACWI	ETF	85.59	86.85	85.58	86.77	4756300.0
2022-11-17	ACWV	ETF	94.64	95.34	94.57	95.25	212500.0
2022-11-17	ACWX	ETF	44.81	45.54	44.79	45.51	2503208.0
2022-11-17	ADFI	ETF	8.35	8.37	8.34	8.36	11600.0
2022-11-17	ADIV	ETF	12.855	12.855	12.855	12.855	100.0
2022-11-17	ADME	ETF	34.74	34.97	34.73	34.919	14800.0
2022-11-17	ADPV	ETF	25.06	25.09	25.0549	25.0549	21466.0
2022-11-17	ADRE	ETF	36.61	37.93	36.61	37.93	28330.0
2022-11-17	AEMB	ETF	37.16	37.21	37.1	37.21	33900.0
2022-11-17	AESR	ETF	11.61	11.74	11.6	11.72	38100.0
2022-11-17	AFIF	ETF	8.69	8.72	8.68	8.72	15026.0
2022-11-17	AFK	ETF	16.81	16.85	16.74	16.85	2780.0
2022-11-17	AFLG	ETF	23.84	23.87	23.81	23.86	600.0
2022-11-17	AFMC	ETF	22.63	22.706	22.63	22.706	100.0
2022-11-17	AFSM	ETF	23.4	23.4	23.26	23.369	400.0
2022-11-17	AFTY	ETF	14.78	14.816	14.78	14.816	300.0
2022-11-17	AGG	ETF	97.03	97.17	96.85	97.14	6889000.0
2022-11-17	AGGY	ETF	42.67	42.75	42.626	42.72	83700.0
2022-11-17	AGNG	ETF	25.708	25.708	25.65	25.65	2300.0
2022-11-17	AGOV	ETF	80.7	80.7	79.735	80.305	2881.0
2022-11-17	AGOX	ETF	20.95	21.16	20.935	21.082	18000.0
2022-11-17	AGQ	ETF	24.73	25.0	24.44	24.94	1540000.0
2022-11-17	AGRH	ETF	25.17	25.2596	25.17	25.23	2191.0
2022-11-17	AGZ	ETF	106.67	106.68	106.563	106.65	15899.0
2022-11-17	AGZD	ETF	22.925	23.065	22.91	23.005	127000.0
2022-11-17	AHHX	ETF	8.47	8.55	8.47	8.5056	7275.0
2022-11-17	AHYB	ETF	43.116	43.197	43.116	43.197	500.0
2022-11-17	AIA	ETF	54.78	56.63	54.755	56.53	29773.0

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

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