PREVIEW / etf_daily / 2020-05-06

all etf daily files

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

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-06	SPY	ETF	288.04	288.46	283.78	284.25	73632600.0
2020-05-06	QQQ	ETF	219.37	221.04	218.11	219.0	36455218.0
2020-05-06	IWM	ETF	127.49	128.2	125.0	125.72	29836800.0
2020-05-06	DIA	ETF	240.34	240.54	236.6	236.86	3082300.0
2020-05-06	GLD	ETF	158.99	159.81	158.1	158.95	13352000.0
2020-05-06	TLT	ETF	163.23	163.64	162.05	163.41	14721500.0
2020-05-06	AAAU	ETF	16.88	16.93	16.77	16.84	237600.0
2020-05-06	AADR	ETF	46.05	46.41	45.92	45.99	1200.0
2020-05-06	AAXJ	ETF	63.35	63.39	62.73	62.81	2109800.0
2020-05-06	ABEQ	ETF	21.6	21.68	21.52	21.52	4900.0
2020-05-06	ACES	ETF	33.05	33.6	32.85	33.22	34200.0
2020-05-06	ACIO	ETF	24.35	24.35	23.841	23.841	33000.0
2020-05-06	ACSI	ETF	30.0353	30.0353	29.8669	29.8669	300.0
2020-05-06	ACTX	ETF	5.31	5.31	4.248	5.31	236.0
2020-05-06	ACWF	ETF	26.19	26.24	25.7502	25.7502	5632.0
2020-05-06	ACWI	ETF	68.16	68.18	67.24	67.24	2618000.0
2020-05-06	ACWV	ETF	86.03	86.28	84.71	84.71	334300.0
2020-05-06	ACWX	ETF	39.53	39.57	39.05	39.06	2211341.0
2020-05-06	ADME	ETF	30.53	30.53	30.24	30.26	31000.0
2020-05-06	ADRE	ETF	35.27	35.35	35.0735	35.0735	4365.0
2020-05-06	AESR	ETF	9.195	9.33	9.153	9.153	27500.0
2020-05-06	AFIF	ETF	9.755	9.98	9.73	9.74	108471.0
2020-05-06	AFK	ETF	14.72	14.98	14.72	14.76	25659.0
2020-05-06	AFLG	ETF	17.53	17.53	17.441	17.441	7300.0
2020-05-06	AFMC	ETF	15.47	15.47	15.433	15.433	1900.0
2020-05-06	AFSM	ETF	15.01	15.01	14.946	14.946	1500.0
2020-05-06	AFTY	ETF	15.73	15.76	15.69	15.715	1900.0
2020-05-06	AGG	ETF	116.44	116.71	116.3	116.41	6394900.0
2020-05-06	AGGY	ETF	52.74	52.83	52.73	52.78	91900.0
2020-05-06	AGNG	ETF	22.72	22.82	22.549	22.549	1100.0
2020-05-06	AGQ	ETF	20.23	20.34	19.95	20.06	196800.0
2020-05-06	AGZ	ETF	121.32	121.32	120.231	120.5	50131.0
2020-05-06	AGZD	ETF	23.2	23.44	23.19	23.215	7200.0
2020-05-06	AIA	ETF	58.91	59.07	58.46	58.46	214959.0
2020-05-06	AIEQ	ETF	25.75	26.0	25.643	25.65	16700.0
2020-05-06	AIQ	ETF	17.8	18.0	17.75	17.9	33970.0
2020-05-06	AIRR	ETF	20.725	20.785	20.374	20.374	29300.0
2020-05-06	AIVI	ETF	32.89	32.89	32.46	32.46	3600.0
2020-05-06	ALTY	ETF	9.64	9.699	9.63	9.674	5300.0
2020-05-06	AMJ	ETF	13.25	13.515	12.73	12.91	1259949.0
2020-05-06	AMLP	ETF	25.1	25.4	23.9	24.25	3719960.0
2020-05-06	AMUB	ETF	8.63	8.63	8.025	8.0916	9302.0
2020-05-06	AMZA	ETF	17.25	17.532	16.2	16.47	70600.0
2020-05-06	ANGL	ETF	26.97	27.16	26.63	26.7	1433000.0
2020-05-06	AOA	ETF	50.76	50.88	50.29	50.31	64800.0
2020-05-06	AOK	ETF	34.96	34.99	34.75	34.77	93347.0
2020-05-06	AOM	ETF	38.01	38.14	37.75	37.8	227112.0
2020-05-06	AOR	ETF	43.59	43.65	43.25	43.25	164720.0
2020-05-06	ARGT	ETF	18.85	19.33	18.81	19.08	311500.0
2020-05-06	ARKF	ETF	24.59	24.777	24.45	24.52	76200.0

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

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