PREVIEW / etf_daily / 2013-11-12

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-12.parquet
  size:    42 KB
  rows:    1,055

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-11-12	SPY	ETF	176.94	177.36	176.37	176.96	83990000.0
2013-11-12	QQQ	ETF	82.16	82.66	82.1199	82.54	20108526.0
2013-11-12	IWM	ETF	109.07	109.51	108.67	109.47	28075100.0
2013-11-12	DIA	ETF	157.42	157.72	156.87	157.37	4094800.0
2013-11-12	GLD	ETF	123.51	123.87	121.73	122.45	7705600.0
2013-11-12	TLT	ETF	103.21	103.59	103.18	103.5	4839500.0
2013-11-12	AADR	ETF	36.17	36.17	35.86	35.99	19000.0
2013-11-12	AAXJ	ETF	58.92	58.92	58.33	58.61	955100.0
2013-11-12	ACTV	ETF	14.48	14.49	14.47	14.49	741510.0
2013-11-12	ACWI	ETF	55.89	55.96	55.65	55.8	559600.0
2013-11-12	ACWV	ETF	63.97	63.97	63.72	63.88	21100.0
2013-11-12	ACWX	ETF	45.69	45.73	45.49	45.59	110294.0
2013-11-12	ADRE	ETF	37.05	37.13	36.77	36.87	4216.0
2013-11-12	AFK	ETF	30.84	31.1499	30.82	30.82	17440.0
2013-11-12	AGG	ETF	106.71	106.79	106.67	106.72	1130600.0
2013-11-12	AGQ	ETF	75.56	75.72	71.4	72.52	502775.0
2013-11-12	AGZ	ETF	111.0	111.2922	111.0	111.0501	5572.0
2013-11-12	AIA	ETF	47.34	47.34	47.18	47.189	4287.0
2013-11-12	AIQ	ETF	23.88	25.8	23.42	25.55	20794.0
2013-11-12	AIVI	ETF	46.75	46.75	46.45	46.61	23100.0
2013-11-12	ALTL	ETF	31.47	31.47	31.39	31.39	500.0
2013-11-12	AMJ	ETF	45.06	45.4499	45.06	45.24	393957.0
2013-11-12	AMLP	ETF	87.05	87.35	86.8	87.2	408580.0
2013-11-12	ANGL	ETF	26.79	26.79	26.69	26.7	4600.0
2013-11-12	AOA	ETF	43.25	43.27	43.1	43.23	13200.0
2013-11-12	AOK	ETF	31.7	31.7	31.6301	31.6599	4249.0
2013-11-12	AOM	ETF	33.83	33.83	33.73	33.82	29041.0
2013-11-12	AOR	ETF	37.67	37.7	37.581	37.7	18555.0
2013-11-12	ARGT	ETF	19.77	19.77	19.25	19.3	7000.0
2013-11-12	ASEA	ETF	16.54	16.58	16.42	16.51	6100.0
2013-11-12	ASHR	ETF	24.62	24.62	24.42	24.44	49800.0
2013-11-12	ATMP	ETF	26.48	26.49	26.42	26.48	69200.0
2013-11-12	AVIV	ETF	25.31	25.51	25.12	25.22	392829.0
2013-11-12	AWAY	ETF	33.03	34.36	33.0175	34.19	2399748.0
2013-11-12	BAB	ETF	27.27	27.3899	27.27	27.35	102526.0
2013-11-12	BAL	ETF	49.21	49.41	49.08	49.18	5030.0
2013-11-12	BALT	ETF	4.99	5.0799	4.86	4.9	419758.0
2013-11-12	BBH	ETF	80.29	80.67	79.66	80.67	32800.0
2013-11-12	BCM	ETF	39.26	39.346	39.07	39.07	631.0
2013-11-12	BFOR	ETF	7.11	7.115	7.06	7.105	114800.0
2013-11-12	BIB	ETF	30.9975	31.25	30.4025	31.1925	85972.0
2013-11-12	BICK	ETF	23.5885	23.5885	23.5885	23.5885	316.0
2013-11-12	BIL	ETF	91.58	91.58	91.56	91.58	129600.0
2013-11-12	BIS	ETF	1035.12	1050.4	1022.8	1023.2	564.5
2013-11-12	BIV	ETF	83.29	83.36	83.18	83.3	240300.0
2013-11-12	BIZD	ETF	20.7	20.72	20.66	20.7	6000.0
2013-11-12	BJK	ETF	49.4	49.4	49.02	49.17	16100.0
2013-11-12	BKF	ETF	37.15	37.26	36.79	36.91	77140.0
2013-11-12	BKLN	ETF	24.89	24.89	24.87	24.89	1101200.0
2013-11-12	BLV	ETF	81.46	81.83	81.45	81.79	85500.0

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

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