PREVIEW / etf_daily / 2020-12-29

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-29.parquet
  size:    83 KB
  rows:    2,200

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-29	SPY	ETF	373.81	374.0	370.83	371.46	53680500.0
2020-12-29	QQQ	ETF	314.05	314.685	312.03	312.96	25871925.0
2020-12-29	IWM	ETF	198.64	199.0	193.44	194.43	33901300.0
2020-12-29	DIA	ETF	305.43	305.7	302.64	303.46	2319600.0
2020-12-29	GLD	ETF	176.25	176.97	175.57	176.35	5983700.0
2020-12-29	TLT	ETF	156.39	157.29	156.36	157.16	9030900.0
2020-12-29	AAA	ETF	25.0675	25.0675	25.065	25.065	857.0
2020-12-29	AAAU	ETF	18.7	18.78	18.65	18.71	432600.0
2020-12-29	AADR	ETF	60.57	60.89	60.36	60.53	17800.0
2020-12-29	AAXJ	ETF	87.98	88.22	87.53	88.16	1181700.0
2020-12-29	ABEQ	ETF	25.475	25.65	25.47	25.513	16400.0
2020-12-29	ACES	ETF	79.75	79.75	76.891	77.63	147700.0
2020-12-29	ACIO	ETF	27.95	27.95	27.62	27.66	40700.0
2020-12-29	ACSI	ETF	43.1184	43.1184	43.1184	43.1184	223.0
2020-12-29	ACTV	ETF	31.03	31.085	30.91	31.0328	16410.0
2020-12-29	ACTX	ETF	2.39	2.41	2.1	2.1	2523.0
2020-12-29	ACVF	ETF	28.03	28.03	27.69	27.695	3600.0
2020-12-29	ACWF	ETF	33.52	33.52	33.316	33.3339	6113.0
2020-12-29	ACWI	ETF	90.77	90.89	90.21	90.36	2479800.0
2020-12-29	ACWV	ETF	96.81	96.81	96.28	96.36	184300.0
2020-12-29	ACWX	ETF	53.15	53.2	52.94	53.04	833358.0
2020-12-29	ADFI	ETF	9.97	9.97	9.97	9.97	100.0
2020-12-29	ADME	ETF	36.32	36.32	35.75	35.83	25000.0
2020-12-29	ADRE	ETF	55.08	55.54	54.8	55.38	14905.0
2020-12-29	AESR	ETF	11.96	11.96	11.89	11.897	3400.0
2020-12-29	AFIF	ETF	9.69	9.79	9.69	9.775	9319.0
2020-12-29	AFK	ETF	20.24	20.5109	20.131	20.173	14735.0
2020-12-29	AFLG	ETF	22.15	22.15	22.137	22.137	100.0
2020-12-29	AFMC	ETF	21.14	21.14	21.14	21.14	100.0
2020-12-29	AFSM	ETF	21.898	21.898	21.898	21.898	100.0
2020-12-29	AFTY	ETF	22.15	22.24	22.15	22.24	4500.0
2020-12-29	AGG	ETF	118.06	118.06	117.92	118.03	4300100.0
2020-12-29	AGGY	ETF	53.57	53.58	53.48	53.56	403500.0
2020-12-29	AGNG	ETF	28.0	28.09	27.918	27.99	6200.0
2020-12-29	AGQ	ETF	50.47	51.14	49.44	50.5	988900.0
2020-12-29	AGZ	ETF	119.485	119.57	119.465	119.51	26926.0
2020-12-29	AGZD	ETF	23.56	23.56	23.51	23.54	15200.0
2020-12-29	AIA	ETF	85.03	85.3299	84.9528	85.25	111750.0
2020-12-29	AIEQ	ETF	35.6	35.748	35.0	35.23	20800.0
2020-12-29	AIQ	ETF	27.1	27.26	26.91	27.0	22480.0
2020-12-29	AIRR	ETF	34.12	34.12	33.319	33.449	7100.0
2020-12-29	AIVI	ETF	40.83	40.83	40.61	40.61	8000.0
2020-12-29	ALTL	ETF	31.63	31.63	31.2244	31.32	22193.0
2020-12-29	ALTY	ETF	11.69	11.714	11.64	11.64	8500.0
2020-12-29	AMJ	ETF	13.99	14.01	13.72	13.8	1187503.0
2020-12-29	AMLP	ETF	25.79	25.96	25.39	25.64	3087600.0
2020-12-29	AMNA	ETF	25.2	25.22	25.12	25.1943	4100.0
2020-12-29	AMND	ETF	26.7825	26.7825	26.7825	26.7825	14.0
2020-12-29	AMOM	ETF	32.13	32.13	31.81	31.852	5500.0
2020-12-29	AMTR	ETF	28.48	28.49	28.32	28.4027	17400.0

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

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