PREVIEW / etf_daily / 2013-08-06

all etf daily files

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

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-08-06	SPY	ETF	170.37	170.74	169.35	169.73	87495000.0
2013-08-06	QQQ	ETF	76.92	76.99	76.25	76.56	23680564.0
2013-08-06	IWM	ETF	105.22	105.32	104.15	104.46	24689300.0
2013-08-06	DIA	ETF	155.37	155.38	154.41	154.85	3582300.0
2013-08-06	GLD	ETF	124.33	124.55	123.55	123.97	6016200.0
2013-08-06	TLT	ETF	105.53	106.01	105.34	106.01	4589000.0
2013-08-06	AADR	ETF	33.96	34.21	33.96	34.21	1200.0
2013-08-06	AAXJ	ETF	56.0	56.03	55.59	55.77	480600.0
2013-08-06	ACTV	ETF	11.25	11.25	9.94	9.95	1518423.0
2013-08-06	ACWI	ETF	53.06	53.11	52.69	52.79	2080000.0
2013-08-06	ACWV	ETF	62.32	62.32	61.95	62.12	83700.0
2013-08-06	ACWX	ETF	43.33	43.369	43.01	43.11	532164.0
2013-08-06	ADRE	ETF	35.5	35.55	35.22	35.24	11422.0
2013-08-06	AFK	ETF	29.63	29.63	29.121	29.17	26772.0
2013-08-06	AGG	ETF	106.85	106.9	106.75	106.79	595700.0
2013-08-06	AGQ	ETF	67.56	67.64	66.6	66.72	292900.0
2013-08-06	AGZ	ETF	110.991	111.15	110.971	111.05	16070.0
2013-08-06	AIA	ETF	43.95	43.97	43.7101	43.76	57630.0
2013-08-06	AIQ	ETF	20.39	20.85	20.0	20.7	289382.0
2013-08-06	AIVI	ETF	42.72	42.76	42.43	42.58	20100.0
2013-08-06	ALTL	ETF	30.27	30.27	30.27	30.27	2000.0
2013-08-06	AMJ	ETF	46.6	47.056	46.22	46.84	557399.0
2013-08-06	AMLP	ETF	89.05	90.0	88.85	89.75	663880.0
2013-08-06	ANGL	ETF	26.92	26.92	26.31	26.31	77600.0
2013-08-06	AOA	ETF	41.8	41.8	41.55	41.63	26200.0
2013-08-06	AOK	ETF	31.25	31.25	31.17	31.18	40912.0
2013-08-06	AOM	ETF	33.19	33.19	33.03	33.12	54501.0
2013-08-06	AOR	ETF	36.7	36.7	36.55	36.5871	16438.0
2013-08-06	ARB	ETF	45.94	46.16	45.94	46.09	109954.0
2013-08-06	ARGT	ETF	17.6	17.64	17.59	17.64	3400.0
2013-08-06	ASEA	ETF	17.02	17.02	16.88	16.89	34000.0
2013-08-06	ATMP	ETF	26.34	26.75	26.34	26.73	16500.0
2013-08-06	AVIV	ETF	24.76	24.93	24.51	24.79	168423.0
2013-08-06	AWAY	ETF	30.11	30.6399	30.0077	30.41	1055538.0
2013-08-06	BAB	ETF	27.68	27.76	27.6101	27.65	283145.0
2013-08-06	BAL	ETF	54.45	54.85	54.4477	54.85	963.0
2013-08-06	BALT	ETF	3.86	4.09	3.832	4.0	129067.0
2013-08-06	BBH	ETF	80.14	80.14	78.4	78.57	104700.0
2013-08-06	BFOR	ETF	6.725	6.725	6.6425	6.6625	176800.0
2013-08-06	BIB	ETF	30.0725	30.0725	28.7712	28.815	152732.0
2013-08-06	BICK	ETF	21.73	21.73	21.59	21.6341	1447.0
2013-08-06	BIL	ETF	91.6	91.6	91.58	91.6	89300.0
2013-08-06	BIS	ETF	1145.204	1188.4	1145.204	1188.4	316.5
2013-08-06	BIV	ETF	83.16	83.27	83.14	83.25	215700.0
2013-08-06	BIZD	ETF	20.46	20.46	20.25	20.33	23900.0
2013-08-06	BJK	ETF	42.88	42.88	42.66	42.66	1700.0
2013-08-06	BKF	ETF	34.69	34.7	34.3245	34.42	65592.0
2013-08-06	BKLN	ETF	24.92	24.92	24.88	24.9	3902700.0
2013-08-06	BLV	ETF	83.12	83.24	82.86	83.12	42400.0
2013-08-06	BMVP	ETF	20.1196	20.1543	20.1037	20.1037	731.0

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

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