PREVIEW / etf_daily / 2016-08-26

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-26.parquet
  size:    51 KB
  rows:    1,283

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-08-26	SPY	ETF	217.92	219.12	216.25	217.29	122506300.0
2016-08-26	QQQ	ETF	116.66	117.54	116.08	116.78	23895963.0
2016-08-26	IWM	ETF	123.45	124.41	122.3	123.06	26734400.0
2016-08-26	DIA	ETF	184.62	185.54	183.14	183.82	3403500.0
2016-08-26	GLD	ETF	126.88	128.11	125.82	126.05	17967700.0
2016-08-26	TLT	ETF	139.73	140.69	138.22	138.36	12962500.0
2016-08-26	AADR	ETF	40.62	40.62	40.32	40.6	6000.0
2016-08-26	AAXJ	ETF	59.18	59.74	58.38	58.75	1832900.0
2016-08-26	ACTX	ETF	3.54	3.54	3.54	3.54	25.0
2016-08-26	ACWI	ETF	58.95	59.39	58.39	58.63	1682800.0
2016-08-26	ACWV	ETF	76.9	77.33	76.07	76.28	156300.0
2016-08-26	ACWX	ETF	41.26	41.66	40.75	40.93	646384.0
2016-08-26	ADRE	ETF	34.22	34.4599	33.87	33.9	3105.0
2016-08-26	AFK	ETF	20.52	20.75	20.2901	20.57	4329.0
2016-08-26	AFTY	ETF	13.57	13.6	13.5	13.535	6400.0
2016-08-26	AGG	ETF	112.69	112.86	112.28	112.34	2513700.0
2016-08-26	AGGY	ETF	52.15	52.268	51.933	51.968	8300.0
2016-08-26	AGNG	ETF	16.56	16.56	16.56	16.56	100.0
2016-08-26	AGQ	ETF	46.32	47.98	45.35	45.95	266800.0
2016-08-26	AGZ	ETF	115.6101	115.8999	115.4101	115.44	11570.0
2016-08-26	AGZD	ETF	24.005	24.005	24.005	24.005	600.0
2016-08-26	AIA	ETF	48.62	49.03	48.0	48.2	32402.0
2016-08-26	AIQ	ETF	6.15	6.24	6.15	6.23	32069.0
2016-08-26	AIRR	ETF	19.96	20.1	19.75	19.83	11400.0
2016-08-26	AIVI	ETF	39.27	39.7	38.85	38.96	57900.0
2016-08-26	AMJ	ETF	31.19	31.36	30.915	31.05	2112977.0
2016-08-26	AMLP	ETF	62.65	63.2	62.6	62.7	979240.0
2016-08-26	AMZA	ETF	115.9	115.9	114.0	114.9	9810.0
2016-08-26	ANGL	ETF	28.75	28.87	28.72	28.74	70600.0
2016-08-26	AOA	ETF	47.5	47.73	47.02	47.18	19800.0
2016-08-26	AOK	ETF	33.4279	33.5449	33.2501	33.27	37173.0
2016-08-26	AOM	ETF	36.07	36.1899	35.85	35.9	76793.0
2016-08-26	AOR	ETF	40.97	41.28	40.75	40.89	43115.0
2016-08-26	ARGT	ETF	22.99	23.01	22.53	22.53	32700.0
2016-08-26	ARKG	ETF	18.232	18.232	18.13	18.13	2200.0
2016-08-26	ARKK	ETF	20.89	20.89	20.89	20.89	100.0
2016-08-26	ARKQ	ETF	21.7	21.758	21.61	21.61	1100.0
2016-08-26	ARKW	ETF	24.37	24.54	24.34	24.34	1000.0
2016-08-26	ASEA	ETF	14.35	14.35	14.35	14.35	100.0
2016-08-26	ASHR	ETF	25.07	25.2	24.84	24.9	991200.0
2016-08-26	ASHS	ETF	35.24	35.3	34.95	34.97	5800.0
2016-08-26	ATMP	ETF	22.7	22.81	22.56	22.63	35200.0
2016-08-26	BAB	ETF	31.67	31.76	31.48	31.51	179679.0
2016-08-26	BAL	ETF	45.1767	45.6	44.8	45.05	9052.0
2016-08-26	BBC	ETF	20.04	20.2571	19.89	20.05	8972.0
2016-08-26	BBH	ETF	114.49	116.09	114.42	115.27	48000.0
2016-08-26	BBP	ETF	30.09	30.915	30.09	30.72	12900.0
2016-08-26	BCM	ETF	26.67	26.67	26.3687	26.4	12165.0
2016-08-26	BFOR	ETF	8.105	8.14	8.0475	8.0475	11200.0
2016-08-26	BIB	ETF	46.68	48.2	46.46	47.32	672201.0

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

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