PREVIEW / etf_daily / 2023-01-10

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-10.parquet
  size:    108 KB
  rows:    2,901

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
2023-01-10	SPY	ETF	387.25	390.65	386.27	390.58	65358100.0
2023-01-10	QQQ	ETF	269.49	272.94	268.97	272.83	35247763.0
2023-01-10	IWM	ETF	177.66	180.62	177.3	180.51	18751100.0
2023-01-10	DIA	ETF	334.95	337.33	334.29	337.23	2277500.0
2023-01-10	GLD	ETF	174.61	174.98	174.06	174.74	4398400.0
2023-01-10	TLT	ETF	104.53	104.82	103.5	103.99	20545200.0
2023-01-10	AAA	ETF	24.383	24.43	24.3815	24.42	4192.0
2023-01-10	AAAU	ETF	18.63	18.66	18.57	18.64	344300.0
2023-01-10	AADR	ETF	47.88	48.89	47.88	48.89	1000.0
2023-01-10	AAPB	ETF	15.49	15.56	15.01	15.56	8246.0
2023-01-10	AAPD	ETF	30.16	30.62	29.92	30.0242	109957.0
2023-01-10	AAPU	ETF	16.65	16.8176	16.29	16.79	37556.0
2023-01-10	AAXJ	ETF	69.35	69.73	69.09	69.72	980200.0
2023-01-10	ABEQ	ETF	28.41	28.69	28.41	28.674	9700.0
2023-01-10	ACES	ETF	46.36	47.27	45.7	47.27	24300.0
2023-01-10	ACIO	ETF	29.05	29.05	28.7	29.01	45200.0
2023-01-10	ACSI	ETF	42.988	42.988	42.988	42.988	32.0
2023-01-10	ACT	ETF	23.78	23.96	23.59	23.65	126235.0
2023-01-10	ACTV	ETF	30.4172	30.7157	30.35	30.7157	8541.0
2023-01-10	ACVF	ETF	30.232	30.37	30.19	30.364	3400.0
2023-01-10	ACWF	ETF	32.615	32.69	32.4124	32.69	10981.0
2023-01-10	ACWI	ETF	87.19	87.77	86.92	87.75	4361200.0
2023-01-10	ACWV	ETF	96.17	96.55	96.1	96.53	234500.0
2023-01-10	ACWX	ETF	47.68	47.84	47.5	47.84	1368770.0
2023-01-10	ADFI	ETF	8.5	8.5	8.47	8.48	7100.0
2023-01-10	ADIV	ETF	13.997	13.997	13.997	13.997	100.0
2023-01-10	ADME	ETF	33.654	33.71	33.531	33.65	28700.0
2023-01-10	ADPV	ETF	25.08	25.13	25.08	25.08	20711.0
2023-01-10	ADRE	ETF	40.67	41.13	40.555	41.13	7241.0
2023-01-10	AEMB	ETF	38.24	38.24	38.24	38.24	100.0
2023-01-10	AESR	ETF	11.47	11.55	11.47	11.52	33000.0
2023-01-10	AFIF	ETF	8.8	8.82	8.78	8.82	55512.0
2023-01-10	AFK	ETF	16.94	16.98	16.565	16.83	8368.0
2023-01-10	AFLG	ETF	23.41	23.529	23.41	23.529	200.0
2023-01-10	AFMC	ETF	22.62	22.834	22.62	22.834	200.0
2023-01-10	AFSM	ETF	22.85	23.13	22.85	23.12	8500.0
2023-01-10	AFTY	ETF	16.87	16.92	16.87	16.92	300.0
2023-01-10	AGG	ETF	99.02	99.15	98.74	98.96	7291300.0
2023-01-10	AGGH	ETF	22.63	22.63	22.63	22.63	159.0
2023-01-10	AGGY	ETF	43.63	43.68	43.52	43.61	139100.0
2023-01-10	AGNG	ETF	26.6	26.84	26.6	26.84	400.0
2023-01-10	AGOV	ETF	80.485	80.485	80.485	80.485	50.0
2023-01-10	AGOX	ETF	20.82	21.14	20.82	21.06	18400.0
2023-01-10	AGQ	ETF	30.99	31.37	30.74	30.94	331200.0
2023-01-10	AGZ	ETF	107.52	107.52	107.3465	107.43	12679.0
2023-01-10	AGZD	ETF	21.8	21.825	21.745	21.805	60000.0
2023-01-10	AHHX	ETF	8.51	8.59	8.51	8.56	9381.0
2023-01-10	AHYB	ETF	43.986	44.065	43.986	44.065	400.0
2023-01-10	AIA	ETF	62.72	63.24	62.42	63.24	125545.0
2023-01-10	AIEQ	ETF	29.48	30.07	29.44	30.07	5600.0

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

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