PREVIEW / etf_daily / 2020-10-02

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-02.parquet
  size:    79 KB
  rows:    2,096

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-10-02	SPY	ETF	331.7	337.01	331.19	333.84	89431100.0
2020-10-02	QQQ	ETF	276.01	282.2412	273.44	274.31	75497391.0
2020-10-02	IWM	ETF	149.41	153.58	148.99	152.85	29452000.0
2020-10-02	DIA	ETF	274.17	278.51	273.6	276.8	4771600.0
2020-10-02	GLD	ETF	178.69	179.29	178.16	178.54	7488500.0
2020-10-02	TLT	ETF	163.61	163.67	162.18	162.75	8828800.0
2020-10-02	AAA	ETF	24.9127	24.925	24.9127	24.915	2995.0
2020-10-02	AAAU	ETF	18.97	19.01	18.91	18.95	376900.0
2020-10-02	AADR	ETF	55.46	55.75	55.42	55.61	4000.0
2020-10-02	AAXJ	ETF	76.84	77.82	76.84	77.19	787200.0
2020-10-02	ABEQ	ETF	22.93	23.53	22.93	23.53	11000.0
2020-10-02	ACES	ETF	55.99	57.15	55.214	56.31	66400.0
2020-10-02	ACIO	ETF	26.51	26.58	26.435	26.52	25300.0
2020-10-02	ACSI	ETF	37.7025	37.7025	37.7025	37.7025	121.0
2020-10-02	ACTX	ETF	2.1641	2.1641	1.7759	1.7759	122.0
2020-10-02	ACWF	ETF	29.42	29.8155	29.42	29.7284	5721.0
2020-10-02	ACWI	ETF	79.36	80.31	79.26	79.91	2635700.0
2020-10-02	ACWV	ETF	91.26	92.32	91.26	92.08	197700.0
2020-10-02	ACWX	ETF	45.75	46.3	45.73	46.14	820444.0
2020-10-02	ADFI	ETF	9.975	9.975	9.975	9.975	100.0
2020-10-02	ADME	ETF	33.44	33.635	33.44	33.46	14800.0
2020-10-02	ADRE	ETF	46.42	46.9879	46.42	46.63	5781.0
2020-10-02	AESR	ETF	10.895	10.92	10.855	10.855	2200.0
2020-10-02	AFIF	ETF	9.79	9.83	9.79	9.815	23819.0
2020-10-02	AFK	ETF	17.25	17.5927	17.16	17.29	10172.0
2020-10-02	AFLG	ETF	20.143	20.143	20.143	20.143	100.0
2020-10-02	AFMC	ETF	18.074	18.074	18.074	18.074	100.0
2020-10-02	AFSM	ETF	18.379	18.379	18.379	18.379	100.0
2020-10-02	AFTY	ETF	19.395	19.395	19.395	19.395	100.0
2020-10-02	AGG	ETF	118.03	118.04	117.81	117.9	5599500.0
2020-10-02	AGGY	ETF	53.82	53.88	53.78	53.87	126800.0
2020-10-02	AGNG	ETF	25.588	25.62	25.516	25.595	2500.0
2020-10-02	AGQ	ETF	44.12	45.36	43.35	43.67	1547100.0
2020-10-02	AGZ	ETF	121.19	121.19	120.995	121.09	58056.0
2020-10-02	AGZD	ETF	23.45	23.45	23.41	23.445	5600.0
2020-10-02	AIA	ETF	71.54	72.45	71.51	71.82	88171.0
2020-10-02	AIEQ	ETF	30.49	31.11	30.49	30.861	13800.0
2020-10-02	AIQ	ETF	23.41	23.73	23.41	23.4717	23254.0
2020-10-02	AIRR	ETF	25.4	26.319	25.29	26.27	9900.0
2020-10-02	AIVI	ETF	35.69	36.12	35.69	36.05	8800.0
2020-10-02	ALTL	ETF	24.975	25.0504	24.828	24.9429	4337.0
2020-10-02	ALTY	ETF	10.5	10.72	10.5	10.72	5000.0
2020-10-02	AMJ	ETF	10.48	10.91	10.45	10.85	1389388.0
2020-10-02	AMLP	ETF	19.29	20.2	19.29	20.07	3635500.0
2020-10-02	AMNA	ETF	21.7157	21.7157	21.7157	21.7157	0.0
2020-10-02	AMND	ETF	22.7673	22.7673	22.7673	22.7673	0.0
2020-10-02	AMOM	ETF	35.74	35.74	35.225	35.406	700.0
2020-10-02	AMUB	ETF	6.6204	6.845	6.6204	6.8368	17447.0
2020-10-02	AMZA	ETF	12.89	13.535	12.81	13.52	103000.0
2020-10-02	ANGL	ETF	29.6	29.72	29.53	29.66	3381000.0

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

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