PREVIEW / etf_daily / 2016-08-09

all etf daily files

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

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-09	SPY	ETF	218.13	218.76	217.8	218.18	51251700.0
2016-08-09	QQQ	ETF	116.73	117.29	116.67	116.92	13276458.0
2016-08-09	IWM	ETF	122.27	122.63	122.14	122.37	12487700.0
2016-08-09	DIA	ETF	185.38	185.86	185.06	185.35	1903800.0
2016-08-09	GLD	ETF	127.94	128.14	127.75	127.96	7500400.0
2016-08-09	TLT	ETF	138.71	139.72	138.62	139.62	5503200.0
2016-08-09	AAXJ	ETF	58.82	59.1	58.76	58.91	445800.0
2016-08-09	ACTX	ETF	3.54	3.54	2.95	3.54	804.0
2016-08-09	ACWI	ETF	58.72	58.95	58.65	58.86	4096400.0
2016-08-09	ACWV	ETF	77.41	77.69	77.24	77.57	177500.0
2016-08-09	ACWX	ETF	40.86	41.13	40.86	41.05	760785.0
2016-08-09	ADRE	ETF	33.63	33.8129	33.6201	33.74	13823.0
2016-08-09	AFK	ETF	20.91	21.03	20.5301	20.7	5537.0
2016-08-09	AFTY	ETF	13.24	13.24	13.223	13.223	1100.0
2016-08-09	AGG	ETF	112.4	112.54	112.3	112.53	2981100.0
2016-08-09	AGGY	ETF	51.98	52.11	51.976	52.1	24100.0
2016-08-09	AGQ	ETF	52.02	52.5	51.93	52.31	125400.0
2016-08-09	AGZ	ETF	115.79	115.79	115.47	115.67	13727.0
2016-08-09	AIA	ETF	48.16	48.343	48.1567	48.215	7806.0
2016-08-09	AIQ	ETF	6.15	6.18	6.1	6.14	15576.0
2016-08-09	AIRR	ETF	19.64	19.64	19.553	19.56	6500.0
2016-08-09	AIVI	ETF	38.88	39.17	38.88	39.03	36000.0
2016-08-09	ALTY	ETF	15.518	15.63	15.518	15.63	1500.0
2016-08-09	AMJ	ETF	32.31	32.42	31.85	31.96	921334.0
2016-08-09	AMLP	ETF	65.15	65.3	64.3	64.5	1303460.0
2016-08-09	AMZA	ETF	116.0	116.3	114.51	115.0	72430.0
2016-08-09	ANGL	ETF	28.38	28.42	28.33	28.39	661700.0
2016-08-09	AOA	ETF	47.26	47.42	47.16	47.29	30700.0
2016-08-09	AOK	ETF	33.3	33.3599	33.25	33.35	80023.0
2016-08-09	AOM	ETF	35.89	36.0	35.8499	35.94	53903.0
2016-08-09	AOR	ETF	40.98	41.039	40.824	40.96	41129.0
2016-08-09	ARGT	ETF	23.0	23.15	22.89	22.98	36300.0
2016-08-09	ARKG	ETF	19.07	19.12	19.07	19.083	4300.0
2016-08-09	ARKK	ETF	20.9	20.9	20.9	20.9	100.0
2016-08-09	ARKQ	ETF	21.212	21.212	21.146	21.146	1500.0
2016-08-09	ARKW	ETF	24.5	24.5	24.39	24.466	1100.0
2016-08-09	ASHR	ETF	24.67	24.7	24.61	24.7	722000.0
2016-08-09	ASHS	ETF	34.75	34.82	34.73	34.75	12900.0
2016-08-09	ATMP	ETF	23.17	23.17	22.89	22.94	8500.0
2016-08-09	BAB	ETF	31.6	31.68	31.5517	31.68	217389.0
2016-08-09	BAL	ETF	49.15	49.1567	47.67	48.1	68369.0
2016-08-09	BBC	ETF	20.5	20.7756	20.5	20.73	3535.0
2016-08-09	BBH	ETF	116.92	116.92	115.93	116.15	46600.0
2016-08-09	BBP	ETF	30.99	31.26	30.99	31.24	8600.0
2016-08-09	BCM	ETF	25.96	26.0	25.882	25.888	25171.0
2016-08-09	BFOR	ETF	8.0325	8.055	8.03	8.0325	27600.0
2016-08-09	BIB	ETF	50.75	51.14	50.21	50.66	483667.0
2016-08-09	BIL	ETF	91.44	91.44	91.42	91.42	1148800.0
2016-08-09	BIS	ETF	250.24	251.2	246.8	248.96	27632.5
2016-08-09	BIV	ETF	87.69	87.88	87.65	87.85	654300.0

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

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