PREVIEW / etf_daily / 2020-12-10

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-10.parquet
  size:    82 KB
  rows:    2,188

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-12-10	SPY	ETF	365.37	367.86	364.43	366.73	57735400.0
2020-12-10	QQQ	ETF	299.21	303.68	298.09	302.52	27519544.0
2020-12-10	IWM	ETF	187.76	191.65	187.31	191.24	21245300.0
2020-12-10	DIA	ETF	299.99	301.15	299.2	300.54	2413000.0
2020-12-10	GLD	ETF	172.9	173.58	171.7	172.17	6564000.0
2020-12-10	TLT	ETF	157.24	158.29	156.83	158.21	10025100.0
2020-12-10	AAA	ETF	25.06	25.06	25.06	25.06	255.0
2020-12-10	AAAU	ETF	18.35	18.42	18.23	18.27	121400.0
2020-12-10	AADR	ETF	58.17	58.61	58.13	58.48	4100.0
2020-12-10	AAXJ	ETF	87.2	88.23	87.08	88.11	1340200.0
2020-12-10	ABEQ	ETF	25.259	25.299	25.259	25.299	500.0
2020-12-10	ACES	ETF	68.0	69.5	67.854	69.28	63700.0
2020-12-10	ACIO	ETF	26.91	27.51	26.91	27.31	5000.0
2020-12-10	ACSI	ETF	42.72	42.79	42.695	42.71	2765.0
2020-12-10	ACTV	ETF	30.94	31.0695	30.92	31.0695	2131.0
2020-12-10	ACTX	ETF	2.7	2.7	2.7	2.7	192.0
2020-12-10	ACVF	ETF	27.25	27.25	27.17	27.17	700.0
2020-12-10	ACWF	ETF	32.82	33.0	32.78	32.9868	23129.0
2020-12-10	ACWI	ETF	88.72	89.52	88.64	89.39	2972900.0
2020-12-10	ACWV	ETF	95.88	96.35	95.83	96.05	249900.0
2020-12-10	ACWX	ETF	52.11	52.6589	52.11	52.59	1353030.0
2020-12-10	ADFI	ETF	9.97	9.97	9.97	9.97	100.0
2020-12-10	ADME	ETF	35.095	35.15	34.99	35.087	5100.0
2020-12-10	ADRE	ETF	55.99	55.99	54.6	55.3837	11797.0
2020-12-10	AESR	ETF	11.72	11.73	11.7	11.73	1900.0
2020-12-10	AFIF	ETF	9.8012	9.83	9.8012	9.815	15351.0
2020-12-10	AFK	ETF	20.37	20.5299	20.37	20.4998	7438.0
2020-12-10	AFLG	ETF	21.87	21.87	21.87	21.87	100.0
2020-12-10	AFMC	ETF	20.885	20.885	20.885	20.885	100.0
2020-12-10	AFSM	ETF	21.336	21.336	21.336	21.336	100.0
2020-12-10	AFTY	ETF	21.99	21.99	21.99	21.99	100.0
2020-12-10	AGG	ETF	117.74	117.93	117.69	117.9	6192200.0
2020-12-10	AGGY	ETF	53.38	53.53	53.38	53.51	80700.0
2020-12-10	AGNG	ETF	27.17	27.18	27.155	27.179	1200.0
2020-12-10	AGQ	ETF	42.88	43.63	42.2	42.68	890200.0
2020-12-10	AGZ	ETF	119.57	119.6	119.4924	119.6	20518.0
2020-12-10	AGZD	ETF	23.55	23.57	23.51	23.535	114400.0
2020-12-10	AIA	ETF	84.31	85.51	84.27	85.4	130777.0
2020-12-10	AIEQ	ETF	34.4	35.15	34.4	35.15	15300.0
2020-12-10	AIQ	ETF	26.22	26.59	26.1	26.57	29356.0
2020-12-10	AIRR	ETF	33.41	33.41	33.13	33.398	3900.0
2020-12-10	AIVI	ETF	40.11	40.46	40.11	40.4	5700.0
2020-12-10	ALTL	ETF	32.6	32.6037	32.43	32.6037	1828.0
2020-12-10	ALTY	ETF	11.65	11.8	11.65	11.8	7700.0
2020-12-10	AMJ	ETF	14.78	15.33	14.7	15.14	1233749.0
2020-12-10	AMLP	ETF	27.26	28.5	27.26	28.37	3420500.0
2020-12-10	AMNA	ETF	27.4332	27.4332	27.4332	27.4332	2.0
2020-12-10	AMND	ETF	29.07	29.35	29.07	29.3425	2705.0
2020-12-10	AMOM	ETF	38.5	38.658	38.49	38.626	1000.0
2020-12-10	AMTR	ETF	30.91	30.98	30.85	30.97	24047.0

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

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