PREVIEW / etf_daily / 2023-03-06

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-06.parquet
  size:    109 KB
  rows:    2,935

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-03-06	SPY	ETF	405.05	407.45	404.01	404.47	72795900.0
2023-03-06	QQQ	ETF	300.94	304.0	299.82	300.02	56736294.0
2023-03-06	IWM	ETF	191.56	191.74	187.9	188.7	23266700.0
2023-03-06	DIA	ETF	334.63	336.12	334.18	334.68	2641700.0
2023-03-06	GLD	ETF	172.32	172.37	171.54	171.62	4264100.0
2023-03-06	TLT	ETF	102.22	102.34	100.99	101.1	16631900.0
2023-03-06	AAA	ETF	24.54	24.54	24.485	24.485	211.0
2023-03-06	AAAU	ETF	18.38	18.39	18.3	18.31	1424300.0
2023-03-06	AADR	ETF	49.84	49.84	49.51	49.73	900.0
2023-03-06	AAPB	ETF	20.32	20.71	20.25	20.25	17616.0
2023-03-06	AAPD	ETF	25.45	25.53	25.06	25.48	356219.0
2023-03-06	AAPU	ETF	21.22	21.6993	21.13	21.21	242756.0
2023-03-06	AAXJ	ETF	67.84	68.01	67.47	67.47	948300.0
2023-03-06	ABEQ	ETF	28.09	28.09	27.965	27.989	2200.0
2023-03-06	ACES	ETF	49.22	49.86	48.81	48.94	104500.0
2023-03-06	ACIO	ETF	29.756	29.9	29.73	29.767	190200.0
2023-03-06	ACSI	ETF	44.86	44.86	44.58	44.61	11464.0
2023-03-06	ACT	ETF	24.49	24.83	24.35	24.47	96540.0
2023-03-06	ACTV	ETF	31.775	31.775	31.4799	31.54	15357.0
2023-03-06	ACVF	ETF	31.39	31.39	31.17	31.17	2000.0
2023-03-06	ACWF	ETF	33.54	33.6008	33.35	33.3981	2696.0
2023-03-06	ACWI	ETF	90.28	90.74	90.08	90.17	4315600.0
2023-03-06	ACWV	ETF	94.35	94.7	94.35	94.51	146700.0
2023-03-06	ACWX	ETF	48.49	48.65	48.38	48.43	648804.0
2023-03-06	ADFI	ETF	8.41	8.44	8.36	8.385	22200.0
2023-03-06	ADIV	ETF	14.01	14.01	14.01	14.01	100.0
2023-03-06	ADME	ETF	34.05	34.199	34.01	34.09	20100.0
2023-03-06	ADPV	ETF	25.62	25.62	25.42	25.47	14830.0
2023-03-06	ADRE	ETF	39.96	40.4	39.84	39.84	8400.0
2023-03-06	AEMB	ETF	37.595	37.595	37.595	37.595	100.0
2023-03-06	AESR	ETF	11.78	11.8	11.733	11.75	68500.0
2023-03-06	AFIF	ETF	8.82	8.85	8.82	8.8252	24164.0
2023-03-06	AFK	ETF	16.52	16.57	16.22	16.22	8975.0
2023-03-06	AFLG	ETF	24.128	24.128	24.128	24.128	100.0
2023-03-06	AFMC	ETF	23.904	23.904	23.904	23.904	100.0
2023-03-06	AFSM	ETF	24.578	24.578	24.347	24.347	100.0
2023-03-06	AFTY	ETF	16.345	16.345	16.345	16.345	100.0
2023-03-06	AGG	ETF	97.27	97.29	96.81	96.84	4188500.0
2023-03-06	AGGY	ETF	42.84	42.84	42.67	42.71	205100.0
2023-03-06	AGNG	ETF	26.5	26.509	26.24	26.377	2700.0
2023-03-06	AGOV	ETF	74.635	74.635	74.635	74.635	48.0
2023-03-06	AGOX	ETF	22.01	22.09	21.88	21.96	10700.0
2023-03-06	AGQ	ETF	24.29	24.35	23.85	23.98	386900.0
2023-03-06	AGZ	ETF	106.25	106.2601	106.11	106.15	13531.0
2023-03-06	AGZD	ETF	21.95	21.98	21.905	21.955	48000.0
2023-03-06	AHHX	ETF	8.6208	8.6208	8.5851	8.5946	5837.0
2023-03-06	AHYB	ETF	43.62	43.62	43.575	43.575	300.0
2023-03-06	AIA	ETF	60.87	61.07	60.57	60.57	23592.0
2023-03-06	AIEQ	ETF	30.86	30.9	30.41	30.41	22200.0
2023-03-06	AIQ	ETF	23.23	23.45	23.09	23.11	54341.0

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

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