PREVIEW / etf_daily / 2012-09-19

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-19.parquet
  size:    39 KB
  rows:    942

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-09-19	SPY	ETF	146.79	147.17	146.41	146.7	128318300.0
2012-09-19	QQQ	ETF	70.29	70.58	70.06	70.4	36484572.0
2012-09-19	IWM	ETF	85.94	86.03	85.41	85.57	29342000.0
2012-09-19	DIA	ETF	135.85	136.24	135.55	135.73	3080800.0
2012-09-19	GLD	ETF	171.88	172.03	171.19	171.74	9125800.0
2012-09-19	TLT	ETF	121.34	121.38	120.61	121.11	5903300.0
2012-09-19	AADR	ETF	29.91	30.28	29.91	30.23	2600.0
2012-09-19	AAXJ	ETF	56.6	56.7	56.35	56.6	376500.0
2012-09-19	ACTV	ETF	12.43	12.99	12.41	12.9	619995.0
2012-09-19	ACWI	ETF	47.85	47.94	47.68	47.8	173000.0
2012-09-19	ACWV	ETF	56.09	56.61	56.09	56.48	14500.0
2012-09-19	ACWX	ETF	40.6	40.72	40.47	40.65	61381.0
2012-09-19	ADRE	ETF	40.39	40.41	40.14	40.23	42364.0
2012-09-19	AFK	ETF	31.63	31.7	31.52	31.62	22220.0
2012-09-19	AGEM	ETF	22.7222	22.7222	22.7222	22.7222	440.0
2012-09-19	AGG	ETF	111.87	111.91	111.76	111.84	732200.0
2012-09-19	AGQ	ETF	235.84	237.8	232.76	235.56	326075.0
2012-09-19	AGZ	ETF	113.67	113.81	113.57	113.75	24653.0
2012-09-19	AIA	ETF	44.91	45.02	44.868	44.95	7864.0
2012-09-19	AIQ	ETF	7.15	7.15	6.65	7.0	3704.0
2012-09-19	AIVI	ETF	41.76	42.04	41.73	41.97	19400.0
2012-09-19	ALTL	ETF	26.14	26.24	26.14	26.214	1740.0
2012-09-19	AMJ	ETF	40.3	40.41	40.23	40.35	627900.0
2012-09-19	AMLP	ETF	83.1	83.15	82.6	82.75	648200.0
2012-09-19	ANGL	ETF	26.8	26.8	26.52	26.69	2100.0
2012-09-19	AOA	ETF	37.36	37.48	37.33	37.46	7200.0
2012-09-19	AOK	ETF	30.68	30.68	30.637	30.64	17075.0
2012-09-19	AOM	ETF	31.96	31.96	31.864	31.94	21614.0
2012-09-19	AOR	ETF	34.1335	34.24	34.1335	34.2	13644.0
2012-09-19	ARB	ETF	38.27	38.27	37.89	38.05	131925.0
2012-09-19	ARGT	ETF	18.16	18.24	17.98	18.02	500.0
2012-09-19	ASEA	ETF	16.83	16.9	16.81	16.89	4300.0
2012-09-19	AWAY	ETF	24.28	24.91	24.2	24.91	796015.0
2012-09-19	BAB	ETF	29.75	29.795	29.68	29.728	309547.0
2012-09-19	BAL	ETF	50.5299	50.54	50.19	50.3	25104.0
2012-09-19	BALT	ETF	3.4	3.66	3.4	3.52	220229.0
2012-09-19	BBH	ETF	54.21	54.35	54.05	54.23	49200.0
2012-09-19	BIB	ETF	16.2175	16.235	15.875	16.0337	55992.0
2012-09-19	BICK	ETF	24.07	24.189	24.03	24.12	13600.0
2012-09-19	BIL	ETF	91.62	91.64	91.62	91.62	178100.0
2012-09-19	BIS	ETF	2497.6	2536.0	2497.6	2500.96	25.85
2012-09-19	BIV	ETF	89.67	89.7	89.51	89.63	195000.0
2012-09-19	BJK	ETF	34.49	34.5	34.33	34.46	1800.0
2012-09-19	BKF	ETF	38.36	38.47	38.23	38.25	66853.0
2012-09-19	BKLN	ETF	25.05	25.05	25.02	25.04	732600.0
2012-09-19	BLV	ETF	95.08	95.17	94.58	94.83	114800.0
2012-09-19	BMVP	ETF	16.25	16.41	16.25	16.29	48758.0
2012-09-19	BND	ETF	84.64	84.71	84.6	84.61	1133600.0
2012-09-19	BNO	ETF	39.815	39.83	38.82	39.005	331400.0
2012-09-19	BOIL	ETF	840600.0	849600.0	802200.0	820600.0	13.4

> showing 50 of 942 rows — these rows as CSV

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