PREVIEW / etf_daily / 2014-06-12

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-12.parquet
  size:    44 KB
  rows:    1,088

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-06-12	SPY	ETF	194.69	194.8	193.11	193.54	106350000.0
2014-06-12	QQQ	ETF	92.69	92.79	91.73	92.05	35275853.0
2014-06-12	IWM	ETF	115.78	115.92	114.91	115.39	39481200.0
2014-06-12	DIA	ETF	168.29	168.34	166.98	167.29	5409200.0
2014-06-12	GLD	ETF	121.92	122.75	121.83	122.64	7388500.0
2014-06-12	TLT	ETF	111.3	112.35	111.0	112.21	9775900.0
2014-06-12	AADR	ETF	38.4	38.44	37.72	38.17	14100.0
2014-06-12	AAXJ	ETF	63.06	63.18	62.55	62.64	174100.0
2014-06-12	ACWI	ETF	60.56	60.71	60.26	60.38	1449800.0
2014-06-12	ACWV	ETF	66.97	67.02	66.52	66.7	276600.0
2014-06-12	ACWX	ETF	48.65	48.75	48.5	48.56	256233.0
2014-06-12	ADRE	ETF	39.16	39.21	38.958	38.9992	20956.0
2014-06-12	AFK	ETF	33.33	33.39	32.7	32.86	131871.0
2014-06-12	AGG	ETF	108.74	109.0	108.68	108.91	1224200.0
2014-06-12	AGQ	ETF	60.25	61.84	60.08	61.67	448000.0
2014-06-12	AGZ	ETF	112.31	112.3899	112.1101	112.38	6019.0
2014-06-12	AGZD	ETF	25.01	25.02	24.98	24.985	22400.0
2014-06-12	AIA	ETF	48.565	48.565	48.28	48.35	18960.0
2014-06-12	AIQ	ETF	29.72	30.0	28.95	29.04	18284.0
2014-06-12	AIRR	ETF	19.18	19.24	19.03	19.07	22700.0
2014-06-12	AIVI	ETF	51.53	51.53	51.3	51.34	17000.0
2014-06-12	AMJ	ETF	50.19	50.29	49.85	50.04	233586.0
2014-06-12	AMLP	ETF	92.25	92.4	91.75	91.9	640920.0
2014-06-12	ANGL	ETF	28.3	28.3	28.21	28.28	2000.0
2014-06-12	AOA	ETF	47.04	47.04	46.51	46.55	16200.0
2014-06-12	AOK	ETF	32.8301	32.91	32.8104	32.8498	13794.0
2014-06-12	AOM	ETF	35.45	35.6	35.41	35.41	44014.0
2014-06-12	AOR	ETF	40.14	40.14	39.9549	40.0	24438.0
2014-06-12	ARGT	ETF	21.0	21.29	21.0	21.29	1100.0
2014-06-12	ASEA	ETF	16.71	16.71	16.68	16.7	1400.0
2014-06-12	ASHR	ETF	22.26	22.29	22.01	22.08	30400.0
2014-06-12	ASHS	ETF	25.85	25.85	25.71	25.76	8400.0
2014-06-12	ATMP	ETF	29.95	29.97	29.89	29.92	17200.0
2014-06-12	AVIV	ETF	28.5	28.51	28.01	28.17	247301.0
2014-06-12	AWAY	ETF	29.82	30.67	29.745	30.05	1593270.0
2014-06-12	BAB	ETF	29.16	29.327	29.136	29.3	49338.0
2014-06-12	BAL	ETF	52.19	52.7699	52.19	52.68	4207.0
2014-06-12	BALT	ETF	6.44	6.45	6.16	6.29	581004.0
2014-06-12	BBH	ETF	93.4	93.79	92.5	92.87	57900.0
2014-06-12	BCHP	ETF	20.43	20.43	20.4	20.42	7040.0
2014-06-12	BCM	ETF	41.068	41.068	41.068	41.068	365.0
2014-06-12	BFOR	ETF	7.72	7.72	7.6425	7.6675	57600.0
2014-06-12	BIB	ETF	43.445	43.995	42.765	43.085	339992.0
2014-06-12	BIL	ETF	91.52	91.54	91.52	91.54	96350.0
2014-06-12	BIS	ETF	617.2	620.4	602.4	614.0	10624.5
2014-06-12	BIV	ETF	84.12	84.34	84.05	84.34	325800.0
2014-06-12	BIZD	ETF	20.06	20.11	20.05	20.08	3600.0
2014-06-12	BJK	ETF	48.61	48.92	48.33	48.33	17100.0
2014-06-12	BKF	ETF	39.26	39.311	38.9893	39.09	566289.0
2014-06-12	BKLN	ETF	24.9	24.94	24.89	24.9	3001900.0

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

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