PREVIEW / etf_daily / 2014-07-24

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-24.parquet
  size:    45 KB
  rows:    1,108

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-24	SPY	ETF	198.83	199.06	198.45	198.65	56888000.0
2014-07-24	QQQ	ETF	97.4	97.51	96.98	97.12	24707180.0
2014-07-24	IWM	ETF	115.22	115.65	114.34	114.64	31905100.0
2014-07-24	DIA	ETF	170.66	170.85	170.22	170.44	3226000.0
2014-07-24	GLD	ETF	124.85	124.87	123.9	124.35	8111600.0
2014-07-24	TLT	ETF	114.52	114.58	114.25	114.32	6609000.0
2014-07-24	AADR	ETF	38.91	39.0	38.85	38.99	12000.0
2014-07-24	AAXJ	ETF	65.11	65.23	65.01	65.14	565700.0
2014-07-24	ACWI	ETF	60.92	61.03	60.88	60.92	1574500.0
2014-07-24	ACWV	ETF	67.62	67.62	67.44	67.6	18900.0
2014-07-24	ACWX	ETF	48.43	48.45	48.23	48.23	1098690.0
2014-07-24	ADRE	ETF	41.39	41.6	41.32	41.6	18100.0
2014-07-24	AFK	ETF	33.86	34.02	33.793	33.88	52959.0
2014-07-24	AGG	ETF	109.32	109.32	109.12	109.12	853400.0
2014-07-24	AGQ	ETF	69.56	69.6	66.1	66.62	599500.0
2014-07-24	AGZ	ETF	112.75	112.75	112.0206	112.0206	7807.0
2014-07-24	AGZD	ETF	25.0	25.03	25.0	25.03	5800.0
2014-07-24	AIA	ETF	49.88	50.11	49.88	50.0	16053.0
2014-07-24	AIQ	ETF	29.8	30.4	29.56	29.79	54959.0
2014-07-24	AIRR	ETF	18.78	18.78	18.59	18.6	4900.0
2014-07-24	AIVI	ETF	51.01	51.03	50.81	50.98	24500.0
2014-07-24	ALTL	ETF	35.56	35.83	35.56	35.83	1247.0
2014-07-24	AMJ	ETF	52.65	52.86	52.29	52.36	752175.0
2014-07-24	AMLP	ETF	95.3	95.55	94.85	94.9	651780.0
2014-07-24	ANGL	ETF	28.37	28.37	27.95	28.16	5200.0
2014-07-24	AOA	ETF	47.0	47.03	46.92	46.98	23400.0
2014-07-24	AOK	ETF	32.93	32.9599	32.91	32.93	21005.0
2014-07-24	AOM	ETF	35.65	35.65	35.5	35.51	33863.0
2014-07-24	AOR	ETF	40.53	40.53	40.2601	40.3	31513.0
2014-07-24	ARGT	ETF	22.22	22.44	22.2	22.2	44700.0
2014-07-24	ASEA	ETF	17.53	17.54	17.45	17.53	5200.0
2014-07-24	ASHR	ETF	23.57	23.65	23.53	23.63	347700.0
2014-07-24	ASHS	ETF	27.62	27.75	27.62	27.75	13300.0
2014-07-24	ATMP	ETF	32.31	32.31	31.87	31.93	40100.0
2014-07-24	AVIV	ETF	29.18	29.36	29.15	29.25	223399.0
2014-07-24	AWAY	ETF	33.74	33.8999	32.11	32.65	3280145.0
2014-07-24	BAB	ETF	29.51	29.57	29.46	29.52	44735.0
2014-07-24	BAL	ETF	45.59	45.6	44.2	44.46	31322.0
2014-07-24	BALT	ETF	5.54	5.68	5.49	5.5	437756.0
2014-07-24	BBH	ETF	98.18	98.35	96.65	97.06	79900.0
2014-07-24	BCHP	ETF	20.75	20.75	20.746	20.746	926.0
2014-07-24	BCM	ETF	40.4	40.42	40.344	40.382	6978.0
2014-07-24	BFOR	ETF	7.8325	7.86	7.8175	7.8375	48000.0
2014-07-24	BIB	ETF	47.495	47.495	45.4205	45.63	377880.0
2014-07-24	BIL	ETF	91.52	91.52	91.5	91.52	441050.0
2014-07-24	BIS	ETF	543.2	568.8	542.4	566.4	11524.5
2014-07-24	BIV	ETF	84.65	84.7	84.54	84.56	222300.0
2014-07-24	BIZD	ETF	20.39	20.54	20.39	20.54	11800.0
2014-07-24	BJK	ETF	50.39	50.63	50.31	50.4	10200.0
2014-07-24	BKF	ETF	40.38	40.73	40.38	40.57	36459.0

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

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