PREVIEW / etf_daily / 2020-05-18

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-18.parquet
  size:    75 KB
  rows:    2,009

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-18	SPY	ETF	293.05	296.75	292.7	295.0	119703800.0
2020-05-18	QQQ	ETF	226.28	228.68	225.47	227.43	42597551.0
2020-05-18	IWM	ETF	131.45	133.39	130.83	132.68	46981100.0
2020-05-18	DIA	ETF	243.51	247.2	243.36	245.93	5207700.0
2020-05-18	GLD	ETF	164.33	164.5	162.41	162.69	14133800.0
2020-05-18	TLT	ETF	164.93	165.06	162.42	163.05	10073100.0
2020-05-18	AAAU	ETF	17.44	17.44	17.23	17.25	552200.0
2020-05-18	AADR	ETF	47.52	47.62	47.39	47.47	3600.0
2020-05-18	AAXJ	ETF	64.47	65.53	64.47	65.34	1282100.0
2020-05-18	ABEQ	ETF	22.03	22.095	21.924	22.095	11000.0
2020-05-18	ACES	ETF	34.07	35.36	34.07	35.27	34800.0
2020-05-18	ACIO	ETF	24.14	24.33	24.14	24.33	3700.0
2020-05-18	ACSI	ETF	31.1	31.3755	31.1	31.3755	633.0
2020-05-18	ACTX	ETF	4.1359	5.5283	4.13	4.13	417.0
2020-05-18	ACWF	ETF	26.39	26.8347	26.39	26.8347	2394.0
2020-05-18	ACWI	ETF	69.31	70.33	69.31	70.04	2832900.0
2020-05-18	ACWV	ETF	86.57	87.35	86.48	87.04	448100.0
2020-05-18	ACWX	ETF	40.09	40.79	40.09	40.68	4626374.0
2020-05-18	ADME	ETF	31.25	31.39	31.25	31.3	15400.0
2020-05-18	ADRE	ETF	36.04	36.89	36.04	36.7837	9261.0
2020-05-18	AESR	ETF	9.415	9.452	9.415	9.452	6000.0
2020-05-18	AFIF	ETF	9.85	9.85	9.75	9.76	15709.0
2020-05-18	AFK	ETF	14.8	15.02	14.8	15.0	11554.0
2020-05-18	AFMC	ETF	15.72	16.132	15.72	16.132	200.0
2020-05-18	AFSM	ETF	15.35	15.79	15.35	15.79	200.0
2020-05-18	AFTY	ETF	15.989	16.08	15.95	16.064	7800.0
2020-05-18	AGG	ETF	116.97	117.09	116.66	116.86	5037100.0
2020-05-18	AGGY	ETF	53.08	53.08	52.87	52.97	116900.0
2020-05-18	AGNG	ETF	23.6	23.7	23.591	23.607	1700.0
2020-05-18	AGQ	ETF	26.64	27.07	26.06	26.31	828600.0
2020-05-18	AGZ	ETF	121.01	121.0399	120.77	120.86	58322.0
2020-05-18	AGZD	ETF	23.08	23.175	23.08	23.16	23000.0
2020-05-18	AIA	ETF	59.36	60.36	59.36	60.24	24414.0
2020-05-18	AIEQ	ETF	27.18	27.33	27.04	27.116	28200.0
2020-05-18	AIQ	ETF	18.8	18.93	18.705	18.92	14065.0
2020-05-18	AIRR	ETF	20.55	21.6	20.55	21.6	8900.0
2020-05-18	AIVI	ETF	33.27	33.89	33.27	33.86	14100.0
2020-05-18	ALTY	ETF	9.77	10.14	9.77	10.1	11600.0
2020-05-18	AMJ	ETF	13.51	14.2	13.51	13.93	1836153.0
2020-05-18	AMLP	ETF	24.89	25.85	24.82	25.34	8691700.0
2020-05-18	AMOM	ETF	27.675	27.675	27.675	27.675	100.0
2020-05-18	AMUB	ETF	8.77	8.8395	8.77	8.8163	10840.0
2020-05-18	AMZA	ETF	18.12	19.105	18.12	18.86	209300.0
2020-05-18	ANGL	ETF	27.01	27.11	26.9	27.04	910700.0
2020-05-18	AOA	ETF	51.43	52.15	51.35	52.03	93200.0
2020-05-18	AOK	ETF	35.27	35.35	35.19	35.3	236684.0
2020-05-18	AOM	ETF	38.27	38.5941	38.27	38.54	492214.0
2020-05-18	AOR	ETF	43.97	44.45	43.97	44.37	205185.0
2020-05-18	ARB	ETF	24.6699	24.6699	24.46	24.4842	2913.0
2020-05-18	ARCM	ETF	100.14	100.555	100.135	100.555	300.0

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

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