PREVIEW / etf_daily / 2022-07-13

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-13.parquet
  size:    101 KB
  rows:    2,750

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-07-13	SPY	ETF	375.1	381.92	374.66	378.83	84224600.0
2022-07-13	QQQ	ETF	280.6	288.05	280.02	285.65	73939418.0
2022-07-13	IWM	ETF	169.15	172.28	168.79	171.32	25535600.0
2022-07-13	DIA	ETF	306.19	309.94	305.11	307.75	3481200.0
2022-07-13	GLD	ETF	160.1	162.71	160.06	161.6	8456600.0
2022-07-13	TLT	ETF	113.77	116.65	113.45	116.44	20594800.0
2022-07-13	AAA	ETF	24.295	24.295	24.295	24.295	0.0
2022-07-13	AAAU	ETF	17.05	17.33	17.05	17.22	1233000.0
2022-07-13	AADR	ETF	46.82	47.49	46.82	47.49	1200.0
2022-07-13	AAXJ	ETF	66.28	67.33	66.22	66.96	1757700.0
2022-07-13	ABEQ	ETF	26.67	26.77	26.66	26.663	8100.0
2022-07-13	ACES	ETF	48.09	49.904	47.88	49.41	52200.0
2022-07-13	ACIO	ETF	28.7	28.94	28.68	28.87	63000.0
2022-07-13	ACSI	ETF	42.7249	42.7249	42.7249	42.7249	47.0
2022-07-13	ACT	ETF	22.15	22.15	21.65	22.0	176867.0
2022-07-13	ACTV	ETF	30.11	30.37	30.11	30.2504	6000.0
2022-07-13	ACTX	ETF	0.6663	0.7	0.6401	0.6401	20381.0
2022-07-13	ACVF	ETF	28.41	28.69	28.41	28.615	400.0
2022-07-13	ACWF	ETF	30.61	31.01	30.42	30.94	10589.0
2022-07-13	ACWI	ETF	82.5	83.95	82.44	83.38	2961000.0
2022-07-13	ACWV	ETF	93.59	95.05	93.59	94.56	121400.0
2022-07-13	ACWX	ETF	43.36	44.08	43.36	43.89	2420828.0
2022-07-13	ADFI	ETF	8.5	8.57	8.5	8.545	5300.0
2022-07-13	ADIV	ETF	13.52	13.52	13.52	13.52	200.0
2022-07-13	ADME	ETF	34.31	34.54	34.29	34.449	32900.0
2022-07-13	ADRE	ETF	38.18	38.19	38.1407	38.19	4168.0
2022-07-13	AEMB	ETF	36.69	36.76	36.69	36.76	200.0
2022-07-13	AESR	ETF	11.088	11.15	11.04	11.04	45400.0
2022-07-13	AFIF	ETF	8.869	8.87	8.85	8.86	97247.0
2022-07-13	AFK	ETF	16.8	16.8	16.49	16.75	9535.0
2022-07-13	AFLG	ETF	22.68	22.79	22.68	22.706	200.0
2022-07-13	AFMC	ETF	21.09	21.17	21.09	21.17	300.0
2022-07-13	AFSM	ETF	21.83	21.956	21.801	21.956	400.0
2022-07-13	AFTY	ETF	18.242	18.242	18.242	18.242	100.0
2022-07-13	AGG	ETF	101.23	102.24	101.19	102.21	6534700.0
2022-07-13	AGGY	ETF	44.62	45.09	44.62	45.09	86500.0
2022-07-13	AGNG	ETF	25.28	25.55	25.28	25.43	5200.0
2022-07-13	AGOV	ETF	80.52	80.52	79.5	79.9644	1517.0
2022-07-13	AGOX	ETF	19.99	20.125	19.98	20.05	14200.0
2022-07-13	AGQ	ETF	21.37	22.39	21.19	21.86	1143900.0
2022-07-13	AGZ	ETF	109.55	110.0	109.55	110.0	12294.0
2022-07-13	AGZD	ETF	22.88	22.93	22.835	22.905	100000.0
2022-07-13	AHHX	ETF	8.44	8.475	8.44	8.475	293.0
2022-07-13	AHYB	ETF	43.12	43.185	43.09	43.185	1000.0
2022-07-13	AIA	ETF	59.75	60.83	59.72	60.52	72476.0
2022-07-13	AIEQ	ETF	30.97	31.67	30.97	31.614	2000.0
2022-07-13	AIQ	ETF	20.41	20.92	20.41	20.77	8521.0
2022-07-13	AIRR	ETF	36.87	37.321	36.87	37.233	13500.0
2022-07-13	AIVI	ETF	34.3	34.59	34.25	34.54	2400.0
2022-07-13	AIVL	ETF	87.41	88.73	87.41	88.41	5300.0

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

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