PREVIEW / etf_daily / 2020-05-27

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-27.parquet
  size:    76 KB
  rows:    1,986

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-05-27	SPY	ETF	302.12	303.57	296.87	303.53	104817400.0
2020-05-27	QQQ	ETF	228.51	230.41	223.94	230.29	55665565.0
2020-05-27	IWM	ETF	141.57	143.5	137.33	143.09	42682000.0
2020-05-27	DIA	ETF	253.73	255.79	250.33	255.77	5326100.0
2020-05-27	GLD	ETF	159.42	161.34	159.2	161.18	13063500.0
2020-05-27	TLT	ETF	162.79	163.91	162.59	163.03	8047400.0
2020-05-27	AAAU	ETF	16.9	17.11	16.88	17.1	480900.0
2020-05-27	AADR	ETF	47.59	48.22	47.37	48.12	3000.0
2020-05-27	AAXJ	ETF	63.96	64.01	63.18	63.73	878100.0
2020-05-27	ABEQ	ETF	22.39	22.39	22.185	22.39	16200.0
2020-05-27	ACES	ETF	36.98	36.98	35.053	36.39	25100.0
2020-05-27	ACIO	ETF	25.54	25.54	24.168	24.51	4200.0
2020-05-27	ACSI	ETF	32.59	32.873	32.59	32.873	501.0
2020-05-27	ACTX	ETF	5.2658	5.2658	4.2539	4.2539	892.0
2020-05-27	ACWF	ETF	27.41	27.51	27.17	27.48	29202.0
2020-05-27	ACWI	ETF	71.73	71.99	70.67	71.99	6271700.0
2020-05-27	ACWV	ETF	87.48	87.58	86.72	87.58	208100.0
2020-05-27	ACWX	ETF	41.63	41.65	41.14	41.65	1195838.0
2020-05-27	ADME	ETF	31.81	31.81	30.87	31.452	4500.0
2020-05-27	ADRE	ETF	36.515	36.5315	36.13	36.5315	5647.0
2020-05-27	AESR	ETF	9.45	9.618	9.45	9.618	16600.0
2020-05-27	AFIF	ETF	9.82	9.86	9.82	9.84	107813.0
2020-05-27	AFK	ETF	15.34	15.4	15.22	15.36	4947.0
2020-05-27	AFLG	ETF	18.534	18.534	18.534	18.534	100.0
2020-05-27	AFMC	ETF	17.232	17.232	17.232	17.232	100.0
2020-05-27	AFSM	ETF	16.908	16.908	16.908	16.908	100.0
2020-05-27	AFTY	ETF	15.56	15.56	15.46	15.508	5400.0
2020-05-27	AGG	ETF	117.5	117.54	117.3	117.42	4772900.0
2020-05-27	AGGY	ETF	53.22	53.35	53.22	53.3	123100.0
2020-05-27	AGNG	ETF	23.5	23.633	23.5	23.633	900.0
2020-05-27	AGQ	ETF	26.12	27.92	26.02	27.87	690500.0
2020-05-27	AGZ	ETF	120.9	121.13	120.9	121.0	55197.0
2020-05-27	AGZD	ETF	23.3	23.355	23.255	23.35	14800.0
2020-05-27	AIA	ETF	59.01	59.01	58.3062	58.86	262399.0
2020-05-27	AIEQ	ETF	26.83	26.92	26.2	26.82	16300.0
2020-05-27	AIQ	ETF	19.0	19.15	18.52	19.1085	25590.0
2020-05-27	AIRR	ETF	23.71	24.26	23.44	24.254	17900.0
2020-05-27	AIVI	ETF	34.35	34.45	34.14	34.45	2800.0
2020-05-27	ALTY	ETF	10.95	10.98	10.67	10.88	13300.0
2020-05-27	AMJ	ETF	15.07	15.16	14.65	14.93	2861349.0
2020-05-27	AMLP	ETF	27.36	27.51	26.56	27.26	2437400.0
2020-05-27	AMOM	ETF	27.123	27.624	27.123	27.624	300.0
2020-05-27	AMUB	ETF	9.31	9.475	9.31	9.4407	20494.0
2020-05-27	AMZA	ETF	21.08	21.08	20.0	20.72	51400.0
2020-05-27	ANGL	ETF	27.88	28.06	27.82	27.99	1180900.0
2020-05-27	AOA	ETF	53.23	53.36	52.62	53.3	50800.0
2020-05-27	AOK	ETF	35.65	35.83	35.6157	35.81	597643.0
2020-05-27	AOM	ETF	39.02	39.18	38.81	39.08	207551.0
2020-05-27	AOR	ETF	45.14	45.3397	44.84	45.3	1406642.0
2020-05-27	ARB	ETF	24.5	24.6298	24.48	24.6298	2105.0

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

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