PREVIEW / etf_daily / 2020-04-06

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-06.parquet
  size:    74 KB
  rows:    1,952

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-06	SPY	ETF	257.84	267.0	248.17	264.86	188061200.0
2020-04-06	QQQ	ETF	190.38	197.65	189.19	196.48	64763518.0
2020-04-06	IWM	ETF	109.09	113.34	109.02	112.63	48708100.0
2020-04-06	DIA	ETF	218.95	227.91	218.12	226.53	10322500.0
2020-04-06	GLD	ETF	154.16	157.22	153.96	156.88	14739300.0
2020-04-06	TLT	ETF	167.0	168.27	166.53	168.06	9434800.0
2020-04-06	AAAU	ETF	16.4	16.65	16.32	16.65	334600.0
2020-04-06	AADR	ETF	40.12	41.63	40.12	41.26	12300.0
2020-04-06	AAXJ	ETF	60.16	61.04	59.98	61.0	2624500.0
2020-04-06	ABEQ	ETF	20.59	20.691	20.51	20.691	2800.0
2020-04-06	ACES	ETF	27.9	29.14	27.9	29.14	18400.0
2020-04-06	ACIO	ETF	22.815	23.12	22.74	23.12	9000.0
2020-04-06	ACSI	ETF	27.82	28.4747	27.75	28.4747	137852.0
2020-04-06	ACTX	ETF	4.13	4.13	3.8645	3.8645	53.0
2020-04-06	ACWF	ETF	24.25	24.66	24.24	24.57	5719.0
2020-04-06	ACWI	ETF	62.12	63.98	61.97	63.69	4577700.0
2020-04-06	ACWV	ETF	80.71	82.76	80.6	82.4	601600.0
2020-04-06	ACWX	ETF	37.23	37.97	37.18	37.84	3162776.0
2020-04-06	ADME	ETF	27.97	28.649	27.97	28.649	14700.0
2020-04-06	ADRE	ETF	33.82	34.245	33.7	34.1642	12645.0
2020-04-06	AESR	ETF	8.206	8.483	8.206	8.483	1100.0
2020-04-06	AFIF	ETF	9.735	9.7798	9.735	9.7798	958.0
2020-04-06	AFK	ETF	12.73	12.9875	12.6801	12.88	11102.0
2020-04-06	AFLG	ETF	15.9	16.242	15.885	16.242	400.0
2020-04-06	AFTY	ETF	15.32	15.47	15.32	15.434	6000.0
2020-04-06	AGG	ETF	115.02	115.61	115.02	115.54	8457700.0
2020-04-06	AGGY	ETF	51.81	52.02	51.61	51.82	167500.0
2020-04-06	AGNG	ETF	19.95	20.38	19.95	20.367	2700.0
2020-04-06	AGQ	ETF	19.93	21.64	19.63	21.39	383000.0
2020-04-06	AGZ	ETF	120.43	120.5899	120.22	120.42	77515.0
2020-04-06	AGZD	ETF	22.875	23.39	22.875	23.17	45400.0
2020-04-06	AIA	ETF	56.54	57.53	56.43	57.53	27429.0
2020-04-06	AIEQ	ETF	22.46	23.15	22.228	22.89	15800.0
2020-04-06	AIQ	ETF	15.37	16.0392	15.36	15.9919	13034.0
2020-04-06	AIRR	ETF	19.4	20.04	19.4	19.949	85700.0
2020-04-06	AIVI	ETF	31.33	31.72	30.95	31.71	50300.0
2020-04-06	ALTY	ETF	8.0	8.38	8.0	8.18	5800.0
2020-04-06	AMJ	ETF	9.45	9.87	9.32	9.32	3188984.0
2020-04-06	AMLP	ETF	17.9	18.9	17.65	17.95	7757340.0
2020-04-06	AMUB	ETF	5.99	6.05	5.99	6.0003	12700.0
2020-04-06	AMZA	ETF	11.26	11.89	11.05	11.43	159200.0
2020-04-06	ANGL	ETF	25.7	25.7	24.93	25.35	1708600.0
2020-04-06	AOA	ETF	47.3	48.27	47.21	48.07	163800.0
2020-04-06	AOK	ETF	33.86	34.15	33.7333	34.15	286474.0
2020-04-06	AOM	ETF	36.37	36.865	36.32	36.73	707802.0
2020-04-06	AOR	ETF	41.21	41.85	41.03	41.82	214168.0
2020-04-06	ARGT	ETF	16.33	16.78	16.33	16.65	15500.0
2020-04-06	ARKF	ETF	19.67	20.62	19.67	20.595	66300.0
2020-04-06	ARKG	ETF	31.49	31.87	30.95	31.79	130900.0
2020-04-06	ARKK	ETF	42.38	44.31	42.02	44.18	578600.0

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

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