PREVIEW / etf_daily / 2013-10-10

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-10.parquet
  size:    42 KB
  rows:    1,035

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-10-10	SPY	ETF	167.29	169.26	167.23	169.17	195955000.0
2013-10-10	QQQ	ETF	77.8	78.79	77.79	78.61	48062722.0
2013-10-10	IWM	ETF	105.01	106.31	104.92	106.14	53157800.0
2013-10-10	DIA	ETF	149.14	151.01	149.09	150.96	12792200.0
2013-10-10	GLD	ETF	125.34	125.83	124.1	124.27	10523600.0
2013-10-10	TLT	ETF	104.8	105.53	104.51	105.49	9944100.0
2013-10-10	AADR	ETF	35.28	35.56	35.28	35.56	2700.0
2013-10-10	AAXJ	ETF	60.17	60.8	60.08	60.76	738100.0
2013-10-10	ACTV	ETF	14.39	14.39	14.36	14.36	1005947.0
2013-10-10	ACWI	ETF	53.89	54.49	53.81	54.43	718500.0
2013-10-10	ACWV	ETF	61.75	62.19	61.63	62.18	22200.0
2013-10-10	ACWX	ETF	44.9	45.47	44.87	45.39	173549.0
2013-10-10	ADRE	ETF	37.42	37.78	37.42	37.78	11799.0
2013-10-10	AFK	ETF	30.59	30.5965	30.28	30.48	27570.0
2013-10-10	AGG	ETF	106.84	107.08	106.75	107.03	2191900.0
2013-10-10	AGQ	ETF	81.76	82.2	79.48	79.48	440725.0
2013-10-10	AGZ	ETF	111.47	111.47	110.83	110.97	12287.0
2013-10-10	AIA	ETF	47.54	48.029	47.54	47.95	15642.0
2013-10-10	AIQ	ETF	26.54	28.47	26.54	27.98	50471.0
2013-10-10	AIVI	ETF	45.47	46.0	45.47	45.97	28300.0
2013-10-10	ALTL	ETF	30.1	30.2	30.02	30.11	34700.0
2013-10-10	AMJ	ETF	44.34	44.44	43.8912	44.09	374752.0
2013-10-10	AMLP	ETF	87.55	87.9	86.85	87.05	580780.0
2013-10-10	ANGL	ETF	26.18	26.5	26.18	26.5	600.0
2013-10-10	AOA	ETF	41.81	42.14	41.8	42.14	31300.0
2013-10-10	AOK	ETF	31.24	31.378	31.24	31.37	34273.0
2013-10-10	AOM	ETF	33.12	33.3299	33.12	33.28	36687.0
2013-10-10	AOR	ETF	36.66	36.9	36.656	36.9	30865.0
2013-10-10	ARGT	ETF	19.86	19.98	19.86	19.96	6800.0
2013-10-10	ASEA	ETF	16.82	17.13	16.82	17.1	36200.0
2013-10-10	ATMP	ETF	25.99	26.02	25.8	25.88	10000.0
2013-10-10	AVIV	ETF	23.08	23.32	23.03	23.14	95261.0
2013-10-10	AWAY	ETF	28.75	29.88	28.66	29.38	996319.0
2013-10-10	BAB	ETF	27.32	27.452	27.29	27.39	162638.0
2013-10-10	BAL	ETF	53.48	53.48	53.1701	53.1701	2195.0
2013-10-10	BALT	ETF	4.82	5.18	4.82	5.12	945925.0
2013-10-10	BBH	ETF	77.36	78.56	77.19	78.48	178500.0
2013-10-10	BFOR	ETF	6.7675	6.8275	6.7475	6.8225	387600.0
2013-10-10	BIB	ETF	29.2325	30.2125	29.125	30.1975	762804.0
2013-10-10	BICK	ETF	24.5	24.5	24.5	24.5	400.0
2013-10-10	BIL	ETF	91.56	91.58	91.56	91.56	939600.0
2013-10-10	BIS	ETF	1124.8	1125.6	1082.4	1082.8	1233.5
2013-10-10	BIV	ETF	83.15	83.28	83.03	83.28	201600.0
2013-10-10	BIZD	ETF	20.14	20.23	20.12	20.18	8300.0
2013-10-10	BJK	ETF	48.31	48.7	48.31	48.66	19900.0
2013-10-10	BKF	ETF	38.5	38.8	38.46	38.76	82315.0
2013-10-10	BKLN	ETF	24.7	24.73	24.69	24.71	1712700.0
2013-10-10	BLV	ETF	82.3	82.77	82.16	82.7	21700.0
2013-10-10	BMVP	ETF	20.1967	20.4729	20.1967	20.4637	5920.0
2013-10-10	BND	ETF	80.52	80.68	80.49	80.65	899700.0

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

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