PREVIEW / etf_daily / 2022-12-13

all etf daily files

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

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-13	SPY	ETF	410.22	410.49	399.07	401.97	123782500.0
2022-12-13	QQQ	ETF	296.65	296.875	285.91	288.65	80667675.0
2022-12-13	IWM	ETF	185.73	186.64	180.14	181.38	38445300.0
2022-12-13	DIA	ETF	348.18	348.22	339.5	341.81	5274300.0
2022-12-13	GLD	ETF	169.21	169.79	168.02	168.51	6750200.0
2022-12-13	TLT	ETF	109.04	109.08	107.46	107.7	23854700.0
2022-12-13	AAA	ETF	24.34	24.34	24.34	24.34	1.0
2022-12-13	AAAU	ETF	18.04	18.1	17.92	17.96	419600.0
2022-12-13	AADR	ETF	49.15	49.23	48.57	48.67	2500.0
2022-12-13	AAPB	ETF	19.96	19.96	18.98	19.01	1134.0
2022-12-13	AAPD	ETF	26.41	27.405	26.4	27.2089	296600.0
2022-12-13	AAPU	ETF	20.89	20.89	19.75	20.02	127274.0
2022-12-13	AAXJ	ETF	67.1	67.43	66.21	66.41	1779200.0
2022-12-13	ABEQ	ETF	28.41	28.41	28.21	28.312	10200.0
2022-12-13	ACES	ETF	53.24	53.82	51.64	52.27	71400.0
2022-12-13	ACIO	ETF	30.27	30.27	29.664	29.78	20300.0
2022-12-13	ACSI	ETF	45.87	45.87	44.2	44.2	895.0
2022-12-13	ACT	ETF	24.76	25.205	24.07	24.31	685040.0
2022-12-13	ACTV	ETF	31.47	31.47	30.63	30.77	7313.0
2022-12-13	ACTX	ETF	0.3	0.3	0.3	0.3	24114.0
2022-12-13	ACVF	ETF	31.86	31.86	30.93	31.133	6700.0
2022-12-13	ACWF	ETF	33.48	33.5	32.945	32.97	8562.0
2022-12-13	ACWI	ETF	89.92	89.92	87.8	88.25	9199600.0
2022-12-13	ACWV	ETF	98.37	98.42	96.78	96.92	165200.0
2022-12-13	ACWX	ETF	47.39	47.47	46.63	46.76	3566290.0
2022-12-13	ADFI	ETF	8.59	8.6	8.54	8.55	7600.0
2022-12-13	ADIV	ETF	13.321	13.321	13.321	13.321	100.0
2022-12-13	ADME	ETF	35.31	35.31	34.86	34.9	15100.0
2022-12-13	ADPV	ETF	25.13	25.13	25.12	25.12	16892.0
2022-12-13	ADRE	ETF	39.67	39.67	38.77	38.8414	6086.0
2022-12-13	AEMB	ETF	38.653	38.653	38.653	38.653	100.0
2022-12-13	AESR	ETF	12.09	12.14	11.895	11.98	21500.0
2022-12-13	AFIF	ETF	8.85	8.86	8.83	8.835	11659.0
2022-12-13	AFK	ETF	17.33	17.5	17.1419	17.2	3972.0
2022-12-13	AFLG	ETF	24.676	24.676	24.2	24.276	1200.0
2022-12-13	AFMC	ETF	23.02	23.16	22.98	23.042	11100.0
2022-12-13	AFSM	ETF	23.484	23.484	23.484	23.484	100.0
2022-12-13	AFTY	ETF	16.3	16.3	16.169	16.169	1100.0
2022-12-13	AGG	ETF	100.18	100.18	99.4	99.47	9120600.0
2022-12-13	AGGY	ETF	44.09	44.1	43.77	43.81	85000.0
2022-12-13	AGNG	ETF	27.17	27.17	26.8	26.888	4400.0
2022-12-13	AGOV	ETF	81.35	82.0245	81.35	82.0245	447.0
2022-12-13	AGOX	ETF	21.64	21.644	21.23	21.31	28600.0
2022-12-13	AGQ	ETF	32.46	32.75	31.21	31.66	944000.0
2022-12-13	AGZ	ETF	107.5664	107.635	107.2507	107.37	23658.0
2022-12-13	AGZD	ETF	21.765	22.085	21.765	21.81	333800.0
2022-12-13	AHHX	ETF	8.61	8.6454	8.6	8.6454	5066.0
2022-12-13	AHYB	ETF	44.01	44.215	44.01	44.215	400.0
2022-12-13	AIA	ETF	59.07	59.415	58.11	58.31	35755.0
2022-12-13	AIEQ	ETF	31.08	31.19	30.2	30.384	15000.0

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

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