PREVIEW / etf_daily / 2022-12-12

all etf daily files

  file:    by_date/etf_daily/2022/2022-12-12.parquet
  size:    107 KB
  rows:    2,873

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-12-12	SPY	ETF	394.11	398.95	393.41	398.95	75405800.0
2022-12-12	QQQ	ETF	282.22	285.64	281.16	285.58	35732518.0
2022-12-12	IWM	ETF	178.85	181.09	178.0	180.72	22765400.0
2022-12-12	DIA	ETF	336.14	340.65	336.06	340.62	5017300.0
2022-12-12	GLD	ETF	166.44	166.6	165.43	165.68	3504400.0
2022-12-12	TLT	ETF	107.86	108.11	106.26	106.67	16897100.0
2022-12-12	AAA	ETF	24.33	24.33	24.33	24.33	37.0
2022-12-12	AAAU	ETF	17.75	17.76	17.64	17.66	220400.0
2022-12-12	AADR	ETF	48.1	48.53	48.1	48.53	2000.0
2022-12-12	AAPB	ETF	18.61	18.79	18.61	18.79	127.0
2022-12-12	AAPD	ETF	27.68	28.05	27.35	27.35	110296.0
2022-12-12	AAPU	ETF	19.45	19.74	19.208	19.74	25006.0
2022-12-12	AAXJ	ETF	66.41	66.55	66.0	66.53	1276900.0
2022-12-12	ABEQ	ETF	28.19	28.19	27.86	28.12	15500.0
2022-12-12	ACES	ETF	50.83	51.82	50.53	51.35	79300.0
2022-12-12	ACIO	ETF	29.55	29.706	29.52	29.7	29000.0
2022-12-12	ACSI	ETF	44.382	44.382	44.382	44.382	44.0
2022-12-12	ACT	ETF	24.33	24.85	24.14	24.33	107515.0
2022-12-12	ACTV	ETF	30.28	30.56	30.0199	30.43	27872.0
2022-12-12	ACVF	ETF	30.5	30.923	30.5	30.923	2400.0
2022-12-12	ACWF	ETF	32.93	33.188	32.93	33.188	3798.0
2022-12-12	ACWI	ETF	87.5	88.13	87.22	88.12	7170700.0
2022-12-12	ACWV	ETF	97.11	97.98	97.11	97.98	147000.0
2022-12-12	ACWX	ETF	46.56	46.68	46.29	46.68	4926416.0
2022-12-12	ADFI	ETF	8.51	8.51	8.475	8.475	17000.0
2022-12-12	ADIV	ETF	13.185	13.185	13.185	13.185	100.0
2022-12-12	ADME	ETF	34.79	34.92	34.74	34.92	26000.0
2022-12-12	ADPV	ETF	25.13	25.14	25.11	25.11	19018.0
2022-12-12	ADRE	ETF	38.76	38.76	38.305	38.67	5369.0
2022-12-12	AEMB	ETF	38.165	38.165	38.165	38.165	100.0
2022-12-12	AESR	ETF	11.76	11.9	11.76	11.9	27600.0
2022-12-12	AFIF	ETF	8.82	8.82	8.79	8.8	91881.0
2022-12-12	AFK	ETF	17.19	17.19	16.9	17.04	6459.0
2022-12-12	AFLG	ETF	24.157	24.157	24.157	24.157	100.0
2022-12-12	AFMC	ETF	22.94	22.974	22.94	22.974	100.0
2022-12-12	AFSM	ETF	23.36	23.44	23.345	23.418	1700.0
2022-12-12	AFTY	ETF	16.065	16.11	16.065	16.11	700.0
2022-12-12	AGG	ETF	99.19	99.24	98.63	98.81	10384200.0
2022-12-12	AGGY	ETF	43.66	43.69	43.437	43.52	144500.0
2022-12-12	AGNG	ETF	26.525	26.73	26.525	26.73	4100.0
2022-12-12	AGOV	ETF	82.3	82.3	79.84	81.1627	7968.0
2022-12-12	AGOX	ETF	21.01	21.21	21.0	21.198	24800.0
2022-12-12	AGQ	ETF	30.91	31.03	30.0	30.53	647600.0
2022-12-12	AGZ	ETF	107.19	107.215	106.92	107.0	23327.0
2022-12-12	AGZD	ETF	21.885	21.905	21.76	21.855	566400.0
2022-12-12	AHHX	ETF	8.4912	8.5479	8.4912	8.5479	324.0
2022-12-12	AHYB	ETF	43.73	43.769	43.71	43.769	800.0
2022-12-12	AIA	ETF	58.66	58.66	57.9015	58.4	33262.0
2022-12-12	AIEQ	ETF	29.47	30.0	29.41	30.0	8900.0
2022-12-12	AIQ	ETF	21.06	21.26	20.94	21.13	9670.0

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

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