PREVIEW / etf_daily / 2022-12-21

all etf daily files

  file:    by_date/etf_daily/2022/2022-12-21.parquet
  size:    107 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-21	SPY	ETF	383.25	387.41	382.69	386.23	78167400.0
2022-12-21	QQQ	ETF	270.6	274.78	269.74	273.45	46394694.0
2022-12-21	IWM	ETF	174.45	176.8	174.2	175.9	22997200.0
2022-12-21	DIA	ETF	331.54	334.33	331.12	333.6	5086800.0
2022-12-21	GLD	ETF	169.04	169.71	168.68	168.8	3990100.0
2022-12-21	TLT	ETF	104.29	104.4	102.96	103.7	15894100.0
2022-12-21	AAA	ETF	24.42	24.42	24.36	24.3839	7987.0
2022-12-21	AAAU	ETF	18.02	18.09	17.99	18.0	379500.0
2022-12-21	AADR	ETF	48.04	48.8	48.04	48.8	4900.0
2022-12-21	AAPB	ETF	16.07	16.8462	16.07	16.69	3793.0
2022-12-21	AAPD	ETF	29.62	29.62	28.74	29.0297	143052.0
2022-12-21	AAPU	ETF	17.3	18.0201	17.3	17.81	146633.0
2022-12-21	AAXJ	ETF	64.61	65.25	64.37	65.2	974500.0
2022-12-21	ABEQ	ETF	27.98	28.09	27.9	28.05	28400.0
2022-12-21	ACES	ETF	48.25	48.85	47.437	48.66	102800.0
2022-12-21	ACIO	ETF	29.03	29.22	29.03	29.12	32500.0
2022-12-21	ACSI	ETF	42.64	42.64	42.5006	42.5006	106.0
2022-12-21	ACT	ETF	24.59	24.86	24.36	24.63	153160.0
2022-12-21	ACTV	ETF	29.09	29.2799	29.06	29.17	8170.0
2022-12-21	ACTX	ETF	0.44	0.44	0.44	0.44	5001.0
2022-12-21	ACVF	ETF	29.75	30.04	29.75	30.004	5700.0
2022-12-21	ACWF	ETF	31.74	31.97	31.705	31.9291	15251.0
2022-12-21	ACWI	ETF	85.12	85.94	84.98	85.7	3799300.0
2022-12-21	ACWV	ETF	94.8	95.55	94.79	95.3	215900.0
2022-12-21	ACWX	ETF	45.61	45.96	45.54	45.88	2459742.0
2022-12-21	ADFI	ETF	8.44	8.45	8.42	8.435	5500.0
2022-12-21	ADIV	ETF	13.096	13.096	13.096	13.096	100.0
2022-12-21	ADME	ETF	33.9	34.085	33.9	34.01	26200.0
2022-12-21	ADPV	ETF	25.03	25.09	25.03	25.07	56862.0
2022-12-21	ADRE	ETF	37.43	38.062	37.43	38.062	4918.0
2022-12-21	AEMB	ETF	38.02	38.08	38.0	38.08	4300.0
2022-12-21	AESR	ETF	11.48	11.59	11.48	11.58	14300.0
2022-12-21	AFIF	ETF	8.79	8.83	8.79	8.81	71623.0
2022-12-21	AFK	ETF	16.06	16.41	16.06	16.36	23831.0
2022-12-21	AFLG	ETF	23.518	23.518	23.518	23.518	100.0
2022-12-21	AFMC	ETF	22.478	22.478	22.478	22.478	100.0
2022-12-21	AFSM	ETF	23.052	23.052	23.052	23.052	400.0
2022-12-21	AFTY	ETF	15.86	15.92	15.84	15.915	3800.0
2022-12-21	AGG	ETF	98.49	98.54	98.19	98.34	8489300.0
2022-12-21	AGGH	ETF	22.69	22.7115	22.68	22.7115	303.0
2022-12-21	AGGY	ETF	43.4	43.43	43.28	43.34	168000.0
2022-12-21	AGNG	ETF	26.116	26.409	26.07	26.245	5500.0
2022-12-21	AGOV	ETF	80.49	80.49	80.49	80.49	61.0
2022-12-21	AGOX	ETF	20.6	20.85	20.6	20.818	40500.0
2022-12-21	AGQ	ETF	32.23	32.8	32.05	32.21	602900.0
2022-12-21	AGZ	ETF	107.05	107.28	107.0248	107.28	89807.0
2022-12-21	AGZD	ETF	21.775	21.855	21.765	21.815	173800.0
2022-12-21	AHHX	ETF	8.51	8.525	8.5	8.525	336.0
2022-12-21	AHYB	ETF	43.443	43.443	43.443	43.443	400.0
2022-12-21	AIA	ETF	56.36	57.2	56.25	57.2	36688.0

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

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