PREVIEW / etf_daily / 2014-07-01

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-01.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-07-01	SPY	ETF	196.2	197.63	196.13	197.03	90470000.0
2014-07-01	QQQ	ETF	94.21	95.19	94.2	94.94	31862487.0
2014-07-01	IWM	ETF	119.26	120.97	119.2	120.02	65733200.0
2014-07-01	DIA	ETF	168.29	169.64	168.23	169.2	4911500.0
2014-07-01	GLD	ETF	127.99	128.12	127.49	127.7	8145900.0
2014-07-01	TLT	ETF	112.5	112.74	112.2	112.28	8019200.0
2014-07-01	AADR	ETF	39.08	39.43	39.0	39.16	41700.0
2014-07-01	AAXJ	ETF	63.0	63.24	62.97	63.22	704100.0
2014-07-01	ACWI	ETF	60.43	60.85	60.43	60.72	3003100.0
2014-07-01	ACWV	ETF	67.19	67.3	66.95	67.19	49100.0
2014-07-01	ACWX	ETF	48.2	48.4899	48.2	48.43	287386.0
2014-07-01	ADRE	ETF	39.2	39.52	39.2	39.51	22176.0
2014-07-01	AFK	ETF	33.0	33.19	32.9999	33.19	15455.0
2014-07-01	AGG	ETF	109.11	109.18	109.05	109.07	1038500.0
2014-07-01	AGQ	ETF	72.0	72.5	71.0	71.23	242400.0
2014-07-01	AGZ	ETF	112.59	112.59	112.4101	112.4666	6867.0
2014-07-01	AGZD	ETF	24.97	25.04	24.96	25.035	45000.0
2014-07-01	AIA	ETF	48.4896	48.5965	48.4635	48.568	27226.0
2014-07-01	AIQ	ETF	27.0	28.8	27.0	28.58	29994.0
2014-07-01	AIRR	ETF	19.6	19.7	19.6	19.6	11400.0
2014-07-01	AIVI	ETF	50.98	51.17	50.83	51.09	41100.0
2014-07-01	AMJ	ETF	52.32	52.6632	52.2001	52.57	899230.0
2014-07-01	AMLP	ETF	95.15	95.3	94.9	95.25	562340.0
2014-07-01	ANGL	ETF	28.3	28.3	28.29	28.29	2000.0
2014-07-01	AOA	ETF	47.61	47.61	47.32	47.52	20900.0
2014-07-01	AOK	ETF	32.97	33.18	32.97	33.12	64338.0
2014-07-01	AOM	ETF	35.73	35.89	35.72	35.85	21913.0
2014-07-01	AOR	ETF	40.65	40.73	40.5331	40.68	21418.0
2014-07-01	ARGT	ETF	22.38	22.54	22.31	22.31	11100.0
2014-07-01	ASEA	ETF	16.75	16.81	16.75	16.79	6500.0
2014-07-01	ASHR	ETF	22.58	22.6	22.52	22.52	169700.0
2014-07-01	ASHS	ETF	26.5	26.5	26.3	26.44	22200.0
2014-07-01	ATMP	ETF	31.67	31.76	31.09	31.76	9600.0
2014-07-01	AVIV	ETF	28.2	28.58	28.138	28.34	324576.0
2014-07-01	AWAY	ETF	34.86	34.91	34.1	34.54	1661505.0
2014-07-01	BAB	ETF	29.22	29.3211	29.21	29.25	60277.0
2014-07-01	BAL	ETF	49.1	49.53	48.82	49.521	9568.0
2014-07-01	BALT	ETF	6.03	6.3	6.03	6.24	1388843.0
2014-07-01	BBH	ETF	95.93	97.8	95.93	97.64	133100.0
2014-07-01	BCHP	ETF	20.8554	20.87	20.8554	20.87	1413.0
2014-07-01	BCM	ETF	41.518	41.6	41.518	41.6	860.0
2014-07-01	BFOR	ETF	7.86	7.9675	7.86	7.9325	64400.0
2014-07-01	BIB	ETF	46.89	48.745	46.825	48.56	653524.0
2014-07-01	BICK	ETF	26.9001	26.97	26.9001	26.97	253.0
2014-07-01	BIL	ETF	91.52	91.54	91.52	91.54	145650.0
2014-07-01	BIS	ETF	563.2	563.2	538.4	538.4	9049.5
2014-07-01	BIV	ETF	84.42	84.46	84.29	84.35	291500.0
2014-07-01	BIZD	ETF	20.87	20.87	20.76	20.79	21300.0
2014-07-01	BJK	ETF	50.73	50.99	50.67	50.98	8000.0
2014-07-01	BKF	ETF	38.68	38.9	38.65	38.7	645285.0

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

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