PREVIEW / etf_daily / 2014-01-10

all etf daily files

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

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-10	SPY	ETF	183.95	184.22	183.01	184.14	102026400.0
2014-01-10	QQQ	ETF	87.24	87.4	86.58	87.3	38012069.0
2014-01-10	IWM	ETF	114.92	115.53	114.4	115.52	29174600.0
2014-01-10	DIA	ETF	164.56	164.69	163.52	164.18	7497200.0
2014-01-10	GLD	ETF	119.72	120.43	119.58	120.26	7993200.0
2014-01-10	TLT	ETF	103.77	104.54	103.69	104.41	13197400.0
2014-01-10	AADR	ETF	37.45	37.49	37.45	37.45	4100.0
2014-01-10	AAXJ	ETF	57.86	58.52	57.86	58.41	355900.0
2014-01-10	ACWI	ETF	57.07	57.2	56.9	57.19	1145500.0
2014-01-10	ACWV	ETF	62.75	63.05	62.72	63.0	28800.0
2014-01-10	ACWX	ETF	45.91	46.11	45.7901	46.08	293187.0
2014-01-10	ADRE	ETF	35.53	35.82	35.45	35.77	12590.0
2014-01-10	AFK	ETF	30.0	30.5	30.0	30.5	22288.0
2014-01-10	AGG	ETF	106.92	107.1	106.84	107.1	1484400.0
2014-01-10	AGQ	ETF	66.92	68.0	66.36	67.36	591825.0
2014-01-10	AGZ	ETF	110.55	110.89	110.55	110.89	28768.0
2014-01-10	AGZD	ETF	25.0	25.06	24.99	25.005	17600.0
2014-01-10	AIA	ETF	45.74	46.14	45.7357	46.03	11675.0
2014-01-10	AIQ	ETF	27.16	28.03	26.96	27.52	88018.0
2014-01-10	AIVI	ETF	46.77	47.14	46.63	47.11	23200.0
2014-01-10	ALTL	ETF	32.8263	32.9104	32.82	32.89	1195.0
2014-01-10	AMJ	ETF	45.31	45.59	45.1615	45.37	714017.0
2014-01-10	AMLP	ETF	87.4	87.55	86.85	86.95	744880.0
2014-01-10	ANGL	ETF	27.11	27.11	27.0	27.09	1800.0
2014-01-10	AOA	ETF	44.5	44.57	44.35	44.57	37500.0
2014-01-10	AOK	ETF	32.04	32.0899	31.994	32.08	35598.0
2014-01-10	AOM	ETF	34.29	34.382	34.26	34.38	56617.0
2014-01-10	AOR	ETF	38.5	38.5199	38.34	38.519	27935.0
2014-01-10	ARGT	ETF	19.0	19.0	18.84	19.0	4100.0
2014-01-10	ASEA	ETF	15.12	15.33	15.12	15.31	10000.0
2014-01-10	ASHR	ETF	23.16	23.43	23.12	23.37	144300.0
2014-01-10	ATMP	ETF	26.8	26.8	26.71	26.72	13100.0
2014-01-10	AVIV	ETF	23.93	24.4	23.9	24.2	124030.0
2014-01-10	AWAY	ETF	40.86	41.655	40.72	41.34	624628.0
2014-01-10	BAB	ETF	27.6	27.74	27.57	27.74	264323.0
2014-01-10	BAL	ETF	52.58	52.8	51.78	52.09	7773.0
2014-01-10	BALT	ETF	5.9	6.21	5.89	6.17	1710111.0
2014-01-10	BBH	ETF	91.62	92.74	90.68	92.74	158000.0
2014-01-10	BCM	ETF	38.71	38.86	38.71	38.86	141138.0
2014-01-10	BFOR	ETF	7.43	7.455	7.395	7.455	141200.0
2014-01-10	BIB	ETF	40.665	41.68	39.7225	41.68	302480.0
2014-01-10	BICK	ETF	23.68	23.8116	23.68	23.8	998.0
2014-01-10	BIL	ETF	91.56	91.56	91.54	91.56	100050.0
2014-01-10	BIS	ETF	760.408	782.88	745.6	747.216	539.5
2014-01-10	BIV	ETF	82.44	82.66	82.4	82.56	244300.0
2014-01-10	BIZD	ETF	21.11	21.11	21.0	21.08	4100.0
2014-01-10	BJK	ETF	54.1	54.65	54.1	54.64	44800.0
2014-01-10	BKF	ETF	35.92	36.472	35.92	36.37	76684.0
2014-01-10	BKLN	ETF	24.97	24.99	24.96	24.97	2173300.0
2014-01-10	BLV	ETF	83.12	83.49	83.1	83.46	112900.0

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

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