PREVIEW / etf_daily / 2023-01-05

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-05.parquet
  size:    107 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-05	SPY	ETF	381.72	381.84	378.76	379.38	76970500.0
2023-01-05	QQQ	ETF	264.04	264.21	261.26	261.58	45396744.0
2023-01-05	IWM	ETF	174.59	174.76	172.39	173.68	17032600.0
2023-01-05	DIA	ETF	330.97	331.15	328.1	329.22	4350100.0
2023-01-05	GLD	ETF	170.82	171.0	169.79	170.52	4692600.0
2023-01-05	TLT	ETF	101.87	103.29	101.78	103.28	14771100.0
2023-01-05	AAA	ETF	24.38	24.38	24.38	24.38	5.0
2023-01-05	AAAU	ETF	18.22	18.23	18.11	18.19	195200.0
2023-01-05	AADR	ETF	47.19	47.34	47.03	47.34	2600.0
2023-01-05	AAPB	ETF	14.81	14.8933	14.36	14.4127	4095.0
2023-01-05	AAPD	ETF	30.9	31.4601	30.77	31.3901	146778.0
2023-01-05	AAPU	ETF	16.11	16.2	15.6558	15.72	117488.0
2023-01-05	AAXJ	ETF	67.52	67.72	67.24	67.56	1115700.0
2023-01-05	ABEQ	ETF	28.26	28.31	28.14	28.3	30800.0
2023-01-05	ACES	ETF	45.1	45.14	44.03	44.14	19000.0
2023-01-05	ACIO	ETF	28.677	28.69	28.559	28.56	25200.0
2023-01-05	ACSI	ETF	41.58	41.58	41.5189	41.5189	4033.0
2023-01-05	ACT	ETF	24.15	24.28	23.74	23.76	77156.0
2023-01-05	ACTV	ETF	29.68	29.93	29.6501	29.78	10356.0
2023-01-05	ACTX	ETF	0.4	0.4	0.4	0.4	172.0
2023-01-05	ACVF	ETF	29.78	29.78	29.49	29.516	2400.0
2023-01-05	ACWF	ETF	31.81	31.8582	31.745	31.7727	4338.0
2023-01-05	ACWI	ETF	85.42	85.52	84.92	85.1	8268000.0
2023-01-05	ACWV	ETF	95.27	95.56	95.05	95.19	213100.0
2023-01-05	ACWX	ETF	46.24	46.46	46.18	46.3	2761340.0
2023-01-05	ADFI	ETF	8.38	8.41	8.38	8.41	5800.0
2023-01-05	ADIV	ETF	13.45	13.53	13.45	13.53	400.0
2023-01-05	ADME	ETF	33.17	33.31	33.17	33.17	23600.0
2023-01-05	ADPV	ETF	25.071	25.3	25.07	25.13	43325.0
2023-01-05	ADRE	ETF	38.98	39.415	38.94	39.4034	6769.0
2023-01-05	AEMB	ETF	37.75	37.75	37.75	37.75	100.0
2023-01-05	AESR	ETF	11.32	11.41	11.3	11.33	19300.0
2023-01-05	AFIF	ETF	8.76	8.77	8.75	8.77	3162.0
2023-01-05	AFK	ETF	16.44	16.45	16.15	16.3	18134.0
2023-01-05	AFLG	ETF	22.936	22.936	22.936	22.936	100.0
2023-01-05	AFMC	ETF	22.21	22.21	22.197	22.197	100.0
2023-01-05	AFSM	ETF	22.46	22.54	22.398	22.455	2800.0
2023-01-05	AFTY	ETF	16.419	16.419	16.419	16.419	200.0
2023-01-05	AGG	ETF	97.64	98.06	97.57	98.02	9682000.0
2023-01-05	AGGH	ETF	22.48	22.48	22.48	22.48	214.0
2023-01-05	AGGY	ETF	42.95	43.12	42.89	43.12	661200.0
2023-01-05	AGNG	ETF	26.26	26.575	24.99	26.39	4300.0
2023-01-05	AGOV	ETF	78.92	78.92	78.92	78.92	3.0
2023-01-05	AGOX	ETF	20.47	20.48	20.39	20.422	5300.0
2023-01-05	AGQ	ETF	30.3	30.38	29.73	30.03	928800.0
2023-01-05	AGZ	ETF	106.73	106.8899	106.63	106.77	117928.0
2023-01-05	AGZD	ETF	21.755	21.775	21.715	21.77	336600.0
2023-01-05	AHHX	ETF	8.45	8.45	8.39	8.4347	658.0
2023-01-05	AHYB	ETF	43.278	43.364	43.278	43.364	400.0
2023-01-05	AIA	ETF	60.3	60.7959	60.12	60.68	22579.0

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

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