PREVIEW / etf_daily / 2021-10-27

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-27.parquet
  size:    95 KB
  rows:    2,534

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-27	SPY	ETF	456.45	457.16	453.86	453.94	72438000.0
2021-10-27	QQQ	ETF	379.58	383.15	379.31	380.0	45760496.0
2021-10-27	IWM	ETF	227.18	227.46	223.5	223.65	27088500.0
2021-10-27	DIA	ETF	358.09	358.3	354.96	354.98	3542100.0
2021-10-27	GLD	ETF	167.73	168.2	166.86	168.12	5823100.0
2021-10-27	TLT	ETF	146.4	148.18	145.93	147.74	22092300.0
2021-10-27	AAA	ETF	25.02	25.02	25.01	25.01	631.0
2021-10-27	AAAU	ETF	17.83	17.89	17.75	17.89	288500.0
2021-10-27	AADR	ETF	65.28	65.28	64.99	65.03	800.0
2021-10-27	AAXJ	ETF	87.61	87.85	87.23	87.23	538400.0
2021-10-27	ABEQ	ETF	27.7	27.713	27.63	27.63	2600.0
2021-10-27	ACES	ETF	75.0	76.39	74.72	74.89	102500.0
2021-10-27	ACIO	ETF	31.515	31.59	31.45	31.45	43500.0
2021-10-27	ACSI	ETF	51.6856	51.6856	51.6856	51.6856	38.0
2021-10-27	ACT	ETF	22.5	23.2347	22.5	22.99	72489.0
2021-10-27	ACTV	ETF	38.6	38.6	38.0162	38.0162	13267.0
2021-10-27	ACTX	ETF	1.04	1.04	1.04	1.04	134.0
2021-10-27	ACVF	ETF	34.2	34.27	33.97	33.97	15000.0
2021-10-27	ACWF	ETF	38.12	38.12	37.776	37.776	3539.0
2021-10-27	ACWI	ETF	105.23	105.39	104.64	104.69	4294300.0
2021-10-27	ACWV	ETF	106.01	106.2	105.21	105.25	84000.0
2021-10-27	ACWX	ETF	57.36	57.47	57.14	57.14	1853938.0
2021-10-27	ADFI	ETF	9.665	9.665	9.665	9.665	100.0
2021-10-27	ADIV	ETF	17.58	17.58	17.556	17.556	100.0
2021-10-27	ADME	ETF	41.63	41.7	41.46	41.46	39900.0
2021-10-27	ADRE	ETF	50.61	51.14	50.5	50.5	7950.0
2021-10-27	AEMB	ETF	49.25	49.25	49.25	49.25	100.0
2021-10-27	AESR	ETF	14.49	14.49	14.39	14.39	2100.0
2021-10-27	AFIF	ETF	9.6433	9.66	9.63	9.65	17833.0
2021-10-27	AFK	ETF	21.59	21.745	21.55	21.55	4248.0
2021-10-27	AFLG	ETF	26.74	26.74	26.567	26.567	500.0
2021-10-27	AFMC	ETF	25.88	25.88	25.529	25.529	500.0
2021-10-27	AFSM	ETF	26.964	26.964	26.514	26.514	500.0
2021-10-27	AFTY	ETF	21.38	21.46	21.33	21.33	2400.0
2021-10-27	AGG	ETF	114.66	114.92	114.43	114.76	8048500.0
2021-10-27	AGGY	ETF	51.92	52.03	51.805	51.93	103300.0
2021-10-27	AGNG	ETF	29.465	29.52	29.404	29.404	2000.0
2021-10-27	AGOV	ETF	99.22	99.22	99.22	99.22	155.0
2021-10-27	AGOX	ETF	27.28	27.28	26.85	26.85	65100.0
2021-10-27	AGQ	ETF	38.07	38.43	37.45	37.86	530200.0
2021-10-27	AGZ	ETF	117.96	118.17	117.89	118.05	92622.0
2021-10-27	AGZD	ETF	23.45	23.46	23.4	23.4	86800.0
2021-10-27	AIA	ETF	81.3	81.84	81.2	81.335	38867.0
2021-10-27	AIEQ	ETF	43.14	43.21	42.762	42.762	9200.0
2021-10-27	AIQ	ETF	31.53	31.64	31.33	31.33	18220.0
2021-10-27	AIRR	ETF	43.49	43.69	42.69	42.69	19800.0
2021-10-27	AIVI	ETF	41.65	41.65	41.49	41.49	3100.0
2021-10-27	ALTL	ETF	43.23	43.3	42.74	42.74	30313.0
2021-10-27	ALTY	ETF	13.703	13.73	13.63	13.71	70100.0
2021-10-27	AMJ	ETF	19.43	19.63	19.29	19.43	536420.0

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

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