PREVIEW / etf_daily / 2023-01-06

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-06.parquet
  size:    108 KB
  rows:    2,903

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
2023-01-06	SPY	ETF	382.61	389.25	379.41	388.08	104189600.0
2023-01-06	QQQ	ETF	263.35	269.94	260.34	268.8	54659739.0
2023-01-06	IWM	ETF	175.3	178.04	173.87	177.58	21986900.0
2023-01-06	DIA	ETF	332.18	337.12	329.91	336.28	4800800.0
2023-01-06	GLD	ETF	171.76	173.96	171.23	173.71	7889000.0
2023-01-06	TLT	ETF	102.7	105.3	102.64	105.18	27473700.0
2023-01-06	AAA	ETF	24.39	24.39	24.39	24.39	1.0
2023-01-06	AAAU	ETF	18.32	18.56	18.27	18.52	659800.0
2023-01-06	AADR	ETF	48.02	48.1	47.88	48.1	400.0
2023-01-06	AAPB	ETF	14.79	15.39	14.7869	15.295	11780.0
2023-01-06	AAPD	ETF	31.15	31.445	30.1057	30.301	278996.0
2023-01-06	AAPU	ETF	15.92	16.665	15.66	16.55	108231.0
2023-01-06	AAXJ	ETF	67.91	68.78	67.43	68.77	702200.0
2023-01-06	ABEQ	ETF	28.67	28.81	28.66	28.737	15400.0
2023-01-06	ACES	ETF	44.51	45.349	43.72	45.09	130400.0
2023-01-06	ACIO	ETF	28.7	29.0	28.57	28.89	27300.0
2023-01-06	ACSI	ETF	41.85	42.5903	41.85	42.5903	2040.0
2023-01-06	ACT	ETF	23.89	24.4	23.885	24.35	112064.0
2023-01-06	ACTV	ETF	29.9	30.52	29.9	30.42	8991.0
2023-01-06	ACVF	ETF	29.93	30.25	29.905	30.247	2200.0
2023-01-06	ACWF	ETF	32.2	32.5276	32.2	32.5276	1112.0
2023-01-06	ACWI	ETF	85.8	87.25	85.13	87.07	5254100.0
2023-01-06	ACWV	ETF	95.65	97.08	94.21	96.9	101100.0
2023-01-06	ACWX	ETF	46.57	47.43	46.33	47.39	1749157.0
2023-01-06	ADFI	ETF	8.35	8.52	7.92	8.52	17400.0
2023-01-06	ADIV	ETF	13.87	13.87	13.87	13.87	100.0
2023-01-06	ADME	ETF	33.31	33.709	33.31	33.648	11100.0
2023-01-06	ADPV	ETF	25.1	25.12	25.07	25.0905	20714.0
2023-01-06	ADRE	ETF	39.3	40.1	39.3	40.1	2662.0
2023-01-06	AEMB	ETF	38.45	38.45	38.45	38.45	100.0
2023-01-06	AESR	ETF	11.38	11.58	11.38	11.54	11200.0
2023-01-06	AFIF	ETF	8.75	8.815	8.75	8.815	31711.0
2023-01-06	AFK	ETF	16.42	16.7	16.39	16.63	6666.0
2023-01-06	AFLG	ETF	23.478	23.478	23.478	23.478	100.0
2023-01-06	AFMC	ETF	22.749	22.749	22.749	22.749	100.0
2023-01-06	AFSM	ETF	23.01	23.013	23.01	23.013	400.0
2023-01-06	AFTY	ETF	16.6	16.728	16.6	16.728	2100.0
2023-01-06	AGG	ETF	98.13	99.15	98.04	99.09	8503000.0
2023-01-06	AGGH	ETF	22.7	22.7	22.7	22.7	108.0
2023-01-06	AGGY	ETF	43.13	43.61	43.11	43.57	278600.0
2023-01-06	AGNG	ETF	26.916	26.916	26.916	26.916	100.0
2023-01-06	AGOV	ETF	80.1	80.1	79.45	79.45	1301.0
2023-01-06	AGOX	ETF	20.79	20.89	20.56	20.89	11000.0
2023-01-06	AGQ	ETF	31.02	31.74	30.71	31.57	857000.0
2023-01-06	AGZ	ETF	106.94	107.53	106.9035	107.53	27371.0
2023-01-06	AGZD	ETF	21.845	21.845	21.695	21.755	148600.0
2023-01-06	AHHX	ETF	8.54	8.575	8.4897	8.5584	2969.0
2023-01-06	AHYB	ETF	43.788	43.942	43.788	43.942	200.0
2023-01-06	AIA	ETF	60.99	61.89	60.6	61.73	100937.0
2023-01-06	AIEQ	ETF	28.421	29.058	28.421	29.028	7400.0

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

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