PREVIEW / etf_daily / 2011-03-25

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-25.parquet
  size:    36 KB
  rows:    835

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-03-25	SPY	ETF	131.24	131.87	130.89	131.3	155642800.0
2011-03-25	QQQ	ETF	56.89	57.22	56.7299	56.84	74133872.0
2011-03-25	IWM	ETF	81.98	83.06	81.55	82.22	78164900.0
2011-03-25	DIA	ETF	121.7	122.33	121.6	121.96	6604100.0
2011-03-25	GLD	ETF	140.0	140.24	138.66	139.26	13191100.0
2011-03-25	TLT	ETF	92.86	92.96	92.02	92.17	6447200.0
2011-03-25	AADR	ETF	30.43	30.43	30.21	30.22	1900.0
2011-03-25	AAXJ	ETF	61.66	62.04	61.56	61.82	196100.0
2011-03-25	ACWI	ETF	48.02	48.11	47.74	47.77	555100.0
2011-03-25	ACWX	ETF	44.85	44.957	44.64	44.67	81510.0
2011-03-25	ADRE	ETF	47.11	47.483	47.11	47.19	101726.0
2011-03-25	AFK	ETF	32.44	32.5	31.93	32.327	13293.0
2011-03-25	AGG	ETF	105.53	105.53	105.18	105.25	811200.0
2011-03-25	AGQ	ETF	447.18	452.0	431.62	440.56	680700.0
2011-03-25	AGZ	ETF	109.66	109.66	109.2209	109.327	8051.0
2011-03-25	AIA	ETF	46.6	46.737	46.38	46.6266	39224.0
2011-03-25	AIQ	ETF	21.5	21.95	21.3	21.9	20176.0
2011-03-25	AIS	ETF	1.61	1.66	1.61	1.65	215723.0
2011-03-25	AIVI	ETF	46.23	46.39	45.98	45.98	13200.0
2011-03-25	AMJ	ETF	37.87	37.87	37.69	37.81	296482.0
2011-03-25	AMLP	ETF	81.5	81.7	81.25	81.6	88060.0
2011-03-25	AOA	ETF	35.63	35.84	35.59	35.68	3600.0
2011-03-25	AOK	ETF	29.21	29.21	29.12	29.1438	24285.0
2011-03-25	AOM	ETF	30.51	30.5284	30.43	30.47	29878.0
2011-03-25	AOR	ETF	32.43	32.53	32.39	32.4	17711.0
2011-03-25	ARB	ETF	38.12	39.07	38.06	38.37	102534.0
2011-03-25	ARGT	ETF	29.7	29.7	29.4	29.46	3700.0
2011-03-25	ASEA	ETF	15.67	15.67	15.62	15.66	800.0
2011-03-25	BAB	ETF	25.41	25.42	25.201	25.26	115929.0
2011-03-25	BAL	ETF	108.14	109.2	104.69	105.67	178527.0
2011-03-25	BALT	ETF	9.02	9.2	8.87	8.93	100565.0
2011-03-25	BBH	ETF	35.0933	35.2167	34.9567	34.9933	48000.0
2011-03-25	BIB	ETF	8.02	8.045	7.9175	8.0062	23200.0
2011-03-25	BICK	ETF	32.17	32.45	32.17	32.3	4294.0
2011-03-25	BIL	ETF	91.7	91.72	91.7	91.7	1271900.0
2011-03-25	BIS	ETF	7420.8	7460.8	7414.4	7460.8	10.0
2011-03-25	BITS	ETF	24.76	25.98	24.48	25.68	9012.0
2011-03-25	BIV	ETF	82.32	82.44	82.04	82.13	87100.0
2011-03-25	BJK	ETF	31.95	32.22	31.95	32.02	699400.0
2011-03-25	BKF	ETF	49.01	49.41	48.97	49.0	129700.0
2011-03-25	BKLN	ETF	24.98	25.03	24.97	25.02	40700.0
2011-03-25	BLV	ETF	78.69	78.86	78.28	78.4	23600.0
2011-03-25	BMVP	ETF	15.39	15.53	15.39	15.45	18440.0
2011-03-25	BND	ETF	80.36	80.39	80.12	80.18	727400.0
2011-03-25	BNO	ETF	38.365	38.51	38.31	38.47	39000.0
2011-03-25	BRF	ETF	54.01	54.1	53.54	53.55	206681.0
2011-03-25	BSCE	ETF	20.9056	20.92	20.8725	20.9	6201.0
2011-03-25	BSV	ETF	80.4	80.42	80.21	80.27	682200.0
2011-03-25	BTF	ETF	84.3	84.3	83.39999999999999	83.75	2538.4
2011-03-25	BWX	ETF	30.16	30.19	29.98	30.065	229650.0

> showing 50 of 835 rows — these rows as CSV

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