PREVIEW / etf_daily / 2013-04-24

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-24.parquet
  size:    40 KB
  rows:    989

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-04-24	SPY	ETF	157.83	158.3	157.54	157.88	96781200.0
2013-04-24	QQQ	ETF	69.26	69.67	69.12	69.42	44500627.0
2013-04-24	IWM	ETF	92.29	92.86	91.93	92.79	41020800.0
2013-04-24	DIA	ETF	147.02	147.21	146.39	146.45	4963800.0
2013-04-24	GLD	ETF	138.09	138.55	137.45	138.37	10369300.0
2013-04-24	TLT	ETF	122.47	122.82	122.3	122.8	3673600.0
2013-04-24	AAXJ	ETF	58.58	59.07	58.58	58.93	247200.0
2013-04-24	ACTV	ETF	4.86	5.18	4.86	5.14	593492.0
2013-04-24	ACWI	ETF	51.24	51.46	51.15	51.32	224300.0
2013-04-24	ACWV	ETF	62.9	63.11	62.75	62.88	81200.0
2013-04-24	ACWX	ETF	43.18	43.48	43.18	43.41	180541.0
2013-04-24	ADRE	ETF	38.15	38.42	38.111	38.391	35154.0
2013-04-24	AFK	ETF	28.88	29.24	28.88	29.24	161400.0
2013-04-24	AGEM	ETF	22.0716	22.1046	22.0716	22.1046	374.0
2013-04-24	AGG	ETF	111.28	111.38	111.26	111.31	743900.0
2013-04-24	AGQ	ETF	97.28	98.32	95.0	97.8	349775.0
2013-04-24	AGZ	ETF	113.64	113.7699	113.61	113.708	7610.0
2013-04-24	AIA	ETF	45.55	45.82	45.55	45.7	36288.0
2013-04-24	AIQ	ETF	10.22	10.81	10.22	10.65	17518.0
2013-04-24	AIVI	ETF	43.07	43.38	43.02	43.22	238200.0
2013-04-24	ALTL	ETF	29.2934	29.2934	29.2934	29.2934	102.0
2013-04-24	AMJ	ETF	47.06	48.64	46.86	47.931	2164127.0
2013-04-24	AMLP	ETF	89.45	89.7	89.3	89.35	699280.0
2013-04-24	ANGL	ETF	27.57	27.75	27.5	27.5	1900.0
2013-04-24	AOA	ETF	39.92	40.06	39.9	39.99	35900.0
2013-04-24	AOK	ETF	31.33	31.417	31.33	31.4	24711.0
2013-04-24	AOM	ETF	32.94	32.9899	32.906	32.98	22917.0
2013-04-24	AOR	ETF	35.77	35.9	35.76	35.82	32142.0
2013-04-24	ARB	ETF	46.72	46.83	46.68	46.74	120690.0
2013-04-24	ARGT	ETF	16.8	16.94	16.8	16.94	1650.0
2013-04-24	ASEA	ETF	17.95	18.06	17.95	18.04	14400.0
2013-04-24	ATMP	ETF	26.4	26.59	26.4	26.47	159200.0
2013-04-24	AVIV	ETF	25.0	25.48	24.87	25.26	310048.0
2013-04-24	AWAY	ETF	31.21	33.0	31.15	32.02	4091280.0
2013-04-24	BAB	ETF	30.81	30.92	30.81	30.9	216980.0
2013-04-24	BAL	ETF	53.0	53.0	52.13	52.13	76131.0
2013-04-24	BALT	ETF	3.4199	3.43	3.35	3.43	22897.0
2013-04-24	BBH	ETF	71.21	71.21	68.91	69.02	286900.0
2013-04-24	BCM	ETF	39.931	40.05	39.931	40.05	3028.0
2013-04-24	BIB	ETF	23.2475	23.2475	21.9125	21.9125	465468.0
2013-04-24	BICK	ETF	23.68	23.7	23.6	23.69	2573.0
2013-04-24	BIL	ETF	91.62	91.62	91.6	91.62	159900.0
2013-04-24	BIS	ETF	1580.8	1670.4	1580.8	1670.4	435.5
2013-04-24	BIV	ETF	88.52	88.58	88.47	88.52	146700.0
2013-04-24	BIZD	ETF	20.25	20.25	20.09	20.2	28800.0
2013-04-24	BJK	ETF	40.5	40.85	40.5	40.84	8700.0
2013-04-24	BKF	ETF	38.34	38.76	38.3	38.65	129482.0
2013-04-24	BKLN	ETF	25.13	25.14	25.13	25.14	4902600.0
2013-04-24	BLV	ETF	94.35	94.5	94.15	94.42	42500.0
2013-04-24	BMVP	ETF	18.63	18.63	18.58	18.58	3813.0

> showing 50 of 989 rows — these rows as CSV

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