PREVIEW / etf_daily / 2014-01-03

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-03.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-03	SPY	ETF	183.23	183.6	182.63	182.89	81390600.0
2014-01-03	QQQ	ETF	87.27	87.35	86.62	86.64	35727317.0
2014-01-03	IWM	ETF	114.53	114.9	114.11	114.69	26468000.0
2014-01-03	DIA	ETF	164.4	164.87	164.04	164.39	6127600.0
2014-01-03	GLD	ETF	118.64	119.62	118.59	119.29	5874400.0
2014-01-03	TLT	ETF	101.81	102.45	101.76	102.17	4083800.0
2014-01-03	AADR	ETF	37.36	37.36	37.36	37.36	200.0
2014-01-03	AAXJ	ETF	58.48	58.48	57.95	58.03	627700.0
2014-01-03	ACWI	ETF	56.82	56.95	56.68	56.77	834700.0
2014-01-03	ACWV	ETF	62.95	62.96	62.64	62.81	43700.0
2014-01-03	ACWX	ETF	45.95	45.95	45.6812	45.76	2078183.0
2014-01-03	ADRE	ETF	36.27	36.27	35.8605	35.9664	11450.0
2014-01-03	AFK	ETF	30.38	30.8799	30.16	30.17	104046.0
2014-01-03	AGG	ETF	106.45	106.63	106.39	106.54	2293500.0
2014-01-03	AGQ	ETF	67.4	68.12	67.04	67.72	368600.0
2014-01-03	AGZ	ETF	110.87	110.9199	110.55	110.57	18953.0
2014-01-03	AIA	ETF	46.47	46.47	46.056	46.18	33382.0
2014-01-03	AIQ	ETF	26.47	26.99	25.01	26.89	36309.0
2014-01-03	AIVI	ETF	46.8	46.8	46.5	46.63	11100.0
2014-01-03	AMJ	ETF	45.89	46.0	45.58	45.7	295173.0
2014-01-03	AMLP	ETF	88.2	88.35	87.65	87.95	420780.0
2014-01-03	ANGL	ETF	26.97	26.98	26.86	26.98	6700.0
2014-01-03	AOA	ETF	44.22	44.29	44.11	44.18	30800.0
2014-01-03	AOK	ETF	31.93	31.94	31.8612	31.92	24110.0
2014-01-03	AOM	ETF	34.19	34.2	34.12	34.17	112600.0
2014-01-03	AOR	ETF	38.28	38.32	38.222	38.25	31773.0
2014-01-03	ARGT	ETF	19.55	19.55	19.29	19.29	7400.0
2014-01-03	ASEA	ETF	15.04	15.11	14.96	14.98	9700.0
2014-01-03	ASHR	ETF	24.11	24.2	24.01	24.09	135400.0
2014-01-03	ATMP	ETF	25.48	27.04	25.48	26.95	6000.0
2014-01-03	AVIV	ETF	22.94	23.32	22.81	23.16	141740.0
2014-01-03	AWAY	ETF	40.25	40.626	39.85	40.45	607419.0
2014-01-03	BAB	ETF	27.38	27.41	27.33	27.39	132695.0
2014-01-03	BAL	ETF	52.39	52.44	52.06	52.35	14039.0
2014-01-03	BALT	ETF	6.4	6.499	6.25	6.4	1019820.0
2014-01-03	BBH	ETF	88.41	88.96	87.72	88.05	53100.0
2014-01-03	BCM	ETF	39.19	39.19	39.04	39.04	2408.0
2014-01-03	BFOR	ETF	7.405	7.4525	7.385	7.405	273200.0
2014-01-03	BIB	ETF	37.7275	37.9348	37.17	37.2925	107328.0
2014-01-03	BICK	ETF	23.99	24.0296	23.99	24.0	1068.0
2014-01-03	BIL	ETF	91.56	91.56	91.54	91.56	85850.0
2014-01-03	BIS	ETF	830.8	839.16	830.396	830.396	236.5
2014-01-03	BIV	ETF	81.93	82.13	81.93	81.97	271600.0
2014-01-03	BIZD	ETF	20.92	20.98	20.8	20.93	22400.0
2014-01-03	BJK	ETF	53.42	53.5	53.04	53.16	16500.0
2014-01-03	BKF	ETF	36.67	36.8	36.34	36.46	80858.0
2014-01-03	BKLN	ETF	24.88	24.91	24.86	24.9	1953600.0
2014-01-03	BLV	ETF	81.92	82.33	81.82	82.08	49800.0
2014-01-03	BMVP	ETF	22.54	22.61	22.48	22.51	19622.0
2014-01-03	BND	ETF	80.08	80.21	80.06	80.13	1577300.0

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

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