PREVIEW / etf_daily / 2020-05-28

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-28.parquet
  size:    77 KB
  rows:    2,010

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-28	SPY	ETF	304.65	306.84	302.24	302.97	90405200.0
2020-05-28	QQQ	ETF	229.05	233.47	229.05	229.99	43008478.0
2020-05-28	IWM	ETF	144.74	144.74	137.58	139.7	42105000.0
2020-05-28	DIA	ETF	257.87	257.94	253.89	254.35	4957600.0
2020-05-28	GLD	ETF	162.12	162.46	160.9	161.72	9758500.0
2020-05-28	TLT	ETF	161.96	162.57	161.66	162.43	10272600.0
2020-05-28	AAAU	ETF	17.21	17.22	17.07	17.16	227500.0
2020-05-28	AADR	ETF	48.2	48.89	48.2	48.38	2400.0
2020-05-28	AAXJ	ETF	63.91	64.24	63.37	63.45	1208000.0
2020-05-28	ABEQ	ETF	22.52	22.58	22.45	22.47	2500.0
2020-05-28	ACES	ETF	36.69	36.69	35.766	35.86	20500.0
2020-05-28	ACIO	ETF	24.6	24.7	24.55	24.57	37600.0
2020-05-28	ACSI	ETF	32.5355	32.5355	32.5355	32.5355	102.0
2020-05-28	ACTX	ETF	4.2539	5.605	4.248	4.251	162.0
2020-05-28	ACWF	ETF	27.6655	27.78	27.44	27.4449	96088.0
2020-05-28	ACWI	ETF	72.35	72.88	71.89	72.05	4204600.0
2020-05-28	ACWV	ETF	88.17	88.86	88.17	88.42	284900.0
2020-05-28	ACWX	ETF	42.01	42.285	41.84	41.86	6265161.0
2020-05-28	ADME	ETF	31.7	31.875	31.63	31.63	16000.0
2020-05-28	ADRE	ETF	36.3713	36.528	36.0766	36.0766	6292.0
2020-05-28	AESR	ETF	9.7	9.7	9.625	9.625	6300.0
2020-05-28	AFIF	ETF	9.79	9.84	9.79	9.82	558759.0
2020-05-28	AFK	ETF	15.34	15.5	15.3	15.35	6263.0
2020-05-28	AFLG	ETF	18.68	18.68	18.554	18.554	200.0
2020-05-28	AFMC	ETF	17.038	17.038	17.038	17.038	100.0
2020-05-28	AFTY	ETF	15.674	15.71	15.553	15.553	9100.0
2020-05-28	AGG	ETF	117.14	117.35	117.14	117.34	11140200.0
2020-05-28	AGGY	ETF	53.29	53.49	53.19	53.25	386100.0
2020-05-28	AGNG	ETF	23.77	24.205	23.77	23.923	2500.0
2020-05-28	AGQ	ETF	28.31	28.74	27.89	28.14	699200.0
2020-05-28	AGZ	ETF	120.98	120.99	120.88	120.96	38153.0
2020-05-28	AGZD	ETF	23.365	23.365	23.3	23.33	16800.0
2020-05-28	AIA	ETF	58.89	59.3	58.55	58.59	62525.0
2020-05-28	AIEQ	ETF	26.93	27.436	26.93	27.1	13900.0
2020-05-28	AIQ	ETF	19.11	19.4605	19.02	19.15	9609.0
2020-05-28	AIRR	ETF	24.64	24.64	23.49	23.522	39500.0
2020-05-28	AIVI	ETF	34.81	35.05	34.79	34.85	12000.0
2020-05-28	ALTY	ETF	10.98	10.98	10.805	10.81	7800.0
2020-05-28	AMJ	ETF	14.61	14.675	14.32	14.45	1594162.0
2020-05-28	AMLP	ETF	27.04	27.3	26.62	26.92	3547600.0
2020-05-28	AMOM	ETF	27.808	27.808	27.808	27.808	100.0
2020-05-28	AMUB	ETF	8.96	9.2	8.96	9.0888	10348.0
2020-05-28	AMZA	ETF	20.8	20.8	20.25	20.37	44300.0
2020-05-28	ANGL	ETF	28.0	28.26	27.9	27.96	918600.0
2020-05-28	AOA	ETF	53.58	53.9	53.35	53.35	69200.0
2020-05-28	AOK	ETF	35.89	35.95	35.74	35.83	162880.0
2020-05-28	AOM	ETF	39.28	39.35	39.0919	39.18	278912.0
2020-05-28	AOR	ETF	45.55	45.6825	45.25	45.35	131122.0
2020-05-28	ARB	ETF	24.7	24.7	24.66	24.66	2322.0
2020-05-28	ARCM	ETF	100.42	100.42	100.41	100.41	500.0

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

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