PREVIEW / etf_daily / 2011-06-06

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-06.parquet
  size:    36 KB
  rows:    848

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-06-06	SPY	ETF	130.09	130.36	128.87	129.04	179951200.0
2011-06-06	QQQ	ETF	56.24	56.53	55.86	55.89	50175542.0
2011-06-06	IWM	ETF	80.75	81.07	79.49	79.55	63782200.0
2011-06-06	DIA	ETF	121.1	121.34	120.51	120.73	4679000.0
2011-06-06	GLD	ETF	150.82	151.45	150.21	150.48	11472600.0
2011-06-06	TLT	ETF	95.47	95.99	95.21	95.6	8776900.0
2011-06-06	AADR	ETF	31.66	31.66	31.54	31.65	800.0
2011-06-06	AAXJ	ETF	62.68	62.74	62.22	62.27	463300.0
2011-06-06	ACTV	ETF	18.0	19.44	18.0	18.96	253374.0
2011-06-06	ACWI	ETF	48.25	48.36	47.8	47.83	231800.0
2011-06-06	ACWX	ETF	45.31	45.3736	44.82	44.85	125085.0
2011-06-06	ADRE	ETF	46.25	46.31	45.63	45.67	33348.0
2011-06-06	AFK	ETF	32.87	33.33	32.84	32.9891	19725.0
2011-06-06	AGG	ETF	107.23	107.43	107.18	107.34	1477400.0
2011-06-06	AGQ	ETF	381.36	385.26	366.1	371.76	759500.0
2011-06-06	AGZ	ETF	110.85	110.88	110.72	110.73	3355.0
2011-06-06	AIA	ETF	47.91	47.91	47.45	47.47	11416.0
2011-06-06	AIQ	ETF	20.7	20.95	19.25	19.3	32010.0
2011-06-06	AIS	ETF	1.85	1.87	1.83	1.84	747817.0
2011-06-06	AIVI	ETF	48.33	48.34	47.71	47.72	25900.0
2011-06-06	AMJ	ETF	36.2	36.34	35.69	35.73	366364.0
2011-06-06	AMLP	ETF	79.05	79.05	78.1	78.15	133420.0
2011-06-06	AOA	ETF	35.5	35.5	35.23	35.23	13000.0
2011-06-06	AOK	ETF	29.3	29.3	29.21	29.2362	14122.0
2011-06-06	AOM	ETF	30.65	30.6791	30.56	30.58	11086.0
2011-06-06	AOR	ETF	32.5	32.5	32.3068	32.31	19697.0
2011-06-06	ARB	ETF	39.0	39.17	38.13	38.15	152698.0
2011-06-06	ARGT	ETF	28.72	28.72	28.6	28.6	750.0
2011-06-06	ASEA	ETF	16.36	16.36	16.1	16.18	4300.0
2011-06-06	BAB	ETF	26.5	26.6	26.43	26.58	102593.0
2011-06-06	BAL	ETF	88.16	88.49	84.104	84.64	87203.0
2011-06-06	BALT	ETF	6.27	6.3	6.02	6.11	350273.0
2011-06-06	BBH	ETF	34.4433	34.6367	34.3967	34.3967	50100.0
2011-06-06	BCM	ETF	47.588	47.588	47.588	47.588	216.0
2011-06-06	BIB	ETF	9.745	9.745	9.2762	9.3362	170720.0
2011-06-06	BICK	ETF	32.14	32.28	31.86	31.86	39769.0
2011-06-06	BIL	ETF	91.72	91.72	91.7	91.7	655250.0
2011-06-06	BITS	ETF	22.0	22.28	21.04	21.56	4364.0
2011-06-06	BIV	ETF	84.55	84.75	84.5	84.66	58000.0
2011-06-06	BJK	ETF	33.75	33.92	33.42	33.42	9600.0
2011-06-06	BKF	ETF	47.96	48.08	47.4	47.4	115593.0
2011-06-06	BKLN	ETF	25.06	25.06	25.0	25.03	94200.0
2011-06-06	BLNG	ETF	49.4602	49.4602	49.4602	49.4602	240.0
2011-06-06	BLV	ETF	81.17	81.44	80.94	81.31	33800.0
2011-06-06	BMVP	ETF	15.35	15.4	15.14	15.19	22559.0
2011-06-06	BND	ETF	81.56	81.69	81.55	81.62	841900.0
2011-06-06	BNO	ETF	38.4	38.425	37.925	37.93	78000.0
2011-06-06	BRF	ETF	58.0	58.0	56.74	56.78	120491.0
2011-06-06	BSCE	ETF	21.16	21.18	21.05	21.18	35912.0
2011-06-06	BSV	ETF	81.09	81.13	81.08	81.13	199200.0

> showing 50 of 848 rows — these rows as CSV

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