PREVIEW / etf_daily / 2013-09-23

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-23.parquet
  size:    41 KB
  rows:    1,016

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-23	SPY	ETF	170.49	170.65	169.39	169.93	104616500.0
2013-09-23	QQQ	ETF	79.34	79.41	78.455	78.83	30319396.0
2013-09-23	IWM	ETF	106.72	106.87	105.8	106.6	47759700.0
2013-09-23	DIA	ETF	154.11	154.32	153.32	153.71	8662000.0
2013-09-23	GLD	ETF	127.52	128.44	127.33	127.55	7421800.0
2013-09-23	TLT	ETF	105.21	105.73	105.11	105.69	10242100.0
2013-09-23	AADR	ETF	36.19	36.19	35.82	35.83	3300.0
2013-09-23	AAXJ	ETF	59.69	60.03	59.63	59.87	556200.0
2013-09-23	ACTV	ETF	10.6	10.65	10.36	10.43	329862.0
2013-09-23	ACWI	ETF	54.52	54.71	54.32	54.54	1546600.0
2013-09-23	ACWV	ETF	62.57	62.57	62.34	62.44	45300.0
2013-09-23	ACWX	ETF	45.4	45.43	45.2	45.35	199968.0
2013-09-23	ADRE	ETF	37.69	37.959	37.6505	37.84	9643.0
2013-09-23	AFK	ETF	29.44	29.99	29.44	29.696	9228.0
2013-09-23	AGEM	ETF	22.84	23.038	22.81	23.038	1770.0
2013-09-23	AGG	ETF	106.8	106.92	106.72	106.85	855800.0
2013-09-23	AGQ	ETF	80.52	82.12	79.36	79.4	326375.0
2013-09-23	AGZ	ETF	110.856	110.94	110.816	110.94	9094.0
2013-09-23	AIA	ETF	47.3872	47.63	47.33	47.51	37191.0
2013-09-23	AIQ	ETF	24.5	24.925	24.05	24.74	42985.0
2013-09-23	AIVI	ETF	45.45	45.53	45.33	45.45	39500.0
2013-09-23	ALTL	ETF	30.38	30.38	30.32	30.32	500.0
2013-09-23	AMJ	ETF	44.75	44.75	44.23	44.4	1140223.0
2013-09-23	AMLP	ETF	87.35	87.7	87.05	87.25	433540.0
2013-09-23	ANGL	ETF	26.51	26.59	26.51	26.59	300.0
2013-09-23	AOA	ETF	42.4	42.4	42.13	42.27	13300.0
2013-09-23	AOK	ETF	31.47	31.47	31.39	31.42	19017.0
2013-09-23	AOM	ETF	33.5	33.5	33.391	33.42	24146.0
2013-09-23	AOR	ETF	37.06	37.07	36.951	37.01	22779.0
2013-09-23	ARB	ETF	47.97	47.99	47.97	47.99	1659650.0
2013-09-23	ARGT	ETF	19.89	19.9	19.88	19.9	1600.0
2013-09-23	ASEA	ETF	17.01	17.14	17.01	17.08	9700.0
2013-09-23	ATMP	ETF	26.1	26.11	25.99	26.01	16800.0
2013-09-23	AVIV	ETF	23.39	23.52	23.21	23.34	277793.0
2013-09-23	AWAY	ETF	31.6	31.6	30.61	30.97	552849.0
2013-09-23	BAB	ETF	27.2	27.2899	27.16	27.23	170423.0
2013-09-23	BAL	ETF	54.0001	54.0238	53.85	53.8699	9986.0
2013-09-23	BALT	ETF	4.87	4.93	4.65	4.69	757908.0
2013-09-23	BBH	ETF	82.77	82.84	81.46	81.81	90100.0
2013-09-23	BFOR	ETF	6.7875	6.835	6.7325	6.7825	821600.0
2013-09-23	BIB	ETF	32.6175	32.705	31.655	32.075	206948.0
2013-09-23	BICK	ETF	23.99	24.0	23.892	24.0	900.0
2013-09-23	BIL	ETF	91.58	91.6	91.58	91.58	191300.0
2013-09-23	BIS	ETF	1020.0	1055.6	1020.0	1042.0	294.5
2013-09-23	BIV	ETF	82.99	83.11	82.95	83.08	165800.0
2013-09-23	BIZD	ETF	20.46	20.49	20.46	20.49	1000.0
2013-09-23	BJK	ETF	47.53	47.53	47.14	47.4	19100.0
2013-09-23	BKF	ETF	38.12	38.45	38.12	38.31	113358.0
2013-09-23	BKLN	ETF	24.78	24.81	24.77	24.81	1619200.0
2013-09-23	BLV	ETF	82.37	82.78	82.37	82.7	82000.0

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

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