PREVIEW / etf_daily / 2012-05-21

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-21.parquet
  size:    39 KB
  rows:    938

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
2012-05-21	SPY	ETF	130.16	132.02	129.95	131.97	177861100.0
2012-05-21	QQQ	ETF	60.92	62.57	60.85	62.51	61471322.0
2012-05-21	IWM	ETF	74.93	76.45	74.41	76.45	61384400.0
2012-05-21	DIA	ETF	123.69	124.81	123.44	124.81	5384900.0
2012-05-21	GLD	ETF	154.11	154.95	153.86	154.65	7542400.0
2012-05-21	TLT	ETF	123.9	124.45	123.62	123.94	9583500.0
2012-05-21	AADR	ETF	28.13	28.32	28.11	28.32	2500.0
2012-05-21	AAXJ	ETF	50.63	51.38	50.6	51.27	649100.0
2012-05-21	ACTV	ETF	12.98	13.18	12.88	13.18	164838.0
2012-05-21	ACWI	ETF	42.39	43.09	42.35	43.03	1001800.0
2012-05-21	ACWV	ETF	52.29	52.67	52.22	52.65	8400.0
2012-05-21	ACWX	ETF	36.09	36.56	35.99	36.53	157497.0
2012-05-21	ADRE	ETF	36.4	37.07	36.4	37.07	108119.0
2012-05-21	AFK	ETF	27.49	27.87	27.49	27.87	32786.0
2012-05-21	AGEM	ETF	19.97	20.172	19.97	20.172	1496.0
2012-05-21	AGG	ETF	111.02	111.05	110.97	110.98	1208500.0
2012-05-21	AGQ	ETF	162.8	167.24	161.92	167.0	341400.0
2012-05-21	AGZ	ETF	113.2	113.23	113.09	113.17	8542.0
2012-05-21	AIA	ETF	40.34	40.88	40.34	40.85	14884.0
2012-05-21	AIQ	ETF	5.45	5.8	5.4	5.45	28747.0
2012-05-21	AIS	ETF	2.91	3.03	2.88	3.03	689492.0
2012-05-21	AIVI	ETF	37.42	37.96	37.34	37.92	59900.0
2012-05-21	AMJ	ETF	36.79	37.82	36.79	37.69	3455579.0
2012-05-21	AMLP	ETF	78.75	79.75	78.25	79.65	358680.0
2012-05-21	ANGL	ETF	24.89	24.97	24.89	24.91	29300.0
2012-05-21	AOA	ETF	33.79	34.29	33.79	34.27	20200.0
2012-05-21	AOK	ETF	29.5	29.65	29.5	29.65	9311.0
2012-05-21	AOM	ETF	30.19	30.36	30.19	30.36	11044.0
2012-05-21	AOR	ETF	31.72	32.01	31.7199	32.01	50806.0
2012-05-21	ARB	ETF	34.73	35.56	34.52	35.48	212113.0
2012-05-21	ARGT	ETF	16.0	16.06	16.0	16.06	100.0
2012-05-21	ASEA	ETF	15.04	15.25	15.04	15.11	5100.0
2012-05-21	AWAY	ETF	24.67	24.85	23.96	24.54	608448.0
2012-05-21	BAB	ETF	29.9	29.91	29.763	29.83	390305.0
2012-05-21	BAL	ETF	48.19	48.202	47.418	48.11	36473.0
2012-05-21	BALT	ETF	3.72	3.85	3.67	3.82	85089.0
2012-05-21	BBH	ETF	45.02	45.98	45.02	45.91	20600.0
2012-05-21	BCM	ETF	42.13	42.269	42.13	42.269	2692.0
2012-05-21	BIB	ETF	11.485	11.9774	11.485	11.973	46384.0
2012-05-21	BICK	ETF	22.05	22.1973	21.831	22.1973	8545.0
2012-05-21	BIL	ETF	91.64	91.66	91.64	91.66	1054000.0
2012-05-21	BIS	ETF	3753.6	3753.6	3584.32	3585.6	43.7
2012-05-21	BIV	ETF	88.23	88.25	88.1	88.15	165500.0
2012-05-21	BJK	ETF	31.73	32.54	31.73	32.54	28400.0
2012-05-21	BKF	ETF	34.78	35.43	34.77	35.42	91347.0
2012-05-21	BKLN	ETF	24.3	24.36	24.21	24.34	288500.0
2012-05-21	BLV	ETF	94.0	94.32	93.76	94.03	48700.0
2012-05-21	BMVP	ETF	14.5	14.589	14.5	14.589	3708.0
2012-05-21	BND	ETF	84.13	84.14	84.07	84.1	2278400.0
2012-05-21	BNO	ETF	38.075	38.64	38.075	38.63	50600.0

> showing 50 of 938 rows — these rows as CSV

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