PREVIEW / etf_daily / 2022-11-29

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-29.parquet
  size:    106 KB
  rows:    2,863

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
2022-11-29	SPY	ETF	396.05	397.3	393.3	395.23	52310000.0
2022-11-29	QQQ	ETF	282.94	283.35	279.17	280.57	35618878.0
2022-11-29	IWM	ETF	181.96	183.61	181.96	182.37	14020600.0
2022-11-29	DIA	ETF	337.93	339.37	336.61	338.48	2943600.0
2022-11-29	GLD	ETF	162.7	163.63	162.6	162.73	2620600.0
2022-11-29	TLT	ETF	102.15	102.96	101.91	101.98	16576400.0
2022-11-29	AAA	ETF	24.37	24.37	24.37	24.37	0.0
2022-11-29	AAAU	ETF	17.35	17.45	17.34	17.35	2029900.0
2022-11-29	AADR	ETF	49.02	49.25	48.98	49.19	700.0
2022-11-29	AAPB	ETF	18.77	18.77	18.0484	18.06	1930.0
2022-11-29	AAPD	ETF	27.51	28.24	27.47	28.1	270474.0
2022-11-29	AAPU	ETF	19.8	19.9	19.005	19.13	70143.0
2022-11-29	AAXJ	ETF	64.45	64.72	64.31	64.55	538600.0
2022-11-29	ABEQ	ETF	28.17	28.17	28.02	28.154	28600.0
2022-11-29	ACES	ETF	53.81	54.15	53.26	53.28	13400.0
2022-11-29	ACIO	ETF	29.71	29.82	29.673	29.713	28200.0
2022-11-29	ACSI	ETF	44.3691	44.3691	44.3691	44.3691	4.0
2022-11-29	ACT	ETF	24.45	24.64	24.1837	24.34	89245.0
2022-11-29	ACTV	ETF	29.98	29.981	29.84	29.86	3214.0
2022-11-29	ACTX	ETF	0.4499	0.4499	0.4299	0.4299	800.0
2022-11-29	ACVF	ETF	30.69	30.7	30.465	30.596	11200.0
2022-11-29	ACWF	ETF	33.329	33.329	33.1132	33.1687	2868.0
2022-11-29	ACWI	ETF	87.31	87.62	86.87	87.19	3482400.0
2022-11-29	ACWV	ETF	96.88	97.14	96.57	96.91	193600.0
2022-11-29	ACWX	ETF	45.99	46.21	45.8635	45.99	1397311.0
2022-11-29	ADFI	ETF	8.371	8.4	8.371	8.395	15900.0
2022-11-29	ADIV	ETF	12.952	12.952	12.952	12.952	100.0
2022-11-29	ADME	ETF	34.85	34.875	34.68	34.83	39700.0
2022-11-29	ADPV	ETF	25.08	25.08	25.07	25.075	18393.0
2022-11-29	ADRE	ETF	37.94	38.044	37.9	37.9137	5203.0
2022-11-29	AESR	ETF	11.8	11.8	11.74	11.8	24900.0
2022-11-29	AFIF	ETF	8.77	8.77	8.73	8.7303	15807.0
2022-11-29	AFK	ETF	17.25	17.28	17.17	17.19	4700.0
2022-11-29	AFLG	ETF	24.11	24.13	24.11	24.13	200.0
2022-11-29	AFMC	ETF	23.17	23.171	23.17	23.171	100.0
2022-11-29	AFSM	ETF	23.62	23.77	23.62	23.77	400.0
2022-11-29	AFTY	ETF	15.04	15.17	15.04	15.17	800.0
2022-11-29	AGG	ETF	97.54	97.79	97.49	97.53	6643300.0
2022-11-29	AGGH	ETF	22.46	22.48	22.37	22.37	4809.0
2022-11-29	AGGY	ETF	42.85	42.89	42.8	42.81	170400.0
2022-11-29	AGNG	ETF	25.87	25.89	25.83	25.89	9900.0
2022-11-29	AGOV	ETF	81.1435	81.1435	79.9576	79.9576	840.0
2022-11-29	AGOX	ETF	21.23	21.23	21.07	21.103	19800.0
2022-11-29	AGQ	ETF	25.34	25.92	25.32	25.42	819500.0
2022-11-29	AGZ	ETF	106.6725	106.79	106.63	106.72	23196.0
2022-11-29	AGZD	ETF	23.035	23.035	22.995	23.01	61600.0
2022-11-29	AHHX	ETF	8.4401	8.51	8.44	8.4802	1897.0
2022-11-29	AHYB	ETF	43.429	43.456	43.429	43.456	300.0
2022-11-29	AIA	ETF	55.73	56.06	55.66	55.8	98457.0
2022-11-29	AIEQ	ETF	30.71	30.935	30.599	30.681	3300.0

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

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