PREVIEW / etf_daily / 2023-04-11

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-11.parquet
  size:    109 KB
  rows:    2,948

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-04-11	SPY	ETF	410.26	411.18	408.92	409.72	59297900.0
2023-04-11	QQQ	ETF	317.83	317.89	315.31	315.83	40113594.0
2023-04-11	IWM	ETF	176.57	177.97	176.12	177.14	21876200.0
2023-04-11	DIA	ETF	336.31	337.87	336.01	336.9	2343100.0
2023-04-11	GLD	ETF	185.91	186.51	185.64	186.28	6031500.0
2023-04-11	TLT	ETF	107.05	107.09	106.51	107.0	13971200.0
2023-04-11	AAA	ETF	24.5299	24.53	24.485	24.485	411.0
2023-04-11	AAAU	ETF	19.84	19.9	19.81	19.88	1930100.0
2023-04-11	AADR	ETF	48.18	48.2	48.09	48.2	1700.0
2023-04-11	AAPB	ETF	21.71	21.85	21.63	21.68	3333.0
2023-04-11	AAPD	ETF	24.06	24.31	24.06	24.29	375026.0
2023-04-11	AAPU	ETF	22.72	22.72	22.37	22.43	102467.0
2023-04-11	AAXJ	ETF	68.15	68.41	68.07	68.13	309000.0
2023-04-11	ABEQ	ETF	28.515	28.532	28.469	28.469	3200.0
2023-04-11	ACES	ETF	44.58	45.37	44.523	45.18	37100.0
2023-04-11	ACIO	ETF	30.222	30.31	30.206	30.24	25900.0
2023-04-11	ACSI	ETF	44.4717	44.4717	44.4717	44.4717	32.0
2023-04-11	ACT	ETF	23.31	24.05	23.31	23.91	78082.0
2023-04-11	ACTV	ETF	29.3	29.7201	29.3	29.627	15232.0
2023-04-11	ACTX	ETF	0.3	0.3	0.3	0.3	218.0
2023-04-11	ACVF	ETF	31.41	31.53	31.41	31.417	5600.0
2023-04-11	ACWF	ETF	33.76	33.87	33.7101	33.7716	22552.0
2023-04-11	ACWI	ETF	91.49	91.75	91.35	91.5	2008000.0
2023-04-11	ACWV	ETF	98.05	98.37	98.05	98.21	146000.0
2023-04-11	ACWX	ETF	49.14	49.29	49.13	49.2	1208920.0
2023-04-11	ADFI	ETF	8.55	8.58	8.55	8.565	29600.0
2023-04-11	ADIV	ETF	13.82	13.82	13.82	13.82	100.0
2023-04-11	ADME	ETF	34.94	34.94	34.736	34.736	8100.0
2023-04-11	ADPV	ETF	23.27	23.27	22.9	23.0786	9337.0
2023-04-11	AEMB	ETF	37.74	37.825	37.74	37.825	2400.0
2023-04-11	AESR	ETF	12.08	12.14	12.05	12.1	89200.0
2023-04-11	AFIF	ETF	8.85	8.8506	8.82	8.8301	56998.0
2023-04-11	AFK	ETF	16.01	16.13	15.91	15.99	23684.0
2023-04-11	AFLG	ETF	24.08	24.08	24.043	24.043	200.0
2023-04-11	AFMC	ETF	23.07	23.07	23.07	23.07	2000.0
2023-04-11	AFSM	ETF	23.05	23.15	23.05	23.068	3500.0
2023-04-11	AFTY	ETF	16.148	16.148	16.148	16.148	100.0
2023-04-11	AGG	ETF	99.81	99.88	99.59	99.81	4543800.0
2023-04-11	AGGY	ETF	43.95	43.95	43.81	43.84	147300.0
2023-04-11	AGIH	ETF	24.79	24.85	24.79	24.85	206.0
2023-04-11	AGNG	ETF	27.5	27.56	27.47	27.55	2000.0
2023-04-11	AGOV	ETF	78.09	78.8	76.14	77.83	1249.0
2023-04-11	AGOX	ETF	21.77	21.77	21.62	21.724	32200.0
2023-04-11	AGQ	ETF	33.41	34.0	33.24	33.75	710300.0
2023-04-11	AGRH	ETF	25.45	25.45	25.45	25.45	112.0
2023-04-11	AGZ	ETF	108.39	108.41	108.2953	108.35	25378.0
2023-04-11	AGZD	ETF	21.76	21.845	21.74	21.82	72000.0
2023-04-11	AHYB	ETF	43.93	44.01	43.93	44.0	900.0
2023-04-11	AIA	ETF	61.69	61.71	61.3	61.3	23674.0
2023-04-11	AIEQ	ETF	28.57	29.1	28.57	28.95	14600.0

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

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