PREVIEW / etf_daily / 2013-11-29

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-29.parquet
  size:    41 KB
  rows:    1,027

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-29	SPY	ETF	181.32	181.75	180.8	181.0	55870900.0
2013-11-29	QQQ	ETF	85.54	85.84	85.4737	85.73	16708898.0
2013-11-29	IWM	ETF	113.94	114.16	113.45	113.51	15675500.0
2013-11-29	DIA	ETF	161.11	161.58	160.58	160.72	2887900.0
2013-11-29	GLD	ETF	120.67	121.05	120.62	120.7	2364700.0
2013-11-29	TLT	ETF	104.08	104.6	103.95	104.45	5084400.0
2013-11-29	AADR	ETF	37.2	37.2	37.2	37.2	100.0
2013-11-29	AAXJ	ETF	60.8	61.24	60.8	61.13	1038100.0
2013-11-29	ACWI	ETF	56.99	57.19	56.91	56.92	1040900.0
2013-11-29	ACWV	ETF	64.43	64.43	64.22	64.22	12700.0
2013-11-29	ACWX	ETF	46.42	46.69	46.42	46.49	155905.0
2013-11-29	ADRE	ETF	37.84	38.12	37.84	38.09	8240.0
2013-11-29	AFK	ETF	31.01	31.16	31.01	31.02	11507.0
2013-11-29	AGG	ETF	107.3	107.49	107.21	107.44	956500.0
2013-11-29	AGQ	ETF	67.28	67.8	66.88	67.08	192150.0
2013-11-29	AGZ	ETF	111.68	111.71	111.4901	111.5401	3088.0
2013-11-29	AIA	ETF	49.17	49.35	49.161	49.29	6509.0
2013-11-29	AIQ	ETF	29.07	29.41	28.4542	28.88	17421.0
2013-11-29	AIVI	ETF	47.31	47.47	47.24	47.24	3100.0
2013-11-29	ALTL	ETF	32.18	32.18	32.14	32.14	900.0
2013-11-29	AMJ	ETF	45.65	45.79	45.53	45.57	231993.0
2013-11-29	AMLP	ETF	88.7	88.75	88.3	88.4	196580.0
2013-11-29	ANGL	ETF	27.34	27.34	27.01	27.01	1000.0
2013-11-29	AOA	ETF	44.05	44.13	44.0	44.0	9900.0
2013-11-29	AOK	ETF	32.0001	32.02	32.0	32.0	7095.0
2013-11-29	AOM	ETF	34.26	34.28	34.21	34.23	15222.0
2013-11-29	AOR	ETF	38.29	38.31	38.24	38.24	11600.0
2013-11-29	ARGT	ETF	20.75	21.02	20.75	20.97	3000.0
2013-11-29	ASEA	ETF	16.36	16.38	16.24	16.36	2800.0
2013-11-29	ASHR	ETF	25.8	25.91	25.72	25.85	363700.0
2013-11-29	AVIV	ETF	25.99	25.99	25.4801	25.7	22779.0
2013-11-29	AWAY	ETF	36.43	36.7	36.26	36.5	234343.0
2013-11-29	BAB	ETF	27.7	27.7	27.53	27.6	40377.0
2013-11-29	BAL	ETF	49.59	49.76	49.18	49.25	5125.0
2013-11-29	BALT	ETF	4.92	5.12	4.92	5.06	845003.0
2013-11-29	BBH	ETF	87.82	87.97	87.6	87.66	43400.0
2013-11-29	BCM	ETF	39.31	39.31	39.31	39.31	1945.0
2013-11-29	BFOR	ETF	7.3475	7.36	7.3275	7.3375	194800.0
2013-11-29	BIB	ETF	36.5	37.125	36.5	37.05	53216.0
2013-11-29	BIL	ETF	91.58	91.58	91.54	91.54	465750.0
2013-11-29	BIS	ETF	860.8	861.6	843.6	859.32	255.5
2013-11-29	BIV	ETF	83.72	83.75	83.62	83.72	78000.0
2013-11-29	BIZD	ETF	21.63	21.63	21.57	21.57	500.0
2013-11-29	BJK	ETF	50.27	50.36	50.1	50.1	10200.0
2013-11-29	BKF	ETF	38.4	38.66	38.35	38.63	41282.0
2013-11-29	BKLN	ETF	24.82	24.84	24.82	24.82	716700.0
2013-11-29	BLV	ETF	82.74	82.86	82.56	82.81	26500.0
2013-11-29	BMVP	ETF	22.55	22.56	22.49	22.52	2165.0
2013-11-29	BND	ETF	80.81	81.0	80.81	80.98	1058600.0
2013-11-29	BNDX	ETF	50.05	50.05	49.97	50.02	56900.0

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

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