PREVIEW / etf_daily / 2021-11-19

all etf daily files

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

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-19	SPY	ETF	469.61	470.94	468.5	468.89	57315600.0
2021-11-19	QQQ	ETF	403.43	405.3	402.58	403.99	45191721.0
2021-11-19	IWM	ETF	233.27	234.42	232.39	232.72	33994000.0
2021-11-19	DIA	ETF	357.89	357.89	355.38	355.91	3542200.0
2021-11-19	GLD	ETF	173.69	174.1	172.24	172.61	8785600.0
2021-11-19	TLT	ETF	147.58	148.6	147.58	148.36	14022100.0
2021-11-19	AAA	ETF	25.04	25.04	25.025	25.025	300.0
2021-11-19	AAAU	ETF	18.47	18.52	18.33	18.37	225200.0
2021-11-19	AADR	ETF	64.13	64.16	64.13	64.16	400.0
2021-11-19	AAXJ	ETF	86.67	87.09	86.59	86.64	588300.0
2021-11-19	ABEQ	ETF	27.83	27.83	27.83	27.83	300.0
2021-11-19	ACES	ETF	77.1	79.94	77.1	79.4	32400.0
2021-11-19	ACIO	ETF	32.1	32.1	31.986	32.01	21700.0
2021-11-19	ACSI	ETF	53.4343	53.4343	53.4343	53.4343	57.0
2021-11-19	ACT	ETF	23.25	23.53	22.84	23.02	198432.0
2021-11-19	ACTV	ETF	38.11	38.11	37.6994	37.6994	4043.0
2021-11-19	ACTX	ETF	1.35	1.54	1.28	1.49	8065.0
2021-11-19	ACVF	ETF	35.32	35.32	35.03	35.12	6300.0
2021-11-19	ACWF	ETF	38.75	38.87	38.65	38.661	5928.0
2021-11-19	ACWI	ETF	106.83	107.06	106.54	106.58	1969900.0
2021-11-19	ACWV	ETF	106.99	107.36	106.81	106.84	124400.0
2021-11-19	ACWX	ETF	57.22	57.2858	57.025	57.05	1336260.0
2021-11-19	ADFI	ETF	9.65	9.65	9.62	9.62	700.0
2021-11-19	ADIV	ETF	17.84	17.855	17.84	17.855	300.0
2021-11-19	ADME	ETF	42.47	42.81	42.47	42.66	20300.0
2021-11-19	ADRE	ETF	49.36	49.57	49.3001	49.35	9292.0
2021-11-19	AEMB	ETF	48.75	48.75	48.75	48.75	100.0
2021-11-19	AESR	ETF	14.85	14.92	14.84	14.85	4300.0
2021-11-19	AFIF	ETF	9.6306	9.6306	9.62	9.62	9821.0
2021-11-19	AFK	ETF	21.26	21.26	21.1296	21.135	5851.0
2021-11-19	AFLG	ETF	27.418	27.418	27.418	27.418	100.0
2021-11-19	AFSM	ETF	28.49	28.49	28.376	28.376	100.0
2021-11-19	AFTY	ETF	20.98	21.04	20.98	21.035	4400.0
2021-11-19	AGG	ETF	114.49	114.59	114.42	114.45	5685900.0
2021-11-19	AGGY	ETF	51.86	51.947	51.85	51.87	187800.0
2021-11-19	AGNG	ETF	29.4	29.405	29.4	29.4	4800.0
2021-11-19	AGOV	ETF	98.45	98.49	98.38	98.38	1805.0
2021-11-19	AGOX	ETF	26.01	26.2	26.01	26.02	43300.0
2021-11-19	AGQ	ETF	40.19	40.57	39.19	39.25	605200.0
2021-11-19	AGZ	ETF	117.96	118.0875	117.88	117.88	24755.0
2021-11-19	AGZD	ETF	23.425	23.445	23.395	23.4	70000.0
2021-11-19	AHHX	ETF	10.43	10.43	10.28	10.405	573492.0
2021-11-19	AHYB	ETF	50.015	50.015	50.01	50.01	300.0
2021-11-19	AIA	ETF	80.74	81.0	80.53	80.53	36350.0
2021-11-19	AIEQ	ETF	44.07	44.335	44.03	44.057	16700.0
2021-11-19	AIQ	ETF	33.15	33.29	33.035	33.05	16619.0
2021-11-19	AIRR	ETF	46.845	47.38	46.8	47.13	37400.0
2021-11-19	AIVI	ETF	41.1	41.1	40.96	40.97	4100.0
2021-11-19	ALTL	ETF	44.75	44.9289	44.73	44.77	35201.0
2021-11-19	ALTY	ETF	13.39	13.45	13.382	13.42	17700.0

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

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