PREVIEW / etf_daily / 2020-09-25

all etf daily files

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

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-25	SPY	ETF	322.58	329.58	321.64	328.73	71069400.0
2020-09-25	QQQ	ETF	265.82	272.395	264.2999	271.56	55242376.0
2020-09-25	IWM	ETF	143.44	146.85	143.35	146.41	20689300.0
2020-09-25	DIA	ETF	266.76	272.31	266.23	271.7	3606800.0
2020-09-25	GLD	ETF	174.41	175.3	173.89	174.94	6779200.0
2020-09-25	TLT	ETF	165.11	165.42	164.71	165.12	5140300.0
2020-09-25	AAA	ETF	24.985	25.0	24.97	24.98	115566.0
2020-09-25	AAAU	ETF	18.52	18.6	18.46	18.57	481300.0
2020-09-25	AADR	ETF	53.47	54.28	53.47	54.28	2900.0
2020-09-25	AAXJ	ETF	74.42	75.04	73.96	74.95	625100.0
2020-09-25	ABEQ	ETF	22.92	23.19	22.9	23.19	3400.0
2020-09-25	ACES	ETF	49.5	51.511	49.5	51.45	31600.0
2020-09-25	ACIO	ETF	26.07	26.36	26.07	26.34	25200.0
2020-09-25	ACSI	ETF	36.6447	36.6447	36.6447	36.6447	102.0
2020-09-25	ACTX	ETF	2.5046	2.5046	2.242	2.242	454.0
2020-09-25	ACWF	ETF	28.74	29.1692	28.74	29.1692	1726.0
2020-09-25	ACWI	ETF	77.37	78.7	77.12	78.59	6358600.0
2020-09-25	ACWV	ETF	89.59	90.6	89.3	90.57	269100.0
2020-09-25	ACWX	ETF	44.86	45.39	44.71	45.36	1013280.0
2020-09-25	ADME	ETF	32.805	33.103	32.805	33.103	2200.0
2020-09-25	ADRE	ETF	44.779	45.38	44.65	45.38	2400.0
2020-09-25	AESR	ETF	10.57	10.695	10.57	10.695	2000.0
2020-09-25	AFIF	ETF	9.815	9.83	9.8	9.81	17528.0
2020-09-25	AFK	ETF	17.16	17.35	17.0	17.29	9777.0
2020-09-25	AFLG	ETF	19.809	19.809	19.809	19.809	100.0
2020-09-25	AFTY	ETF	18.843	19.056	18.843	19.056	3200.0
2020-09-25	AGG	ETF	118.12	118.17	118.05	118.13	5138200.0
2020-09-25	AGGY	ETF	53.81	53.856	53.8	53.8	74300.0
2020-09-25	AGNG	ETF	24.74	24.74	24.73	24.73	4300.0
2020-09-25	AGQ	ETF	39.98	41.49	39.81	40.63	2343800.0
2020-09-25	AGZ	ETF	121.1	121.29	121.1	121.27	32455.0
2020-09-25	AGZD	ETF	23.41	23.485	23.41	23.435	15400.0
2020-09-25	AIA	ETF	69.66	70.22	69.25	70.22	61176.0
2020-09-25	AIEQ	ETF	29.4	30.145	29.4	30.057	7500.0
2020-09-25	AIQ	ETF	22.5	22.87	22.24	22.8195	19404.0
2020-09-25	AIRR	ETF	24.75	25.19	24.75	25.152	19500.0
2020-09-25	AIVI	ETF	35.33	35.61	35.17	35.61	5600.0
2020-09-25	ALTL	ETF	24.26	24.69	24.2443	24.6369	6452.0
2020-09-25	ALTY	ETF	10.23	10.38	10.23	10.365	10000.0
2020-09-25	AMJ	ETF	10.56	10.67	10.36	10.56	1385414.0
2020-09-25	AMLP	ETF	19.44	19.73	19.13	19.56	3266400.0
2020-09-25	AMNA	ETF	21.58	21.8336	21.5	21.8336	1600.0
2020-09-25	AMND	ETF	23.58	25.94	22.33	22.7232	3504.0
2020-09-25	AMOM	ETF	33.56	34.745	33.56	34.43	5000.0
2020-09-25	AMUB	ETF	6.6	6.66	6.6	6.66	10103.0
2020-09-25	AMZA	ETF	12.93	13.04	12.605	12.95	67200.0
2020-09-25	ANGL	ETF	29.38	29.49	29.29	29.43	1212900.0
2020-09-25	AOA	ETF	56.51	57.21	56.39	57.2	412400.0
2020-09-25	AOK	ETF	36.79	37.0	36.7	37.0	56648.0
2020-09-25	AOM	ETF	40.55	40.8	40.4373	40.8	301629.0

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

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