PREVIEW / etf_daily / 2011-04-27

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-27.parquet
  size:    36 KB
  rows:    846

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-04-27	SPY	ETF	135.05	135.87	134.5	135.67	143031000.0
2011-04-27	QQQ	ETF	58.9	59.29	58.66	59.22	56465494.0
2011-04-27	IWM	ETF	85.23	85.77	84.89	85.69	44680600.0
2011-04-27	DIA	ETF	125.88	126.87	125.67	126.69	5703800.0
2011-04-27	GLD	ETF	147.38	149.21	146.52	149.2	21945900.0
2011-04-27	TLT	ETF	93.44	93.57	92.75	92.89	8869300.0
2011-04-27	AADR	ETF	31.41	31.68	31.41	31.68	5600.0
2011-04-27	AAXJ	ETF	64.95	64.99	64.19	64.92	411300.0
2011-04-27	ACWI	ETF	50.04	50.42	49.74	50.37	1042300.0
2011-04-27	ACWX	ETF	47.12	47.37	46.697	47.3	85379.0
2011-04-27	ADRE	ETF	48.85	48.8585	48.1432	48.73	41184.0
2011-04-27	AFK	ETF	34.18	34.25	33.72	34.06	14019.0
2011-04-27	AGG	ETF	106.02	106.15	105.87	106.12	473300.0
2011-04-27	AGQ	ETF	660.28	727.84	630.0	723.5	2165650.0
2011-04-27	AGZ	ETF	109.72	109.763	109.64	109.71	32727.0
2011-04-27	AIA	ETF	49.34	49.46	48.89	49.28	28443.0
2011-04-27	AIQ	ETF	23.15	23.25	22.75	22.75	10840.0
2011-04-27	AIS	ETF	1.69	1.74	1.68	1.74	540193.0
2011-04-27	AIVI	ETF	49.59	50.18	49.3	50.04	27600.0
2011-04-27	AMJ	ETF	39.0	39.128	38.7741	39.04	394514.0
2011-04-27	AMLP	ETF	83.5	83.55	83.05	83.45	226360.0
2011-04-27	AOA	ETF	36.78	36.98	36.65	36.93	27200.0
2011-04-27	AOK	ETF	29.44	29.5	29.44	29.4744	21913.0
2011-04-27	AOM	ETF	30.94	31.06	30.9	31.06	20291.0
2011-04-27	AOR	ETF	33.11	33.2899	33.07	33.27	54313.0
2011-04-27	ARB	ETF	36.83	37.52	36.71	37.47	140768.0
2011-04-27	ARGT	ETF	30.34	30.34	29.76	29.82	4400.0
2011-04-27	ASEA	ETF	16.55	16.66	16.55	16.66	2600.0
2011-04-27	BAB	ETF	25.79	25.81	25.69	25.74	112813.0
2011-04-27	BAL	ETF	85.55	86.0	82.53	83.99	360838.0
2011-04-27	BALT	ETF	8.23	8.3	8.02	8.07	98347.0
2011-04-27	BBH	ETF	34.6133	34.76	34.58	34.6967	78900.0
2011-04-27	BCM	ETF	50.22	50.53	49.97	50.53	10000.0
2011-04-27	BIB	ETF	9.81	10.0375	9.6625	10.0375	59696.0
2011-04-27	BICK	ETF	35.24	35.24	34.59	35.03	22801.0
2011-04-27	BIL	ETF	91.7	91.72	91.7	91.7	106000.0
2011-04-27	BIS	ETF	6124.8	6128.0	5920.0	5920.0	121.5
2011-04-27	BITS	ETF	24.84	24.84	24.686	24.686	450.0
2011-04-27	BIV	ETF	82.87	83.0	82.73	82.99	123200.0
2011-04-27	BJK	ETF	34.72	35.11	34.6	35.09	7200.0
2011-04-27	BKF	ETF	51.16	51.16	50.08	50.58	384079.0
2011-04-27	BKLN	ETF	25.28	25.28	25.25	25.26	99800.0
2011-04-27	BLNG	ETF	51.16	51.53	50.38	51.53	9200.0
2011-04-27	BLV	ETF	79.43	79.63	79.3	79.45	16700.0
2011-04-27	BMVP	ETF	16.0	16.04	15.91	16.03	7197.0
2011-04-27	BND	ETF	80.59	80.73	80.55	80.7	760700.0
2011-04-27	BNO	ETF	41.445	41.81	41.04	41.765	58000.0
2011-04-27	BOSS	ETF	60.7	61.4	59.7	61.4	400.0
2011-04-27	BRF	ETF	59.71	60.41	58.804	59.56	270000.0
2011-04-27	BSCE	ETF	21.0	21.07	20.996	21.042	30031.0

> showing 50 of 846 rows — these rows as CSV

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