PREVIEW / etf_daily / 2012-11-29

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-29.parquet
  size:    39 KB
  rows:    949

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-29	SPY	ETF	141.99	142.51	141.37	142.12	151085900.0
2012-11-29	QQQ	ETF	65.82	66.135	65.58	65.91	41135813.0
2012-11-29	IWM	ETF	81.95	82.41	81.62	82.24	53043500.0
2012-11-29	DIA	ETF	130.23	130.54	129.51	130.14	6112800.0
2012-11-29	GLD	ETF	167.14	167.5	166.85	167.18	7446800.0
2012-11-29	TLT	ETF	124.86	125.44	124.66	125.13	2761000.0
2012-11-29	AADR	ETF	30.61	30.64	30.54	30.64	400.0
2012-11-29	AAXJ	ETF	57.79	58.14	57.76	58.05	164400.0
2012-11-29	ACTV	ETF	4.82	5.17	4.79	5.05	1203576.0
2012-11-29	ACWI	ETF	47.12	47.29	46.95	47.21	371500.0
2012-11-29	ACWV	ETF	56.48	56.51	56.27	56.37	13500.0
2012-11-29	ACWX	ETF	40.53	40.64	40.36	40.59	132081.0
2012-11-29	ADRE	ETF	38.2	38.5347	38.1801	38.48	134472.0
2012-11-29	AFK	ETF	30.02	30.277	30.02	30.2399	26496.0
2012-11-29	AGEM	ETF	22.33	22.33	22.144	22.144	1530.0
2012-11-29	AGG	ETF	112.14	112.31	112.14	112.31	661800.0
2012-11-29	AGQ	ETF	222.52	228.64	222.28	226.4	343825.0
2012-11-29	AGZ	ETF	113.95	113.95	113.8199	113.85	16894.0
2012-11-29	AIA	ETF	46.09	46.27	45.98	46.03	27181.0
2012-11-29	AIQ	ETF	6.1	6.25	5.95	5.95	67386.0
2012-11-29	AIVI	ETF	40.48	40.66	40.37	40.55	20600.0
2012-11-29	AMJ	ETF	39.78	39.91	39.6001	39.76	951135.0
2012-11-29	AMLP	ETF	81.55	81.75	81.35	81.6	438120.0
2012-11-29	ANGL	ETF	27.02	27.03	26.81	26.87	13400.0
2012-11-29	AOA	ETF	36.77	36.83	36.62	36.77	15300.0
2012-11-29	AOK	ETF	30.51	30.59	30.51	30.55	15300.0
2012-11-29	AOM	ETF	31.57	31.68	31.57	31.68	24809.0
2012-11-29	AOR	ETF	33.75	33.7886	33.651	33.75	7057.0
2012-11-29	ARB	ETF	37.07	37.17	36.69	37.0	77952.0
2012-11-29	ARGT	ETF	16.02	16.28	16.02	16.28	300.0
2012-11-29	ASEA	ETF	16.71	16.74	16.61	16.65	5400.0
2012-11-29	AWAY	ETF	20.89	21.33	20.68	21.01	316332.0
2012-11-29	BAB	ETF	30.59	30.62	30.5101	30.58	150876.0
2012-11-29	BAL	ETF	47.736	48.11	47.736	47.78	14085.0
2012-11-29	BALT	ETF	2.94	3.05	2.88	3.03	123344.0
2012-11-29	BBH	ETF	54.25	54.85	54.24	54.83	23300.0
2012-11-29	BCM	ETF	44.9959	44.9959	44.85	44.9116	1640.0
2012-11-29	BIB	ETF	14.775	15.16	14.7747	15.1175	75032.0
2012-11-29	BICK	ETF	23.78	23.9	23.78	23.9	3373.0
2012-11-29	BIL	ETF	91.62	91.64	91.62	91.62	1176750.0
2012-11-29	BIS	ETF	2657.6	2657.6	2575.6	2580.0	57.0
2012-11-29	BIV	ETF	90.47	90.55	90.43	90.54	214200.0
2012-11-29	BJK	ETF	35.71	35.85	35.71	35.75	8600.0
2012-11-29	BKF	ETF	37.97	38.246	37.905	38.12	78240.0
2012-11-29	BKLN	ETF	24.67	24.72	24.63	24.68	1759900.0
2012-11-29	BLV	ETF	96.99	97.21	96.76	97.08	52400.0
2012-11-29	BMVP	ETF	15.92	16.02	15.92	15.99	19069.0
2012-11-29	BND	ETF	84.92	85.02	84.91	85.0	921600.0
2012-11-29	BNO	ETF	40.635	40.695	40.38	40.45	40000.0
2012-11-29	BOIL	ETF	998000.0	1003400.0	946000.0	951400.0	23.8

> showing 50 of 949 rows — these rows as CSV

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