PREVIEW / etf_daily / 2014-09-04

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-04.parquet
  size:    46 KB
  rows:    1,127

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-04	SPY	ETF	200.84	201.58	199.66	200.21	85236000.0
2014-09-04	QQQ	ETF	99.73	100.22	99.14	99.39	24663511.0
2014-09-04	IWM	ETF	116.78	117.49	115.72	116.01	26523500.0
2014-09-04	DIA	ETF	170.91	171.56	170.22	170.66	3760900.0
2014-09-04	GLD	ETF	122.48	122.66	121.25	121.48	7310600.0
2014-09-04	TLT	ETF	116.62	116.88	115.93	115.95	12528900.0
2014-09-04	AADR	ETF	39.14	39.14	39.14	39.14	500.0
2014-09-04	AAXJ	ETF	66.47	66.54	66.07	66.38	502300.0
2014-09-04	ACWI	ETF	61.17	61.32	60.76	60.89	2042900.0
2014-09-04	ACWV	ETF	68.42	68.53	68.16	68.29	24100.0
2014-09-04	ACWX	ETF	48.23	48.33	47.927	48.0	64083.0
2014-09-04	ADRE	ETF	44.47	44.6099	44.05	44.1	14172.0
2014-09-04	AFK	ETF	33.68	33.86	33.55	33.58	15902.0
2014-09-04	AGG	ETF	109.44	109.54	109.31	109.43	1308900.0
2014-09-04	AGQ	ETF	59.35	59.71	57.77	58.15	255000.0
2014-09-04	AGZ	ETF	112.6	112.6	112.36	112.44	5324.0
2014-09-04	AGZD	ETF	24.96	25.06	24.96	24.98	2125400.0
2014-09-04	AIA	ETF	51.1	51.365	50.98	51.04	14450.0
2014-09-04	AIQ	ETF	28.19	28.34	27.93	28.17	18784.0
2014-09-04	AIRR	ETF	19.65	19.65	19.4	19.4	40600.0
2014-09-04	AIVI	ETF	49.83	49.94	49.49	49.56	16500.0
2014-09-04	AMJ	ETF	53.69	53.96	53.13	53.33	1487970.0
2014-09-04	AMLP	ETF	96.35	96.5	95.65	95.95	630240.0
2014-09-04	ANGL	ETF	28.08	28.29	27.95	28.25	16300.0
2014-09-04	AOA	ETF	47.32	47.4	46.92	46.92	47100.0
2014-09-04	AOK	ETF	32.96	33.0	32.63	32.63	83092.0
2014-09-04	AOM	ETF	35.72	35.7298	35.54	35.54	37794.0
2014-09-04	AOR	ETF	40.59	40.62	40.36	40.36	81624.0
2014-09-04	ARGT	ETF	21.81	21.81	21.24	21.25	24900.0
2014-09-04	ASEA	ETF	17.49	17.5	17.37	17.39	6800.0
2014-09-04	ASHR	ETF	25.83	25.84	25.68	25.72	675200.0
2014-09-04	ASHS	ETF	32.0	32.0	31.9	31.9	13100.0
2014-09-04	ATMP	ETF	32.72	32.72	32.38	32.47	26100.0
2014-09-04	AVIV	ETF	28.68	28.68	28.21	28.43	363482.0
2014-09-04	AWAY	ETF	32.88	32.97	32.03	32.12	643542.0
2014-09-04	BAB	ETF	29.85	29.86	29.65	29.77	133060.0
2014-09-04	BAL	ETF	44.1	44.17	43.7	43.78	10140.0
2014-09-04	BALT	ETF	5.65	5.8	5.49	5.52	593762.0
2014-09-04	BAR	ETF	3.543	3.543	3.47	3.47	41760.0
2014-09-04	BBH	ETF	107.26	107.29	105.09	105.28	61800.0
2014-09-04	BCHP	ETF	20.45	20.47	20.38	20.4	2619.0
2014-09-04	BCM	ETF	38.912	38.912	38.835	38.84	7682.0
2014-09-04	BFOR	ETF	7.8925	7.945	7.8475	7.8625	72400.0
2014-09-04	BIB	ETF	53.14	53.1605	50.875	51.1275	376168.0
2014-09-04	BICK	ETF	27.93	28.0129	27.93	28.01	848.0
2014-09-04	BIL	ETF	91.5	91.52	91.5	91.5	105250.0
2014-09-04	BIS	ETF	482.8	499.2	477.64	496.8	10387.0
2014-09-04	BIV	ETF	84.83	84.85	84.59	84.59	174700.0
2014-09-04	BIZD	ETF	20.54	20.64	20.54	20.57	11700.0
2014-09-04	BJK	ETF	46.57	46.96	46.57	46.81	15500.0

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

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