PREVIEW / etf_daily / 2013-06-11

all etf daily files

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

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-11	SPY	ETF	163.3	164.54	162.74	163.1	159505400.0
2013-06-11	QQQ	ETF	72.67	73.34	72.44	72.69	40281421.0
2013-06-11	IWM	ETF	97.68	98.47	96.86	97.73	43461300.0
2013-06-11	DIA	ETF	151.08	152.42	150.7	151.2	7012500.0
2013-06-11	GLD	ETF	132.31	133.51	132.24	133.25	7199300.0
2013-06-11	TLT	ETF	112.27	113.96	112.12	113.96	12841200.0
2013-06-11	AADR	ETF	33.61	33.65	33.23	33.38	24300.0
2013-06-11	AAXJ	ETF	55.81	56.22	55.63	55.89	378600.0
2013-06-11	ACTV	ETF	7.46	7.5	7.28	7.3	416204.0
2013-06-11	ACWI	ETF	51.41	51.8	51.25	51.45	1596600.0
2013-06-11	ACWV	ETF	60.62	60.86	60.4	60.59	57200.0
2013-06-11	ACWX	ETF	42.2	42.54	42.04	42.27	562289.0
2013-06-11	ADRE	ETF	35.85	36.05	35.65	35.84	45188.0
2013-06-11	AFK	ETF	29.02	29.24	28.91	29.04	123602.0
2013-06-11	AGEM	ETF	20.799	20.8716	20.7204	20.8011	13049.0
2013-06-11	AGG	ETF	108.19	108.45	108.0	108.4	1118700.0
2013-06-11	AGQ	ETF	83.12	85.04	82.72	84.12	354825.0
2013-06-11	AGZ	ETF	112.36	112.36	111.72	111.9572	16647.0
2013-06-11	AIA	ETF	43.5	43.83	43.42	43.6	39442.0
2013-06-11	AIQ	ETF	15.65	16.18	15.601	16.15	24359.0
2013-06-11	AIVI	ETF	42.21	42.51	42.15	42.36	33500.0
2013-06-11	AMJ	ETF	46.27	47.39	45.8824	46.27	1454470.0
2013-06-11	AMLP	ETF	87.6	88.0	87.0	87.0	537700.0
2013-06-11	ANGL	ETF	26.92	27.01	26.82	27.01	1000.0
2013-06-11	AOA	ETF	40.32	40.54	40.2	40.31	30000.0
2013-06-11	AOK	ETF	30.96	31.076	30.9501	31.04	14916.0
2013-06-11	AOM	ETF	32.72	32.8299	32.699	32.75	55570.0
2013-06-11	AOR	ETF	35.88	36.03	35.7784	35.87	29612.0
2013-06-11	ARB	ETF	46.86	46.99	46.85	46.9	148526.0
2013-06-11	ARGT	ETF	17.62	17.62	17.31	17.32	1400.0
2013-06-11	ASEA	ETF	16.8	16.9	16.7	16.79	76800.0
2013-06-11	ATMP	ETF	25.47	25.47	25.2	25.22	228600.0
2013-06-11	AVIV	ETF	26.6	26.75	26.3	26.48	173612.0
2013-06-11	AWAY	ETF	29.53	30.1	29.18	29.58	313578.0
2013-06-11	BAB	ETF	29.4	29.5448	29.38	29.51	726707.0
2013-06-11	BAL	ETF	54.34	56.1	54.28	54.64	23883.0
2013-06-11	BALT	ETF	3.5	3.53	3.46	3.51	72578.0
2013-06-11	BBH	ETF	69.66	70.76	69.12	70.1	38700.0
2013-06-11	BCM	ETF	40.18	40.36	40.18	40.36	11004.0
2013-06-11	BFOR	ETF	6.25	6.275	6.2	6.23	800000.0
2013-06-11	BIB	ETF	23.395	24.4175	23.1875	23.93	124392.0
2013-06-11	BICK	ETF	22.12	22.2287	22.05	22.181	4120.0
2013-06-11	BIL	ETF	91.62	91.62	91.6	91.62	160350.0
2013-06-11	BIS	ETF	1500.0	1510.4	1448.44	1478.8	662.0
2013-06-11	BIV	ETF	85.06	85.4	85.03	85.3	415100.0
2013-06-11	BIZD	ETF	19.85	19.97	19.7	19.7	7100.0
2013-06-11	BJK	ETF	41.69	41.85	41.59	41.62	2400.0
2013-06-11	BKF	ETF	35.72	36.05	35.61	35.81	176124.0
2013-06-11	BKLN	ETF	24.95	24.98	24.92	24.97	2528400.0
2013-06-11	BLV	ETF	87.04	87.93	86.85	87.85	56000.0

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

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