PREVIEW / etf_daily / 2014-08-13

all etf daily files

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

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-13	SPY	ETF	194.29	195.06	193.96	194.84	69047000.0
2014-08-13	QQQ	ETF	95.81	96.47	95.76	96.43	27996489.0
2014-08-13	IWM	ETF	112.92	113.65	112.7	113.44	23122900.0
2014-08-13	DIA	ETF	166.0	166.66	165.76	166.49	2841700.0
2014-08-13	GLD	ETF	126.35	126.53	125.9	126.2	3967500.0
2014-08-13	TLT	ETF	114.87	115.52	114.78	115.51	8210500.0
2014-08-13	AAXJ	ETF	65.39	65.66	65.39	65.57	1210400.0
2014-08-13	ACWI	ETF	59.4	59.61	59.37	59.52	275200.0
2014-08-13	ACWV	ETF	66.89	66.94	66.72	66.88	50800.0
2014-08-13	ACWX	ETF	47.21	47.21	47.0157	47.05	92456.0
2014-08-13	ADRE	ETF	41.65	41.65	41.196	41.25	12848.0
2014-08-13	AFK	ETF	33.86	33.86	33.65	33.69	13314.0
2014-08-13	AGG	ETF	109.44	109.57	109.39	109.56	3471700.0
2014-08-13	AGQ	ETF	64.07	64.07	62.15	62.94	160100.0
2014-08-13	AGZ	ETF	112.65	112.65	112.5701	112.6499	5858.0
2014-08-13	AIA	ETF	50.58	50.58	50.42	50.55	33747.0
2014-08-13	AIQ	ETF	28.76	29.0	28.43	28.43	37625.0
2014-08-13	AIRR	ETF	18.55	18.73	18.55	18.67	9700.0
2014-08-13	AIVI	ETF	49.03	49.04	48.85	48.95	9300.0
2014-08-13	AMJ	ETF	51.89	52.55	51.55	52.26	929912.0
2014-08-13	AMLP	ETF	93.15	94.0	92.6	93.55	590900.0
2014-08-13	ANGL	ETF	27.97	28.03	27.97	28.02	8300.0
2014-08-13	AOA	ETF	45.98	46.19	45.98	46.16	54500.0
2014-08-13	AOK	ETF	32.69	32.7	32.64	32.7	51941.0
2014-08-13	AOM	ETF	35.17	35.24	35.16	35.19	27199.0
2014-08-13	AOR	ETF	39.7	39.838	39.7	39.83	14991.0
2014-08-13	ARGT	ETF	21.27	21.46	21.27	21.45	13500.0
2014-08-13	ASEA	ETF	17.39	17.43	17.39	17.43	4400.0
2014-08-13	ASHR	ETF	24.96	25.11	24.96	25.02	299900.0
2014-08-13	ASHS	ETF	30.3	30.34	30.3	30.32	1200.0
2014-08-13	ATMP	ETF	31.27	31.84	31.27	31.65	19300.0
2014-08-13	AVIV	ETF	27.77	28.05	27.7	27.9	205838.0
2014-08-13	AWAY	ETF	33.04	33.11	32.01	32.52	1150232.0
2014-08-13	BAB	ETF	29.6	29.625	29.5	29.61	68383.0
2014-08-13	BAL	ETF	42.9	43.77	42.84	43.51	19748.0
2014-08-13	BALT	ETF	5.58	5.73	5.515	5.68	326859.0
2014-08-13	BBH	ETF	98.22	99.89	98.01	99.68	58900.0
2014-08-13	BCHP	ETF	20.0536	20.08	20.0536	20.0573	761.0
2014-08-13	BCM	ETF	39.65	39.67	39.64	39.67	1310.0
2014-08-13	BFOR	ETF	7.66	7.68	7.6275	7.665	72000.0
2014-08-13	BIB	ETF	44.705	46.325	44.553	46.14	395496.0
2014-08-13	BICK	ETF	26.9433	26.9433	26.87	26.87	1496.0
2014-08-13	BIL	ETF	91.5	91.52	91.5	91.52	234700.0
2014-08-13	BIS	ETF	572.0	575.596	552.8	554.4	8050.5
2014-08-13	BIV	ETF	84.84	84.99	84.78	84.95	299700.0
2014-08-13	BIZD	ETF	20.3	20.3	20.24	20.24	3900.0
2014-08-13	BJK	ETF	48.24	48.47	48.24	48.33	21000.0
2014-08-13	BKF	ETF	40.36	40.61	40.1906	40.32	144058.0
2014-08-13	BKLN	ETF	24.58	24.62	24.58	24.61	1571100.0
2014-08-13	BLV	ETF	90.18	90.48	90.1	90.47	183200.0

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

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