PREVIEW / etf_daily / 2023-01-11

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-11.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-11	SPY	ETF	392.23	395.6	391.38	395.52	68881100.0
2023-01-11	QQQ	ETF	273.92	277.66	273.12	277.55	44077036.0
2023-01-11	IWM	ETF	181.26	182.79	180.68	182.76	18222700.0
2023-01-11	DIA	ETF	338.4	339.81	337.13	339.76	3265800.0
2023-01-11	GLD	ETF	174.76	174.79	173.72	174.62	3374200.0
2023-01-11	TLT	ETF	104.97	105.72	104.7	105.68	18794000.0
2023-01-11	AAA	ETF	24.395	24.395	24.395	24.395	112.0
2023-01-11	AAAU	ETF	18.64	18.65	18.53	18.62	594700.0
2023-01-11	AADR	ETF	48.58	48.9	48.52	48.68	3000.0
2023-01-11	AAPB	ETF	15.59	16.06	15.57	16.06	5033.0
2023-01-11	AAPD	ETF	29.82	30.05	29.34	29.34	113094.0
2023-01-11	AAPU	ETF	16.93	17.29	16.75	17.29	106716.0
2023-01-11	AAXJ	ETF	69.57	70.03	69.45	69.9	2644800.0
2023-01-11	ABEQ	ETF	28.66	28.753	28.632	28.753	7700.0
2023-01-11	ACES	ETF	47.45	49.43	47.41	49.41	73400.0
2023-01-11	ACIO	ETF	29.12	29.28	29.105	29.27	55700.0
2023-01-11	ACSI	ETF	43.5885	43.5885	43.5885	43.5885	30.0
2023-01-11	ACT	ETF	23.77	23.87	23.68	23.8	184421.0
2023-01-11	ACTV	ETF	31.05	31.05	30.82	31.03	10380.0
2023-01-11	ACVF	ETF	30.56	30.698	30.56	30.698	2500.0
2023-01-11	ACWF	ETF	32.81	33.02	32.78	33.02	14854.0
2023-01-11	ACWI	ETF	88.07	88.69	87.91	88.67	13190300.0
2023-01-11	ACWV	ETF	96.44	96.84	96.32	96.75	860200.0
2023-01-11	ACWX	ETF	47.99	48.17	47.87	48.16	1193312.0
2023-01-11	ADFI	ETF	8.51	8.54	8.51	8.535	13700.0
2023-01-11	ADIV	ETF	14.1	14.1	14.1	14.1	100.0
2023-01-11	ADME	ETF	33.86	33.97	33.74	33.95	36300.0
2023-01-11	ADPV	ETF	25.08	25.13	25.08	25.115	20466.0
2023-01-11	ADRE	ETF	41.08	41.32	40.8517	41.32	3598.0
2023-01-11	AEMB	ETF	38.77	38.77	38.51	38.69	116600.0
2023-01-11	AESR	ETF	11.6	11.68	11.55	11.68	22300.0
2023-01-11	AFIF	ETF	8.82	8.82	8.8	8.815	12029.0
2023-01-11	AFK	ETF	17.22	17.22	16.74	16.95	10238.0
2023-01-11	AFLG	ETF	23.76	23.823	23.76	23.823	200.0
2023-01-11	AFMC	ETF	23.07	23.119	23.07	23.119	700.0
2023-01-11	AFSM	ETF	23.4	23.4	23.22	23.361	6900.0
2023-01-11	AFTY	ETF	16.985	16.985	16.985	16.985	100.0
2023-01-11	AGG	ETF	99.28	99.57	99.26	99.57	6102900.0
2023-01-11	AGGY	ETF	43.71	43.84	43.7	43.84	1396900.0
2023-01-11	AGNG	ETF	26.68	26.8	26.15	26.776	6400.0
2023-01-11	AGOV	ETF	80.655	80.655	80.655	80.655	19.0
2023-01-11	AGOX	ETF	21.22	21.34	21.159	21.34	52500.0
2023-01-11	AGQ	ETF	31.29	31.39	29.91	30.46	691500.0
2023-01-11	AGZ	ETF	107.48	107.78	107.48	107.78	12367.0
2023-01-11	AGZD	ETF	21.795	21.825	21.795	21.805	33400.0
2023-01-11	AHHX	ETF	8.63	8.6455	8.6	8.6455	99954.0
2023-01-11	AHYB	ETF	44.305	44.305	44.305	44.305	200.0
2023-01-11	AIA	ETF	63.23	63.69	63.02	63.69	138171.0
2023-01-11	AIEQ	ETF	30.21	30.51	30.1	30.51	8500.0
2023-01-11	AIQ	ETF	21.42	21.67	21.29	21.635	35160.0

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

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