PREVIEW / etf_daily / 2022-12-28

all etf daily files

  file:    by_date/etf_daily/2022/2022-12-28.parquet
  size:    108 KB
  rows:    2,897

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-28	SPY	ETF	381.33	383.39	376.42	376.66	70911500.0
2022-12-28	QQQ	ETF	263.17	265.47	259.73	260.1	47139043.0
2022-12-28	IWM	ETF	173.18	174.1	170.34	170.53	19648000.0
2022-12-28	DIA	ETF	332.69	333.74	328.57	328.57	3102400.0
2022-12-28	GLD	ETF	168.05	168.34	167.1	167.91	3662500.0
2022-12-28	TLT	ETF	100.65	100.78	99.35	99.55	17302900.0
2022-12-28	AAA	ETF	24.469	24.47	24.44	24.44	1077.0
2022-12-28	AAAU	ETF	17.91	17.95	17.83	17.9	369200.0
2022-12-28	AADR	ETF	48.44	48.44	47.32	47.4	5000.0
2022-12-28	AAPB	ETF	15.24	15.55	14.64	14.64	12631.0
2022-12-28	AAPD	ETF	30.35	31.21	30.08	31.17	608179.0
2022-12-28	AAPU	ETF	16.45	16.84	15.9	15.96	102759.0
2022-12-28	AAXJ	ETF	65.4	65.47	64.42	64.42	1083700.0
2022-12-28	ABEQ	ETF	28.09	28.09	27.89	27.914	3500.0
2022-12-28	ACES	ETF	44.76	45.218	44.03	44.13	155900.0
2022-12-28	ACIO	ETF	28.71	28.755	28.58	28.64	29400.0
2022-12-28	ACSI	ETF	41.21	41.21	41.0819	41.0819	146.0
2022-12-28	ACT	ETF	24.09	24.09	23.58	23.63	69474.0
2022-12-28	ACTV	ETF	28.82	28.82	28.38	28.43	9626.0
2022-12-28	ACTX	ETF	0.2621	0.2621	0.2621	0.2621	131.0
2022-12-28	ACVF	ETF	29.606	29.606	29.352	29.352	7900.0
2022-12-28	ACWF	ETF	31.891	31.919	31.47	31.4756	12323.0
2022-12-28	ACWI	ETF	85.05	85.39	83.93	83.93	3474700.0
2022-12-28	ACWV	ETF	95.41	95.82	94.6	94.64	320000.0
2022-12-28	ACWX	ETF	45.91	46.0	45.315	45.32	2897949.0
2022-12-28	ADFI	ETF	8.35	8.35	8.305	8.305	10500.0
2022-12-28	ADIV	ETF	13.015	13.015	13.015	13.015	100.0
2022-12-28	ADME	ETF	33.565	33.565	33.42	33.45	40400.0
2022-12-28	ADPV	ETF	25.11	25.12	25.11	25.115	8377.0
2022-12-28	ADRE	ETF	37.69	37.69	36.99	37.22	61955.0
2022-12-28	AESR	ETF	11.51	11.51	11.34	11.34	64500.0
2022-12-28	AFIF	ETF	8.82	8.82	8.78	8.79	44834.0
2022-12-28	AFK	ETF	16.33	16.34	16.1	16.15	9294.0
2022-12-28	AFLG	ETF	22.98	22.98	22.88	22.88	200.0
2022-12-28	AFMC	ETF	22.0	22.01	21.904	21.904	200.0
2022-12-28	AFSM	ETF	22.4	22.4	22.288	22.288	200.0
2022-12-28	AFTY	ETF	15.74	15.74	15.617	15.617	3100.0
2022-12-28	AGG	ETF	97.47	97.5	97.08	97.09	12131200.0
2022-12-28	AGGH	ETF	22.44	22.46	22.39	22.46	1709.0
2022-12-28	AGGY	ETF	42.79	42.83	42.64	42.66	107700.0
2022-12-28	AGNG	ETF	26.035	26.06	25.88	25.88	900.0
2022-12-28	AGOV	ETF	78.295	78.295	78.295	78.295	254.0
2022-12-28	AGOX	ETF	20.48	20.48	20.11	20.11	39300.0
2022-12-28	AGQ	ETF	31.8	31.89	30.73	30.77	790000.0
2022-12-28	AGRH	ETF	25.36	25.36	25.345	25.345	296.0
2022-12-28	AGZ	ETF	106.77	106.91	106.6095	106.75	36874.0
2022-12-28	AGZD	ETF	21.775	21.78	21.66	21.705	152800.0
2022-12-28	AHHX	ETF	8.415	8.415	8.302	8.302	3640.0
2022-12-28	AHYB	ETF	42.85	42.85	42.314	42.314	400.0
2022-12-28	AIA	ETF	57.49	57.61	56.41	56.42	26993.0

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

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