PREVIEW / etf_daily / 2019-03-15

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-15.parquet
  size:    68 KB
  rows:    1,761

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
2019-03-15	SPY	ETF	280.54	282.21	280.33	281.31	81309000.0
2019-03-15	QQQ	ETF	177.43	178.88	177.28	178.35	38191958.0
2019-03-15	IWM	ETF	154.53	155.87	154.33	154.76	22025900.0
2019-03-15	DIA	ETF	257.58	259.15	256.33	258.34	4225100.0
2019-03-15	GLD	ETF	123.06	123.4	122.91	122.97	9412000.0
2019-03-15	TLT	ETF	121.74	121.95	121.4	121.75	4302000.0
2019-03-15	AAAU	ETF	13.02	13.02	13.0	13.01	10700.0
2019-03-15	AADR	ETF	45.9	45.96	45.67	45.88	15200.0
2019-03-15	AAXJ	ETF	70.06	70.39	69.98	70.33	776600.0
2019-03-15	ACES	ETF	27.33	27.52	27.204	27.204	10400.0
2019-03-15	ACSI	ETF	32.5201	32.5734	32.5201	32.5734	739.0
2019-03-15	ACTX	ETF	53.1005	53.1005	50.1505	51.3305	645.0
2019-03-15	ACWF	ETF	29.15	29.25	29.1199	29.15	5887.0
2019-03-15	ACWI	ETF	71.81	72.19	71.78	72.06	3079900.0
2019-03-15	ACWV	ETF	88.32	88.65	88.31	88.52	172100.0
2019-03-15	ACWX	ETF	46.27	46.51	46.27	46.47	1754061.0
2019-03-15	ADRE	ETF	41.23	41.3762	41.23	41.3597	2330.0
2019-03-15	AFIF	ETF	10.0	10.04	10.0	10.02	20455.0
2019-03-15	AFK	ETF	21.75	21.75	21.601	21.605	1210.0
2019-03-15	AFTY	ETF	16.36	16.4	16.346	16.36	9300.0
2019-03-15	AGG	ETF	107.65	107.74	107.57	107.7	2756900.0
2019-03-15	AGGY	ETF	49.19	49.26	49.16	49.19	197500.0
2019-03-15	AGNG	ETF	21.6	21.865	21.6	21.865	3600.0
2019-03-15	AGQ	ETF	25.3	25.44	25.1	25.12	154000.0
2019-03-15	AGZ	ETF	112.55	112.65	112.5401	112.65	13972.0
2019-03-15	AGZD	ETF	23.84	23.91	23.84	23.875	5000.0
2019-03-15	AIA	ETF	60.88	61.295	60.88	61.22	51130.0
2019-03-15	AIEQ	ETF	25.9	26.04	25.9	25.92	74400.0
2019-03-15	AIQ	ETF	15.5	15.64	15.5	15.56	10918.0
2019-03-15	AIRR	ETF	24.81	25.117	24.81	24.92	10800.0
2019-03-15	AIVI	ETF	41.55	41.64	41.55	41.6	10900.0
2019-03-15	ALTY	ETF	14.74	14.76	14.732	14.75	3400.0
2019-03-15	AMJ	ETF	25.1	25.15	24.88	25.08	837103.0
2019-03-15	AMLP	ETF	49.45	49.55	49.0	49.45	2638720.0
2019-03-15	AMUB	ETF	15.8	15.8	15.7658	15.7658	201.0
2019-03-15	AMZA	ETF	59.4	59.8	59.2	59.6	56060.0
2019-03-15	ANGL	ETF	28.47	28.55	28.47	28.55	247000.0
2019-03-15	AOA	ETF	53.25	53.46	53.25	53.35	40800.0
2019-03-15	AOK	ETF	34.13	34.24	34.13	34.24	32034.0
2019-03-15	AOM	ETF	37.74	37.82	37.7315	37.79	100551.0
2019-03-15	AOR	ETF	44.43	44.56	44.4199	44.54	50810.0
2019-03-15	ARGT	ETF	28.2	28.5	28.14	28.48	21800.0
2019-03-15	ARKF	ETF	21.29	21.405	21.27	21.326	13300.0
2019-03-15	ARKG	ETF	32.36	32.94	32.244	32.79	234900.0
2019-03-15	ARKK	ETF	46.77	47.259	46.6	46.99	388400.0
2019-03-15	ARKQ	ETF	34.34	34.34	33.9	33.9	33900.0
2019-03-15	ARKW	ETF	51.54	51.79	51.37	51.52	51900.0
2019-03-15	ASEA	ETF	15.84	15.96	15.84	15.96	2400.0
2019-03-15	ASET	ETF	28.81	28.8905	28.81	28.8135	3305.0
2019-03-15	ASHR	ETF	27.98	28.15	27.92	28.11	4900900.0

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

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