PREVIEW / etf_daily / 2011-05-19

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-19.parquet
  size:    36 KB
  rows:    850

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
2011-05-19	SPY	ETF	134.8	135.03	133.94	134.68	119489500.0
2011-05-19	QQQ	ETF	58.23	58.34	57.85	58.21	35024234.0
2011-05-19	IWM	ETF	83.86	83.97	82.73	83.47	52914400.0
2011-05-19	DIA	ETF	126.11	126.48	125.46	126.18	4714900.0
2011-05-19	GLD	ETF	145.12	145.85	144.86	145.65	8098100.0
2011-05-19	TLT	ETF	94.46	95.32	94.46	95.27	8052400.0
2011-05-19	AADR	ETF	31.61	31.61	31.61	31.61	500.0
2011-05-19	AAXJ	ETF	63.15	63.2	62.69	63.09	398800.0
2011-05-19	ACWI	ETF	49.03	49.21	48.82	49.19	229500.0
2011-05-19	ACWX	ETF	45.66	45.7485	45.364	45.69	72640.0
2011-05-19	ADRE	ETF	45.91	45.9565	45.5	45.76	27664.0
2011-05-19	AFK	ETF	32.6	32.99	32.54	32.86	7400.0
2011-05-19	AGG	ETF	106.68	106.95	106.64	106.89	632800.0
2011-05-19	AGQ	ETF	350.0	353.0	334.68	345.98	1298500.0
2011-05-19	AGZ	ETF	110.34	111.12	110.12	110.41	14430.0
2011-05-19	AIA	ETF	48.21	48.21	47.64	47.98	29454.0
2011-05-19	AIQ	ETF	20.55	20.7	20.3005	20.6	22411.0
2011-05-19	AIS	ETF	1.7	1.75	1.66	1.74	608514.0
2011-05-19	AIVI	ETF	48.38	48.67	48.16	48.67	10100.0
2011-05-19	AMJ	ETF	36.5	37.0	36.5	36.96	4407931.0
2011-05-19	AMLP	ETF	78.3	79.2	78.3	79.2	184140.0
2011-05-19	AOA	ETF	36.5	36.5	36.29	36.45	9800.0
2011-05-19	AOK	ETF	29.46	29.46	29.42	29.44	4874.0
2011-05-19	AOM	ETF	30.87	30.93	30.8568	30.9	20236.0
2011-05-19	AOR	ETF	33.03	33.03	32.871	33.0	17305.0
2011-05-19	ARB	ETF	42.71	43.021	41.7	42.89	168255.0
2011-05-19	ARGT	ETF	29.96	29.96	29.7	29.7	200.0
2011-05-19	ASEA	ETF	16.55	16.6	16.47	16.49	5700.0
2011-05-19	BAB	ETF	26.21	26.42	26.2	26.372	113691.0
2011-05-19	BAL	ETF	87.23	87.36	84.91	85.66	78489.0
2011-05-19	BALT	ETF	6.58	6.85	6.47	6.68	314850.0
2011-05-19	BBH	ETF	35.67	35.7167	35.2967	35.41	36000.0
2011-05-19	BCM	ETF	46.5601	47.15	46.5601	47.15	900.0
2011-05-19	BIB	ETF	10.1575	10.1575	9.7538	9.9138	94928.0
2011-05-19	BICK	ETF	32.58	32.59	32.3727	32.44	14294.0
2011-05-19	BIL	ETF	91.7	91.74	91.7	91.74	71300.0
2011-05-19	BIS	ETF	5947.2	5988.8	5945.92	5945.92	9.6
2011-05-19	BITS	ETF	22.0	23.92	22.0	23.92	4456.0
2011-05-19	BIV	ETF	83.59	83.94	83.52	83.93	99200.0
2011-05-19	BJK	ETF	34.59	34.59	34.24	34.36	4400.0
2011-05-19	BKF	ETF	47.9	47.9	47.21	47.43	226656.0
2011-05-19	BKLN	ETF	25.19	25.19	25.15	25.17	111500.0
2011-05-19	BLV	ETF	80.8	81.37	80.66	81.26	19200.0
2011-05-19	BMVP	ETF	15.8533	15.9103	15.8267	15.8933	6078.0
2011-05-19	BND	ETF	81.04	81.29	81.04	81.25	759900.0
2011-05-19	BNO	ETF	37.435	37.58	37.04	37.115	65200.0
2011-05-19	BRF	ETF	56.64	56.64	55.09	55.09	95716.0
2011-05-19	BSCE	ETF	21.09	21.13	21.09	21.126	16715.0
2011-05-19	BSV	ETF	80.73	80.88	80.71	80.87	552100.0
2011-05-19	BTF	ETF	83.64999999999999	83.75	83.5225	83.625	2191.4

> showing 50 of 850 rows — these rows as CSV

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