PREVIEW / etf_daily / 2021-08-24

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-24.parquet
  size:    92 KB
  rows:    2,442

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-08-24	SPY	ETF	447.97	448.54	447.42	447.97	38744700.0
2021-08-24	QQQ	ETF	373.84	374.99	373.36	374.37	21732913.0
2021-08-24	IWM	ETF	220.32	221.92	219.69	221.78	18677900.0
2021-08-24	DIA	ETF	354.08	354.49	353.62	353.74	1981400.0
2021-08-24	GLD	ETF	169.04	169.27	168.52	168.65	4519200.0
2021-08-24	TLT	ETF	149.76	150.07	149.28	149.28	13835900.0
2021-08-24	AAA	ETF	25.03	25.03	25.015	25.015	264.0
2021-08-24	AAAU	ETF	17.98	18.0	17.93	17.94	134400.0
2021-08-24	AADR	ETF	68.07	68.08	67.63	68.07	2300.0
2021-08-24	AAXJ	ETF	86.38	87.2	86.38	87.15	864400.0
2021-08-24	ABEQ	ETF	27.73	27.82	27.73	27.815	2600.0
2021-08-24	ACES	ETF	69.64	70.24	69.63	70.0	45700.0
2021-08-24	ACIO	ETF	31.0	31.0	30.94	30.95	41900.0
2021-08-24	ACSI	ETF	51.7705	51.7705	51.7705	51.7705	13.0
2021-08-24	ACTV	ETF	38.41	38.41	37.86	38.1186	7851.0
2021-08-24	ACVF	ETF	33.45	33.66	33.2	33.286	142800.0
2021-08-24	ACWF	ETF	38.54	38.6796	38.54	38.6045	4318.0
2021-08-24	ACWI	ETF	103.4	103.67	103.3	103.52	3243200.0
2021-08-24	ACWV	ETF	106.83	106.83	106.33	106.4	242100.0
2021-08-24	ACWX	ETF	56.7	57.04	56.7	56.98	760592.0
2021-08-24	ADFI	ETF	9.75	9.76	9.741	9.741	3000.0
2021-08-24	ADIV	ETF	18.09	18.09	18.09	18.09	1400.0
2021-08-24	ADME	ETF	41.015	41.06	40.95	41.0	67800.0
2021-08-24	ADRE	ETF	50.51	51.2045	50.51	51.1873	10599.0
2021-08-24	AESR	ETF	14.18	14.21	14.17	14.175	24300.0
2021-08-24	AFIF	ETF	9.6703	9.68	9.66	9.668	28275.0
2021-08-24	AFK	ETF	21.5	21.578	21.4449	21.49	3756.0
2021-08-24	AFLG	ETF	26.53	26.549	26.496	26.496	4000.0
2021-08-24	AFMC	ETF	25.792	25.792	25.792	25.792	100.0
2021-08-24	AFSM	ETF	26.23	26.23	26.21	26.21	600.0
2021-08-24	AFTY	ETF	20.46	20.47	20.41	20.46	3800.0
2021-08-24	AGG	ETF	116.08	116.14	115.96	115.99	5875400.0
2021-08-24	AGGY	ETF	52.69	52.725	52.68	52.68	60200.0
2021-08-24	AGNG	ETF	30.88	31.09	30.857	30.857	3900.0
2021-08-24	AGOV	ETF	100.31	100.31	100.14	100.14	400.0
2021-08-24	AGOX	ETF	26.37	26.43	26.286	26.4	23200.0
2021-08-24	AGQ	ETF	37.72	38.0	37.32	37.69	613000.0
2021-08-24	AGZ	ETF	119.09	119.1366	119.05	119.08	22099.0
2021-08-24	AGZD	ETF	23.415	23.445	23.415	23.445	47200.0
2021-08-24	AIA	ETF	81.53	82.41	81.48	82.25	955582.0
2021-08-24	AIEQ	ETF	42.14	42.28	41.96	42.28	39000.0
2021-08-24	AIQ	ETF	31.0	31.23	31.0	31.22	47214.0
2021-08-24	AIRR	ETF	41.8	42.089	41.74	41.944	15300.0
2021-08-24	AIVI	ETF	43.17	43.25	43.17	43.25	1300.0
2021-08-24	ALTL	ETF	43.68	43.68	43.23	43.23	191707.0
2021-08-24	ALTY	ETF	13.7	13.7	13.62	13.64	25600.0
2021-08-24	AMJ	ETF	17.82	17.925	17.73	17.78	424202.0
2021-08-24	AMLP	ETF	32.15	32.43	32.05	32.22	1471500.0
2021-08-24	AMNA	ETF	31.7182	31.7182	31.7182	31.7182	0.0
2021-08-24	AMND	ETF	33.236	33.236	33.236	33.236	4.0

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

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