PREVIEW / etf_daily / 2023-01-26

all etf daily files

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

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-26	SPY	ETF	403.13	404.92	400.03	404.75	72287400.0
2023-01-26	QQQ	ETF	291.22	293.52	288.519	293.34	51596335.0
2023-01-26	IWM	ETF	188.98	189.85	186.29	188.56	18369100.0
2023-01-26	DIA	ETF	338.45	339.46	336.2	339.36	2930900.0
2023-01-26	GLD	ETF	180.15	180.27	178.46	179.47	5860100.0
2023-01-26	TLT	ETF	107.14	107.65	106.49	106.98	15549400.0
2023-01-26	AAA	ETF	24.53	24.53	24.53	24.53	16.0
2023-01-26	AAAU	ETF	19.22	19.22	19.04	19.14	642600.0
2023-01-26	AADR	ETF	49.84	50.31	49.84	50.31	2100.0
2023-01-26	AAPB	ETF	18.0498	18.28	18.0498	18.2672	1459.0
2023-01-26	AAPD	ETF	27.42	27.6399	27.22	27.2781	161613.0
2023-01-26	AAPU	ETF	19.17	19.34	18.92	19.29	96997.0
2023-01-26	AAXJ	ETF	72.98	73.09	72.58	73.08	1605100.0
2023-01-26	ABEQ	ETF	28.72	28.884	28.72	28.884	6000.0
2023-01-26	ACES	ETF	51.53	51.845	49.83	50.49	38500.0
2023-01-26	ACIO	ETF	29.75	29.77	29.54	29.75	27400.0
2023-01-26	ACSI	ETF	44.9841	44.9841	44.9841	44.9841	44.0
2023-01-26	ACT	ETF	24.58	24.8	24.5114	24.75	127708.0
2023-01-26	ACTV	ETF	31.85	31.9	31.51	31.6601	11388.0
2023-01-26	ACVF	ETF	31.07	31.247	31.005	31.247	20000.0
2023-01-26	ACWF	ETF	33.8482	34.0225	33.77	34.0225	11599.0
2023-01-26	ACWI	ETF	91.11	91.36	90.4	91.32	5496300.0
2023-01-26	ACWV	ETF	97.54	97.54	96.76	97.48	213200.0
2023-01-26	ACWX	ETF	50.0	50.07	49.65	50.03	1000593.0
2023-01-26	ADFI	ETF	8.61	8.63	8.59	8.615	20400.0
2023-01-26	ADIV	ETF	14.868	14.868	14.868	14.868	100.0
2023-01-26	ADME	ETF	34.48	34.53	34.132	34.53	28000.0
2023-01-26	ADPV	ETF	25.1689	25.18	25.11	25.13	26855.0
2023-01-26	ADRE	ETF	43.76	43.9105	43.51	43.88	10622.0
2023-01-26	AEMB	ETF	39.456	39.456	39.456	39.456	200.0
2023-01-26	AESR	ETF	11.84	11.84	11.73	11.814	5500.0
2023-01-26	AFIF	ETF	8.855	8.86	8.84	8.86	22448.0
2023-01-26	AFK	ETF	17.53	17.63	17.4892	17.51	10101.0
2023-01-26	AFLG	ETF	24.07	24.26	24.07	24.26	400.0
2023-01-26	AFMC	ETF	23.71	23.767	23.71	23.767	100.0
2023-01-26	AFSM	ETF	24.071	24.071	24.071	24.071	100.0
2023-01-26	AFTY	ETF	17.93	17.977	17.93	17.977	1500.0
2023-01-26	AGG	ETF	100.33	100.46	100.07	100.23	5399100.0
2023-01-26	AGGH	ETF	22.7	22.74	22.7	22.73	3628.0
2023-01-26	AGGY	ETF	44.15	44.184	43.99	44.09	199200.0
2023-01-26	AGNG	ETF	26.99	26.99	26.94	26.962	1100.0
2023-01-26	AGOV	ETF	81.78	81.78	79.59	79.59	551.0
2023-01-26	AGOX	ETF	21.83	22.03	21.8	22.018	12400.0
2023-01-26	AGQ	ETF	32.27	32.32	31.13	31.7	567800.0
2023-01-26	AGRH	ETF	25.58	25.69	25.58	25.6399	351.0
2023-01-26	AGZ	ETF	108.38	108.39	108.21	108.34	149298.0
2023-01-26	AGZD	ETF	21.86	21.92	21.825	21.895	87800.0
2023-01-26	AHHX	ETF	8.66	8.7059	8.64	8.7059	4497.0
2023-01-26	AHYB	ETF	44.38	44.44	44.3	44.44	2900.0
2023-01-26	AIA	ETF	67.21	67.35	66.79	67.35	337471.0

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

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