PREVIEW / etf_daily / 2022-12-19

all etf daily files

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

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-19	SPY	ETF	383.47	383.82	378.28	380.02	79878100.0
2022-12-19	QQQ	ETF	273.87	273.96	268.49	269.75	44167920.0
2022-12-19	IWM	ETF	174.61	175.05	171.47	172.01	25614000.0
2022-12-19	DIA	ETF	328.87	330.33	325.71	327.38	3709600.0
2022-12-19	GLD	ETF	166.71	167.11	165.99	166.32	3940500.0
2022-12-19	TLT	ETF	105.83	105.84	104.98	105.31	26126800.0
2022-12-19	AAA	ETF	24.4399	24.4399	24.41	24.41	502.0
2022-12-19	AAAU	ETF	17.77	17.82	17.71	17.73	329200.0
2022-12-19	AADR	ETF	47.38	47.48	47.32	47.47	900.0
2022-12-19	AAPB	ETF	16.3499	16.3499	15.8255	16.04	5852.0
2022-12-19	AAPD	ETF	29.26	30.059	29.25	29.82	345229.0
2022-12-19	AAPU	ETF	17.86	17.86	17.121	17.33	74960.0
2022-12-19	AAXJ	ETF	65.39	65.39	64.8	64.91	499800.0
2022-12-19	ABEQ	ETF	27.66	27.67	27.44	27.57	33100.0
2022-12-19	ACES	ETF	50.0	50.0	48.11	48.37	50600.0
2022-12-19	ACIO	ETF	29.0	29.02	28.843	28.908	43500.0
2022-12-19	ACSI	ETF	41.8012	41.8694	41.8012	41.8694	146.0
2022-12-19	ACT	ETF	23.86	24.1975	23.83	23.94	105398.0
2022-12-19	ACTV	ETF	29.04	29.04	28.665	28.7	4550.0
2022-12-19	ACTX	ETF	0.4	0.45	0.4	0.45	7111.0
2022-12-19	ACVF	ETF	29.88	29.88	29.555	29.621	2900.0
2022-12-19	ACWF	ETF	31.9	31.9	31.51	31.6	42667.0
2022-12-19	ACWI	ETF	85.11	85.14	84.1	84.4	5020400.0
2022-12-19	ACWV	ETF	94.86	94.96	94.06	94.26	173300.0
2022-12-19	ACWX	ETF	45.56	45.56	45.15	45.27	2568433.0
2022-12-19	ADFI	ETF	8.43	8.43	8.42	8.425	10200.0
2022-12-19	ADIV	ETF	12.996	12.996	12.996	12.996	100.0
2022-12-19	ADME	ETF	34.06	34.06	33.8	33.87	29400.0
2022-12-19	ADPV	ETF	25.15	25.15	25.11	25.138	25388.0
2022-12-19	ADRE	ETF	37.65	37.65	36.9834	37.3	4993.0
2022-12-19	AEMB	ETF	37.815	37.815	37.8	37.8	200.0
2022-12-19	AESR	ETF	11.46	11.49	11.33	11.41	23600.0
2022-12-19	AFIF	ETF	8.7975	8.81	8.77	8.8	23592.0
2022-12-19	AFK	ETF	16.54	16.54	16.031	16.13	14491.0
2022-12-19	AFLG	ETF	23.296	23.296	23.172	23.172	1300.0
2022-12-19	AFMC	ETF	22.035	22.035	22.035	22.035	100.0
2022-12-19	AFSM	ETF	22.55	22.55	22.495	22.495	100.0
2022-12-19	AFTY	ETF	16.05	16.05	16.05	16.05	100.0
2022-12-19	AGG	ETF	98.9	98.93	98.61	98.74	10351000.0
2022-12-19	AGGH	ETF	22.8159	22.8159	22.808	22.808	701.0
2022-12-19	AGGY	ETF	43.63	43.63	43.47	43.63	1117500.0
2022-12-19	AGNG	ETF	25.87	25.885	25.84	25.885	400.0
2022-12-19	AGOV	ETF	81.0001	81.834	81.0	81.405	8470.0
2022-12-19	AGOX	ETF	20.53	20.54	20.32	20.42	66300.0
2022-12-19	AGQ	ETF	30.21	30.3	29.23	29.45	685300.0
2022-12-19	AGZ	ETF	107.09	107.2	107.0501	107.2	24208.0
2022-12-19	AGZD	ETF	21.8	21.825	21.765	21.81	2128600.0
2022-12-19	AHHX	ETF	8.445	8.48	8.445	8.4713	2213.0
2022-12-19	AHYB	ETF	43.23	43.23	43.201	43.218	600.0
2022-12-19	AIA	ETF	57.08	57.08	56.491	56.67	195529.0

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

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