PREVIEW / etf_daily / 2020-04-14

all etf daily files

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

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-14	SPY	ETF	280.98	284.9	275.51	283.79	134143400.0
2020-04-14	QQQ	ETF	207.17	212.5	206.42	211.86	63959563.0
2020-04-14	IWM	ETF	123.9	124.88	121.3	122.81	35089700.0
2020-04-14	DIA	ETF	238.7	240.47	236.88	239.68	5391900.0
2020-04-14	GLD	ETF	162.73	164.42	161.78	162.68	17095100.0
2020-04-14	TLT	ETF	163.84	164.74	163.48	163.84	9019100.0
2020-04-14	AAAU	ETF	17.34	17.43	17.02	17.25	536400.0
2020-04-14	AADR	ETF	44.55	45.01	44.25	44.57	6600.0
2020-04-14	AAXJ	ETF	62.98	63.42	62.79	63.1	1644800.0
2020-04-14	ABEQ	ETF	21.87	21.87	21.4	21.718	19200.0
2020-04-14	ACES	ETF	32.03	32.73	31.652	32.2	37000.0
2020-04-14	ACIO	ETF	23.59	23.91	23.59	23.747	9500.0
2020-04-14	ACSI	ETF	30.13	30.65	30.13	30.65	354.0
2020-04-14	ACTX	ETF	3.835	5.8411	3.835	4.779	756.0
2020-04-14	ACWF	ETF	26.0	26.154	25.9696	26.11	6870.0
2020-04-14	ACWI	ETF	66.92	67.63	66.79	67.41	3172500.0
2020-04-14	ACWV	ETF	86.52	87.35	86.37	87.01	610400.0
2020-04-14	ACWX	ETF	39.54	39.84	39.43	39.54	2190830.0
2020-04-14	ADME	ETF	29.83	30.17	29.791	29.87	10900.0
2020-04-14	ADRE	ETF	35.59	36.0321	35.55	35.6262	3926.0
2020-04-14	AESR	ETF	9.03	9.106	9.03	9.106	73400.0
2020-04-14	AFIF	ETF	9.81	9.83	9.725	9.775	317264.0
2020-04-14	AFK	ETF	14.42	14.635	14.2	14.39	12816.0
2020-04-14	AFLG	ETF	17.32	17.328	17.3	17.328	39900.0
2020-04-14	AFMC	ETF	15.462	15.462	15.33	15.347	8100.0
2020-04-14	AFSM	ETF	14.79	14.79	14.785	14.785	6600.0
2020-04-14	AFTY	ETF	15.42	15.57	15.42	15.545	1500.0
2020-04-14	AGG	ETF	116.99	117.0	116.59	116.76	5506700.0
2020-04-14	AGGY	ETF	53.17	53.23	52.472	53.2	452900.0
2020-04-14	AGNG	ETF	21.87	22.038	21.75	22.01	2800.0
2020-04-14	AGQ	ETF	23.55	24.25	23.12	23.41	343500.0
2020-04-14	AGZ	ETF	120.37	120.37	119.845	120.11	81293.0
2020-04-14	AGZD	ETF	23.52	23.6	23.4	23.5	19800.0
2020-04-14	AIA	ETF	58.72	59.0	58.53	58.87	292697.0
2020-04-14	AIEQ	ETF	24.0	24.621	24.0	24.46	33600.0
2020-04-14	AIQ	ETF	16.72	17.2	16.72	17.2	117088.0
2020-04-14	AIRR	ETF	21.44	21.56	20.99	21.234	46400.0
2020-04-14	AIVI	ETF	33.09	33.26	32.92	33.01	16900.0
2020-04-14	ALTY	ETF	10.08	10.08	9.8	9.93	8900.0
2020-04-14	AMJ	ETF	10.45	10.95	10.45	10.86	2824300.0
2020-04-14	AMLP	ETF	20.2	20.85	19.9	20.7	5933120.0
2020-04-14	AMUB	ETF	6.8251	6.8305	6.8251	6.8305	199.0
2020-04-14	AMZA	ETF	13.65	14.1	13.45	13.94	115800.0
2020-04-14	ANGL	ETF	27.44	27.63	27.0	27.44	5299900.0
2020-04-14	AOA	ETF	50.18	50.59	50.14	50.54	91000.0
2020-04-14	AOK	ETF	34.78	34.99	34.78	34.96	112160.0
2020-04-14	AOM	ETF	37.84	37.99	37.69	37.87	260209.0
2020-04-14	AOR	ETF	43.14	43.427	43.085	43.39	175151.0
2020-04-14	ARGT	ETF	17.52	17.68	17.36	17.59	96400.0
2020-04-14	ARKF	ETF	22.47	22.76	22.334	22.69	116900.0

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

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