PREVIEW / etf_daily / 2020-05-07

all etf daily files

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

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-07	SPY	ETF	287.75	289.78	287.13	287.68	75250400.0
2020-05-07	QQQ	ETF	221.75	222.73	220.42	221.82	38624836.0
2020-05-07	IWM	ETF	127.39	128.5	126.55	127.44	27493000.0
2020-05-07	DIA	ETF	239.24	241.18	238.55	238.91	3411500.0
2020-05-07	GLD	ETF	159.5	161.96	159.36	161.39	13691700.0
2020-05-07	TLT	ETF	163.56	166.37	163.34	166.14	9164800.0
2020-05-07	AAAU	ETF	16.92	17.17	16.9	17.11	295700.0
2020-05-07	AADR	ETF	46.32	46.8	46.06	46.63	5500.0
2020-05-07	AAXJ	ETF	63.41	63.53	63.06	63.4	860500.0
2020-05-07	ABEQ	ETF	21.82	21.87	21.748	21.748	800.0
2020-05-07	ACES	ETF	33.6	33.85	33.355	33.79	24100.0
2020-05-07	ACIO	ETF	23.96	24.01	23.9	23.9	12900.0
2020-05-07	ACSI	ETF	30.35	30.35	30.303	30.303	523.0
2020-05-07	ACTX	ETF	5.8912	5.9001	4.248	5.3041	807.0
2020-05-07	ACWF	ETF	26.03	26.15	26.03	26.11	18985.0
2020-05-07	ACWI	ETF	68.09	68.53	67.94	68.13	3227300.0
2020-05-07	ACWV	ETF	85.41	86.15	85.38	85.64	473400.0
2020-05-07	ACWX	ETF	39.56	39.74	39.38	39.55	1768927.0
2020-05-07	ADME	ETF	30.41	30.48	30.41	30.47	2700.0
2020-05-07	ADRE	ETF	35.21	35.34	35.0112	35.2278	5148.0
2020-05-07	AESR	ETF	9.245	9.28	9.208	9.208	40200.0
2020-05-07	AFIF	ETF	9.83	9.83	9.8	9.8	23297.0
2020-05-07	AFK	ETF	14.92	14.937	14.89	14.9	2985.0
2020-05-07	AFMC	ETF	15.64	15.73	15.64	15.641	400.0
2020-05-07	AFTY	ETF	15.91	15.927	15.86	15.927	1800.0
2020-05-07	AGG	ETF	116.61	116.77	116.42	116.77	3786700.0
2020-05-07	AGGY	ETF	52.78	53.1	52.74	52.9	173600.0
2020-05-07	AGNG	ETF	22.97	23.05	22.86	22.87	14800.0
2020-05-07	AGQ	ETF	20.53	21.76	20.45	21.41	528700.0
2020-05-07	AGZ	ETF	120.6	120.8	120.31	120.8	40825.0
2020-05-07	AGZD	ETF	23.16	23.325	23.16	23.26	4600.0
2020-05-07	AIA	ETF	58.85	59.14	58.75	58.97	47564.0
2020-05-07	AIEQ	ETF	26.02	26.27	26.0	26.07	18500.0
2020-05-07	AIQ	ETF	18.05	18.3499	18.05	18.24	33372.0
2020-05-07	AIRR	ETF	20.92	20.96	20.72	20.817	4700.0
2020-05-07	AIVI	ETF	32.69	32.88	32.65	32.73	7400.0
2020-05-07	ALTY	ETF	9.68	9.965	9.68	9.798	3600.0
2020-05-07	AMJ	ETF	13.25	13.33	12.81	12.85	1206106.0
2020-05-07	AMLP	ETF	24.15	24.3	23.3	23.45	4782000.0
2020-05-07	AMOM	ETF	26.914	26.95	26.833	26.833	1200.0
2020-05-07	AMUB	ETF	8.24	8.29	8.0854	8.0854	2993.0
2020-05-07	AMZA	ETF	17.0	17.24	16.47	16.54	101300.0
2020-05-07	ANGL	ETF	26.94	27.08	26.7	26.84	1160000.0
2020-05-07	AOA	ETF	50.86	51.09	50.76	50.82	45200.0
2020-05-07	AOK	ETF	34.85	35.05	34.85	35.0	142157.0
2020-05-07	AOM	ETF	38.02	38.18	37.96	38.07	232684.0
2020-05-07	AOR	ETF	43.51	43.8225	43.51	43.6	193368.0
2020-05-07	ARB	ETF	25.12	25.12	25.0585	25.1178	101460.0
2020-05-07	ARCM	ETF	100.07	100.765	100.07	100.765	400.0
2020-05-07	ARGT	ETF	19.15	19.93	19.15	19.75	137000.0

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

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