PREVIEW / etf_daily / 2021-11-02

all etf daily files

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

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-02	SPY	ETF	460.22	462.23	460.08	461.9	48908400.0
2021-11-02	QQQ	ETF	386.8	389.54	386.75	389.05	25135292.0
2021-11-02	IWM	ETF	234.38	234.85	232.65	234.45	24949700.0
2021-11-02	DIA	ETF	359.41	360.88	358.79	360.57	2629000.0
2021-11-02	GLD	ETF	167.43	167.63	166.96	167.16	3760700.0
2021-11-02	TLT	ETF	146.5	147.57	146.5	147.09	9836700.0
2021-11-02	AAA	ETF	24.985	24.985	24.985	24.985	139.0
2021-11-02	AAAU	ETF	17.82	17.83	17.77	17.78	157400.0
2021-11-02	AADR	ETF	65.58	65.58	65.32	65.46	1400.0
2021-11-02	AAXJ	ETF	86.37	86.37	86.0	86.04	1307700.0
2021-11-02	ABEQ	ETF	27.46	27.777	27.46	27.741	3500.0
2021-11-02	ACES	ETF	81.46	81.46	79.891	80.61	77300.0
2021-11-02	ACIO	ETF	31.73	31.73	31.648	31.72	25300.0
2021-11-02	ACSI	ETF	52.2553	52.2553	52.2553	52.2553	52.0
2021-11-02	ACT	ETF	23.27	23.27	22.56	22.64	129013.0
2021-11-02	ACTV	ETF	39.06	39.06	38.88	38.9384	2726.0
2021-11-02	ACTX	ETF	0.9499	0.9499	0.9498	0.9498	408.0
2021-11-02	ACVF	ETF	34.59	34.7	34.59	34.7	3800.0
2021-11-02	ACWF	ETF	38.13	38.169	38.115	38.169	2284.0
2021-11-02	ACWI	ETF	105.73	105.98	105.62	105.9	2185600.0
2021-11-02	ACWV	ETF	105.79	106.21	105.79	106.09	113200.0
2021-11-02	ACWX	ETF	57.4	57.46	57.32	57.35	745157.0
2021-11-02	ADFI	ETF	9.665	9.68	9.65	9.665	900.0
2021-11-02	ADIV	ETF	17.482	17.482	17.482	17.482	100.0
2021-11-02	ADME	ETF	41.99	42.12	41.68	41.84	19400.0
2021-11-02	ADRE	ETF	50.0	50.0	49.65	49.65	4314.0
2021-11-02	AEMB	ETF	48.835	48.835	48.835	48.835	100.0
2021-11-02	AESR	ETF	14.66	14.68	14.64	14.65	3100.0
2021-11-02	AFIF	ETF	9.63	9.67	9.63	9.67	107475.0
2021-11-02	AFK	ETF	21.54	21.85	21.42	21.43	8745.0
2021-11-02	AFLG	ETF	27.015	27.015	27.015	27.015	100.0
2021-11-02	AFMC	ETF	26.384	26.384	26.384	26.384	100.0
2021-11-02	AFSM	ETF	27.76	27.76	27.699	27.699	1100.0
2021-11-02	AFTY	ETF	20.99	20.99	20.87	20.87	28200.0
2021-11-02	AGG	ETF	114.43	114.69	114.43	114.62	5317000.0
2021-11-02	AGGY	ETF	51.94	52.009	51.91	51.99	160800.0
2021-11-02	AGNG	ETF	30.03	30.12	30.01	30.071	1300.0
2021-11-02	AGOV	ETF	98.93	98.93	98.65	98.735	577.0
2021-11-02	AGOX	ETF	27.58	27.58	27.25	27.29	14900.0
2021-11-02	AGQ	ETF	36.64	36.66	35.63	36.09	1076800.0
2021-11-02	AGZ	ETF	118.01	118.09	117.94	118.02	26626.0
2021-11-02	AGZD	ETF	23.44	23.505	23.42	23.42	42000.0
2021-11-02	AIA	ETF	80.36	80.36	79.885	79.89	67702.0
2021-11-02	AIEQ	ETF	43.69	43.84	43.47	43.826	6300.0
2021-11-02	AIQ	ETF	31.93	31.99	31.85	31.92	19319.0
2021-11-02	AIRR	ETF	45.24	45.24	44.553	44.71	16700.0
2021-11-02	AIVI	ETF	41.55	41.56	41.43	41.48	2300.0
2021-11-02	ALTL	ETF	44.42	44.55	44.26	44.4378	27723.0
2021-11-02	ALTY	ETF	13.76	13.76	13.64	13.7	58700.0
2021-11-02	AMJ	ETF	19.39	19.46	19.13	19.35	326112.0

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

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