PREVIEW / etf_daily / 2020-09-01

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-01.parquet
  size:    79 KB
  rows:    2,080

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
2020-09-01	SPY	ETF	350.21	352.71	349.24	352.6	54908700.0
2020-09-01	QQQ	ETF	297.6	300.04	295.79	299.92	36395774.0
2020-09-01	IWM	ETF	155.22	157.31	154.45	157.21	15638800.0
2020-09-01	DIA	ETF	283.73	286.93	283.17	286.79	3023600.0
2020-09-01	GLD	ETF	186.99	186.99	184.33	185.05	10662100.0
2020-09-01	TLT	ETF	161.76	164.07	161.18	163.86	10587000.0
2020-09-01	AAAU	ETF	19.85	19.85	19.56	19.64	974900.0
2020-09-01	AADR	ETF	57.05	57.14	56.86	56.92	6100.0
2020-09-01	AAXJ	ETF	78.37	79.07	78.34	79.07	3881700.0
2020-09-01	ABEQ	ETF	22.71	23.699	22.71	23.699	5700.0
2020-09-01	ACES	ETF	53.78	54.16	53.289	54.16	99300.0
2020-09-01	ACIO	ETF	27.52	27.53	27.31	27.355	45900.0
2020-09-01	ACSI	ETF	38.89	39.0814	38.89	39.0814	213.0
2020-09-01	ACTX	ETF	2.655	2.95	2.242	2.242	1218.0
2020-09-01	ACWF	ETF	30.4	30.432	30.365	30.432	3495.0
2020-09-01	ACWI	ETF	82.61	83.09	82.42	83.06	3436600.0
2020-09-01	ACWV	ETF	93.15	93.15	92.55	92.86	232200.0
2020-09-01	ACWX	ETF	47.0	47.19	46.9	47.18	831615.0
2020-09-01	ADME	ETF	35.4	35.53	35.29	35.486	31800.0
2020-09-01	ADRE	ETF	47.7	48.27	47.7	48.26	11667.0
2020-09-01	AESR	ETF	11.44	11.44	11.4	11.436	11200.0
2020-09-01	AFIF	ETF	9.83	9.85	9.82	9.84	29424.0
2020-09-01	AFK	ETF	17.74	18.0199	17.74	17.96	35857.0
2020-09-01	AFLG	ETF	21.07	21.117	21.07	21.117	200.0
2020-09-01	AFMC	ETF	18.46	18.517	18.46	18.517	200.0
2020-09-01	AFSM	ETF	18.53	18.631	18.53	18.631	200.0
2020-09-01	AFTY	ETF	19.8	19.85	19.8	19.828	2400.0
2020-09-01	AGG	ETF	118.12	118.44	118.0	118.42	9843200.0
2020-09-01	AGGY	ETF	53.9	54.06	53.85	54.02	178800.0
2020-09-01	AGNG	ETF	25.74	25.74	25.527	25.6	9000.0
2020-09-01	AGQ	ETF	66.07	66.11	60.74	63.09	2506700.0
2020-09-01	AGZ	ETF	121.16	121.34	121.04	121.23	68294.0
2020-09-01	AGZD	ETF	23.51	23.525	23.47	23.52	15800.0
2020-09-01	AIA	ETF	72.64	73.09	72.56	73.09	84009.0
2020-09-01	AIEQ	ETF	31.97	32.29	31.891	32.29	21900.0
2020-09-01	AIQ	ETF	24.21	24.56	24.205	24.52	82269.0
2020-09-01	AIRR	ETF	26.8	27.341	26.699	27.341	8900.0
2020-09-01	AIVI	ETF	37.14	37.14	36.92	37.0	7700.0
2020-09-01	ALTL	ETF	25.46	25.4861	25.35	25.4544	3476.0
2020-09-01	ALTY	ETF	10.98	11.01	10.935	10.97	10800.0
2020-09-01	AMJ	ETF	12.43	12.485	12.2699	12.41	1556010.0
2020-09-01	AMLP	ETF	23.05	23.05	22.62	22.91	2782400.0
2020-09-01	AMNA	ETF	24.06	24.32	24.06	24.21	4600.0
2020-09-01	AMND	ETF	25.37	25.37	25.3673	25.3673	200.0
2020-09-01	AMOM	ETF	37.106	37.78	37.106	37.53	7100.0
2020-09-01	AMUB	ETF	7.8	7.8	7.75	7.8	14168.0
2020-09-01	AMZA	ETF	16.67	16.725	16.425	16.53	52100.0
2020-09-01	ANGL	ETF	30.48	30.58	30.33	30.56	1275800.0
2020-09-01	AOA	ETF	59.42	59.81	59.42	59.73	43000.0
2020-09-01	AOK	ETF	37.62	37.78	37.62	37.7485	140802.0

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

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