PREVIEW / etf_daily / 2012-08-23

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-23.parquet
  size:    38 KB
  rows:    931

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-23	SPY	ETF	141.47	141.48	140.44	140.66	111466400.0
2012-08-23	QQQ	ETF	68.14	68.34	67.6905	67.87	28802214.0
2012-08-23	IWM	ETF	81.06	81.06	80.2	80.52	32208500.0
2012-08-23	DIA	ETF	131.26	131.29	130.2	130.38	4159600.0
2012-08-23	GLD	ETF	161.41	162.45	161.23	161.89	17237600.0
2012-08-23	TLT	ETF	124.74	125.14	124.65	124.93	7139100.0
2012-08-23	AADR	ETF	29.06	29.06	29.06	29.06	600.0
2012-08-23	AAXJ	ETF	54.17	54.28	53.82	53.93	195200.0
2012-08-23	ACTV	ETF	11.25	11.25	10.94	10.99	343451.0
2012-08-23	ACWI	ETF	45.94	45.94	45.57	45.63	416500.0
2012-08-23	ACWV	ETF	55.78	55.91	55.7	55.75	6100.0
2012-08-23	ACWX	ETF	38.73	38.7312	38.42	38.51	1590612.0
2012-08-23	ADRE	ETF	38.76	38.76	38.24	38.35	32882.0
2012-08-23	AFK	ETF	29.47	29.48	29.3356	29.3465	4118.0
2012-08-23	AGEM	ETF	21.77	21.86	21.7	21.7055	5726.0
2012-08-23	AGG	ETF	111.84	111.94	111.83	111.9	421500.0
2012-08-23	AGQ	ETF	186.44	188.96	183.84	185.6	596450.0
2012-08-23	AGZ	ETF	113.52	113.73	113.52	113.52	8943.0
2012-08-23	AIA	ETF	42.71	42.71	42.48	42.48	19719.0
2012-08-23	AIQ	ETF	6.8	6.95	6.6	6.7	20442.0
2012-08-23	AIVI	ETF	39.72	39.83	39.54	39.65	37000.0
2012-08-23	AMJ	ETF	40.05	40.05	39.5	39.65	376620.0
2012-08-23	AMLP	ETF	81.45	81.45	81.0	81.15	357700.0
2012-08-23	ANGL	ETF	26.65	26.65	26.2	26.3	1900.0
2012-08-23	AOA	ETF	36.11	36.15	36.0	36.0	5100.0
2012-08-23	AOK	ETF	30.23	30.25	30.182	30.22	9958.0
2012-08-23	AOM	ETF	31.3058	31.3058	31.2	31.21	133632.0
2012-08-23	AOR	ETF	33.32	33.32	33.171	33.191	31863.0
2012-08-23	ARB	ETF	36.34	36.38	36.0	36.03	79535.0
2012-08-23	ARGT	ETF	17.22	17.3	17.22	17.28	850.0
2012-08-23	ASEA	ETF	16.39	16.44	16.33	16.33	6300.0
2012-08-23	AWAY	ETF	24.85	24.85	23.95	24.0	262426.0
2012-08-23	BAB	ETF	30.04	30.06	29.9608	30.04	227365.0
2012-08-23	BAL	ETF	50.49	50.88	50.01	50.44	8000.0
2012-08-23	BALT	ETF	3.01	3.13	3.0	3.08	35438.0
2012-08-23	BBH	ETF	50.43	50.43	49.92	50.28	5400.0
2012-08-23	BCM	ETF	45.65	45.73	45.65	45.73	1284.0
2012-08-23	BIB	ETF	14.0	14.025	13.9	13.9337	9080.0
2012-08-23	BICK	ETF	23.14	23.14	22.9901	23.01	4719.0
2012-08-23	BIL	ETF	91.62	91.64	91.62	91.62	134200.0
2012-08-23	BIS	ETF	2899.2	2899.2	2899.2	2899.2	23.75
2012-08-23	BIV	ETF	89.45	89.54	89.45	89.5	116400.0
2012-08-23	BJK	ETF	32.4	32.43	32.21	32.24	5300.0
2012-08-23	BKF	ETF	36.9	36.97	36.5302	36.61	68549.0
2012-08-23	BKLN	ETF	24.73	24.74	24.71	24.72	294800.0
2012-08-23	BLV	ETF	96.07	96.26	95.96	96.24	85900.0
2012-08-23	BMVP	ETF	15.9767	15.9767	15.8458	15.8669	2356.0
2012-08-23	BND	ETF	84.77	84.8	84.72	84.72	1125400.0
2012-08-23	BNO	ETF	41.75	41.83	41.205	41.3	48200.0
2012-08-23	BOIL	ETF	867600.0	874200.0	792800.0	868400.0	18.0

> showing 50 of 931 rows — these rows as CSV

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