PREVIEW / etf_daily / 2014-08-11

all etf daily files

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

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-11	SPY	ETF	193.97	194.66	193.71	193.8	74544000.0
2014-08-11	QQQ	ETF	95.25	95.76	95.2	95.46	28283279.0
2014-08-11	IWM	ETF	112.89	114.22	112.62	113.34	31000700.0
2014-08-11	DIA	ETF	165.96	166.15	165.47	165.55	5761500.0
2014-08-11	GLD	ETF	125.84	126.04	125.64	125.96	3163500.0
2014-08-11	TLT	ETF	115.65	115.82	115.29	115.51	6668800.0
2014-08-11	AADR	ETF	37.9	37.94	37.76	37.94	600.0
2014-08-11	AAXJ	ETF	64.73	65.03	64.67	64.91	201100.0
2014-08-11	ACWI	ETF	59.24	59.41	59.01	59.2	1228900.0
2014-08-11	ACWV	ETF	66.47	66.7	66.45	66.58	40400.0
2014-08-11	ACWX	ETF	46.81	46.9	46.7101	46.81	339775.0
2014-08-11	ADRE	ETF	40.93	41.33	40.93	41.29	30143.0
2014-08-11	AFK	ETF	33.78	33.819	33.58	33.75	40997.0
2014-08-11	AGG	ETF	109.4	109.49	109.35	109.39	1632900.0
2014-08-11	AGQ	ETF	63.76	64.59	63.6	64.21	75600.0
2014-08-11	AGZ	ETF	112.5201	112.7171	112.4423	112.5401	5081.0
2014-08-11	AIA	ETF	50.12	50.16	49.9495	50.14	41907.0
2014-08-11	AIQ	ETF	28.56	30.03	28.29	29.36	61939.0
2014-08-11	AIRR	ETF	18.5	18.811	18.5	18.68	12000.0
2014-08-11	AIVI	ETF	48.99	48.99	48.76	48.87	26700.0
2014-08-11	ALTL	ETF	35.07	35.07	35.07	35.07	467.0
2014-08-11	AMJ	ETF	51.83	52.63	51.8	52.18	1170525.0
2014-08-11	AMLP	ETF	93.75	94.15	93.05	93.5	1390720.0
2014-08-11	ANGL	ETF	27.75	27.96	27.67	27.67	3700.0
2014-08-11	AOA	ETF	45.9	46.07	45.87	45.95	26100.0
2014-08-11	AOK	ETF	32.65	32.66	32.59	32.63	11283.0
2014-08-11	AOM	ETF	35.05	35.1799	35.05	35.15	59280.0
2014-08-11	AOR	ETF	39.68	39.75	39.64	39.67	60948.0
2014-08-11	ARGT	ETF	21.86	21.97	21.5	21.54	11900.0
2014-08-11	ASEA	ETF	17.34	17.34	17.26	17.34	12400.0
2014-08-11	ASHR	ETF	25.01	25.07	24.92	25.05	208800.0
2014-08-11	ASHS	ETF	30.13	30.13	30.01	30.06	4300.0
2014-08-11	ATMP	ETF	31.09	31.84	31.09	31.6	14500.0
2014-08-11	AVIV	ETF	27.79	28.04	27.66	27.79	118595.0
2014-08-11	AWAY	ETF	33.63	33.69	33.03	33.47	812599.0
2014-08-11	BAB	ETF	29.63	29.72	29.63	29.65	321965.0
2014-08-11	BAL	ETF	43.51	43.53	43.22	43.27	8772.0
2014-08-11	BALT	ETF	5.14	5.48	5.1	5.44	475981.0
2014-08-11	BBH	ETF	97.96	98.21	96.92	97.69	38300.0
2014-08-11	BFOR	ETF	7.64	7.7075	7.64	7.6625	89600.0
2014-08-11	BIB	ETF	45.0	45.25	43.965	44.685	272016.0
2014-08-11	BICK	ETF	26.76	26.8199	26.76	26.78	2450.0
2014-08-11	BIL	ETF	91.52	91.52	91.5	91.5	475700.0
2014-08-11	BIS	ETF	568.4	583.2	566.0	573.6	4479.0
2014-08-11	BIV	ETF	84.83	84.87	84.72	84.81	163400.0
2014-08-11	BIZD	ETF	20.21	20.3	20.21	20.25	2000.0
2014-08-11	BJK	ETF	48.12	48.12	47.74	47.93	28100.0
2014-08-11	BKF	ETF	39.91	40.22	39.82	40.17	44108.0
2014-08-11	BKLN	ETF	24.58	24.63	24.58	24.59	2233600.0
2014-08-11	BLV	ETF	90.47	90.75	90.46	90.63	144000.0

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

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