PREVIEW / etf_daily / 2019-02-12

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-12.parquet
  size:    67 KB
  rows:    1,745

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-02-12	SPY	ETF	272.42	274.52	272.34	274.1	72270200.0
2019-02-12	QQQ	ETF	169.59	171.14	169.33	170.89	29722073.0
2019-02-12	IWM	ETF	151.92	153.19	151.88	152.99	20779900.0
2019-02-12	DIA	ETF	252.72	254.88	252.67	254.53	3080600.0
2019-02-12	GLD	ETF	123.96	124.03	123.61	123.86	4271900.0
2019-02-12	TLT	ETF	121.66	121.75	121.2	121.56	7939600.0
2019-02-12	AAAU	ETF	13.11	13.11	13.08	13.1	35000.0
2019-02-12	AADR	ETF	44.21	44.62	44.21	44.61	13500.0
2019-02-12	AAXJ	ETF	68.65	68.83	68.55	68.7	1184800.0
2019-02-12	ACES	ETF	26.19	26.2	26.128	26.128	5100.0
2019-02-12	ACSI	ETF	32.0101	32.15	32.0101	32.1386	1240.0
2019-02-12	ACTX	ETF	46.0204	47.2004	44.8404	45.4304	691.0
2019-02-12	ACWF	ETF	28.54	28.77	28.54	28.74	18205.0
2019-02-12	ACWI	ETF	69.45	69.87	69.45	69.79	2141700.0
2019-02-12	ACWV	ETF	86.04	86.24	85.83	86.08	112200.0
2019-02-12	ACWX	ETF	44.87	45.01	44.85	44.95	1941397.0
2019-02-12	ADRE	ETF	39.69	39.91	39.69	39.7901	1492.0
2019-02-12	AFIF	ETF	9.96	10.01	9.96	10.0	14987.0
2019-02-12	AFK	ETF	21.6	22.05	21.6	21.9423	15021.0
2019-02-12	AFTY	ETF	14.947	14.97	14.91	14.931	61100.0
2019-02-12	AGG	ETF	107.22	107.26	107.12	107.25	3136700.0
2019-02-12	AGGY	ETF	48.97	49.09	48.88	48.98	1404900.0
2019-02-12	AGNG	ETF	21.0	21.256	21.0	21.13	3600.0
2019-02-12	AGQ	ETF	26.89	26.94	26.73	26.84	59400.0
2019-02-12	AGZ	ETF	112.18	112.18	112.0994	112.1241	12652.0
2019-02-12	AGZD	ETF	23.88	23.88	23.78	23.78	6800.0
2019-02-12	AIA	ETF	60.29	60.35	60.13	60.2	110217.0
2019-02-12	AIEQ	ETF	25.15	25.35	25.15	25.28	30700.0
2019-02-12	AIQ	ETF	14.94	15.05	14.94	15.05	10072.0
2019-02-12	AIRR	ETF	24.21	24.537	24.21	24.46	31600.0
2019-02-12	AIVI	ETF	40.01	40.08	39.92	40.05	8300.0
2019-02-12	ALTY	ETF	14.75	14.75	14.62	14.665	3200.0
2019-02-12	AMJ	ETF	24.66	24.99	24.655	24.95	1769004.0
2019-02-12	AMLP	ETF	48.75	49.25	48.55	49.05	3667580.0
2019-02-12	AMUB	ETF	15.68	15.68	15.6707	15.6707	200.0
2019-02-12	AMZA	ETF	57.9	58.4	57.5	58.3	56160.0
2019-02-12	ANGL	ETF	28.23	28.34	28.23	28.27	149600.0
2019-02-12	AOA	ETF	51.81	52.06	51.81	51.98	139700.0
2019-02-12	AOK	ETF	33.72	33.77	33.7	33.76	178105.0
2019-02-12	AOM	ETF	37.1	37.1535	37.06	37.13	180839.0
2019-02-12	AOR	ETF	43.42	43.59	43.42	43.59	128419.0
2019-02-12	ARGT	ETF	27.86	28.06	27.78	27.98	89200.0
2019-02-12	ARKF	ETF	20.43	20.58	20.4	20.575	24900.0
2019-02-12	ARKG	ETF	28.46	28.546	28.219	28.54	160100.0
2019-02-12	ARKK	ETF	43.77	44.29	43.58	44.25	314400.0
2019-02-12	ARKQ	ETF	33.81	34.41	33.81	34.375	17400.0
2019-02-12	ARKW	ETF	50.02	50.52	49.83	50.47	86800.0
2019-02-12	ASEA	ETF	16.0	16.06	15.89	16.06	67400.0
2019-02-12	ASET	ETF	27.82	27.8327	27.82	27.8327	837.0
2019-02-12	ASHR	ETF	24.62	24.68	24.53	24.66	3113300.0

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

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