PREVIEW / etf_daily / 2013-09-24

all etf daily files

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

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-24	SPY	ETF	169.9	170.53	169.21	169.53	106333100.0
2013-09-24	QQQ	ETF	79.0	79.25	78.57	78.83	21875702.0
2013-09-24	IWM	ETF	106.46	107.42	105.79	106.67	45267000.0
2013-09-24	DIA	ETF	153.74	154.02	152.95	153.06	5774900.0
2013-09-24	GLD	ETF	126.4	128.21	126.34	127.66	7349700.0
2013-09-24	TLT	ETF	105.99	106.84	105.84	106.83	11446600.0
2013-09-24	AADR	ETF	35.91	35.91	35.52	35.69	1400.0
2013-09-24	AAXJ	ETF	59.59	59.74	59.29	59.45	304200.0
2013-09-24	ACTV	ETF	10.48	11.31	10.25	10.73	1265595.0
2013-09-24	ACWI	ETF	54.44	54.69	54.3	54.43	815500.0
2013-09-24	ACWV	ETF	62.27	62.61	62.27	62.38	12100.0
2013-09-24	ACWX	ETF	45.29	45.44	45.1503	45.24	204124.0
2013-09-24	ADRE	ETF	37.6507	37.8756	37.61	37.65	17558.0
2013-09-24	AFK	ETF	30.0	30.16	29.6201	29.99	110382.0
2013-09-24	AGG	ETF	106.99	107.16	106.94	107.1	718200.0
2013-09-24	AGQ	ETF	78.44	81.32	78.44	80.24	314875.0
2013-09-24	AGZ	ETF	110.9028	111.06	110.9028	111.05	6914.0
2013-09-24	AIA	ETF	47.36	47.66	47.2985	47.36	48857.0
2013-09-24	AIQ	ETF	24.74	24.74	24.41	24.49	44126.0
2013-09-24	AIVI	ETF	45.45	45.61	45.33	45.43	17500.0
2013-09-24	AMJ	ETF	44.16	44.65	44.16	44.26	1030043.0
2013-09-24	AMLP	ETF	87.5	87.75	87.1	87.3	454640.0
2013-09-24	ANGL	ETF	27.59	27.59	26.43	26.62	2000.0
2013-09-24	AOA	ETF	42.22	42.41	42.14	42.32	8000.0
2013-09-24	AOK	ETF	31.47	31.49	31.391	31.4484	11457.0
2013-09-24	AOM	ETF	33.42	33.519	33.41	33.41	11721.0
2013-09-24	AOR	ETF	37.01	37.14	36.96	36.99	17374.0
2013-09-24	ARB	ETF	47.98	48.01	47.98	47.99	1219230.0
2013-09-24	ARGT	ETF	19.9	19.98	19.84	19.84	6400.0
2013-09-24	ASEA	ETF	16.87	16.89	16.8	16.82	8500.0
2013-09-24	ATMP	ETF	26.15	26.6	25.93	25.99	18900.0
2013-09-24	AVIV	ETF	23.43	23.4899	23.01	23.09	132350.0
2013-09-24	AWAY	ETF	30.77	31.145	30.71	30.93	376618.0
2013-09-24	BAB	ETF	27.26	27.4	27.2207	27.31	182736.0
2013-09-24	BAL	ETF	54.07	54.16	53.886	54.07	5911.0
2013-09-24	BALT	ETF	4.76	5.0793	4.7184	5.02	1263033.0
2013-09-24	BBH	ETF	81.69	82.31	81.47	81.88	83600.0
2013-09-24	BCM	ETF	40.28	40.28	40.28	40.28	3444.0
2013-09-24	BFOR	ETF	6.7875	6.845	6.75	6.8025	342000.0
2013-09-24	BIB	ETF	32.0875	32.56	31.7125	32.255	145488.0
2013-09-24	BICK	ETF	23.82	23.9616	23.796	23.93	1561.0
2013-09-24	BIL	ETF	91.6	91.6	91.58	91.58	160600.0
2013-09-24	BIS	ETF	1036.0	1056.8	1025.608	1040.0	512.0
2013-09-24	BIV	ETF	83.19	83.36	83.08	83.28	173400.0
2013-09-24	BIZD	ETF	20.69	20.69	20.47	20.53	12700.0
2013-09-24	BJK	ETF	47.36	47.62	47.23	47.4	10400.0
2013-09-24	BKF	ETF	38.14	38.268	37.9003	38.1	75393.0
2013-09-24	BKLN	ETF	24.79	24.82	24.78	24.79	4605200.0
2013-09-24	BLV	ETF	83.0	83.39	82.9	83.36	118000.0
2013-09-24	BMVP	ETF	20.2033	20.3566	20.2033	20.2967	4423.0

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

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