PREVIEW / etf_daily / 2014-08-28

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-28.parquet
  size:    45 KB
  rows:    1,115

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
2014-08-28	SPY	ETF	199.59	200.27	199.39	200.14	58330000.0
2014-08-28	QQQ	ETF	99.2	99.53	99.08	99.41	23563850.0
2014-08-28	IWM	ETF	116.03	116.23	115.51	115.91	22817800.0
2014-08-28	DIA	ETF	170.4	170.88	170.1	170.77	2781900.0
2014-08-28	GLD	ETF	124.15	124.33	123.81	124.0	3296700.0
2014-08-28	TLT	ETF	119.13	119.37	118.67	118.97	9463600.0
2014-08-28	AADR	ETF	38.72	38.72	38.72	38.72	400.0
2014-08-28	AAXJ	ETF	65.5	65.72	65.46	65.7	254400.0
2014-08-28	ACWI	ETF	60.64	60.82	60.6	60.81	1099200.0
2014-08-28	ACWV	ETF	67.94	68.13	67.71	68.02	76700.0
2014-08-28	ACWX	ETF	47.71	47.8	47.66	47.78	211584.0
2014-08-28	ADRE	ETF	43.0	43.175	42.91	43.1301	23574.0
2014-08-28	AFK	ETF	33.49	33.64	33.4	33.5818	30293.0
2014-08-28	AGG	ETF	109.96	110.05	109.89	110.02	1123700.0
2014-08-28	AGQ	ETF	61.6	61.68	60.83	60.83	265300.0
2014-08-28	AGZ	ETF	112.8819	113.0099	112.71	112.8005	13025.0
2014-08-28	AIA	ETF	50.71	50.72	50.53	50.72	8596.0
2014-08-28	AIQ	ETF	28.03	28.22	26.88	27.19	33646.0
2014-08-28	AIRR	ETF	19.34	19.34	19.25	19.3	55300.0
2014-08-28	AIVI	ETF	49.57	49.7	49.57	49.7	8300.0
2014-08-28	AMJ	ETF	53.48	53.63	53.3	53.56	430007.0
2014-08-28	AMLP	ETF	95.75	96.05	95.7	96.0	383960.0
2014-08-28	ANGL	ETF	28.36	28.38	28.28	28.31	4400.0
2014-08-28	AOA	ETF	46.98	47.04	46.92	47.03	9900.0
2014-08-28	AOK	ETF	33.0	33.0	32.91	32.98	21607.0
2014-08-28	AOM	ETF	35.62	35.62	35.5764	35.62	8719.0
2014-08-28	AOR	ETF	40.41	40.44	40.346	40.4	17776.0
2014-08-28	ARGT	ETF	21.0	21.01	20.83	20.85	20100.0
2014-08-28	ASEA	ETF	17.5	17.54	17.49	17.54	1900.0
2014-08-28	ASHR	ETF	24.37	24.38	24.26	24.36	1050100.0
2014-08-28	ASHS	ETF	29.74	29.81	29.7	29.72	13800.0
2014-08-28	ATMP	ETF	32.42	32.51	32.41	32.49	26900.0
2014-08-28	AVIV	ETF	28.88	29.1	28.75	28.99	800807.0
2014-08-28	AWAY	ETF	32.77	33.35	32.33	33.21	1140516.0
2014-08-28	BAB	ETF	29.88	30.03	29.8601	29.98	439371.0
2014-08-28	BAL	ETF	45.08	45.11	44.45	44.78	16350.0
2014-08-28	BALT	ETF	5.7	5.99	5.65	5.85	387000.0
2014-08-28	BAR	ETF	3.725	3.725	3.701	3.7121	11790.0
2014-08-28	BBH	ETF	105.73	106.84	105.73	105.99	55700.0
2014-08-28	BCHP	ETF	20.4722	20.4722	20.4722	20.4722	364.0
2014-08-28	BCM	ETF	39.403	40.374	39.367	39.43	4198.0
2014-08-28	BFOR	ETF	7.8525	7.875	7.7	7.855	192800.0
2014-08-28	BIB	ETF	52.235	53.25	52.0	52.26	319232.0
2014-08-28	BICK	ETF	27.34	27.4399	27.34	27.4399	256.0
2014-08-28	BIL	ETF	91.5	91.52	91.5	91.52	145100.0
2014-08-28	BIS	ETF	490.8	491.2	478.04	487.2	9224.5
2014-08-28	BIV	ETF	85.32	85.33	85.16	85.22	298900.0
2014-08-28	BIZD	ETF	20.53	20.53	20.36	20.49	35800.0
2014-08-28	BJK	ETF	48.16	48.24	47.77	48.11	3600.0
2014-08-28	BKF	ETF	40.96	41.05	40.8204	41.05	39215.0

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

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