PREVIEW / etf_daily / 2020-07-01

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-01.parquet
  size:    77 KB
  rows:    2,038

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-07-01	SPY	ETF	309.57	311.89	309.07	310.52	72396500.0
2020-07-01	QQQ	ETF	247.66	251.52	247.0802	250.49	34689213.0
2020-07-01	IWM	ETF	143.65	144.51	141.24	141.82	26457500.0
2020-07-01	DIA	ETF	258.87	260.26	257.14	257.31	3575300.0
2020-07-01	GLD	ETF	167.05	167.06	165.34	166.62	13214800.0
2020-07-01	TLT	ETF	162.81	163.56	162.15	163.42	13181000.0
2020-07-01	AAAU	ETF	17.73	17.73	17.54	17.68	468100.0
2020-07-01	AADR	ETF	53.03	53.38	53.03	53.38	3900.0
2020-07-01	AAXJ	ETF	69.64	70.18	69.56	69.88	743400.0
2020-07-01	ABEQ	ETF	22.33	22.344	22.26	22.288	3100.0
2020-07-01	ACES	ETF	39.83	39.83	39.22	39.334	48200.0
2020-07-01	ACIO	ETF	25.28	25.37	25.274	25.274	2100.0
2020-07-01	ACSI	ETF	33.94	33.94	33.8	33.8	1341.0
2020-07-01	ACTX	ETF	3.304	3.304	3.304	3.304	56.0
2020-07-01	ACWF	ETF	27.89	27.97	27.8	27.8479	58424.0
2020-07-01	ACWI	ETF	73.95	74.51	73.89	74.27	2135500.0
2020-07-01	ACWV	ETF	87.73	88.14	87.6	87.94	182700.0
2020-07-01	ACWX	ETF	43.28	43.59	43.245	43.48	1860693.0
2020-07-01	ADME	ETF	32.08	32.48	32.08	32.368	1500.0
2020-07-01	ADRE	ETF	39.855	40.0	39.796	39.875	4283.0
2020-07-01	AESR	ETF	9.97	10.027	9.97	10.021	3800.0
2020-07-01	AFIF	ETF	9.97	9.97	9.8101	9.82	6944.0
2020-07-01	AFK	ETF	16.35	16.6	16.35	16.48	5158.0
2020-07-01	AFLG	ETF	18.9	18.9	18.874	18.874	100.0
2020-07-01	AFMC	ETF	16.92	16.92	16.814	16.814	200.0
2020-07-01	AFSM	ETF	16.79	16.79	16.657	16.657	100.0
2020-07-01	AFTY	ETF	17.16	17.239	17.16	17.239	1600.0
2020-07-01	AGG	ETF	117.9	118.07	117.76	118.05	6746500.0
2020-07-01	AGGY	ETF	53.73	53.84	53.65	53.78	270000.0
2020-07-01	AGNG	ETF	24.62	24.62	24.58	24.61	2500.0
2020-07-01	AGQ	ETF	29.47	29.47	27.85	28.57	1492600.0
2020-07-01	AGZ	ETF	120.91	120.91	120.77	120.89	38564.0
2020-07-01	AGZD	ETF	23.575	23.605	23.495	23.555	27600.0
2020-07-01	AIA	ETF	65.27	65.73	65.25	65.56	149719.0
2020-07-01	AIEQ	ETF	28.24	28.55	28.15	28.54	31200.0
2020-07-01	AIQ	ETF	20.63	20.9499	20.63	20.8881	13369.0
2020-07-01	AIRR	ETF	24.045	24.06	23.54	23.54	4000.0
2020-07-01	AIVI	ETF	35.41	35.63	35.41	35.6	4600.0
2020-07-01	ALTL	ETF	24.74	24.74	23.8666	23.8666	14736.0
2020-07-01	ALTY	ETF	10.76	10.85	10.72	10.82	35100.0
2020-07-01	AMJ	ETF	13.22	13.52	12.99	13.23	734735.0
2020-07-01	AMLP	ETF	24.68	25.14	24.07	24.41	3641200.0
2020-07-01	AMNA	ETF	23.7119	23.7119	23.7119	23.7119	0.0
2020-07-01	AMOM	ETF	29.9	30.154	29.9	30.154	800.0
2020-07-01	AMUB	ETF	8.45	8.45	8.19	8.2797	8754.0
2020-07-01	AMZA	ETF	17.44	17.988	16.891	17.29	56500.0
2020-07-01	ANGL	ETF	28.73	28.73	28.54	28.6	551100.0
2020-07-01	AOA	ETF	54.92	55.2	54.92	55.0	111500.0
2020-07-01	AOK	ETF	36.37	36.46	36.33	36.46	115767.0
2020-07-01	AOM	ETF	39.88	40.0443	39.8488	40.0	209305.0

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

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