PREVIEW / etf_daily / 2014-09-05

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-05.parquet
  size:    45 KB
  rows:    1,118

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-09-05	SPY	ETF	200.17	201.19	199.41	201.11	102177000.0
2014-09-05	QQQ	ETF	99.58	99.95	99.03	99.89	30805767.0
2014-09-05	IWM	ETF	115.78	116.42	115.17	116.38	26935300.0
2014-09-05	DIA	ETF	170.52	171.29	170.01	171.25	3403600.0
2014-09-05	GLD	ETF	121.83	122.06	121.63	122.06	3490100.0
2014-09-05	TLT	ETF	116.44	116.6	115.44	115.73	6886000.0
2014-09-05	AADR	ETF	38.89	38.9	38.89	38.9	800.0
2014-09-05	AAXJ	ETF	66.22	66.51	66.01	66.51	447600.0
2014-09-05	ACWI	ETF	60.89	61.15	60.68	61.15	600300.0
2014-09-05	ACWV	ETF	68.1	68.49	68.04	68.43	45500.0
2014-09-05	ACWX	ETF	47.94	48.09	47.8399	48.09	125293.0
2014-09-05	ADRE	ETF	44.21	44.25	43.96	44.24	19835.0
2014-09-05	AFK	ETF	33.45	33.74	33.45	33.74	16641.0
2014-09-05	AGG	ETF	109.44	109.54	109.29	109.37	798500.0
2014-09-05	AGQ	ETF	58.11	58.78	57.85	58.75	135700.0
2014-09-05	AGZ	ETF	112.75	112.75	112.48	112.49	8928.0
2014-09-05	AGZD	ETF	24.99	24.995	24.945	24.945	436200.0
2014-09-05	AIA	ETF	50.96	51.21	50.82	51.2	33773.0
2014-09-05	AIQ	ETF	27.9	31.01	27.76	28.66	112416.0
2014-09-05	AIRR	ETF	19.39	19.46	19.34	19.46	548700.0
2014-09-05	AIVI	ETF	49.48	49.72	49.37	49.72	30600.0
2014-09-05	AMJ	ETF	53.35	53.56	53.11	53.49	355853.0
2014-09-05	AMLP	ETF	95.95	96.2	95.6	96.2	432100.0
2014-09-05	ANGL	ETF	28.08	28.14	27.95	28.12	5800.0
2014-09-05	AOA	ETF	47.02	47.27	47.0	47.27	26600.0
2014-09-05	AOK	ETF	32.88	32.93	32.86	32.91	40034.0
2014-09-05	AOM	ETF	35.62	35.66	35.555	35.66	17414.0
2014-09-05	AOR	ETF	40.37	40.54	40.37	40.54	21544.0
2014-09-05	ARGT	ETF	21.45	21.57	21.09	21.57	25900.0
2014-09-05	ASEA	ETF	17.46	17.55	17.46	17.53	3300.0
2014-09-05	ASHR	ETF	25.94	26.05	25.87	26.04	381900.0
2014-09-05	ASHS	ETF	32.01	32.11	31.86	32.11	7100.0
2014-09-05	ATMP	ETF	32.39	32.65	32.39	32.65	22400.0
2014-09-05	AVIV	ETF	28.36	28.63	28.3	28.62	338587.0
2014-09-05	AWAY	ETF	32.11	32.13	31.51	31.54	1101926.0
2014-09-05	BAB	ETF	29.83	29.83	29.55	29.64	107574.0
2014-09-05	BAL	ETF	43.12	43.3835	42.89	43.21	20673.0
2014-09-05	BALT	ETF	5.49	5.76	5.49	5.72	341369.0
2014-09-05	BAR	ETF	3.496	3.512	3.496	3.509	13620.0
2014-09-05	BBH	ETF	105.64	105.64	102.74	104.9	74900.0
2014-09-05	BCM	ETF	38.84	38.9	38.79	38.9	3029.0
2014-09-05	BFOR	ETF	7.8725	7.8875	7.825	7.8875	44000.0
2014-09-05	BIB	ETF	50.955	51.22	49.15	51.005	575248.0
2014-09-05	BICK	ETF	27.91	27.91	27.91	27.91	109.0
2014-09-05	BIL	ETF	91.52	91.52	91.5	91.52	105200.0
2014-09-05	BIS	ETF	496.4	516.796	496.4	498.0	21773.5
2014-09-05	BIV	ETF	84.8	84.81	84.58	84.65	194000.0
2014-09-05	BIZD	ETF	20.64	20.64	20.45	20.58	29400.0
2014-09-05	BJK	ETF	46.53	46.77	46.47	46.76	22500.0
2014-09-05	BKF	ETF	41.96	42.15	41.85	42.15	10553.0

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

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