PREVIEW / etf_daily / 2022-12-27

all etf daily files

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

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-27	SPY	ETF	382.79	383.15	379.65	381.4	51638200.0
2022-12-27	QQQ	ETF	266.74	266.85	263.03	263.58	38009005.0
2022-12-27	IWM	ETF	174.36	174.57	172.58	173.22	13553800.0
2022-12-27	DIA	ETF	332.34	333.82	330.57	332.37	3098900.0
2022-12-27	GLD	ETF	167.89	170.61	167.8	168.67	6885700.0
2022-12-27	TLT	ETF	100.49	101.07	100.01	100.14	26475700.0
2022-12-27	AAA	ETF	24.425	24.425	24.425	24.425	86.0
2022-12-27	AAAU	ETF	17.9	18.19	17.9	17.99	362300.0
2022-12-27	AADR	ETF	47.47	47.8	47.47	47.64	7100.0
2022-12-27	AAPB	ETF	15.26	15.52	15.26	15.51	2031.0
2022-12-27	AAPD	ETF	29.94	30.52	29.94	30.26	198372.0
2022-12-27	AAPU	ETF	16.98	16.98	16.49	16.73	60006.0
2022-12-27	AAXJ	ETF	65.38	66.05	65.13	65.76	350100.0
2022-12-27	ABEQ	ETF	28.17	28.31	28.17	28.27	40300.0
2022-12-27	ACES	ETF	46.2	46.2	44.56	44.74	79200.0
2022-12-27	ACIO	ETF	28.88	29.0	28.82	28.89	116100.0
2022-12-27	ACSI	ETF	41.63	41.63	41.6126	41.6126	115.0
2022-12-27	ACT	ETF	24.27	24.37	24.075	24.12	52438.0
2022-12-27	ACTV	ETF	28.68	28.92	28.68	28.84	16364.0
2022-12-27	ACTX	ETF	0.322	0.322	0.2622	0.2622	443.0
2022-12-27	ACVF	ETF	29.83	29.83	29.61	29.646	2700.0
2022-12-27	ACWF	ETF	31.75	31.91	31.75	31.8637	7014.0
2022-12-27	ACWI	ETF	85.15	85.35	84.69	85.03	4102300.0
2022-12-27	ACWV	ETF	95.2	95.68	95.2	95.51	114400.0
2022-12-27	ACWX	ETF	45.76	46.025	45.73	45.88	4408963.0
2022-12-27	ADFI	ETF	8.37	8.37	8.345	8.345	3200.0
2022-12-27	ADIV	ETF	13.239	13.239	13.239	13.239	100.0
2022-12-27	ADME	ETF	33.82	33.9	33.69	33.69	181400.0
2022-12-27	ADPV	ETF	25.08	25.08	25.08	25.08	10788.0
2022-12-27	ADRE	ETF	37.5	37.8303	37.5	37.67	5132.0
2022-12-27	AEMB	ETF	37.555	37.555	37.555	37.555	100.0
2022-12-27	AESR	ETF	11.51	11.53	11.47	11.48	17600.0
2022-12-27	AFIF	ETF	8.77	8.79	8.77	8.79	24868.0
2022-12-27	AFK	ETF	16.41	16.69	16.328	16.39	14003.0
2022-12-27	AFLG	ETF	23.2	23.27	23.16	23.213	5900.0
2022-12-27	AFMC	ETF	22.32	22.32	22.32	22.32	100.0
2022-12-27	AFSM	ETF	22.8	22.8	22.717	22.717	600.0
2022-12-27	AFTY	ETF	15.78	15.879	15.77	15.879	5700.0
2022-12-27	AGG	ETF	97.46	97.62	97.21	97.26	7925700.0
2022-12-27	AGGH	ETF	23.94	24.1	22.05	22.4	11177.0
2022-12-27	AGGY	ETF	42.84	42.89	42.71	42.76	155000.0
2022-12-27	AGIH	ETF	24.22	24.22	24.175	24.175	121.0
2022-12-27	AGNG	ETF	26.27	26.27	26.05	26.052	3600.0
2022-12-27	AGOV	ETF	79.5	79.5766	79.345	79.345	1139.0
2022-12-27	AGOX	ETF	20.47	20.58	20.42	20.472	17400.0
2022-12-27	AGQ	ETF	31.77	32.96	31.74	32.25	713700.0
2022-12-27	AGZ	ETF	106.8	106.88	106.63	106.6862	36580.0
2022-12-27	AGZD	ETF	21.735	21.775	21.62	21.705	117200.0
2022-12-27	AHHX	ETF	8.43	8.4572	8.415	8.415	889.0
2022-12-27	AHYB	ETF	43.154	43.154	42.865	42.865	400.0

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

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