PREVIEW / etf_daily / 2020-04-27

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-27.parquet
  size:    75 KB
  rows:    1,967

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-04-27	SPY	ETF	285.12	288.27	284.62	287.05	77896600.0
2020-04-27	QQQ	ETF	216.18	216.63	214.5	215.56	36451698.0
2020-04-27	IWM	ETF	123.95	128.44	123.86	127.26	39021300.0
2020-04-27	DIA	ETF	239.12	242.19	238.45	241.32	3632500.0
2020-04-27	GLD	ETF	161.88	162.0	160.41	161.56	9033500.0
2020-04-27	TLT	ETF	169.66	169.75	167.44	167.66	9039500.0
2020-04-27	AAAU	ETF	17.14	17.24	17.02	17.13	395400.0
2020-04-27	AADR	ETF	45.63	45.78	45.35	45.78	4000.0
2020-04-27	AAXJ	ETF	63.49	63.91	63.32	63.86	607700.0
2020-04-27	ABEQ	ETF	21.785	22.02	21.785	21.99	5200.0
2020-04-27	ACES	ETF	31.99	32.831	31.99	32.77	34800.0
2020-04-27	ACIO	ETF	24.08	24.13	24.01	24.113	5800.0
2020-04-27	ACSI	ETF	30.43	30.8267	30.43	30.7761	918.0
2020-04-27	ACTX	ETF	5.7762	5.7762	4.13	4.1595	702.0
2020-04-27	ACWF	ETF	26.29	26.37	26.16	26.3223	3402.0
2020-04-27	ACWI	ETF	67.52	68.15	67.36	67.99	10858600.0
2020-04-27	ACWV	ETF	86.67	87.25	86.37	87.06	1026100.0
2020-04-27	ACWX	ETF	39.36	39.66	39.25	39.6	1814351.0
2020-04-27	ADME	ETF	30.19	30.229	30.1	30.154	4300.0
2020-04-27	ADRE	ETF	35.57	35.885	35.57	35.81	6952.0
2020-04-27	AESR	ETF	9.187	9.193	9.187	9.193	3400.0
2020-04-27	AFIF	ETF	9.79	9.8	9.74	9.77	16513.0
2020-04-27	AFK	ETF	14.07	14.6027	14.07	14.3918	16082.0
2020-04-27	AFTY	ETF	15.68	15.72	15.68	15.714	5700.0
2020-04-27	AGG	ETF	117.21	117.36	116.82	116.82	5576300.0
2020-04-27	AGGY	ETF	53.05	53.09	52.73	52.88	214800.0
2020-04-27	AGNG	ETF	22.85	22.97	22.778	22.95	2300.0
2020-04-27	AGQ	ETF	21.32	21.39	20.74	21.17	185600.0
2020-04-27	AGZ	ETF	120.42	120.545	120.42	120.46	56736.0
2020-04-27	AGZD	ETF	23.205	23.6	22.85	23.225	66400.0
2020-04-27	AIA	ETF	59.07	59.41	59.01	59.32	161468.0
2020-04-27	AIEQ	ETF	25.8	25.95	25.68	25.8	22400.0
2020-04-27	AIQ	ETF	17.6	17.6905	17.55	17.55	25926.0
2020-04-27	AIRR	ETF	20.57	21.618	20.57	21.482	44800.0
2020-04-27	AIVI	ETF	32.66	32.92	32.59	32.88	8300.0
2020-04-27	ALTY	ETF	9.47	9.75	9.465	9.715	6400.0
2020-04-27	AMJ	ETF	12.14	12.46	11.91	12.44	2232649.0
2020-04-27	AMLP	ETF	23.2	23.4	22.4	23.4	7734900.0
2020-04-27	AMOM	ETF	25.663	25.663	25.588	25.588	100.0
2020-04-27	AMUB	ETF	7.58	7.838	7.52	7.838	31685.0
2020-04-27	AMZA	ETF	15.64	15.81	15.08	15.79	115600.0
2020-04-27	ANGL	ETF	26.65	26.79	26.51	26.61	1662000.0
2020-04-27	AOA	ETF	50.54	50.9	50.39	50.86	216400.0
2020-04-27	AOK	ETF	35.02	35.0899	34.95	35.05	434084.0
2020-04-27	AOM	ETF	38.02	38.0888	37.93	38.07	490293.0
2020-04-27	AOR	ETF	43.45	43.665	43.38	43.63	359927.0
2020-04-27	ARGT	ETF	16.94	17.2	16.92	17.2	21800.0
2020-04-27	ARKF	ETF	23.67	23.92	23.641	23.89	54800.0
2020-04-27	ARKG	ETF	41.01	42.61	40.78	41.915	828600.0
2020-04-27	ARKK	ETF	54.07	56.429	53.755	55.64	1905900.0

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

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