PREVIEW / etf_daily / 2020-11-02

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-02.parquet
  size:    80 KB
  rows:    2,134

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-11-02	SPY	ETF	330.2	332.36	327.24	330.2	86068300.0
2020-11-02	QQQ	ETF	271.73	273.52	266.97	269.98	39987409.0
2020-11-02	IWM	ETF	154.77	155.89	153.67	155.82	25252100.0
2020-11-02	DIA	ETF	268.9	270.5	266.93	269.2	5062900.0
2020-11-02	GLD	ETF	177.45	177.93	177.13	177.91	6498400.0
2020-11-02	TLT	ETF	158.7	159.19	158.33	158.58	10810500.0
2020-11-02	AAA	ETF	24.9	24.9	24.89	24.89	9183.0
2020-11-02	AAAU	ETF	18.84	18.88	18.8	18.87	325200.0
2020-11-02	AADR	ETF	54.23	54.51	54.03	54.45	4000.0
2020-11-02	AAXJ	ETF	79.54	79.74	79.06	79.74	1149400.0
2020-11-02	ABEQ	ETF	23.24	23.49	23.24	23.49	1800.0
2020-11-02	ACES	ETF	56.26	57.18	55.91	57.18	72700.0
2020-11-02	ACIO	ETF	26.27	26.41	26.24	26.3	23800.0
2020-11-02	ACSI	ETF	37.77	37.822	37.69	37.822	541.0
2020-11-02	ACTV	ETF	24.61	24.68	24.43	24.63	2663.0
2020-11-02	ACTX	ETF	2.84	3.0	2.8	2.99	1496.0
2020-11-02	ACVF	ETF	24.45	24.505	24.43	24.476	3000.0
2020-11-02	ACWF	ETF	29.5472	29.5472	29.33	29.5342	37366.0
2020-11-02	ACWI	ETF	78.94	79.3	78.36	79.0	6132900.0
2020-11-02	ACWV	ETF	90.39	90.77	90.04	90.61	341200.0
2020-11-02	ACWX	ETF	45.53	45.62	45.3	45.61	1522389.0
2020-11-02	ADME	ETF	33.17	33.53	33.01	33.199	20500.0
2020-11-02	ADRE	ETF	49.3	49.6184	49.0717	49.2027	8462.0
2020-11-02	AESR	ETF	10.68	10.724	10.66	10.673	3500.0
2020-11-02	AFIF	ETF	9.795	9.8013	9.775	9.788	7988.0
2020-11-02	AFK	ETF	17.8	18.0	17.548	17.9784	11541.0
2020-11-02	AFLG	ETF	19.906	19.906	19.906	19.906	100.0
2020-11-02	AFSM	ETF	18.36	18.36	18.36	18.36	200.0
2020-11-02	AFTY	ETF	20.32	20.372	20.32	20.372	700.0
2020-11-02	AGG	ETF	117.27	117.35	117.18	117.22	6667900.0
2020-11-02	AGGY	ETF	53.37	53.448	53.35	53.36	127300.0
2020-11-02	AGNG	ETF	24.67	24.771	24.53	24.68	2000.0
2020-11-02	AGQ	ETF	43.64	44.24	42.91	44.15	1063500.0
2020-11-02	AGZ	ETF	120.65	120.7411	120.62	120.62	80094.0
2020-11-02	AGZD	ETF	23.48	23.49	23.41	23.41	80000.0
2020-11-02	AIA	ETF	75.3	75.6	74.96	75.59	159604.0
2020-11-02	AIEQ	ETF	29.85	30.22	29.685	29.88	28100.0
2020-11-02	AIQ	ETF	23.42	23.54	23.03	23.26	12811.0
2020-11-02	AIRR	ETF	26.9	27.294	26.83	27.294	14600.0
2020-11-02	AIVI	ETF	34.68	34.8	34.58	34.78	11700.0
2020-11-02	ALTL	ETF	24.7399	24.7399	24.435	24.612	409316.0
2020-11-02	ALTY	ETF	10.35	10.51	10.35	10.494	6100.0
2020-11-02	AMJ	ETF	11.44	11.44	11.17	11.28	458663.0
2020-11-02	AMLP	ETF	21.07	21.15	20.69	20.94	2419000.0
2020-11-02	AMNA	ETF	21.22	21.22	21.1002	21.1002	200.0
2020-11-02	AMND	ETF	22.54	22.54	22.4129	22.4129	1402.0
2020-11-02	AMOM	ETF	34.585	34.585	34.202	34.55	800.0
2020-11-02	AMTR	ETF	23.8113	23.8113	23.8113	23.8113	0.0
2020-11-02	AMUB	ETF	7.14	7.16	7.09	7.1	11989.0
2020-11-02	AMZA	ETF	14.06	14.21	13.78	13.86	50600.0

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

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