PREVIEW / etf_daily / 2013-09-10

all etf daily files

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

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-09-10	SPY	ETF	168.64	168.9	168.26	168.87	105847200.0
2013-09-10	QQQ	ETF	78.27	78.32	77.92	78.21	27619372.0
2013-09-10	IWM	ETF	104.58	104.98	104.2	104.96	25126300.0
2013-09-10	DIA	ETF	151.47	151.82	151.1	151.79	7917100.0
2013-09-10	GLD	ETF	131.82	132.0	131.11	131.74	8433100.0
2013-09-10	TLT	ETF	102.73	103.34	102.36	102.38	8069000.0
2013-09-10	AADR	ETF	34.75	35.09	34.75	34.84	26600.0
2013-09-10	AAXJ	ETF	58.75	58.98	58.59	58.8	4354400.0
2013-09-10	ACTV	ETF	9.88	10.1	9.72	10.08	348044.0
2013-09-10	ACWI	ETF	53.4	53.47	53.24	53.46	839700.0
2013-09-10	ACWV	ETF	61.39	61.39	61.12	61.31	37600.0
2013-09-10	ACWX	ETF	44.3	44.3599	44.1736	44.34	230681.0
2013-09-10	ADRE	ETF	37.38	37.53	37.35	37.5	8427.0
2013-09-10	AFK	ETF	29.09	29.599	29.07	29.4	30637.0
2013-09-10	AGEM	ETF	22.24	22.49	22.24	22.39	33463.0
2013-09-10	AGG	ETF	105.34	105.48	105.25	105.3	628400.0
2013-09-10	AGQ	ETF	91.6	92.16	89.88	91.08	554875.0
2013-09-10	AGZ	ETF	110.02	110.1299	109.895	109.9	12890.0
2013-09-10	AIA	ETF	47.21	47.21	47.0129	47.1	33869.0
2013-09-10	AIQ	ETF	24.89	25.067	24.61	24.81	56650.0
2013-09-10	AIVI	ETF	44.36	44.49	44.25	44.44	45300.0
2013-09-10	ALTL	ETF	29.9409	29.9409	29.92	29.92	1700.0
2013-09-10	AMJ	ETF	44.74	45.17	44.15	45.17	522987.0
2013-09-10	AMLP	ETF	87.1	87.65	86.95	87.55	526780.0
2013-09-10	ANGL	ETF	26.26	26.26	26.2	26.26	2500.0
2013-09-10	AOA	ETF	41.59	41.64	41.48	41.63	10000.0
2013-09-10	AOK	ETF	31.0	31.05	31.0	31.046	44323.0
2013-09-10	AOM	ETF	32.95	33.0	32.94	32.97	45376.0
2013-09-10	AOR	ETF	36.48	36.52	36.4416	36.49	19479.0
2013-09-10	ARB	ETF	47.48	47.56	47.41	47.55	365526.0
2013-09-10	ARGT	ETF	19.44	19.71	19.44	19.71	10400.0
2013-09-10	ASEA	ETF	16.33	16.38	16.31	16.35	37400.0
2013-09-10	ATMP	ETF	25.97	26.06	25.96	26.03	78800.0
2013-09-10	AVIV	ETF	22.28	22.51	22.2	22.31	117784.0
2013-09-10	AWAY	ETF	32.21	32.49	31.75	31.94	830710.0
2013-09-10	BAB	ETF	26.9	27.03	26.86	26.88	146299.0
2013-09-10	BAL	ETF	53.6299	54.01	53.59	54.009	7342.0
2013-09-10	BALT	ETF	5.63	5.705	5.28	5.51	941812.0
2013-09-10	BBH	ETF	83.17	83.17	81.88	82.45	137800.0
2013-09-10	BCM	ETF	40.9499	40.9999	40.9499	40.9999	1463.0
2013-09-10	BFOR	ETF	6.725	6.725	6.68	6.6975	477200.0
2013-09-10	BIB	ETF	32.165	32.175	31.3287	31.75	213428.0
2013-09-10	BICK	ETF	23.62	23.68	23.62	23.67	1231.0
2013-09-10	BIL	ETF	91.6	91.6	91.58	91.58	275950.0
2013-09-10	BIS	ETF	1052.4	1069.44	1047.6	1055.204	22.5
2013-09-10	BIV	ETF	81.5	81.67	81.41	81.41	215100.0
2013-09-10	BIZD	ETF	20.23	20.46	20.23	20.45	8600.0
2013-09-10	BJK	ETF	45.97	46.24	45.97	46.09	38100.0
2013-09-10	BKF	ETF	37.52	37.61	37.32	37.51	127412.0
2013-09-10	BKLN	ETF	24.74	24.81	24.74	24.8	2520700.0

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

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