PREVIEW / etf_daily / 2014-06-03

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-03.parquet
  size:    45 KB
  rows:    1,096

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-06-03	SPY	ETF	192.43	192.9	192.25	192.8	65047000.0
2014-06-03	QQQ	ETF	90.91	91.33	90.8	91.18	21783686.0
2014-06-03	IWM	ETF	111.64	112.36	111.11	111.98	31143700.0
2014-06-03	DIA	ETF	166.94	167.2	166.75	167.02	4125200.0
2014-06-03	GLD	ETF	119.73	120.09	119.42	120.01	5008300.0
2014-06-03	TLT	ETF	112.41	112.54	111.51	111.57	12694100.0
2014-06-03	AADR	ETF	38.49	38.49	38.48	38.48	400.0
2014-06-03	AAXJ	ETF	62.06	62.58	62.06	62.48	440500.0
2014-06-03	ACWI	ETF	60.01	60.25	59.89	60.25	798400.0
2014-06-03	ACWV	ETF	66.55	66.69	66.4	66.69	27700.0
2014-06-03	ACWX	ETF	48.08	48.26	48.08	48.24	326179.0
2014-06-03	ADRE	ETF	37.85	37.993	37.78	37.993	5614.0
2014-06-03	AFK	ETF	33.03	33.0899	32.75	32.8305	113347.0
2014-06-03	AGG	ETF	109.02	109.04	108.78	108.84	864600.0
2014-06-03	AGQ	ETF	57.3	57.44	56.87	57.43	167700.0
2014-06-03	AGZ	ETF	112.29	112.43	112.23	112.2391	7335.0
2014-06-03	AGZD	ETF	24.975	25.03	24.975	25.01	26000.0
2014-06-03	AIA	ETF	48.55	48.845	48.55	48.78	33185.0
2014-06-03	AIQ	ETF	29.74	29.96	28.7	29.26	23673.0
2014-06-03	AIRR	ETF	18.81	19.21	18.6	18.67	5200.0
2014-06-03	AIVI	ETF	51.05	51.08	50.9	51.03	83700.0
2014-06-03	ALTL	ETF	34.7499	34.7499	34.7	34.7	496.0
2014-06-03	AMJ	ETF	49.84	49.99	49.572	49.7	410125.0
2014-06-03	AMLP	ETF	91.7	91.9	91.45	91.55	628280.0
2014-06-03	ANGL	ETF	28.11	28.11	28.11	28.11	400.0
2014-06-03	AOA	ETF	46.25	46.3	46.19	46.29	12400.0
2014-06-03	AOK	ETF	32.77	32.77	32.7	32.74	59832.0
2014-06-03	AOM	ETF	35.31	35.31	35.2597	35.29	23600.0
2014-06-03	AOR	ETF	39.69	39.83	39.69	39.82	45256.0
2014-06-03	ARGT	ETF	20.17	20.17	20.03	20.1	3700.0
2014-06-03	ASEA	ETF	16.68	16.77	16.68	16.77	9900.0
2014-06-03	ASHR	ETF	21.97	22.14	21.95	22.09	50500.0
2014-06-03	ASHS	ETF	25.52	25.67	25.52	25.67	13200.0
2014-06-03	ATMP	ETF	29.76	30.0	29.76	29.85	13100.0
2014-06-03	AVIV	ETF	27.9	28.37	27.78	28.34	207102.0
2014-06-03	AWAY	ETF	30.44	30.87	30.19	30.41	1231424.0
2014-06-03	BAB	ETF	29.38	29.38	29.23	29.26	92585.0
2014-06-03	BAL	ETF	54.29	54.29	53.21	53.85	11758.0
2014-06-03	BALT	ETF	6.28	6.28	6.07	6.23	935995.0
2014-06-03	BBH	ETF	90.45	91.7	90.37	91.67	68700.0
2014-06-03	BCHP	ETF	20.4	20.4	20.4	20.4	228.0
2014-06-03	BCM	ETF	40.67	40.68	40.644	40.644	6155.0
2014-06-03	BFOR	ETF	7.555	7.5825	7.5325	7.575	58000.0
2014-06-03	BIB	ETF	39.71	40.79	39.575	40.785	242342.0
2014-06-03	BICK	ETF	25.79	25.8099	25.69	25.71	6278.0
2014-06-03	BIL	ETF	91.52	91.54	91.52	91.52	135950.0
2014-06-03	BIS	ETF	669.6	670.8	651.2	651.996	7222.0
2014-06-03	BIV	ETF	84.38	84.38	84.13	84.17	164300.0
2014-06-03	BIZD	ETF	19.82	19.82	19.63	19.82	15000.0
2014-06-03	BJK	ETF	49.63	49.63	49.19	49.52	39800.0

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

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