PREVIEW / etf_daily / 2022-12-06

all etf daily files

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

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-06	SPY	ETF	399.42	399.99	391.64	393.83	77972200.0
2022-12-06	QQQ	ETF	287.48	287.62	280.255	281.68	53937605.0
2022-12-06	IWM	ETF	182.88	182.98	179.08	180.07	18502100.0
2022-12-06	DIA	ETF	339.77	340.65	334.72	336.46	5516300.0
2022-12-06	GLD	ETF	165.2	165.54	164.45	164.84	3597800.0
2022-12-06	TLT	ETF	106.5	107.39	106.19	106.95	21754500.0
2022-12-06	AAA	ETF	24.305	24.305	24.305	24.305	3.0
2022-12-06	AAAU	ETF	17.62	17.65	17.54	17.58	608600.0
2022-12-06	AADR	ETF	48.7	48.7	48.28	48.65	3500.0
2022-12-06	AAPB	ETF	18.34	18.46	18.2899	18.46	1517.0
2022-12-06	AAPD	ETF	26.89	27.86	26.89	27.66	172385.0
2022-12-06	AAPU	ETF	20.4	20.4	19.3001	19.5	47386.0
2022-12-06	AAXJ	ETF	66.71	66.71	66.15	66.3	519500.0
2022-12-06	ABEQ	ETF	28.08	28.08	27.9	28.01	10600.0
2022-12-06	ACES	ETF	54.34	54.34	51.34	51.87	36900.0
2022-12-06	ACIO	ETF	29.71	29.71	29.39	29.46	65200.0
2022-12-06	ACSI	ETF	44.1132	44.1132	44.1132	44.1132	10.0
2022-12-06	ACT	ETF	24.62	24.77	23.76	23.85	129193.0
2022-12-06	ACTV	ETF	30.31	30.33	29.8271	29.99	6389.0
2022-12-06	ACTX	ETF	0.3	0.3	0.3	0.3	348.0
2022-12-06	ACVF	ETF	30.95	30.95	30.38	30.478	7600.0
2022-12-06	ACWF	ETF	32.9	32.93	32.9	32.93	1431.0
2022-12-06	ACWI	ETF	88.25	88.35	86.84	87.25	4401400.0
2022-12-06	ACWV	ETF	97.72	97.87	96.89	97.08	115200.0
2022-12-06	ACWX	ETF	46.66	46.76	46.2301	46.38	1848837.0
2022-12-06	ADFI	ETF	8.48	8.5	8.46	8.485	11300.0
2022-12-06	ADIV	ETF	13.024	13.05	13.024	13.05	200.0
2022-12-06	ADME	ETF	34.8	34.967	34.69	34.757	99800.0
2022-12-06	ADPV	ETF	25.09	25.095	25.09	25.095	17199.0
2022-12-06	ADRE	ETF	39.04	39.23	38.9919	39.1599	4596.0
2022-12-06	AEMB	ETF	38.06	38.06	37.825	37.825	200.0
2022-12-06	AESR	ETF	11.88	11.88	11.7	11.77	21100.0
2022-12-06	AFIF	ETF	8.8	8.8179	8.8	8.81	10335.0
2022-12-06	AFK	ETF	17.39	17.39	17.03	17.03	6625.0
2022-12-06	AFLG	ETF	24.02	24.02	23.919	23.919	100.0
2022-12-06	AFMC	ETF	22.86	22.86	22.846	22.846	100.0
2022-12-06	AFSM	ETF	23.352	23.352	23.352	23.352	100.0
2022-12-06	AFTY	ETF	16.103	16.103	16.103	16.103	300.0
2022-12-06	AGG	ETF	98.71	98.92	98.59	98.8	7660100.0
2022-12-06	AGGH	ETF	22.73	22.7362	22.73	22.7362	298.0
2022-12-06	AGGY	ETF	43.48	43.55	43.424	43.55	123700.0
2022-12-06	AGNG	ETF	26.25	26.25	26.246	26.246	400.0
2022-12-06	AGOV	ETF	81.82	82.12	81.76	82.12	1571.0
2022-12-06	AGOX	ETF	21.18	21.215	20.86	20.949	26100.0
2022-12-06	AGQ	ETF	28.15	28.5	27.25	27.61	858600.0
2022-12-06	AGZ	ETF	107.06	107.47	106.7806	107.32	63666.0
2022-12-06	AGZD	ETF	23.08	23.135	23.02	23.045	321000.0
2022-12-06	AHHX	ETF	8.58	8.59	8.4844	8.4844	6453.0
2022-12-06	AHYB	ETF	43.44	43.44	43.44	43.44	400.0
2022-12-06	AIA	ETF	58.42	58.44	57.934	58.075	27617.0

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

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