PREVIEW / etf_daily / 2021-10-22

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-22.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-10-22	SPY	ETF	453.13	454.67	451.05	453.12	58845100.0
2021-10-22	QQQ	ETF	375.98	376.97	372.385	374.1	36275822.0
2021-10-22	IWM	ETF	227.8	228.39	225.69	227.41	16887000.0
2021-10-22	DIA	ETF	355.97	357.62	355.32	356.74	3872300.0
2021-10-22	GLD	ETF	168.67	169.54	166.67	167.77	10703900.0
2021-10-22	TLT	ETF	143.45	144.4	143.21	144.13	13740000.0
2021-10-22	AAA	ETF	25.01	25.01	25.0	25.0	1022.0
2021-10-22	AAAU	ETF	17.94	18.02	17.74	17.85	215600.0
2021-10-22	AADR	ETF	65.72	65.72	65.16	65.69	3600.0
2021-10-22	AAXJ	ETF	88.51	88.87	87.96	88.08	698100.0
2021-10-22	ABEQ	ETF	28.0	28.0	27.905	27.94	4600.0
2021-10-22	ACES	ETF	72.6	72.6	71.06	71.75	67600.0
2021-10-22	ACIO	ETF	31.31	31.49	31.31	31.452	64300.0
2021-10-22	ACSI	ETF	52.0411	52.0411	52.0411	52.0411	123.0
2021-10-22	ACT	ETF	22.98	23.2728	22.78	22.98	147700.0
2021-10-22	ACTV	ETF	39.365	39.389	39.25	39.3345	1906.0
2021-10-22	ACTX	ETF	1.01	1.01	1.01	1.01	589.0
2021-10-22	ACVF	ETF	33.9	33.99	33.83	33.968	5900.0
2021-10-22	ACWF	ETF	38.41	38.42	38.18	38.21	5345.0
2021-10-22	ACWI	ETF	104.94	105.29	104.45	104.91	3291500.0
2021-10-22	ACWV	ETF	105.75	106.24	105.75	106.08	173600.0
2021-10-22	ACWX	ETF	57.45	57.68	57.24	57.47	1663142.0
2021-10-22	ADFI	ETF	9.63	9.63	9.62	9.625	1300.0
2021-10-22	ADIV	ETF	17.701	17.701	17.701	17.701	100.0
2021-10-22	ADME	ETF	41.34	41.55	41.34	41.49	50900.0
2021-10-22	ADRE	ETF	51.6	51.6	51.205	51.28	3668.0
2021-10-22	AESR	ETF	14.39	14.39	14.33	14.39	9000.0
2021-10-22	AFIF	ETF	9.6	9.64	9.6	9.62	18329.0
2021-10-22	AFK	ETF	22.1	22.1	21.67	21.75	4345.0
2021-10-22	AFLG	ETF	26.731	26.731	26.731	26.731	100.0
2021-10-22	AFMC	ETF	26.162	26.162	26.162	26.162	100.0
2021-10-22	AFTY	ETF	21.82	21.861	21.796	21.861	1400.0
2021-10-22	AGG	ETF	113.97	114.14	113.9	114.06	3528600.0
2021-10-22	AGGY	ETF	51.6	51.69	51.595	51.655	71400.0
2021-10-22	AGNG	ETF	29.68	29.74	29.6	29.657	4700.0
2021-10-22	AGOV	ETF	99.29	99.29	99.29	99.29	30.0
2021-10-22	AGOX	ETF	27.15	27.17	26.978	27.105	23000.0
2021-10-22	AGQ	ETF	39.01	40.3	38.24	38.68	1402800.0
2021-10-22	AGZ	ETF	117.66	117.82	117.66	117.82	29453.0
2021-10-22	AGZD	ETF	23.555	23.555	23.455	23.455	42200.0
2021-10-22	AIA	ETF	82.6	83.13	82.08	82.37	61668.0
2021-10-22	AIEQ	ETF	43.25	43.348	42.971	43.086	8400.0
2021-10-22	AIQ	ETF	31.87	31.92	31.58	31.63	22701.0
2021-10-22	AIRR	ETF	43.22	43.464	43.077	43.24	14800.0
2021-10-22	AIVI	ETF	41.6	41.78	41.57	41.7	1800.0
2021-10-22	ALTL	ETF	43.0	43.38	42.82	43.04	20734.0
2021-10-22	ALTY	ETF	13.64	13.681	13.64	13.656	12200.0
2021-10-22	AMJ	ETF	19.9	19.98	19.595	19.86	521161.0
2021-10-22	AMLP	ETF	36.68	36.81	36.13	36.52	1817600.0
2021-10-22	AMNA	ETF	35.5659	35.5659	35.5659	35.5659	2.0

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

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