PREVIEW / etf_daily / 2021-09-30

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-30.parquet
  size:    95 KB
  rows:    2,518

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-09-30	SPY	ETF	436.02	436.77	428.78	429.14	140506000.0
2021-09-30	QQQ	ETF	360.97	362.68	357.1	357.96	61384577.0
2021-09-30	IWM	ETF	222.12	222.61	218.6	218.75	33153600.0
2021-09-30	DIA	ETF	345.08	345.44	338.11	338.29	7926000.0
2021-09-30	GLD	ETF	162.66	164.95	162.34	164.22	10572900.0
2021-09-30	TLT	ETF	144.1	144.51	143.65	144.32	22567600.0
2021-09-30	AAA	ETF	25.02	25.02	25.01	25.01	469.0
2021-09-30	AAAU	ETF	17.3	17.53	17.27	17.46	266100.0
2021-09-30	AADR	ETF	63.88	63.88	63.53	63.54	2600.0
2021-09-30	AAXJ	ETF	85.05	85.61	84.88	84.93	1710900.0
2021-09-30	ABEQ	ETF	26.935	27.02	26.87	26.87	1600.0
2021-09-30	ACES	ETF	65.9	66.52	65.5	66.14	69100.0
2021-09-30	ACIO	ETF	30.265	30.265	29.919	29.95	24400.0
2021-09-30	ACSI	ETF	49.0023	49.0023	49.0023	49.0023	157.0
2021-09-30	ACT	ETF	21.81	22.1345	21.69	21.93	76535.0
2021-09-30	ACTV	ETF	38.33	38.33	37.9791	37.9791	14713.0
2021-09-30	ACTX	ETF	1.09	1.09	1.0	1.0	1032.0
2021-09-30	ACVF	ETF	32.505	32.505	32.0	32.0	7500.0
2021-09-30	ACWF	ETF	37.4	37.4	36.9085	36.9085	19629.0
2021-09-30	ACWI	ETF	101.01	101.25	99.92	99.92	2935600.0
2021-09-30	ACWV	ETF	103.51	103.9	102.73	102.73	90700.0
2021-09-30	ACWX	ETF	55.63	55.79	55.3	55.41	2681425.0
2021-09-30	ADFI	ETF	9.66	9.7	9.66	9.685	7000.0
2021-09-30	ADIV	ETF	16.941	16.941	16.941	16.941	100.0
2021-09-30	ADME	ETF	40.03	40.047	39.42	39.43	21300.0
2021-09-30	ADRE	ETF	48.34	48.57	48.15	48.375	7384.0
2021-09-30	AEMB	ETF	49.17	49.17	49.165	49.165	200.0
2021-09-30	AESR	ETF	13.85	13.85	13.61	13.61	27500.0
2021-09-30	AFIF	ETF	9.6201	9.64	9.62	9.62	59387.0
2021-09-30	AFK	ETF	20.59	20.95	20.53	20.77	6066.0
2021-09-30	AFLG	ETF	25.75	25.75	25.33	25.33	900.0
2021-09-30	AFMC	ETF	24.919	24.919	24.919	24.919	100.0
2021-09-30	AFSM	ETF	25.881	25.881	25.881	25.881	600.0
2021-09-30	AFTY	ETF	20.76	20.76	20.683	20.683	900.0
2021-09-30	AGG	ETF	114.77	114.86	114.69	114.83	5348800.0
2021-09-30	AGGY	ETF	51.86	52.05	51.82	51.92	181600.0
2021-09-30	AGNG	ETF	29.24	29.24	29.24	29.24	2100.0
2021-09-30	AGOV	ETF	99.2	99.2245	99.2	99.2245	630.0
2021-09-30	AGOX	ETF	26.0	26.035	25.72	25.72	23600.0
2021-09-30	AGQ	ETF	31.02	32.22	30.88	31.99	1516400.0
2021-09-30	AGZ	ETF	118.29	118.49	118.29	118.48	39943.0
2021-09-30	AGZD	ETF	23.515	23.515	23.425	23.435	46600.0
2021-09-30	AIA	ETF	78.32	78.92	78.18	78.2	113555.0
2021-09-30	AIEQ	ETF	41.41	41.56	41.199	41.199	6300.0
2021-09-30	AIQ	ETF	30.29	30.36	30.091	30.33	8230.0
2021-09-30	AIRR	ETF	41.82	41.908	40.92	41.008	27400.0
2021-09-30	AIVI	ETF	40.95	40.95	40.76	40.76	3400.0
2021-09-30	ALTL	ETF	41.95	41.95	41.17	41.18	34194.0
2021-09-30	ALTY	ETF	13.48	13.48	13.32	13.32	19000.0
2021-09-30	AMJ	ETF	18.3	18.425	18.13	18.17	410128.0

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

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