PREVIEW / etf_daily / 2011-11-21

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-21.parquet
  size:    37 KB
  rows:    897

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-11-21	SPY	ETF	120.2	120.35	118.65	119.66	229611600.0
2011-11-21	QQQ	ETF	54.68	54.73	53.78	54.34	52289447.0
2011-11-21	IWM	ETF	70.54	70.85	69.61	70.26	58233500.0
2011-11-21	DIA	ETF	116.11	116.32	114.28	115.16	18829600.0
2011-11-21	GLD	ETF	166.61	166.71	162.07	163.5	22030700.0
2011-11-21	TLT	ETF	120.38	120.73	119.91	120.05	7345600.0
2011-11-21	AADR	ETF	26.89	27.11	26.89	27.01	2000.0
2011-11-21	AAXJ	ETF	49.58	49.61	48.72	49.01	371100.0
2011-11-21	ACTV	ETF	14.87	14.87	13.76	13.98	258281.0
2011-11-21	ACWI	ETF	41.06	41.06	40.33	40.67	1386600.0
2011-11-21	ACWV	ETF	48.98	49.17	48.98	49.03	600.0
2011-11-21	ACWX	ETF	36.12	36.19	35.63	35.95	370335.0
2011-11-21	ADRE	ETF	38.39	38.52	37.86	38.36	42860.0
2011-11-21	AFK	ETF	26.52	26.52	26.18	26.44	8709.0
2011-11-21	AGEM	ETF	20.86	21.0	20.44	20.548	117970.0
2011-11-21	AGG	ETF	109.76	109.78	109.57	109.6	838800.0
2011-11-21	AGQ	ETF	221.44	226.4	212.0	225.24	706350.0
2011-11-21	AGZ	ETF	112.67	112.67	112.18	112.33	15482.0
2011-11-21	AIA	ETF	39.0	39.0	38.43	38.8	13348.0
2011-11-21	AIQ	ETF	6.0	6.15	5.7	5.8	26261.0
2011-11-21	AIS	ETF	2.65	2.65	2.5	2.62	2608638.0
2011-11-21	AIVI	ETF	39.02	39.02	38.4	38.73	108600.0
2011-11-21	AMJ	ETF	37.03	37.31	36.57	37.04	891171.0
2011-11-21	AMLP	ETF	79.2	80.0	78.65	79.35	184340.0
2011-11-21	AOA	ETF	32.01	32.01	31.6	31.8	11300.0
2011-11-21	AOK	ETF	29.02	29.02	28.934	28.9548	20653.0
2011-11-21	AOM	ETF	29.41	29.45	29.34	29.41	17757.0
2011-11-21	AOR	ETF	30.49	30.49	30.19	30.3	25795.0
2011-11-21	ARB	ETF	38.73	39.31	38.31	38.7	111000.0
2011-11-21	ARGT	ETF	21.3	21.48	21.22	21.48	9550.0
2011-11-21	ASEA	ETF	14.26	14.26	14.07	14.13	3400.0
2011-11-21	AWAY	ETF	30.56	30.87	29.98	30.82	172578.0
2011-11-21	BAB	ETF	28.68	28.79	28.62	28.74	259620.0
2011-11-21	BAL	ETF	57.39	57.5899	55.77	56.32	60218.0
2011-11-21	BALT	ETF	5.0	5.07	4.9	5.02	80748.0
2011-11-21	BBH	ETF	33.26	33.26	32.63	32.9867	48000.0
2011-11-21	BCM	ETF	43.42	43.62	43.03	43.62	2550.0
2011-11-21	BIB	ETF	7.34	7.525	7.34	7.48	76280.0
2011-11-21	BICK	ETF	23.49	23.49	23.018	23.36	23205.0
2011-11-21	BIL	ETF	91.7	91.7	91.68	91.7	2169100.0
2011-11-21	BIS	ETF	6291.2	6320.0	6210.88	6216.0	63.0
2011-11-21	BITS	ETF	21.4	21.8	21.12	21.64	1336.0
2011-11-21	BIV	ETF	87.56	87.64	87.4	87.47	177900.0
2011-11-21	BJK	ETF	29.89	29.89	29.01	29.36	34100.0
2011-11-21	BKF	ETF	36.73	36.732	35.9	36.33	393936.0
2011-11-21	BKLN	ETF	23.97	23.97	23.82	23.86	54200.0
2011-11-21	BLV	ETF	91.98	92.09	91.41	91.64	79200.0
2011-11-21	BMVP	ETF	13.103	13.103	12.939	13.065	8701.0
2011-11-21	BND	ETF	83.67	83.73	83.58	83.6	2076200.0
2011-11-21	BNO	ETF	37.11	37.19	36.655	37.14	70200.0

> showing 50 of 897 rows — these rows as CSV

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