PREVIEW / etf_daily / 2011-10-27

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-27.parquet
  size:    38 KB
  rows:    895

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-10-27	SPY	ETF	127.63	129.42	126.61	128.63	393220200.0
2011-10-27	QQQ	ETF	58.64	59.2	58.03	58.85	104455431.0
2011-10-27	IWM	ETF	75.29	76.97	72.65	76.42	130508100.0
2011-10-27	DIA	ETF	121.08	122.58	120.45	121.94	12948500.0
2011-10-27	GLD	ETF	167.59	170.29	166.65	169.55	15876900.0
2011-10-27	TLT	ETF	112.52	112.85	109.82	110.3	19471400.0
2011-10-27	AADR	ETF	29.18	29.62	29.15	29.62	65300.0
2011-10-27	AAXJ	ETF	54.99	56.63	54.85	56.23	648200.0
2011-10-27	ACTV	ETF	14.56	14.67	14.06	14.36	134005.0
2011-10-27	ACWI	ETF	45.2	45.67	44.6	45.33	1153400.0
2011-10-27	ACWV	ETF	52.29	52.29	52.29	52.29	100.0
2011-10-27	ACWX	ETF	40.5	41.266	40.33	41.04	554583.0
2011-10-27	ADRE	ETF	41.35	42.3571	41.28	42.09	89625.0
2011-10-27	AFK	ETF	28.68	29.41	28.58	29.276	50007.0
2011-10-27	AGEM	ETF	23.15	23.69	23.07	23.69	7592.0
2011-10-27	AGG	ETF	109.39	109.42	108.91	109.08	960200.0
2011-10-27	AGQ	ETF	263.4	286.36	259.48	281.04	903725.0
2011-10-27	AGZ	ETF	112.03	112.13	111.671	111.671	23913.0
2011-10-27	AIA	ETF	42.38	43.44	42.0552	42.96	66159.0
2011-10-27	AIQ	ETF	6.25	6.75	5.8	6.1	49794.0
2011-10-27	AIS	ETF	2.34	2.35	2.26	2.34	1030266.0
2011-10-27	AIVI	ETF	44.07	44.6	43.63	44.46	113400.0
2011-10-27	AMJ	ETF	37.94	37.94	37.328	37.48	3594358.0
2011-10-27	AMLP	ETF	81.5	81.5	80.25	80.7	592600.0
2011-10-27	AOA	ETF	34.02	34.5	33.83	34.29	62600.0
2011-10-27	AOK	ETF	29.43	29.46	29.34	29.43	90482.0
2011-10-27	AOM	ETF	30.33	30.4	30.18	30.33	206962.0
2011-10-27	AOR	ETF	31.79	31.95	31.6	31.82	122917.0
2011-10-27	ARB	ETF	41.78	42.15	40.62	41.06	236182.0
2011-10-27	ARGT	ETF	22.92	23.38	22.92	23.38	1400.0
2011-10-27	ASEA	ETF	15.56	16.05	15.49	15.74	44000.0
2011-10-27	AWAY	ETF	37.0	37.86	35.9	37.32	173347.0
2011-10-27	BAB	ETF	27.81	27.81	27.38	27.51	187378.0
2011-10-27	BAL	ETF	62.99	64.6132	62.99	64.5	60093.0
2011-10-27	BALT	ETF	5.97	6.07	5.77	5.93	209020.0
2011-10-27	BBH	ETF	36.0767	36.1933	35.64	36.1367	40200.0
2011-10-27	BCM	ETF	45.46	45.46	45.46	45.46	225.0
2011-10-27	BIB	ETF	7.9988	8.0638	7.8297	7.9925	48368.0
2011-10-27	BICK	ETF	27.05	27.43	26.67	27.15	10560.0
2011-10-27	BIL	ETF	91.68	91.7	91.68	91.68	1490300.0
2011-10-27	BIS	ETF	6056.0	6129.6	5900.8	5900.8	6.9
2011-10-27	BITS	ETF	23.0	23.52	22.496	22.92	1181.0
2011-10-27	BIV	ETF	87.0	87.15	86.48	86.75	199900.0
2011-10-27	BJK	ETF	32.73	33.59	32.56	33.26	127500.0
2011-10-27	BKF	ETF	40.67	41.87	40.36	41.45	223189.0
2011-10-27	BKLN	ETF	23.97	24.12	23.97	24.04	240200.0
2011-10-27	BLV	ETF	89.35	89.63	87.75	88.23	132800.0
2011-10-27	BMVP	ETF	14.14	14.3667	14.0067	14.3667	17645.0
2011-10-27	BND	ETF	83.29	83.31	82.9	82.95	1586200.0
2011-10-27	BNO	ETF	38.475	38.645	38.225	38.4	380600.0

> showing 50 of 895 rows — these rows as CSV

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