PREVIEW / etf_daily / 2012-08-16

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-16.parquet
  size:    38 KB
  rows:    933

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
2012-08-16	SPY	ETF	141.15	142.16	140.8	141.99	112014200.0
2012-08-16	QQQ	ETF	67.47	68.17	67.39	68.02	35706443.0
2012-08-16	IWM	ETF	80.18	81.3	79.83	81.14	46037700.0
2012-08-16	DIA	ETF	131.77	132.75	131.5	132.57	5340400.0
2012-08-16	GLD	ETF	155.85	157.09	155.5	156.56	8838300.0
2012-08-16	TLT	ETF	122.21	122.5	120.52	121.01	13240000.0
2012-08-16	AAXJ	ETF	54.34	54.62	54.12	54.44	210100.0
2012-08-16	ACTV	ETF	11.5	11.73	11.43	11.54	718347.0
2012-08-16	ACWI	ETF	45.69	46.03	45.55	45.98	317300.0
2012-08-16	ACWV	ETF	55.8	56.08	55.75	56.03	24100.0
2012-08-16	ACWX	ETF	38.49	38.884	38.46	38.78	121908.0
2012-08-16	ADRE	ETF	38.95	39.16	38.84	39.12	35450.0
2012-08-16	AFK	ETF	29.25	29.61	29.25	29.4201	27538.0
2012-08-16	AGEM	ETF	21.8	22.03	21.8	22.03	437.0
2012-08-16	AGG	ETF	111.3	111.32	110.97	111.1	668300.0
2012-08-16	AGQ	ETF	155.44	159.64	154.2	158.72	173350.0
2012-08-16	AGZ	ETF	113.2	113.21	113.1	113.132	19331.0
2012-08-16	AIA	ETF	43.28	43.59	43.25	43.46	16807.0
2012-08-16	AIQ	ETF	6.95	7.25	5.95	6.25	166437.0
2012-08-16	AIVI	ETF	39.44	39.94	39.42	39.84	29000.0
2012-08-16	AMJ	ETF	39.83	40.067	39.71	40.02	494728.0
2012-08-16	AMLP	ETF	81.65	81.95	81.4	81.9	409360.0
2012-08-16	ANGL	ETF	26.25	26.25	26.05	26.05	5500.0
2012-08-16	AOA	ETF	36.0	36.2	35.89	36.18	15300.0
2012-08-16	AOK	ETF	30.13	30.15	30.0753	30.13	13483.0
2012-08-16	AOM	ETF	31.17	31.23	31.17	31.23	5718.0
2012-08-16	AOR	ETF	33.1	33.3	33.1	33.2496	6947.0
2012-08-16	ARB	ETF	36.29	36.41	35.7	36.34	70718.0
2012-08-16	ARGT	ETF	17.28	17.28	17.28	17.28	100.0
2012-08-16	ASEA	ETF	16.45	16.54	16.45	16.48	2200.0
2012-08-16	AWAY	ETF	24.34	24.98	24.3	24.8	575655.0
2012-08-16	BAB	ETF	29.63	29.75	29.46	29.47	339620.0
2012-08-16	BAL	ETF	48.21	48.21	47.86	47.97	17244.0
2012-08-16	BALT	ETF	3.22	3.26	3.1	3.15	75187.0
2012-08-16	BBH	ETF	50.48	50.48	49.95	50.0	10100.0
2012-08-16	BCM	ETF	44.69	44.69	44.61	44.61	780.0
2012-08-16	BIB	ETF	13.875	13.9	13.6988	13.8413	40880.0
2012-08-16	BICK	ETF	23.11	23.4	23.11	23.3764	6920.0
2012-08-16	BIL	ETF	91.62	91.64	91.62	91.62	538500.0
2012-08-16	BIS	ETF	2918.4	2937.6	2918.4	2937.6	6.75
2012-08-16	BIV	ETF	88.74	88.76	88.43	88.53	166800.0
2012-08-16	BJK	ETF	31.32	31.83	31.32	31.75	5300.0
2012-08-16	BKF	ETF	36.86	37.08	36.7	37.02	100239.0
2012-08-16	BKLN	ETF	24.67	24.67	24.63	24.65	753200.0
2012-08-16	BLV	ETF	94.51	94.72	93.5	93.8	62000.0
2012-08-16	BMVP	ETF	15.89	16.01	15.863	16.01	3598.0
2012-08-16	BND	ETF	84.24	84.25	84.0	84.09	723800.0
2012-08-16	BNO	ETF	41.205	41.475	40.94	41.205	116600.0
2012-08-16	BOIL	ETF	847200.0	886000.0	808600.0	817800.0	20.2
2012-08-16	BOND	ETF	106.6	106.72	106.311	106.416	800354.0

> showing 50 of 933 rows — these rows as CSV

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