PREVIEW / etf_daily / 2013-11-27

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-27.parquet
  size:    42 KB
  rows:    1,054

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-11-27	SPY	ETF	180.87	181.24	180.65	181.12	58800000.0
2013-11-27	QQQ	ETF	84.79	85.24	84.73	85.22	21638074.0
2013-11-27	IWM	ETF	112.84	113.57	112.64	113.45	29099600.0
2013-11-27	DIA	ETF	160.79	160.94	160.41	160.85	6272800.0
2013-11-27	GLD	ETF	120.49	120.69	119.25	119.46	6144600.0
2013-11-27	TLT	ETF	104.68	104.7	103.96	104.42	6063000.0
2013-11-27	AADR	ETF	37.0	37.0	36.55	36.81	4300.0
2013-11-27	AAXJ	ETF	60.23	60.72	60.23	60.62	211600.0
2013-11-27	ACWI	ETF	56.79	56.92	56.75	56.82	638100.0
2013-11-27	ACWV	ETF	64.28	64.28	64.01	64.14	12100.0
2013-11-27	ACWX	ETF	46.33	46.42	46.278	46.36	180971.0
2013-11-27	ADRE	ETF	37.65	37.85	37.64	37.72	23277.0
2013-11-27	AFK	ETF	31.09	31.16	30.91	31.0101	32364.0
2013-11-27	AGG	ETF	107.44	107.48	107.21	107.4	932800.0
2013-11-27	AGQ	ETF	66.68	66.92	64.88	65.12	324500.0
2013-11-27	AGZ	ETF	111.5401	111.779	111.49	111.56	18639.0
2013-11-27	AIA	ETF	48.78	49.14	48.78	49.11	19480.0
2013-11-27	AIQ	ETF	28.11	29.06	28.05	28.635	26371.0
2013-11-27	AIVI	ETF	47.16	47.2	47.03	47.06	7400.0
2013-11-27	ALTL	ETF	32.1389	32.1389	32.1389	32.1389	400.0
2013-11-27	AMJ	ETF	45.59	45.7	45.38	45.53	238262.0
2013-11-27	AMLP	ETF	88.65	88.65	88.15	88.25	344260.0
2013-11-27	ANGL	ETF	27.1	27.1	26.93	26.93	4300.0
2013-11-27	AOA	ETF	43.98	44.01	43.91	44.01	9800.0
2013-11-27	AOK	ETF	31.99	31.99	31.9387	31.98	16666.0
2013-11-27	AOM	ETF	34.17	34.22	34.15	34.22	42123.0
2013-11-27	AOR	ETF	38.22	38.35	38.16	38.23	291084.0
2013-11-27	ARGT	ETF	20.43	20.73	20.43	20.73	5300.0
2013-11-27	ASEA	ETF	16.24	16.33	16.19	16.26	7500.0
2013-11-27	ASHR	ETF	25.38	25.6	25.35	25.59	385400.0
2013-11-27	ATMP	ETF	26.73	26.73	26.67	26.69	33000.0
2013-11-27	AVIV	ETF	25.29	25.9	25.14	25.9	142497.0
2013-11-27	AWAY	ETF	36.06	36.65	35.87	36.39	740177.0
2013-11-27	BAB	ETF	27.64	27.69	27.5601	27.635	120550.0
2013-11-27	BAL	ETF	48.98	49.25	48.74	49.25	7950.0
2013-11-27	BALT	ETF	4.82	4.94	4.73	4.76	529852.0
2013-11-27	BBH	ETF	87.85	87.86	87.04	87.47	36500.0
2013-11-27	BCM	ETF	39.149	39.15	39.041	39.041	1433.0
2013-11-27	BFOR	ETF	7.325	7.3325	7.305	7.3325	299200.0
2013-11-27	BIB	ETF	36.77	36.8625	36.25	36.5	215120.0
2013-11-27	BICK	ETF	24.6	24.7025	24.5801	24.5801	800.0
2013-11-27	BIL	ETF	91.58	91.58	91.56	91.58	145900.0
2013-11-27	BIS	ETF	861.2	872.0	861.2	870.56	116.0
2013-11-27	BIV	ETF	83.85	83.85	83.55	83.77	291300.0
2013-11-27	BIZD	ETF	21.52	21.53	21.39	21.53	13300.0
2013-11-27	BJK	ETF	49.84	49.98	49.71	49.91	12500.0
2013-11-27	BKF	ETF	38.23	38.57	38.23	38.45	46463.0
2013-11-27	BKLN	ETF	24.85	24.85	24.82	24.82	2574000.0
2013-11-27	BLV	ETF	82.7	82.91	82.5	82.69	238400.0
2013-11-27	BMVP	ETF	22.5333	22.5333	22.4698	22.51	1310.0

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

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