PREVIEW / etf_daily / 2014-11-14

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-14.parquet
  size:    46 KB
  rows:    1,137

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-11-14	SPY	ETF	204.1	204.49	203.72	204.24	80417500.0
2014-11-14	QQQ	ETF	102.87	103.22	102.53	103.22	19251346.0
2014-11-14	IWM	ETF	116.94	117.21	116.37	116.69	23321400.0
2014-11-14	DIA	ETF	176.36	176.65	176.12	176.35	3521100.0
2014-11-14	GLD	ETF	110.76	114.72	110.65	114.47	14173600.0
2014-11-14	TLT	ETF	118.84	119.59	118.68	119.49	5191200.0
2014-11-14	AADR	ETF	37.61	37.61	37.61	37.61	1000.0
2014-11-14	AAXJ	ETF	62.51	62.87	62.47	62.78	2311300.0
2014-11-14	ACWI	ETF	59.52	59.71	59.45	59.71	1108500.0
2014-11-14	ACWV	ETF	69.5	69.64	69.38	69.44	204300.0
2014-11-14	ACWX	ETF	44.71	45.0	44.68	45.0	254134.0
2014-11-14	ADRE	ETF	38.13	38.59	38.13	38.53	20223.0
2014-11-14	AFK	ETF	28.83	29.4	28.83	29.4	14513.0
2014-11-14	AGG	ETF	109.68	109.94	109.64	109.86	1073000.0
2014-11-14	AGQ	ETF	37.27	41.94	37.18	41.49	510000.0
2014-11-14	AGZ	ETF	112.75	112.97	112.6608	112.85	5931.0
2014-11-14	AGZD	ETF	24.745	24.795	24.715	24.79	15800.0
2014-11-14	AIA	ETF	48.16	48.335	48.031	48.33	48305.0
2014-11-14	AIQ	ETF	21.88	22.18	21.565	22.02	16758.0
2014-11-14	AIRR	ETF	18.99	18.99	18.67	18.82	12800.0
2014-11-14	AIVI	ETF	45.53	45.75	45.51	45.71	13100.0
2014-11-14	AMJ	ETF	50.1	50.78	50.09	50.71	1197055.0
2014-11-14	AMLP	ETF	91.45	92.35	91.3	92.35	785780.0
2014-11-14	AMZA	ETF	243.39	244.5	243.0	244.1	270.0
2014-11-14	ANGL	ETF	27.7	27.7	27.63	27.68	2900.0
2014-11-14	AOA	ETF	46.49	46.55	46.43	46.55	20600.0
2014-11-14	AOK	ETF	32.72	32.74	32.67	32.72	39822.0
2014-11-14	AOM	ETF	35.34	35.34	35.26	35.33	26415.0
2014-11-14	AOR	ETF	40.22	40.22	40.1	40.19	60680.0
2014-11-14	ARGT	ETF	20.69	20.86	20.69	20.77	1600.0
2014-11-14	ARKG	ETF	19.87	19.87	19.78	19.78	1100.0
2014-11-14	ARKK	ETF	20.42	20.44	20.42	20.44	1300.0
2014-11-14	ARKQ	ETF	20.14	20.21	20.14	20.21	400.0
2014-11-14	ARKW	ETF	20.52	20.747	20.52	20.747	400.0
2014-11-14	ASEA	ETF	16.64	16.76	16.64	16.76	8500.0
2014-11-14	ASHR	ETF	27.85	28.32	27.77	28.25	1350600.0
2014-11-14	ASHS	ETF	33.87	34.33	33.87	34.29	23000.0
2014-11-14	ATMP	ETF	31.48	31.74	31.48	31.67	21600.0
2014-11-14	AVIV	ETF	33.31	33.524	32.97	33.04	491201.0
2014-11-14	AWAY	ETF	31.0	31.25	30.63	30.97	1074951.0
2014-11-14	BAB	ETF	29.83	29.83	29.73	29.79	64840.0
2014-11-14	BAL	ETF	40.1501	40.62	40.1501	40.62	3282.0
2014-11-14	BALT	ETF	3.17	3.45	3.15	3.44	704682.0
2014-11-14	BAR	ETF	2.571	2.8518	2.5663	2.832	80820.0
2014-11-14	BBH	ETF	115.0	115.0	111.45	112.34	163000.0
2014-11-14	BCHP	ETF	18.5	18.52	18.5	18.51	1416.0
2014-11-14	BCM	ETF	35.261	35.4299	35.261	35.4299	1072.0
2014-11-14	BFOR	ETF	7.9075	7.935	7.9	7.915	56400.0
2014-11-14	BIB	ETF	59.29	59.5	56.3005	57.18	603908.0
2014-11-14	BICK	ETF	24.72	24.7546	24.67	24.7546	995.0

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

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