PREVIEW / etf_daily / 2014-01-06

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-06.parquet
  size:    43 KB
  rows:    1,056

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
2014-01-06	SPY	ETF	183.49	183.56	182.08	182.36	108028200.0
2014-01-06	QQQ	ETF	86.65	86.76	86.0	86.32	32092437.0
2014-01-06	IWM	ETF	115.22	115.27	113.71	113.76	36198000.0
2014-01-06	DIA	ETF	164.99	165.06	163.71	163.89	7446800.0
2014-01-06	GLD	ETF	119.76	120.39	117.11	119.5	10106500.0
2014-01-06	TLT	ETF	102.38	103.0	102.37	102.6	7796200.0
2014-01-06	AADR	ETF	37.36	37.36	37.05	37.07	4000.0
2014-01-06	AAXJ	ETF	57.99	57.99	57.56	57.64	1116800.0
2014-01-06	ACWI	ETF	56.85	56.87	56.57	56.59	1400600.0
2014-01-06	ACWV	ETF	62.9	62.9	62.53	62.64	55800.0
2014-01-06	ACWX	ETF	45.68	45.76	45.58	45.6	461554.0
2014-01-06	ADRE	ETF	35.9	35.9	35.7	35.71	55893.0
2014-01-06	AFK	ETF	30.17	30.4	30.1	30.208	16536.0
2014-01-06	AGG	ETF	106.53	106.68	106.53	106.68	4413900.0
2014-01-06	AGQ	ETF	67.8	68.96	66.6	67.72	688025.0
2014-01-06	AGZ	ETF	110.73	110.73	110.62	110.63	14276.0
2014-01-06	AIA	ETF	46.05	46.05	45.68	45.81	51945.0
2014-01-06	AIQ	ETF	26.86	27.42	26.01	27.3	38915.0
2014-01-06	AIVI	ETF	46.56	46.64	46.49	46.55	20200.0
2014-01-06	ALTL	ETF	32.5249	32.5249	32.5249	32.5249	180.0
2014-01-06	AMJ	ETF	45.9	45.9	45.57	45.64	421056.0
2014-01-06	AMLP	ETF	88.0	88.15	87.65	87.8	538000.0
2014-01-06	ANGL	ETF	27.07	27.07	26.92	26.92	2200.0
2014-01-06	AOA	ETF	44.29	44.29	44.05	44.12	37000.0
2014-01-06	AOK	ETF	31.92	31.93	31.88	31.88	39121.0
2014-01-06	AOM	ETF	34.23	34.23	34.0901	34.11	102666.0
2014-01-06	AOR	ETF	38.33	38.33	38.14	38.17	42659.0
2014-01-06	ARGT	ETF	19.3	19.34	18.97	19.17	11800.0
2014-01-06	ASEA	ETF	15.0	15.0	14.88	14.9	181000.0
2014-01-06	ASHR	ETF	23.73	23.76	23.45	23.49	277000.0
2014-01-06	ATMP	ETF	26.86	26.9	26.86	26.88	9100.0
2014-01-06	AVIV	ETF	23.16	23.37	22.85	23.31	162868.0
2014-01-06	AWAY	ETF	40.84	41.08	39.91	40.92	1649803.0
2014-01-06	BAB	ETF	27.44	27.48	27.39	27.45	172367.0
2014-01-06	BAL	ETF	52.33	52.57	52.18	52.537	2058.0
2014-01-06	BALT	ETF	6.4	6.68	6.3	6.53	1160222.0
2014-01-06	BBH	ETF	87.89	88.33	86.66	87.2	164400.0
2014-01-06	BCM	ETF	39.11	39.11	39.05	39.06	1785.0
2014-01-06	BFOR	ETF	7.41	7.4375	7.345	7.365	298000.0
2014-01-06	BIB	ETF	37.3875	37.642	36.16	36.55	205080.0
2014-01-06	BICK	ETF	23.751	23.752	23.75	23.75	1169.0
2014-01-06	BIL	ETF	91.54	91.56	91.54	91.54	166200.0
2014-01-06	BIS	ETF	844.396	862.8	831.2	844.8	998.5
2014-01-06	BIV	ETF	82.08	82.24	82.07	82.14	279700.0
2014-01-06	BIZD	ETF	21.07	21.07	20.88	20.95	23200.0
2014-01-06	BJK	ETF	53.45	53.45	53.08	53.18	15200.0
2014-01-06	BKF	ETF	36.19	36.38	36.054	36.09	48329.0
2014-01-06	BKLN	ETF	24.9	24.92	24.87	24.87	3454200.0
2014-01-06	BLV	ETF	82.2	82.55	82.17	82.28	21500.0
2014-01-06	BMVP	ETF	22.593	22.657	22.453	22.48	6766.0

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

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