PREVIEW / etf_daily / 2014-04-11

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-11.parquet
  size:    44 KB
  rows:    1,084

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-04-11	SPY	ETF	182.14	183.42	181.31	181.51	167251000.0
2014-04-11	QQQ	ETF	84.34	85.44	83.91	84.11	93657425.0
2014-04-11	IWM	ETF	111.04	112.24	109.86	110.41	70998200.0
2014-04-11	DIA	ETF	160.67	161.32	159.88	160.02	11067500.0
2014-04-11	GLD	ETF	127.04	127.31	126.73	126.93	4697200.0
2014-04-11	TLT	ETF	110.54	110.79	110.13	110.73	10267000.0
2014-04-11	AADR	ETF	36.96	37.33	36.96	37.06	1200.0
2014-04-11	AAXJ	ETF	60.35	60.74	60.35	60.67	394700.0
2014-04-11	ACWI	ETF	57.31	57.52	57.0	57.04	1910000.0
2014-04-11	ACWV	ETF	63.62	63.97	63.62	63.7	24700.0
2014-04-11	ACWX	ETF	46.25	46.56	46.23	46.3	282719.0
2014-04-11	ADRE	ETF	37.23	37.46	37.0101	37.45	8141.0
2014-04-11	AFK	ETF	31.32	31.566	31.314	31.36	44952.0
2014-04-11	AGG	ETF	108.58	108.58	108.41	108.43	1168700.0
2014-04-11	AGQ	ETF	65.37	65.58	64.86	64.96	142200.0
2014-04-11	AGZ	ETF	112.2639	112.3999	112.1804	112.2	10108.0
2014-04-11	AIA	ETF	47.21	47.44	47.21	47.31	11032.0
2014-04-11	AIQ	ETF	30.88	31.2	29.231	29.46	45232.0
2014-04-11	AIRR	ETF	19.18	19.18	18.84	18.89	107500.0
2014-04-11	AIVI	ETF	48.67	48.97	48.64	48.64	28000.0
2014-04-11	ALTL	ETF	33.0389	33.0389	33.0389	33.0389	150.0
2014-04-11	AMJ	ETF	47.0	47.64	46.84	47.54	191216.0
2014-04-11	AMLP	ETF	88.8	89.7	88.7	89.65	2940440.0
2014-04-11	ANGL	ETF	27.64	27.64	27.57	27.59	1000.0
2014-04-11	AOA	ETF	44.5	44.69	44.32	44.38	33200.0
2014-04-11	AOK	ETF	32.23	32.25	32.12	32.12	25802.0
2014-04-11	AOM	ETF	34.49	34.531	34.38	34.38	36391.0
2014-04-11	AOR	ETF	38.59	38.7	38.46	38.5	39203.0
2014-04-11	ARGT	ETF	19.94	20.03	19.61	19.84	12100.0
2014-04-11	ASEA	ETF	16.16	16.23	16.16	16.19	7400.0
2014-04-11	ASHR	ETF	22.99	23.19	22.99	23.09	186800.0
2014-04-11	ATMP	ETF	28.22	28.45	28.22	28.38	68400.0
2014-04-11	AVIV	ETF	24.52	25.08	24.49	25.0	612393.0
2014-04-11	AWAY	ETF	33.31	33.9	32.5	32.92	2271846.0
2014-04-11	BAB	ETF	28.9	29.0	28.9	28.98	127256.0
2014-04-11	BAL	ETF	55.75	56.34	55.67	56.2	4993.0
2014-04-11	BALT	ETF	6.02	6.19	5.89	6.1	683934.0
2014-04-11	BBH	ETF	83.53	86.67	82.68	82.69	335800.0
2014-04-11	BCM	ETF	41.4201	41.47	41.4201	41.45	800.0
2014-04-11	BFOR	ETF	7.355	7.37	7.255	7.275	339600.0
2014-04-11	BIB	ETF	33.825	36.225	32.8753	32.935	1473972.0
2014-04-11	BICK	ETF	24.94	24.94	24.89	24.89	2950.0
2014-04-11	BIL	ETF	91.54	91.56	91.54	91.54	166600.0
2014-04-11	BIS	ETF	816.0	837.2	760.0	833.6	43512.0
2014-04-11	BIV	ETF	83.98	83.99	83.8	83.89	259800.0
2014-04-11	BIZD	ETF	19.99	19.99	19.8	19.8	10600.0
2014-04-11	BJK	ETF	51.01	51.37	50.65	50.83	24700.0
2014-04-11	BKF	ETF	36.64	37.04	36.64	37.04	64223.0
2014-04-11	BKLN	ETF	24.82	24.82	24.75	24.75	3516400.0
2014-04-11	BLV	ETF	87.63	87.73	87.25	87.7	49300.0

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

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