PREVIEW / etf_daily / 2022-12-14

all etf daily files

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

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-14	SPY	ETF	401.61	405.5	396.31	399.4	108111300.0
2022-12-14	QQQ	ETF	288.05	291.41	283.19	286.51	64984432.0
2022-12-14	IWM	ETF	181.31	182.91	178.83	180.19	32406900.0
2022-12-14	DIA	ETF	341.78	344.66	337.64	340.22	5498400.0
2022-12-14	GLD	ETF	168.43	168.81	167.14	168.1	5643000.0
2022-12-14	TLT	ETF	107.66	108.32	106.89	108.16	19517500.0
2022-12-14	AAA	ETF	24.355	24.37	24.33	24.37	1571.0
2022-12-14	AAAU	ETF	17.96	18.0	17.83	17.93	451300.0
2022-12-14	AADR	ETF	48.46	48.46	48.34	48.34	800.0
2022-12-14	AAPB	ETF	18.42	18.54	18.04	18.4559	1423.0
2022-12-14	AAPD	ETF	27.23	28.0	26.9904	27.6192	112201.0
2022-12-14	AAPU	ETF	19.99	20.19	19.13	19.54	58345.0
2022-12-14	AAXJ	ETF	66.5	66.8	66.04	66.47	628200.0
2022-12-14	ABEQ	ETF	28.346	28.53	28.16	28.367	11500.0
2022-12-14	ACES	ETF	52.24	53.36	52.24	52.62	118100.0
2022-12-14	ACIO	ETF	29.89	29.94	29.623	29.65	47900.0
2022-12-14	ACSI	ETF	43.9567	43.9567	43.9567	43.9567	79.0
2022-12-14	ACT	ETF	24.16	24.47	23.9	23.93	100417.0
2022-12-14	ACTV	ETF	30.81	31.12	30.6699	30.6699	4624.0
2022-12-14	ACTX	ETF	0.35	0.4	0.3375	0.4	10889.0
2022-12-14	ACVF	ETF	31.16	31.35	30.91	30.924	3700.0
2022-12-14	ACWF	ETF	33.009	33.009	32.7591	32.7591	2005.0
2022-12-14	ACWI	ETF	88.3	89.0	87.25	87.91	6056000.0
2022-12-14	ACWV	ETF	96.96	97.81	96.55	97.02	217200.0
2022-12-14	ACWX	ETF	46.88	47.1	46.43	46.75	2837965.0
2022-12-14	ADFI	ETF	8.56	8.565	8.53	8.555	9300.0
2022-12-14	ADIV	ETF	13.44	13.44	13.399	13.399	2500.0
2022-12-14	ADME	ETF	35.005	35.067	34.74	34.756	17600.0
2022-12-14	ADPV	ETF	25.08	25.31	25.08	25.11	29498.0
2022-12-14	ADRE	ETF	38.82	38.98	38.51	38.65	5218.0
2022-12-14	AEMB	ETF	38.552	38.552	38.447	38.447	200.0
2022-12-14	AESR	ETF	11.99	12.06	11.86	11.95	65500.0
2022-12-14	AFIF	ETF	8.8592	8.8592	8.78	8.805	7851.0
2022-12-14	AFK	ETF	17.3	17.3	17.19	17.24	8663.0
2022-12-14	AFLG	ETF	24.41	24.44	24.154	24.154	200.0
2022-12-14	AFMC	ETF	23.18	23.18	22.968	22.968	100.0
2022-12-14	AFSM	ETF	23.29	23.368	23.29	23.368	100.0
2022-12-14	AFTY	ETF	16.37	16.39	16.366	16.366	1100.0
2022-12-14	AGG	ETF	99.52	99.79	99.17	99.69	10624000.0
2022-12-14	AGGY	ETF	43.86	43.95	43.71	43.91	232400.0
2022-12-14	AGNG	ETF	27.04	27.04	27.0	27.0	300.0
2022-12-14	AGOV	ETF	80.33	81.4927	80.33	81.4927	304.0
2022-12-14	AGOX	ETF	21.36	21.417	21.12	21.204	11000.0
2022-12-14	AGQ	ETF	31.9	32.5	30.75	32.13	984900.0
2022-12-14	AGZ	ETF	107.5199	107.5299	107.16	107.395	16171.0
2022-12-14	AGZD	ETF	21.87	21.87	21.75	21.845	188800.0
2022-12-14	AHHX	ETF	8.61	8.63	8.55	8.5824	2682.0
2022-12-14	AHYB	ETF	44.22	44.22	43.84	44.006	400.0
2022-12-14	AIA	ETF	58.18	58.54	57.86	58.3	57785.0
2022-12-14	AIEQ	ETF	30.17	30.667	30.17	30.29	9000.0

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

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