PREVIEW / etf_daily / 2013-12-16

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-16.parquet
  size:    43 KB
  rows:    1,061

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
2013-12-16	SPY	ETF	178.95	179.81	178.9	179.22	96195000.0
2013-12-16	QQQ	ETF	85.27	85.81	85.21	85.32	24908324.0
2013-12-16	IWM	ETF	110.62	111.57	110.15	111.51	33991200.0
2013-12-16	DIA	ETF	158.37	159.37	158.25	158.9	7076500.0
2013-12-16	GLD	ETF	119.26	120.77	118.97	119.69	8189500.0
2013-12-16	TLT	ETF	103.58	103.69	102.73	102.83	6376400.0
2013-12-16	AADR	ETF	36.3	36.54	36.24	36.35	14400.0
2013-12-16	AAXJ	ETF	59.65	60.09	59.65	59.81	503400.0
2013-12-16	ACWI	ETF	55.78	56.01	55.75	55.91	4815600.0
2013-12-16	ACWV	ETF	62.91	63.15	62.85	62.98	119100.0
2013-12-16	ACWX	ETF	45.33	45.48	45.29	45.33	456317.0
2013-12-16	ADRE	ETF	37.01	37.219	36.89	36.89	17670.0
2013-12-16	AFK	ETF	30.61	30.8	30.6	30.8	10075.0
2013-12-16	AGG	ETF	106.92	106.92	106.67	106.73	804900.0
2013-12-16	AGQ	ETF	64.72	68.76	64.52	66.52	460125.0
2013-12-16	AGZ	ETF	110.98	111.0099	110.95	110.9601	10543.0
2013-12-16	AIA	ETF	47.71	47.96	47.71	47.802	11194.0
2013-12-16	AIQ	ETF	23.34	24.63	22.98	24.34	60244.0
2013-12-16	AIVI	ETF	45.92	46.1	45.86	46.02	93400.0
2013-12-16	ALTL	ETF	31.86	31.86	31.78	31.86	8800.0
2013-12-16	AMJ	ETF	43.7	44.29	43.7	43.87	316453.0
2013-12-16	AMLP	ETF	85.9	86.3	85.6	85.75	506980.0
2013-12-16	ANGL	ETF	26.93	27.1	26.93	27.1	1600.0
2013-12-16	AOA	ETF	43.43	43.53	43.43	43.48	45200.0
2013-12-16	AOK	ETF	31.75	31.75	31.7063	31.74	8980.0
2013-12-16	AOM	ETF	33.92	33.972	33.9048	33.93	32735.0
2013-12-16	AOR	ETF	37.79	37.91	37.79	37.84	11647.0
2013-12-16	ARGT	ETF	19.71	19.9	19.63	19.9	6900.0
2013-12-16	ASEA	ETF	15.8	15.88	15.76	15.83	64600.0
2013-12-16	ASHR	ETF	25.12	25.16	24.85	24.91	250100.0
2013-12-16	ATMP	ETF	26.04	26.04	25.68	25.68	31600.0
2013-12-16	AVIV	ETF	23.84	24.03	23.66	23.91	92841.0
2013-12-16	AWAY	ETF	38.13	38.41	37.5	37.83	986992.0
2013-12-16	BAB	ETF	27.53	27.53	27.42	27.44	298002.0
2013-12-16	BAL	ETF	51.97	52.4	51.92	52.39	4744.0
2013-12-16	BALT	ETF	5.63	5.75	5.53	5.65	910156.0
2013-12-16	BBH	ETF	85.34	86.24	84.67	84.72	62800.0
2013-12-16	BCM	ETF	39.66	39.66	39.53	39.538	147334.0
2013-12-16	BFOR	ETF	7.195	7.2275	7.195	7.2225	182800.0
2013-12-16	BIB	ETF	34.19	35.3425	34.19	34.3225	229188.0
2013-12-16	BICK	ETF	24.34	24.4608	24.29	24.4608	5636.0
2013-12-16	BIL	ETF	91.58	91.58	91.56	91.56	412600.0
2013-12-16	BIS	ETF	917.6	917.6	887.2	914.0	316.0
2013-12-16	BIV	ETF	83.19	83.26	83.06	83.16	379900.0
2013-12-16	BIZD	ETF	20.92	20.94	20.8	20.89	25300.0
2013-12-16	BJK	ETF	52.06	52.69	52.06	52.31	28100.0
2013-12-16	BKF	ETF	37.43	37.75	37.36	37.36	100823.0
2013-12-16	BKLN	ETF	24.76	24.78	24.75	24.77	1313900.0
2013-12-16	BLV	ETF	82.53	82.65	82.14	82.24	35300.0
2013-12-16	BMVP	ETF	22.04	22.18	22.04	22.15	5868.0

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

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