PREVIEW / etf_daily / 2021-07-26

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-26.parquet
  size:    91 KB
  rows:    2,417

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
2021-07-26	SPY	ETF	439.31	441.03	439.26	441.02	43719200.0
2021-07-26	QQQ	ETF	367.49	368.89	366.601	368.49	28438126.0
2021-07-26	IWM	ETF	220.39	222.05	219.15	220.19	22194200.0
2021-07-26	DIA	ETF	350.0	351.45	349.49	351.41	2466600.0
2021-07-26	GLD	ETF	168.58	168.86	168.08	168.16	5229800.0
2021-07-26	TLT	ETF	149.0	149.06	147.88	148.06	10737700.0
2021-07-26	AAA	ETF	25.02	25.02	25.02	25.02	481.0
2021-07-26	AAAU	ETF	17.92	17.95	17.87	17.88	282700.0
2021-07-26	AADR	ETF	65.91	66.67	65.91	66.41	2900.0
2021-07-26	AAXJ	ETF	87.73	88.23	87.43	87.7	3185400.0
2021-07-26	ABEQ	ETF	27.32	27.36	27.3	27.338	7200.0
2021-07-26	ACES	ETF	69.52	70.43	68.965	69.51	36900.0
2021-07-26	ACIO	ETF	30.85	31.04	30.85	31.03	12200.0
2021-07-26	ACSI	ETF	51.35	51.5349	51.35	51.5349	331.0
2021-07-26	ACTV	ETF	38.25	38.37	38.06	38.35	8156.0
2021-07-26	ACTX	ETF	1.62	1.62	1.62	1.62	332.0
2021-07-26	ACVF	ETF	32.52	32.52	32.46	32.5	3200.0
2021-07-26	ACWF	ETF	38.05	38.26	37.95	38.0508	50948.0
2021-07-26	ACWI	ETF	102.04	102.35	102.01	102.35	4286300.0
2021-07-26	ACWV	ETF	104.3	104.62	104.29	104.61	175000.0
2021-07-26	ACWX	ETF	56.3	56.53	56.3	56.47	811736.0
2021-07-26	ADFI	ETF	9.76	9.76	9.76	9.76	600.0
2021-07-26	ADIV	ETF	18.022	18.022	18.022	18.022	100.0
2021-07-26	ADME	ETF	40.93	40.93	40.83	40.916	13200.0
2021-07-26	ADRE	ETF	52.71	52.855	51.955	52.15	24239.0
2021-07-26	AESR	ETF	13.95	13.984	13.935	13.984	2900.0
2021-07-26	AFIF	ETF	9.71	9.71	9.69	9.69	6533.0
2021-07-26	AFK	ETF	21.37	21.52	21.3159	21.45	15763.0
2021-07-26	AFLG	ETF	26.0	26.023	26.0	26.023	1300.0
2021-07-26	AFMC	ETF	25.08	25.2	25.08	25.2	200.0
2021-07-26	AFSM	ETF	25.703	25.703	25.703	25.703	100.0
2021-07-26	AFTY	ETF	20.75	20.78	20.661	20.69	52900.0
2021-07-26	AGG	ETF	116.3	116.33	116.09	116.11	7127400.0
2021-07-26	AGGY	ETF	52.72	52.739	52.622	52.638	47700.0
2021-07-26	AGNG	ETF	30.61	30.61	30.12	30.12	2800.0
2021-07-26	AGOV	ETF	100.3	100.3	99.99	99.99	525.0
2021-07-26	AGOX	ETF	26.03	26.17	26.03	26.146	26300.0
2021-07-26	AGQ	ETF	42.63	42.93	42.5	42.62	329500.0
2021-07-26	AGZ	ETF	119.23	119.23	119.09	119.14	17511.0
2021-07-26	AGZD	ETF	23.435	23.5	23.43	23.445	17600.0
2021-07-26	AIA	ETF	84.46	84.47	83.4	83.67	199374.0
2021-07-26	AIEQ	ETF	41.32	41.32	41.05	41.23	10900.0
2021-07-26	AIQ	ETF	30.85	30.87	30.71	30.73	12898.0
2021-07-26	AIRR	ETF	40.44	40.79	40.41	40.63	35300.0
2021-07-26	AIVI	ETF	43.71	43.77	43.69	43.77	1400.0
2021-07-26	ALTL	ETF	42.93	43.3443	42.4	42.63	34661.0
2021-07-26	ALTY	ETF	13.56	13.64	13.56	13.63	21700.0
2021-07-26	AMJ	ETF	18.21	18.71	18.18	18.65	410469.0
2021-07-26	AMLP	ETF	33.57	34.67	33.57	34.67	2374000.0
2021-07-26	AMNA	ETF	32.7212	32.7212	32.7212	32.7212	0.0

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

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