PREVIEW / etf_daily / 2018-11-07

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-07.parquet
  size:    64 KB
  rows:    1,669

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
2018-11-07	SPY	ETF	277.56	281.1	277.08	281.01	102752100.0
2018-11-07	QQQ	ETF	172.25	175.58	171.87	175.58	51169614.0
2018-11-07	IWM	ETF	155.36	157.41	154.8	157.41	22127800.0
2018-11-07	DIA	ETF	258.46	261.86	257.5	261.78	4462300.0
2018-11-07	GLD	ETF	116.26	116.35	115.9	116.03	8392100.0
2018-11-07	TLT	ETF	113.19	113.4	112.41	112.52	9313100.0
2018-11-07	AAAU	ETF	12.28	12.29	12.26	12.27	10100.0
2018-11-07	AADR	ETF	47.98	48.48	47.62	48.48	27700.0
2018-11-07	AAXJ	ETF	66.27	66.92	66.05	66.87	685200.0
2018-11-07	ACSI	ETF	33.14	33.33	33.0999	33.33	5736.0
2018-11-07	ACTX	ETF	94.4008	94.4008	82.0107	90.2708	1508.0
2018-11-07	ACWF	ETF	29.01	29.35	29.01	29.3407	6243.0
2018-11-07	ACWI	ETF	70.69	71.37	70.54	71.36	1902000.0
2018-11-07	ACWV	ETF	85.66	86.22	85.4	86.19	410500.0
2018-11-07	ACWX	ETF	45.37	45.61	45.23	45.61	1576314.0
2018-11-07	ADRE	ETF	38.65	38.9725	38.65	38.94	4272.0
2018-11-07	AFIF	ETF	10.04	10.0798	10.02	10.0683	11620.0
2018-11-07	AFK	ETF	20.96	21.2373	20.87	21.205	3204.0
2018-11-07	AFTY	ETF	14.76	14.76	14.575	14.71	4400.0
2018-11-07	AGG	ETF	104.25	104.36	104.14	104.2	4677200.0
2018-11-07	AGGY	ETF	47.58	47.63	47.484	47.484	193000.0
2018-11-07	AGNG	ETF	20.581	20.751	20.581	20.751	4800.0
2018-11-07	AGQ	ETF	23.89	23.97	23.64	23.68	43800.0
2018-11-07	AGZ	ETF	110.115	110.16	109.95	109.9514	9389.0
2018-11-07	AGZD	ETF	23.835	23.885	23.79	23.855	19200.0
2018-11-07	AIA	ETF	58.03	58.59	57.82	58.57	84354.0
2018-11-07	AIEQ	ETF	27.22	27.6	27.22	27.6	93000.0
2018-11-07	AIQ	ETF	14.22	14.5	14.22	14.5	21102.0
2018-11-07	AIRR	ETF	25.91	26.27	25.73	26.26	12200.0
2018-11-07	AIVI	ETF	40.73	40.88	40.68	40.88	9100.0
2018-11-07	ALTY	ETF	14.64	14.69	14.614	14.69	4000.0
2018-11-07	AMJ	ETF	26.08	26.46	26.01	26.19	1361599.0
2018-11-07	AMLP	ETF	50.8	51.6	50.65	51.0	4173560.0
2018-11-07	AMZA	ETF	65.1	67.0	65.0	66.4	99740.0
2018-11-07	ANGL	ETF	28.25	28.28	28.16	28.25	3604800.0
2018-11-07	AOA	ETF	52.34	52.66	52.2	52.65	45900.0
2018-11-07	AOK	ETF	33.36	33.479	33.3401	33.46	270955.0
2018-11-07	AOM	ETF	36.82	36.94	36.7602	36.93	150230.0
2018-11-07	AOR	ETF	43.48	43.73	43.42	43.67	175185.0
2018-11-07	ARCM	ETF	99.994	99.994	99.994	99.994	100.0
2018-11-07	ARGT	ETF	26.79	26.8	26.34	26.64	64100.0
2018-11-07	ARKG	ETF	30.27	30.85	30.04	30.74	259000.0
2018-11-07	ARKK	ETF	45.34	46.065	45.0	45.96	472400.0
2018-11-07	ARKQ	ETF	34.31	34.76	34.256	34.71	18300.0
2018-11-07	ARKW	ETF	55.06	56.27	55.0	56.121	201200.0
2018-11-07	ARVR	ETF	19.09	19.09	19.09	19.09	223.0
2018-11-07	ASEA	ETF	16.03	16.03	15.83	15.83	23900.0
2018-11-07	ASET	ETF	27.1	27.19	27.1	27.19	200.0
2018-11-07	ASHR	ETF	23.88	24.01	23.74	24.01	1855400.0
2018-11-07	ASHS	ETF	23.56	23.79	23.56	23.79	11100.0

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

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