PREVIEW / etf_daily / 2013-10-30

all etf daily files

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

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-10-30	SPY	ETF	177.38	177.51	175.66	176.29	140002000.0
2013-10-30	QQQ	ETF	83.36	83.485	82.58	82.98	33535470.0
2013-10-30	IWM	ETF	111.4	111.48	109.52	109.83	46076600.0
2013-10-30	DIA	ETF	156.73	156.87	155.37	155.87	6100200.0
2013-10-30	GLD	ETF	130.83	131.22	128.81	129.6	8896000.0
2013-10-30	TLT	ETF	107.93	108.21	107.21	107.41	10199300.0
2013-10-30	AADR	ETF	36.77	36.8	36.77	36.77	500.0
2013-10-30	AAXJ	ETF	61.1	61.1	60.33	60.61	316700.0
2013-10-30	ACTV	ETF	14.43	14.45	14.42	14.42	1600719.0
2013-10-30	ACWI	ETF	56.7	56.7	56.11	56.36	489000.0
2013-10-30	ACWV	ETF	64.79	64.79	64.05	64.3	19900.0
2013-10-30	ACWX	ETF	46.88	46.8999	46.43	46.62	522681.0
2013-10-30	ADRE	ETF	38.95	39.03	38.7	38.88	27246.0
2013-10-30	AFK	ETF	31.96	31.96	31.72	31.72	35726.0
2013-10-30	AGG	ETF	108.11	108.21	107.82	107.89	492100.0
2013-10-30	AGQ	ETF	89.44	89.92	85.08	87.12	594825.0
2013-10-30	AGZ	ETF	113.0	113.0	111.69	111.85	18888.0
2013-10-30	AIA	ETF	48.5	48.58	48.13	48.26	44764.0
2013-10-30	AIQ	ETF	24.38	24.865	23.5	24.03	41221.0
2013-10-30	AIVI	ETF	47.87	47.87	47.23	47.41	20000.0
2013-10-30	ALTL	ETF	31.64	31.64	31.6	31.6	699.0
2013-10-30	AMJ	ETF	45.98	46.2	45.72	46.0	385000.0
2013-10-30	AMLP	ETF	89.65	89.85	89.1	89.55	440780.0
2013-10-30	ANGL	ETF	26.89	26.89	26.89	26.89	2700.0
2013-10-30	AOA	ETF	43.71	43.71	43.36	43.46	10300.0
2013-10-30	AOK	ETF	32.0	32.0	31.82	31.82	52634.0
2013-10-30	AOM	ETF	34.21	34.21	33.968	34.02	54817.0
2013-10-30	AOR	ETF	38.05	38.05	37.8	37.87	16326.0
2013-10-30	ARGT	ETF	20.71	20.71	20.45	20.45	4800.0
2013-10-30	ASEA	ETF	17.25	17.25	17.11	17.12	16400.0
2013-10-30	ATMP	ETF	26.75	26.99	26.75	26.88	15700.0
2013-10-30	AVIV	ETF	25.71	25.71	25.19	25.62	144822.0
2013-10-30	AWAY	ETF	29.87	30.05	29.58	29.58	887379.0
2013-10-30	BAB	ETF	27.81	27.85	27.7	27.73	75820.0
2013-10-30	BAL	ETF	49.6	50.08	49.51	49.58	9225.0
2013-10-30	BALT	ETF	4.7	4.77	4.46	4.5	746388.0
2013-10-30	BBH	ETF	84.25	84.68	82.61	82.99	69300.0
2013-10-30	BFOR	ETF	7.16	7.2225	7.055	7.0875	636400.0
2013-10-30	BIB	ETF	33.12	33.35	31.41	31.6028	357644.0
2013-10-30	BICK	ETF	25.06	25.06	25.06	25.06	113.0
2013-10-30	BIL	ETF	91.56	91.58	91.56	91.56	399450.0
2013-10-30	BIS	ETF	968.0	1024.0	966.8	1020.76	262.0
2013-10-30	BIV	ETF	84.69	84.86	84.38	84.57	332100.0
2013-10-30	BIZD	ETF	20.78	20.84	20.68	20.68	5100.0
2013-10-30	BJK	ETF	50.83	50.85	50.08	50.42	17100.0
2013-10-30	BKF	ETF	38.87	39.0	38.61	38.85	86457.0
2013-10-30	BKLN	ETF	24.83	24.84	24.81	24.82	4476400.0
2013-10-30	BLV	ETF	84.71	84.97	84.33	84.57	38600.0
2013-10-30	BMVP	ETF	21.58	21.6	21.33	21.33	1703.0
2013-10-30	BND	ETF	81.54	81.59	81.32	81.4	907100.0

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

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