PREVIEW / etf_daily / 2014-01-22

all etf daily files

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

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-22	SPY	ETF	184.49	184.57	183.91	184.3	61270900.0
2014-01-22	QQQ	ETF	88.75	89.0	88.52	88.78	29425432.0
2014-01-22	IWM	ETF	116.69	117.37	116.5	117.21	24011500.0
2014-01-22	DIA	ETF	163.76	163.8	162.99	163.47	5418100.0
2014-01-22	GLD	ETF	119.65	119.77	119.17	119.19	4891800.0
2014-01-22	TLT	ETF	105.37	105.75	105.24	105.3	4646700.0
2014-01-22	AADR	ETF	37.69	37.69	37.35	37.68	1700.0
2014-01-22	AAXJ	ETF	58.35	58.67	58.2	58.66	340100.0
2014-01-22	ACWI	ETF	57.32	57.42	57.2	57.36	1396200.0
2014-01-22	ACWV	ETF	63.42	63.42	62.82	63.03	64600.0
2014-01-22	ACWX	ETF	46.1	46.19	46.03	46.15	969265.0
2014-01-22	ADRE	ETF	35.61	35.81	35.6	35.8	11321.0
2014-01-22	AFK	ETF	31.24	31.3299	31.0475	31.26	68321.0
2014-01-22	AGG	ETF	107.11	107.24	107.02	107.07	892900.0
2014-01-22	AGQ	ETF	65.64	65.88	64.84	64.88	304525.0
2014-01-22	AGZ	ETF	111.3199	111.3199	110.971	111.0599	11236.0
2014-01-22	AGZD	ETF	25.02	25.055	25.01	25.055	72400.0
2014-01-22	AIA	ETF	46.11	46.29	45.98	46.26	57789.0
2014-01-22	AIQ	ETF	27.5	28.41	27.35	27.77	46415.0
2014-01-22	AIVI	ETF	47.58	47.67	47.5	47.59	42400.0
2014-01-22	AMJ	ETF	45.87	46.38	45.87	46.37	584887.0
2014-01-22	AMLP	ETF	88.25	88.65	88.2	88.6	523260.0
2014-01-22	ANGL	ETF	27.3	27.3	27.16	27.3	3200.0
2014-01-22	AOA	ETF	44.72	44.72	44.56	44.7	86600.0
2014-01-22	AOK	ETF	32.16	32.16	32.09	32.1	29003.0
2014-01-22	AOM	ETF	34.47	34.47	34.4	34.4	46944.0
2014-01-22	AOR	ETF	38.55	38.63	38.55	38.61	48161.0
2014-01-22	ARGT	ETF	19.75	19.75	19.15	19.15	4400.0
2014-01-22	ASEA	ETF	15.05	15.2	15.04	15.19	22100.0
2014-01-22	ASHR	ETF	23.5	23.79	23.5	23.79	353700.0
2014-01-22	ATMP	ETF	27.22	27.28	27.19	27.28	10300.0
2014-01-22	AVIV	ETF	24.61	24.8	24.39	24.52	68056.0
2014-01-22	AWAY	ETF	41.72	43.32	41.7	43.05	1040923.0
2014-01-22	BAB	ETF	27.83	27.8399	27.73	27.755	92238.0
2014-01-22	BAL	ETF	54.89	55.39	54.89	55.2631	15647.0
2014-01-22	BALT	ETF	6.03	6.1	5.92	5.95	943756.0
2014-01-22	BBH	ETF	99.08	99.21	98.09	98.99	197000.0
2014-01-22	BCM	ETF	39.04	39.129	39.0	39.08	294962.0
2014-01-22	BFOR	ETF	7.4475	7.475	7.4225	7.4675	224800.0
2014-01-22	BIB	ETF	47.225	47.25	46.1302	46.9375	573632.0
2014-01-22	BICK	ETF	23.88	24.0292	23.88	24.0292	489.0
2014-01-22	BIL	ETF	91.54	91.56	91.54	91.56	154400.0
2014-01-22	BIS	ETF	659.112	670.4	652.0	658.0	1424.0
2014-01-22	BIV	ETF	82.59	82.73	82.56	82.61	256100.0
2014-01-22	BIZD	ETF	21.33	21.47	21.33	21.47	1100.0
2014-01-22	BJK	ETF	54.07	54.07	53.11	53.67	53300.0
2014-01-22	BKF	ETF	36.19	36.49	36.1	36.47	65216.0
2014-01-22	BKLN	ETF	24.93	24.94	24.93	24.94	1729900.0
2014-01-22	BLNG	ETF	35.11	35.11	35.08	35.08	300.0
2014-01-22	BLV	ETF	84.06	84.24	83.8	83.85	58700.0

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

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