PREVIEW / etf_daily / 2020-09-09

all etf daily files

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

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-09	SPY	ETF	337.55	342.46	336.61	339.79	91462300.0
2020-09-09	QQQ	ETF	275.54	280.045	273.0	277.88	64837872.0
2020-09-09	IWM	ETF	151.43	152.78	150.57	152.13	20160800.0
2020-09-09	DIA	ETF	278.09	282.49	277.39	279.85	3488900.0
2020-09-09	GLD	ETF	182.5	183.22	182.19	183.05	8424100.0
2020-09-09	TLT	ETF	163.94	164.25	162.76	163.3	9558900.0
2020-09-09	AAA	ETF	25.1	25.119	25.0699	25.0699	17526.0
2020-09-09	AAAU	ETF	19.37	19.44	19.33	19.42	454200.0
2020-09-09	AADR	ETF	54.48	55.92	54.48	55.9	2300.0
2020-09-09	AAXJ	ETF	76.6	77.11	76.43	76.98	938700.0
2020-09-09	ABEQ	ETF	23.86	23.9	23.811	23.811	11600.0
2020-09-09	ACES	ETF	49.57	50.669	49.57	50.55	65100.0
2020-09-09	ACIO	ETF	26.81	26.98	26.809	26.81	23600.0
2020-09-09	ACSI	ETF	37.45	37.6145	37.45	37.6145	492.0
2020-09-09	ACTX	ETF	2.2479	2.7052	2.2479	2.7052	291.0
2020-09-09	ACWF	ETF	29.67	29.99	29.6623	29.8866	11219.0
2020-09-09	ACWI	ETF	80.3	81.16	80.08	80.7	3072700.0
2020-09-09	ACWV	ETF	91.75	92.91	91.75	92.38	228000.0
2020-09-09	ACWX	ETF	46.53	46.85	46.45	46.7	734003.0
2020-09-09	ADME	ETF	33.59	34.05	33.59	33.934	5400.0
2020-09-09	ADRE	ETF	46.47	46.685	46.47	46.685	5277.0
2020-09-09	AESR	ETF	10.97	11.04	10.97	11.001	12200.0
2020-09-09	AFIF	ETF	9.8312	9.8399	9.8	9.82	81855.0
2020-09-09	AFK	ETF	17.63	18.02	17.63	17.85	8669.0
2020-09-09	AFLG	ETF	20.32	20.39	20.32	20.382	200.0
2020-09-09	AFMC	ETF	17.76	17.874	17.76	17.874	100.0
2020-09-09	AFSM	ETF	17.8	17.935	17.8	17.935	100.0
2020-09-09	AFTY	ETF	19.16	19.26	19.16	19.23	3000.0
2020-09-09	AGG	ETF	118.39	118.39	118.04	118.22	7824800.0
2020-09-09	AGGY	ETF	53.95	54.03	53.91	53.99	307500.0
2020-09-09	AGNG	ETF	25.15	25.49	25.15	25.359	6800.0
2020-09-09	AGQ	ETF	57.08	58.38	56.69	58.05	1225100.0
2020-09-09	AGZ	ETF	121.25	121.25	120.99	120.99	97963.0
2020-09-09	AGZD	ETF	23.555	23.555	23.505	23.525	18000.0
2020-09-09	AIA	ETF	71.57	72.26	71.48	72.14	322495.0
2020-09-09	AIEQ	ETF	29.62	30.08	29.62	29.86	10700.0
2020-09-09	AIQ	ETF	22.87	23.28	22.79	23.1579	41646.0
2020-09-09	AIRR	ETF	26.25	26.54	26.25	26.35	230200.0
2020-09-09	AIVI	ETF	37.02	37.23	37.02	37.18	8100.0
2020-09-09	ALTL	ETF	24.82	25.23	24.82	25.13	4993.0
2020-09-09	ALTY	ETF	10.82	10.82	10.778	10.8	7300.0
2020-09-09	AMJ	ETF	11.98	12.06	11.85	11.87	896249.0
2020-09-09	AMLP	ETF	22.08	22.27	21.86	21.94	2026500.0
2020-09-09	AMNA	ETF	23.61	23.79	23.55	23.6009	3600.0
2020-09-09	AMND	ETF	24.7225	24.7225	24.7225	24.7225	0.0
2020-09-09	AMOM	ETF	34.2	34.89	34.2	34.752	1300.0
2020-09-09	AMUB	ETF	7.58	7.58	7.45	7.4823	44688.0
2020-09-09	AMZA	ETF	15.73	15.785	15.47	15.64	202900.0
2020-09-09	ANGL	ETF	30.23	30.3	30.11	30.23	2226900.0
2020-09-09	AOA	ETF	58.25	58.87	58.2	58.63	32200.0

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

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