PREVIEW / etf_daily / 2021-11-03

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-03.parquet
  size:    96 KB
  rows:    2,561

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-11-03	SPY	ETF	461.3	465.15	460.83	464.72	52509800.0
2021-11-03	QQQ	ETF	389.55	393.61	388.48	393.18	33748901.0
2021-11-03	IWM	ETF	234.15	239.81	233.92	238.64	47648500.0
2021-11-03	DIA	ETF	359.91	361.84	358.9	361.56	3557400.0
2021-11-03	GLD	ETF	165.34	165.95	164.38	165.77	9055200.0
2021-11-03	TLT	ETF	147.82	147.98	145.53	145.57	20639400.0
2021-11-03	AAA	ETF	24.98	24.99	24.98	24.9898	675.0
2021-11-03	AAAU	ETF	17.6	17.65	17.49	17.64	336800.0
2021-11-03	AADR	ETF	65.71	65.74	65.71	65.74	800.0
2021-11-03	AAXJ	ETF	85.9	86.51	85.66	86.38	889300.0
2021-11-03	ABEQ	ETF	27.83	27.93	27.78	27.92	5800.0
2021-11-03	ACES	ETF	80.06	80.94	79.21	80.92	38800.0
2021-11-03	ACIO	ETF	31.53	31.765	31.53	31.758	10600.0
2021-11-03	ACSI	ETF	53.0798	53.0798	53.0798	53.0798	177.0
2021-11-03	ACT	ETF	22.64	24.0	22.3742	23.36	232493.0
2021-11-03	ACTV	ETF	39.21	39.33	39.12	39.2257	3931.0
2021-11-03	ACTX	ETF	0.9498	1.09	0.66	1.09	2111.0
2021-11-03	ACVF	ETF	34.6	34.92	34.6	34.919	3800.0
2021-11-03	ACWF	ETF	38.29	38.4887	38.21	38.4887	3354.0
2021-11-03	ACWI	ETF	105.75	106.67	105.65	106.58	1696500.0
2021-11-03	ACWV	ETF	105.84	106.69	105.84	106.69	146900.0
2021-11-03	ACWX	ETF	57.33	57.815	57.19	57.74	769440.0
2021-11-03	ADFI	ETF	9.65	9.68	9.64	9.66	2500.0
2021-11-03	ADIV	ETF	17.574	17.574	17.574	17.574	100.0
2021-11-03	ADME	ETF	41.765	42.06	41.71	42.03	13300.0
2021-11-03	ADRE	ETF	49.9	49.978	49.6	49.978	3176.0
2021-11-03	AEMB	ETF	48.68	48.68	48.68	48.68	100.0
2021-11-03	AESR	ETF	14.63	14.77	14.63	14.76	13200.0
2021-11-03	AFIF	ETF	9.65	9.65	9.6	9.6	35022.0
2021-11-03	AFK	ETF	21.84	21.84	21.475	21.68	17342.0
2021-11-03	AFLG	ETF	27.156	27.156	27.156	27.156	100.0
2021-11-03	AFMC	ETF	26.58	26.821	26.58	26.821	300.0
2021-11-03	AFSM	ETF	28.27	28.4	28.2	28.388	5100.0
2021-11-03	AFTY	ETF	20.77	20.821	20.71	20.821	3400.0
2021-11-03	AGG	ETF	114.65	114.69	114.25	114.39	6421700.0
2021-11-03	AGGY	ETF	51.99	52.017	51.82	51.87	111700.0
2021-11-03	AGNG	ETF	30.15	30.485	30.15	30.485	3900.0
2021-11-03	AGOV	ETF	98.55	98.565	98.29	98.42	1225.0
2021-11-03	AGOX	ETF	27.59	27.59	27.25	27.48	45600.0
2021-11-03	AGQ	ETF	34.8	36.16	34.46	36.11	1678000.0
2021-11-03	AGZ	ETF	118.0	118.0	117.86	117.89	32302.0
2021-11-03	AGZD	ETF	23.425	23.485	23.42	23.455	46800.0
2021-11-03	AIA	ETF	79.79	80.49	79.5629	80.36	49656.0
2021-11-03	AIEQ	ETF	43.77	44.35	43.75	44.281	9700.0
2021-11-03	AIQ	ETF	32.03	32.325	31.975	32.28	15563.0
2021-11-03	AIRR	ETF	44.78	45.39	44.55	45.32	22900.0
2021-11-03	AIVI	ETF	41.44	41.77	41.44	41.77	3100.0
2021-11-03	ALTL	ETF	44.58	44.58	44.21	44.51	35002.0
2021-11-03	ALTY	ETF	13.69	13.69	13.58	13.61	36200.0
2021-11-03	AMJ	ETF	19.15	19.34	19.08	19.26	422238.0

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

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