PREVIEW / etf_daily / 2013-06-12

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-12.parquet
  size:    41 KB
  rows:    1,001

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-06-12	SPY	ETF	164.22	164.39	161.6	161.75	177361500.0
2013-06-12	QQQ	ETF	73.12	73.14	71.74	71.85	42081831.0
2013-06-12	IWM	ETF	98.33	98.48	96.63	96.76	58446900.0
2013-06-12	DIA	ETF	152.18	152.35	149.7	149.86	6901000.0
2013-06-12	GLD	ETF	132.95	134.83	132.83	134.25	6550600.0
2013-06-12	TLT	ETF	113.0	113.83	112.27	112.33	10193200.0
2013-06-12	AADR	ETF	33.52	33.52	33.47	33.47	500.0
2013-06-12	AAXJ	ETF	56.04	56.21	55.46	55.68	638700.0
2013-06-12	ACTV	ETF	7.36	7.49	7.3	7.46	271908.0
2013-06-12	ACWI	ETF	51.93	51.94	51.15	51.2	1377900.0
2013-06-12	ACWV	ETF	60.89	61.16	60.18	60.29	101500.0
2013-06-12	ACWX	ETF	42.71	42.74	42.13	42.19	203947.0
2013-06-12	ADRE	ETF	36.0	36.0	35.305	35.35	29760.0
2013-06-12	AFK	ETF	29.19	29.19	28.58	28.58	38052.0
2013-06-12	AGEM	ETF	20.701	20.701	20.5523	20.5523	2912.0
2013-06-12	AGG	ETF	108.33	108.5	108.2	108.22	1469500.0
2013-06-12	AGQ	ETF	84.32	86.8	83.96	84.72	271900.0
2013-06-12	AGZ	ETF	112.19	112.19	111.86	111.86	18189.0
2013-06-12	AIA	ETF	43.71	43.82	43.23	43.44	69213.0
2013-06-12	AIQ	ETF	16.25	16.68	16.0	16.15	23241.0
2013-06-12	AIVI	ETF	42.82	42.93	42.3	42.31	45700.0
2013-06-12	AMJ	ETF	46.25	46.57	45.49	45.97	874183.0
2013-06-12	AMLP	ETF	87.2	87.45	86.85	87.2	528680.0
2013-06-12	ANGL	ETF	27.05	27.05	26.84	27.05	2800.0
2013-06-12	AOA	ETF	40.57	40.57	40.08	40.08	27800.0
2013-06-12	AOK	ETF	31.12	31.12	30.93	30.95	21635.0
2013-06-12	AOM	ETF	32.87	32.87	32.59	32.63	24336.0
2013-06-12	AOR	ETF	36.07	36.15	35.7	35.71	135022.0
2013-06-12	ARB	ETF	46.99	46.99	46.7999	46.84	99021.0
2013-06-12	ARGT	ETF	17.29	17.29	17.29	17.29	1200.0
2013-06-12	ASEA	ETF	16.99	16.99	16.65	16.67	93700.0
2013-06-12	ATMP	ETF	25.49	25.49	25.29	25.4	104800.0
2013-06-12	AVIV	ETF	26.66	26.66	25.77	26.03	202539.0
2013-06-12	AWAY	ETF	29.69	30.23	29.23	29.49	351543.0
2013-06-12	BAB	ETF	29.33	29.43	28.63	28.7364	474120.0
2013-06-12	BAL	ETF	54.64	56.4899	54.43	56.3599	12528.0
2013-06-12	BALT	ETF	3.55	3.6299	3.49	3.49	132701.0
2013-06-12	BBH	ETF	70.61	70.78	68.55	68.55	92200.0
2013-06-12	BFOR	ETF	6.3075	6.3075	6.1775	6.1875	899600.0
2013-06-12	BIB	ETF	24.165	24.3747	22.96	22.975	276136.0
2013-06-12	BICK	ETF	22.1	22.2101	21.88	21.94	7801.0
2013-06-12	BIL	ETF	91.62	91.62	91.6	91.6	490050.0
2013-06-12	BIS	ETF	1452.0	1535.6	1440.404	1530.8	758.5
2013-06-12	BIV	ETF	85.25	85.43	85.06	85.1	258700.0
2013-06-12	BIZD	ETF	19.79	19.79	19.46	19.48	20200.0
2013-06-12	BJK	ETF	41.95	41.95	41.5	41.54	3100.0
2013-06-12	BKF	ETF	35.98	35.99	35.43	35.52	135184.0
2013-06-12	BKLN	ETF	24.94	24.94	24.87	24.94	3694100.0
2013-06-12	BLV	ETF	87.7	88.02	87.14	87.14	35500.0
2013-06-12	BMVP	ETF	19.16	19.16	19.04	19.04	1498.0

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

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