PREVIEW / etf_daily / 2015-12-09

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-09.parquet
  size:    49 KB
  rows:    1,226

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
2015-12-09	SPY	ETF	206.19	208.68	204.18	205.34	162401500.0
2015-12-09	QQQ	ETF	114.11	114.76	112.2	112.89	48509199.0
2015-12-09	IWM	ETF	115.03	116.17	113.6	114.08	41980400.0
2015-12-09	DIA	ETF	175.44	177.76	174.08	174.99	9545800.0
2015-12-09	GLD	ETF	103.63	103.66	102.32	102.64	6026300.0
2015-12-09	TLT	ETF	121.35	122.15	120.51	121.68	8993900.0
2015-12-09	AADR	ETF	38.15	38.36	38.15	38.36	1600.0
2015-12-09	AAXJ	ETF	53.86	54.41	53.66	53.92	2038500.0
2015-12-09	ACTX	ETF	7.6701	7.6701	6.4901	7.0801	1190.0
2015-12-09	ACWF	ETF	23.66	23.79	23.37	23.4799	39277.0
2015-12-09	ACWI	ETF	56.7	57.32	56.24	56.55	4088800.0
2015-12-09	ACWV	ETF	69.78	70.22	69.12	69.39	75900.0
2015-12-09	ACWX	ETF	40.18	40.46	39.79	39.98	1682823.0
2015-12-09	ADRE	ETF	30.12	30.4	29.88	29.955	5500.0
2015-12-09	AFK	ETF	18.31	18.53	18.0301	18.2	27452.0
2015-12-09	AFTY	ETF	16.33	16.43	16.28	16.29	25900.0
2015-12-09	AGG	ETF	108.34	108.58	108.21	108.44	2791000.0
2015-12-09	AGGY	ETF	49.24	49.35	49.24	49.34	5800.0
2015-12-09	AGQ	ETF	29.24	29.24	28.48	28.54	79500.0
2015-12-09	AGZ	ETF	113.07	113.3106	112.98	113.12	38299.0
2015-12-09	AGZD	ETF	24.02	24.03	24.02	24.03	1200.0
2015-12-09	AIA	ETF	43.21	43.55	43.03	43.26	72795.0
2015-12-09	AIQ	ETF	8.56	8.96	8.56	8.84	31198.0
2015-12-09	AIRR	ETF	17.22	17.252	16.92	16.96	11000.0
2015-12-09	AIVI	ETF	38.41	38.78	38.08	38.28	176600.0
2015-12-09	AMJ	ETF	25.82	27.79	25.79	27.71	12738361.0
2015-12-09	AMLP	ETF	52.3	56.9	52.25	56.8	6549600.0
2015-12-09	AMZA	ETF	93.2	105.9	93.2	105.9	2930.0
2015-12-09	ANGL	ETF	24.97	24.97	24.89	24.95	14700.0
2015-12-09	AOA	ETF	45.47	45.67	45.03	45.24	127100.0
2015-12-09	AOK	ETF	31.81	31.93	31.8001	31.86	196549.0
2015-12-09	AOM	ETF	34.44	34.5	34.26	34.32	370419.0
2015-12-09	AOR	ETF	39.23	39.4144	39.05	39.13	3361367.0
2015-12-09	ARGT	ETF	17.62	18.12	17.62	17.86	22800.0
2015-12-09	ARKG	ETF	19.806	19.806	19.7	19.7	200.0
2015-12-09	ARKK	ETF	20.95	21.602	20.715	20.715	2000.0
2015-12-09	ARKQ	ETF	19.37	19.37	19.33	19.33	200.0
2015-12-09	ARKW	ETF	23.89	24.02	23.89	24.02	1700.0
2015-12-09	ASEA	ETF	12.56	12.6	12.56	12.58	1400.0
2015-12-09	ASHR	ETF	35.75	36.05	35.5	35.51	1267300.0
2015-12-09	ASHS	ETF	44.0	44.5	43.57	43.77	140900.0
2015-12-09	ASHX	ETF	25.484	25.484	25.484	25.484	215.0
2015-12-09	ATMP	ETF	17.23	18.14	17.2	18.11	185600.0
2015-12-09	AWAY	ETF	35.79	36.26	35.515	35.88	6199941.0
2015-12-09	BAB	ETF	29.1	29.25	29.038	29.17	47389.0
2015-12-09	BAL	ETF	43.0864	43.45	42.67	43.2199	18327.0
2015-12-09	BBC	ETF	29.72	29.72	28.8	28.8	2746.0
2015-12-09	BBH	ETF	123.2	124.26	121.38	122.12	71400.0
2015-12-09	BBP	ETF	30.42	30.42	29.94	29.94	2300.0
2015-12-09	BCM	ETF	24.1496	24.21	24.1496	24.18	4778.0

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

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