PREVIEW / etf_daily / 2020-03-02

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-02.parquet
  size:    76 KB
  rows:    1,981

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-03-02	SPY	ETF	298.21	309.16	294.46	309.09	238703600.0
2020-03-02	QQQ	ETF	208.88	216.57	205.94	216.42	112933945.0
2020-03-02	IWM	ETF	147.97	151.23	145.39	151.03	33569300.0
2020-03-02	DIA	ETF	256.71	267.25	254.06	267.03	8544500.0
2020-03-02	GLD	ETF	150.0	150.73	149.04	149.2	16295400.0
2020-03-02	TLT	ETF	155.3	156.5	153.76	153.94	28152400.0
2020-03-02	AAAU	ETF	15.9	15.97	15.8	15.81	293900.0
2020-03-02	AADR	ETF	49.78	51.08	49.44	51.08	11700.0
2020-03-02	AAXJ	ETF	68.32	69.31	67.86	69.31	3489600.0
2020-03-02	ABEQ	ETF	23.14	23.438	23.115	23.438	1800.0
2020-03-02	ACES	ETF	37.69	38.809	37.2	38.75	90600.0
2020-03-02	ACIO	ETF	24.285	24.84	24.285	24.67	46100.0
2020-03-02	ACSI	ETF	33.2	34.2547	33.17	34.2547	13298.0
2020-03-02	ACTX	ETF	6.3426	8.3781	6.3426	6.9326	208.0
2020-03-02	ACWF	ETF	28.31	29.01	28.06	28.9956	12673.0
2020-03-02	ACWI	ETF	72.62	74.71	71.99	74.65	7880100.0
2020-03-02	ACWV	ETF	90.3	93.05	90.21	93.0	972900.0
2020-03-02	ACWX	ETF	44.37	45.025	43.97	44.99	2356179.0
2020-03-02	ADME	ETF	29.91	30.75	29.86	30.7	21500.0
2020-03-02	ADRE	ETF	40.13	40.8569	39.9604	40.8569	15456.0
2020-03-02	AESR	ETF	9.48	9.666	9.455	9.666	300.0
2020-03-02	AFIF	ETF	9.91	9.93	9.87	9.875	1123.0
2020-03-02	AFK	ETF	17.45	17.82	17.0044	17.8096	22245.0
2020-03-02	AFLG	ETF	18.6	19.345	18.6	19.345	100.0
2020-03-02	AFSM	ETF	17.8	18.411	17.8	18.411	100.0
2020-03-02	AFTY	ETF	16.34	16.57	16.34	16.491	25900.0
2020-03-02	AGG	ETF	116.29	116.44	115.89	115.94	13198200.0
2020-03-02	AGGY	ETF	53.92	53.97	53.655	53.7	1970700.0
2020-03-02	AGNG	ETF	22.45	23.27	22.36	23.27	9000.0
2020-03-02	AGQ	ETF	27.01	27.25	26.75	26.81	297300.0
2020-03-02	AGZ	ETF	119.19	119.39	118.96	118.98	778036.0
2020-03-02	AGZD	ETF	23.86	23.87	23.715	23.835	58200.0
2020-03-02	AIA	ETF	61.82	62.71	61.63	62.59	222136.0
2020-03-02	AIEQ	ETF	26.57	27.389	26.264	27.3	54300.0
2020-03-02	AIQ	ETF	17.6	18.05	17.35	18.05	18453.0
2020-03-02	AIRR	ETF	25.5	26.379	25.288	26.379	31100.0
2020-03-02	AIVI	ETF	37.52	38.21	37.4	38.21	27600.0
2020-03-02	ALTY	ETF	13.3	13.835	13.3	13.81	32500.0
2020-03-02	AMJ	ETF	17.52	17.92	17.06	17.73	4293034.0
2020-03-02	AMLP	ETF	33.75	34.7	33.0	34.35	7106140.0
2020-03-02	AMOM	ETF	24.78	25.895	24.78	25.895	400.0
2020-03-02	AMUB	ETF	10.86	11.1533	10.86	11.1511	9321.0
2020-03-02	AMZA	ETF	32.0	33.3	31.0	32.7	189710.0
2020-03-02	ANGL	ETF	29.45	29.51	29.24	29.51	1230800.0
2020-03-02	AOA	ETF	54.13	55.28	53.8	55.27	134600.0
2020-03-02	AOK	ETF	35.86	36.22	35.86	36.22	205392.0
2020-03-02	AOM	ETF	39.27	39.76	39.2	39.67	335235.0
2020-03-02	AOR	ETF	45.7	46.48	45.5568	46.46	219342.0
2020-03-02	ARCM	ETF	100.065	100.065	100.065	100.065	100.0
2020-03-02	ARGT	ETF	23.05	23.83	22.94	23.82	25900.0

> showing 50 of 1,981 rows — these rows as CSV

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