PREVIEW / etf_daily / 2014-04-22

all etf daily files

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

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-22	SPY	ETF	187.23	188.4	187.13	187.89	85790000.0
2014-04-22	QQQ	ETF	87.1	87.745	86.9898	87.53	38593408.0
2014-04-22	IWM	ETF	113.63	115.02	113.47	114.62	40541900.0
2014-04-22	DIA	ETF	164.3	165.3	164.23	164.8	4044300.0
2014-04-22	GLD	ETF	124.15	124.16	122.92	123.78	6898100.0
2014-04-22	TLT	ETF	109.66	110.49	109.61	110.33	5748700.0
2014-04-22	AADR	ETF	38.28	38.29	38.03	38.03	7900.0
2014-04-22	AAXJ	ETF	60.6	60.74	60.4	60.4	1392900.0
2014-04-22	ACWI	ETF	58.57	58.74	58.48	58.65	2662800.0
2014-04-22	ACWV	ETF	64.58	64.85	64.58	64.68	7400.0
2014-04-22	ACWX	ETF	47.2	47.22	47.09	47.165	157766.0
2014-04-22	ADRE	ETF	37.43	37.5563	37.43	37.472	11938.0
2014-04-22	AFK	ETF	31.98	32.47	31.86	32.27	74507.0
2014-04-22	AGG	ETF	108.1	108.16	108.05	108.16	1034800.0
2014-04-22	AGQ	ETF	61.65	61.85	60.88	61.72	215100.0
2014-04-22	AGZ	ETF	111.79	111.7999	110.59	111.701	19986.0
2014-04-22	AIA	ETF	47.38	47.51	47.36	47.36	10637.0
2014-04-22	AIQ	ETF	30.314	31.4	30.2	31.09	52582.0
2014-04-22	AIRR	ETF	19.4	19.63	19.4	19.59	7400.0
2014-04-22	AIVI	ETF	49.78	49.98	49.75	49.85	23500.0
2014-04-22	AMJ	ETF	48.64	48.87	48.46	48.57	603459.0
2014-04-22	AMLP	ETF	90.85	91.25	90.7	90.8	573780.0
2014-04-22	ANGL	ETF	27.72	27.72	27.65	27.71	5100.0
2014-04-22	AOA	ETF	45.33	45.47	45.23	45.41	34800.0
2014-04-22	AOK	ETF	32.35	32.46	32.35	32.46	24814.0
2014-04-22	AOM	ETF	34.75	34.86	34.75	34.85	19559.0
2014-04-22	AOR	ETF	39.14	39.22	39.0701	39.19	28764.0
2014-04-22	ARGT	ETF	19.63	19.7	19.63	19.7	400.0
2014-04-22	ASEA	ETF	16.49	16.5	16.48	16.49	1900.0
2014-04-22	ASHR	ETF	22.31	22.31	22.19	22.21	47500.0
2014-04-22	ATMP	ETF	29.11	29.11	28.92	28.97	114900.0
2014-04-22	AVIV	ETF	25.77	26.0	25.65	25.7	561971.0
2014-04-22	AWAY	ETF	36.73	37.75	36.51	37.45	3074821.0
2014-04-22	BAB	ETF	28.7	28.8699	28.7	28.84	59958.0
2014-04-22	BAL	ETF	57.6	57.85	57.54	57.85	11749.0
2014-04-22	BALT	ETF	6.44	6.54	6.39	6.48	571733.0
2014-04-22	BBH	ETF	88.58	90.03	88.08	89.53	269100.0
2014-04-22	BCM	ETF	41.319	41.319	41.319	41.319	407.0
2014-04-22	BFOR	ETF	7.5325	7.6	7.53	7.585	128000.0
2014-04-22	BIB	ETF	37.61	39.3	37.4155	38.955	1593914.0
2014-04-22	BICK	ETF	25.0	25.055	24.96	24.96	904.0
2014-04-22	BIL	ETF	91.52	91.54	91.52	91.52	92550.0
2014-04-22	BIS	ETF	733.2	733.2	692.0	698.8	24230.0
2014-04-22	BIV	ETF	83.53	83.53	83.34	83.5	271600.0
2014-04-22	BIZD	ETF	20.03	20.13	20.0	20.11	16400.0
2014-04-22	BJK	ETF	51.16	51.85	51.16	51.75	15900.0
2014-04-22	BKF	ETF	36.48	36.65	36.43	36.46	33607.0
2014-04-22	BKLN	ETF	24.68	24.7	24.67	24.67	2857400.0
2014-04-22	BLV	ETF	87.37	87.76	87.25	87.75	41500.0
2014-04-22	BMVP	ETF	23.63	23.76	23.58	23.68	10731.0

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

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