PREVIEW / etf_daily / 2016-12-05

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-05.parquet
  size:    54 KB
  rows:    1,354

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-12-05	SPY	ETF	220.65	221.4	220.42	221.0	67837800.0
2016-12-05	QQQ	ETF	116.32	117.06	115.77	116.6	21419667.0
2016-12-05	IWM	ETF	131.97	133.33	131.89	133.15	27547100.0
2016-12-05	DIA	ETF	192.48	192.78	191.89	192.22	2925600.0
2016-12-05	GLD	ETF	111.15	112.11	110.31	111.54	10187900.0
2016-12-05	TLT	ETF	118.93	120.4	118.45	119.47	12100100.0
2016-12-05	AADR	ETF	39.56	40.12	39.56	40.12	3100.0
2016-12-05	AAXJ	ETF	56.65	56.82	56.63	56.75	864600.0
2016-12-05	ACSI	ETF	26.68	26.69	26.62	26.68	9169.0
2016-12-05	ACTX	ETF	20.0602	23.0692	17.7002	21.8302	1819.0
2016-12-05	ACWI	ETF	58.65	58.85	58.61	58.79	1690300.0
2016-12-05	ACWV	ETF	72.26	72.26	72.03	72.16	476000.0
2016-12-05	ACWX	ETF	40.01	40.23	40.0	40.17	1769871.0
2016-12-05	ADRE	ETF	32.55	32.74	32.55	32.73	2676.0
2016-12-05	AFK	ETF	19.55	19.94	19.55	19.83	15861.0
2016-12-05	AFTY	ETF	13.962	13.962	13.93	13.93	1700.0
2016-12-05	AGG	ETF	107.94	108.26	107.78	108.11	3398000.0
2016-12-05	AGGY	ETF	49.414	49.58	49.41	49.533	4000.0
2016-12-05	AGNG	ETF	15.265	15.265	15.265	15.265	100.0
2016-12-05	AGQ	ETF	35.31	36.35	34.88	35.83	289000.0
2016-12-05	AGZ	ETF	111.99	112.62	110.44	112.36	19110.0
2016-12-05	AGZD	ETF	24.05	24.075	24.05	24.075	400.0
2016-12-05	AIA	ETF	47.94	48.15	47.94	48.13	29699.0
2016-12-05	AIQ	ETF	7.5113	7.65	7.5	7.55	8173.0
2016-12-05	AIRR	ETF	23.16	23.33	23.16	23.26	100000.0
2016-12-05	AIVI	ETF	36.61	36.98	36.61	36.91	32800.0
2016-12-05	ALTY	ETF	14.63	14.705	14.53	14.661	22400.0
2016-12-05	AMJ	ETF	29.96	30.01	29.65	29.75	1620459.0
2016-12-05	AMLP	ETF	61.05	61.2	60.45	60.7	1587620.0
2016-12-05	AMZA	ETF	107.6	108.5	107.1	107.6	26170.0
2016-12-05	ANGL	ETF	28.71	28.75	28.63	28.74	302200.0
2016-12-05	AOA	ETF	46.95	46.99	46.83	46.9	238200.0
2016-12-05	AOK	ETF	32.37	32.459	32.3	32.36	376359.0
2016-12-05	AOM	ETF	35.15	35.22	34.98	35.1	294533.0
2016-12-05	AOR	ETF	40.2	40.39	40.198	40.33	474142.0
2016-12-05	ARGT	ETF	23.1	23.32	22.96	23.32	35800.0
2016-12-05	ARKG	ETF	17.75	17.847	17.71	17.84	400.0
2016-12-05	ARKK	ETF	20.16	20.21	20.16	20.198	4300.0
2016-12-05	ARKQ	ETF	21.32	21.32	21.32	21.32	300.0
2016-12-05	ARKW	ETF	24.72	25.02	24.72	24.98	800.0
2016-12-05	ASEA	ETF	13.24	13.24	13.23	13.24	600.0
2016-12-05	ASHR	ETF	25.56	25.63	25.47	25.55	1081400.0
2016-12-05	ASHS	ETF	34.03	34.39	34.03	34.37	8600.0
2016-12-05	ATMP	ETF	22.37	22.52	22.25	22.35	115400.0
2016-12-05	BAB	ETF	29.17	29.349	29.12	29.28	265911.0
2016-12-05	BAL	ETF	47.24	47.24	46.6303	46.7507	5930.0
2016-12-05	BBC	ETF	20.89	20.89	19.78	19.93	28509.0
2016-12-05	BBH	ETF	107.87	108.93	107.38	107.9	27700.0
2016-12-05	BBP	ETF	33.63	34.24	33.58	33.938	7700.0
2016-12-05	BFOR	ETF	8.675	8.675	8.6475	8.67	69200.0

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

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