PREVIEW / etf_daily / 2016-09-06

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-06.parquet
  size:    52 KB
  rows:    1,312

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
2016-09-06	SPY	ETF	218.7	219.12	217.86	219.03	56702100.0
2016-09-06	QQQ	ETF	117.29	117.85	117.06	117.85	18525231.0
2016-09-06	IWM	ETF	124.92	124.97	123.97	124.63	13711000.0
2016-09-06	DIA	ETF	185.11	185.49	184.45	185.32	2152300.0
2016-09-06	GLD	ETF	127.4	129.08	127.27	128.71	15115300.0
2016-09-06	TLT	ETF	138.71	140.08	138.51	139.64	8542600.0
2016-09-06	AADR	ETF	40.9	40.93	40.71	40.91	7900.0
2016-09-06	AAXJ	ETF	60.66	61.13	60.63	61.02	2174500.0
2016-09-06	ACTX	ETF	2.95	2.95	2.891	2.891	858.0
2016-09-06	ACWF	ETF	24.4299	24.4299	24.4299	24.4299	275.0
2016-09-06	ACWI	ETF	59.36	59.63	59.31	59.63	2453100.0
2016-09-06	ACWV	ETF	76.87	77.27	76.77	77.27	350900.0
2016-09-06	ACWX	ETF	41.82	42.1	41.82	42.08	448831.0
2016-09-06	ADRE	ETF	34.96	35.3962	34.96	35.3904	24891.0
2016-09-06	AFK	ETF	20.46	21.38	20.287	21.18	24179.0
2016-09-06	AFTY	ETF	13.74	13.74	13.711	13.711	1600.0
2016-09-06	AGG	ETF	112.36	112.68	112.29	112.55	3745800.0
2016-09-06	AGGY	ETF	52.08	52.26	52.065	52.198	16400.0
2016-09-06	AGQ	ETF	50.8	53.35	50.66	52.98	503000.0
2016-09-06	AGZ	ETF	115.19	115.84	115.19	115.657	8448.0
2016-09-06	AGZD	ETF	23.885	23.965	23.86	23.915	7200.0
2016-09-06	AIA	ETF	49.98	50.349	49.98	50.3209	37105.0
2016-09-06	AIQ	ETF	6.33	6.46	6.33	6.41	16672.0
2016-09-06	AIRR	ETF	20.1	20.368	20.058	20.08	7400.0
2016-09-06	AIVI	ETF	39.54	39.75	39.44	39.67	11100.0
2016-09-06	ALTY	ETF	15.8	15.9	15.747	15.9	9600.0
2016-09-06	AMJ	ETF	31.44	31.67	31.33	31.57	1220923.0
2016-09-06	AMLP	ETF	62.85	63.65	62.85	63.5	1245160.0
2016-09-06	AMZA	ETF	116.2	117.4	116.2	116.7	19990.0
2016-09-06	ANGL	ETF	28.72	28.72	28.64	28.69	260400.0
2016-09-06	AOA	ETF	47.71	47.85	47.68	47.84	24900.0
2016-09-06	AOK	ETF	33.43	33.57	33.3985	33.51	29952.0
2016-09-06	AOM	ETF	36.17	36.26	36.0801	36.22	33732.0
2016-09-06	AOR	ETF	41.16	41.37	41.16	41.36	112816.0
2016-09-06	ARGT	ETF	23.08	23.32	23.04	23.26	59300.0
2016-09-06	ARKG	ETF	18.59	18.715	18.59	18.7	900.0
2016-09-06	ARKK	ETF	21.169	21.169	21.169	21.169	200.0
2016-09-06	ARKQ	ETF	21.49	21.54	21.47	21.49	1800.0
2016-09-06	ARKW	ETF	24.81	24.81	24.77	24.77	200.0
2016-09-06	ASEA	ETF	14.2	14.24	14.16	14.22	4900.0
2016-09-06	ASHR	ETF	25.25	25.36	25.19	25.34	1117300.0
2016-09-06	ASHS	ETF	35.46	35.64	35.4	35.61	15900.0
2016-09-06	ATMP	ETF	22.68	23.2	22.65	23.14	12100.0
2016-09-06	BAB	ETF	31.6	31.74	31.545	31.72	224796.0
2016-09-06	BAL	ETF	45.02	45.9891	45.02	45.97	28704.0
2016-09-06	BBC	ETF	20.1	20.54	20.1	20.53	1753.0
2016-09-06	BBH	ETF	114.54	115.69	114.33	115.21	53600.0
2016-09-06	BBP	ETF	30.69	30.872	30.605	30.86	2500.0
2016-09-06	BCM	ETF	25.73	25.9033	25.73	25.9	4293.0
2016-09-06	BFIT	ETF	16.1699	16.1699	16.1699	16.1699	210.0

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

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