PREVIEW / etf_daily / 2014-01-13

all etf daily files

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

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-13	SPY	ETF	183.67	184.18	181.34	181.69	149892000.0
2014-01-13	QQQ	ETF	87.18	87.48	85.675	86.01	48855231.0
2014-01-13	IWM	ETF	115.3	115.49	113.26	113.94	45370800.0
2014-01-13	DIA	ETF	163.9	164.28	162.14	162.24	10676100.0
2014-01-13	GLD	ETF	120.27	121.04	120.2	121.02	5872700.0
2014-01-13	TLT	ETF	104.51	105.14	104.47	104.93	9667400.0
2014-01-13	AADR	ETF	37.49	37.49	36.95	36.95	1300.0
2014-01-13	AAXJ	ETF	58.39	58.44	57.74	57.9	447800.0
2014-01-13	ACWI	ETF	57.14	57.15	56.53	56.64	953200.0
2014-01-13	ACWV	ETF	62.96	62.98	62.44	62.52	47100.0
2014-01-13	ACWX	ETF	46.02	46.03	45.6	45.79	403608.0
2014-01-13	ADRE	ETF	35.82	35.9	35.36	35.38	26403.0
2014-01-13	AFK	ETF	30.49	30.66	30.2135	30.2401	11953.0
2014-01-13	AGG	ETF	107.15	107.31	107.14	107.2	1139500.0
2014-01-13	AGQ	ETF	66.68	69.52	66.68	69.44	728925.0
2014-01-13	AGZ	ETF	110.971	111.14	110.971	111.14	44324.0
2014-01-13	AGZD	ETF	25.035	25.035	25.005	25.005	19600.0
2014-01-13	AIA	ETF	45.92	45.9299	45.55	45.6375	19013.0
2014-01-13	AIQ	ETF	27.56	27.65	26.95	27.15	36450.0
2014-01-13	AIVI	ETF	46.88	46.99	46.56	46.7	45100.0
2014-01-13	ALTL	ETF	32.91	32.91	32.89	32.89	546.0
2014-01-13	AMJ	ETF	45.26	45.539	45.07	45.15	482831.0
2014-01-13	AMLP	ETF	86.9	87.45	86.9	87.0	560440.0
2014-01-13	ANGL	ETF	27.0	27.03	27.0	27.02	1800.0
2014-01-13	AOA	ETF	44.52	44.52	44.03	44.08	99900.0
2014-01-13	AOK	ETF	32.09	32.09	31.95	31.98	66013.0
2014-01-13	AOM	ETF	34.4	34.4	34.15	34.17	168830.0
2014-01-13	AOR	ETF	38.51	38.52	38.2101	38.25	49973.0
2014-01-13	ARGT	ETF	19.27	19.27	19.0	19.0	5000.0
2014-01-13	ASEA	ETF	15.41	15.43	15.17	15.25	4400.0
2014-01-13	ASHR	ETF	23.17	23.23	23.01	23.04	122100.0
2014-01-13	ATMP	ETF	26.82	26.84	26.67	26.67	12300.0
2014-01-13	AVIV	ETF	24.09	24.304	23.71	23.85	77058.0
2014-01-13	AWAY	ETF	42.37	42.55	39.61	40.2	1385461.0
2014-01-13	BAB	ETF	27.69	27.79	27.69	27.75	94329.0
2014-01-13	BAL	ETF	52.0475	53.0	51.931	52.61	2771.0
2014-01-13	BALT	ETF	6.17	6.22	5.81	5.89	1343399.0
2014-01-13	BBH	ETF	93.07	93.53	90.4	90.96	179400.0
2014-01-13	BCM	ETF	38.84	38.95	38.27	38.89	65340.0
2014-01-13	BFOR	ETF	7.445	7.445	7.2975	7.3225	263200.0
2014-01-13	BIB	ETF	42.9775	43.085	39.9402	40.525	646708.0
2014-01-13	BICK	ETF	23.83	23.92	23.83	23.92	1150.0
2014-01-13	BIL	ETF	91.56	91.56	91.54	91.56	173550.0
2014-01-13	BIS	ETF	737.6	771.6	722.04	766.0	1195.0
2014-01-13	BIV	ETF	82.64	82.82	82.64	82.71	295500.0
2014-01-13	BIZD	ETF	21.11	21.14	20.94	20.97	16900.0
2014-01-13	BJK	ETF	54.64	54.74	53.92	53.96	26700.0
2014-01-13	BKF	ETF	36.41	36.46	35.89	35.94	44173.0
2014-01-13	BKLN	ETF	24.98	24.99	24.97	24.99	2223000.0
2014-01-13	BLV	ETF	83.38	83.79	83.38	83.66	39700.0

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

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