PREVIEW / etf_daily / 2014-04-24

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-24.parquet
  size:    43 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-24	SPY	ETF	188.37	188.39	186.93	187.83	88170000.0
2014-04-24	QQQ	ETF	88.2	88.21	86.65	87.59	48926264.0
2014-04-24	IWM	ETF	114.59	114.67	112.68	113.61	44318900.0
2014-04-24	DIA	ETF	165.01	165.11	164.19	164.69	4028700.0
2014-04-24	GLD	ETF	122.87	125.12	122.84	124.56	8754200.0
2014-04-24	TLT	ETF	110.45	111.21	110.45	111.17	6337800.0
2014-04-24	AADR	ETF	38.2	38.2	37.95	37.99	800.0
2014-04-24	AAXJ	ETF	60.15	60.15	59.75	60.13	180000.0
2014-04-24	ACWI	ETF	58.57	58.64	58.22	58.52	1221500.0
2014-04-24	ACWV	ETF	64.71	64.71	64.3	64.44	51200.0
2014-04-24	ACWX	ETF	47.08	47.08	46.76	46.99	360534.0
2014-04-24	ADRE	ETF	37.39	37.4	37.0504	37.39	8557.0
2014-04-24	AFK	ETF	32.4	32.7084	32.2236	32.61	34180.0
2014-04-24	AGG	ETF	108.22	108.37	108.18	108.37	494000.0
2014-04-24	AGQ	ETF	60.78	64.46	60.78	63.03	408400.0
2014-04-24	AGZ	ETF	111.862	112.04	111.851	112.04	18085.0
2014-04-24	AGZD	ETF	25.05	25.055	25.05	25.055	600.0
2014-04-24	AIA	ETF	46.89	47.0294	46.76	46.96	28322.0
2014-04-24	AIQ	ETF	30.47	31.18	29.6	30.44	39930.0
2014-04-24	AIRR	ETF	19.6	19.6	19.41	19.518	21600.0
2014-04-24	AIVI	ETF	49.55	49.67	49.31	49.51	26000.0
2014-04-24	AMJ	ETF	48.53	48.8281	48.0	48.15	1034332.0
2014-04-24	AMLP	ETF	91.25	91.25	90.05	90.15	918920.0
2014-04-24	ANGL	ETF	27.76	27.77	27.76	27.77	1800.0
2014-04-24	AOA	ETF	45.46	45.46	45.09	45.37	19800.0
2014-04-24	AOK	ETF	32.59	32.59	32.4046	32.46	11959.0
2014-04-24	AOM	ETF	34.95	34.95	34.75	34.82	41781.0
2014-04-24	AOR	ETF	39.3	39.3	39.01	39.14	40523.0
2014-04-24	ARGT	ETF	19.96	20.23	19.95	20.13	5700.0
2014-04-24	ASEA	ETF	16.35	16.39	16.35	16.35	3300.0
2014-04-24	ASHR	ETF	22.16	22.22	22.06	22.19	255100.0
2014-04-24	ATMP	ETF	29.14	29.14	28.71	28.74	20700.0
2014-04-24	AVIV	ETF	26.15	26.36	25.94	26.31	329926.0
2014-04-24	AWAY	ETF	37.15	37.25	35.53	36.94	2737236.0
2014-04-24	BAB	ETF	28.9	28.95	28.82	28.9288	103527.0
2014-04-24	BAL	ETF	57.42	57.8	57.42	57.6	4569.0
2014-04-24	BALT	ETF	6.39	6.53	6.22	6.36	974103.0
2014-04-24	BBH	ETF	88.5	88.5	85.33	87.4	134100.0
2014-04-24	BCHP	ETF	20.09	20.09	19.9999	20.009	4357.0
2014-04-24	BCM	ETF	41.7	41.7	41.67	41.68	450.0
2014-04-24	BFOR	ETF	7.5775	7.6	7.48	7.5425	177600.0
2014-04-24	BIB	ETF	38.47	38.5995	35.32	37.285	969658.0
2014-04-24	BICK	ETF	24.98	24.98	24.98	24.98	182.0
2014-04-24	BIL	ETF	91.52	91.54	91.52	91.54	262250.0
2014-04-24	BIS	ETF	706.8	767.6	702.8	731.6	23436.0
2014-04-24	BIV	ETF	83.56	83.68	83.55	83.63	382100.0
2014-04-24	BIZD	ETF	20.1	20.13	20.05	20.1	62800.0
2014-04-24	BJK	ETF	51.5	51.65	51.06	51.5	3900.0
2014-04-24	BKF	ETF	36.2	36.22	35.8813	36.2	41681.0
2014-04-24	BKLN	ETF	24.67	24.68	24.63	24.65	2284600.0

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

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