PREVIEW / etf_daily / 2012-11-19

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-19.parquet
  size:    39 KB
  rows:    950

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-11-19	SPY	ETF	137.9	139.15	136.41	139.13	151495800.0
2012-11-19	QQQ	ETF	62.97	63.83	62.96	63.7806	55306381.0
2012-11-19	IWM	ETF	78.32	79.18	78.22	79.12	45621100.0
2012-11-19	DIA	ETF	126.63	127.68	126.51	127.63	9551500.0
2012-11-19	GLD	ETF	167.75	168.16	167.38	167.87	6764500.0
2012-11-19	TLT	ETF	125.46	125.81	125.3	125.66	3621600.0
2012-11-19	AADR	ETF	29.31	29.4	29.24	29.35	1100.0
2012-11-19	AAXJ	ETF	56.15	56.59	56.15	56.59	124300.0
2012-11-19	ACTV	ETF	5.02	5.18	4.96	5.03	564343.0
2012-11-19	ACWI	ETF	45.64	46.07	45.64	46.06	504600.0
2012-11-19	ACWV	ETF	55.23	56.46	55.23	55.65	37100.0
2012-11-19	ACWX	ETF	39.01	39.38	39.01	39.36	133107.0
2012-11-19	ADRE	ETF	37.93	38.0287	37.87	38.02	37976.0
2012-11-19	AFK	ETF	30.93	31.049	30.88	30.98	18490.0
2012-11-19	AGEM	ETF	21.99	22.11	21.97	22.08	81470.0
2012-11-19	AGG	ETF	112.09	112.29	112.06	112.29	917000.0
2012-11-19	AGQ	ETF	210.48	213.4	208.04	212.28	259125.0
2012-11-19	AGZ	ETF	113.96	114.019	113.83	113.89	38700.0
2012-11-19	AIA	ETF	44.53	44.84	44.51	44.84	23543.0
2012-11-19	AIQ	ETF	6.25	6.35	6.1	6.25	21750.0
2012-11-19	AIVI	ETF	38.68	39.08	38.68	39.03	23100.0
2012-11-19	AMJ	ETF	38.82	39.68	38.82	39.48	1812278.0
2012-11-19	AMLP	ETF	79.9	80.65	79.5	80.5	711360.0
2012-11-19	ANGL	ETF	26.64	26.68	26.44	26.63	88500.0
2012-11-19	AOA	ETF	35.75	35.94	35.75	35.94	13000.0
2012-11-19	AOK	ETF	30.26	30.32	30.25	30.312	15858.0
2012-11-19	AOM	ETF	31.16	31.3	31.16	31.3	104353.0
2012-11-19	AOR	ETF	33.15	33.23	33.1	33.23	20494.0
2012-11-19	ARB	ETF	35.98	36.29	35.851	36.22	68417.0
2012-11-19	ARGT	ETF	15.74	15.74	15.74	15.74	300.0
2012-11-19	ASEA	ETF	16.55	16.58	16.48	16.57	14900.0
2012-11-19	AWAY	ETF	21.52	21.71	20.97	21.0201	391760.0
2012-11-19	BAB	ETF	30.48	30.49	30.4	30.44	164622.0
2012-11-19	BAL	ETF	47.69	47.69	46.9	46.9	4172.0
2012-11-19	BALT	ETF	2.92	2.93	2.84	2.88	170141.0
2012-11-19	BBH	ETF	52.8	52.8	52.2	52.69	22400.0
2012-11-19	BIB	ETF	13.75	13.75	13.32	13.7472	131180.0
2012-11-19	BICK	ETF	23.14	23.36	23.14	23.3325	2539.0
2012-11-19	BIL	ETF	91.62	91.64	91.62	91.64	133650.0
2012-11-19	BIV	ETF	90.39	90.44	90.31	90.38	268400.0
2012-11-19	BJK	ETF	34.21	34.47	34.17	34.36	66700.0
2012-11-19	BKF	ETF	37.33	37.68	37.33	37.66	45894.0
2012-11-19	BKLN	ETF	24.58	24.68	24.52	24.65	1866800.0
2012-11-19	BLV	ETF	97.29	97.42	97.01	97.2	187300.0
2012-11-19	BMVP	ETF	15.46	15.59	15.46	15.59	5926.0
2012-11-19	BND	ETF	84.9	84.96	84.85	84.95	1094200.0
2012-11-19	BNO	ETF	40.59	41.045	40.535	40.895	167200.0
2012-11-19	BOIL	ETF	1075800.0	1100000.0	1051400.0	1062200.0	6.0
2012-11-19	BOND	ETF	110.03	110.04	109.93	110.036	354433.0
2012-11-19	BRF	ETF	38.94	39.18	38.7708	39.02	47618.0

> showing 50 of 950 rows — these rows as CSV

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