PREVIEW / etf_daily / 2012-06-18

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-18.parquet
  size:    38 KB
  rows:    930

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-06-18	SPY	ETF	133.58	134.73	133.28	134.4	131360900.0
2012-06-18	QQQ	ETF	62.75	63.74	62.63	63.58	32191113.0
2012-06-18	IWM	ETF	76.6	77.6	76.35	77.31	45656600.0
2012-06-18	DIA	ETF	126.8	127.54	126.65	127.13	4568500.0
2012-06-18	GLD	ETF	157.46	158.21	156.54	157.93	6733000.0
2012-06-18	TLT	ETF	127.15	127.34	126.26	127.08	6698400.0
2012-06-18	AAXJ	ETF	52.32	52.59	52.09	52.46	183900.0
2012-06-18	ACTV	ETF	15.66	15.95	15.415	15.71	413116.0
2012-06-18	ACWI	ETF	43.48	43.7	43.34	43.6	594900.0
2012-06-18	ACWV	ETF	54.09	54.51	54.09	54.51	1700.0
2012-06-18	ACWX	ETF	36.56	36.79	36.5	36.75	239851.0
2012-06-18	ADRE	ETF	36.71	37.24	36.71	37.2	18580.0
2012-06-18	AFK	ETF	27.22	27.3583	27.06	27.33	15478.0
2012-06-18	AGEM	ETF	20.67	20.85	20.67	20.74	6820.0
2012-06-18	AGG	ETF	111.33	111.43	111.23	111.35	696000.0
2012-06-18	AGQ	ETF	163.64	168.92	162.72	167.52	249175.0
2012-06-18	AGZ	ETF	113.58	113.699	113.43	113.55	8771.0
2012-06-18	AIA	ETF	41.39	41.59	41.33	41.54	5053.0
2012-06-18	AIQ	ETF	4.5145	4.5995	4.4	4.4035	20665.0
2012-06-18	AIVI	ETF	37.52	37.72	37.33	37.65	185600.0
2012-06-18	AMJ	ETF	36.0	36.23	35.94	36.23	1833869.0
2012-06-18	AMLP	ETF	78.0	78.05	77.6	77.85	370400.0
2012-06-18	ANGL	ETF	25.19	25.19	25.17	25.17	800.0
2012-06-18	AOA	ETF	34.54	34.74	34.5	34.72	5900.0
2012-06-18	AOK	ETF	29.771	29.82	29.764	29.79	9060.0
2012-06-18	AOM	ETF	30.57	30.6609	30.57	30.64	3657.0
2012-06-18	AOR	ETF	32.2	32.39	32.2	32.3	5169.0
2012-06-18	ARB	ETF	34.14	35.15	33.96	34.85	100318.0
2012-06-18	ARGT	ETF	15.38	15.44	15.38	15.44	5600.0
2012-06-18	ASEA	ETF	15.13	15.31	15.13	15.24	11300.0
2012-06-18	AWAY	ETF	21.09	21.8	20.92	21.5	357157.0
2012-06-18	BAB	ETF	29.89	29.92	29.82	29.89	145621.0
2012-06-18	BAL	ETF	46.84	47.79	46.84	47.6135	10630.0
2012-06-18	BALT	ETF	3.27	3.3	3.13	3.25	118454.0
2012-06-18	BBH	ETF	45.66	46.19	45.66	46.06	7900.0
2012-06-18	BCM	ETF	40.63	40.6807	40.61	40.649	34745.0
2012-06-18	BIB	ETF	12.2788	12.5338	11.9038	12.4314	60168.0
2012-06-18	BICK	ETF	22.51	22.5791	22.46	22.5492	2684.0
2012-06-18	BIL	ETF	91.66	91.66	91.64	91.66	132300.0
2012-06-18	BIS	ETF	3499.2	3499.2	3374.24	3374.4	33.75
2012-06-18	BIV	ETF	88.87	88.9	88.71	88.84	160200.0
2012-06-18	BJK	ETF	31.4	31.75	31.4	31.69	36500.0
2012-06-18	BKF	ETF	36.03	36.23	35.75	36.1	83523.0
2012-06-18	BKLN	ETF	24.1	24.16	24.03	24.12	173000.0
2012-06-18	BLNG	ETF	48.17	48.28	48.17	48.18	2600.0
2012-06-18	BLV	ETF	95.31	95.46	95.0	95.31	42400.0
2012-06-18	BMVP	ETF	14.6867	14.8219	14.66	14.82	12542.0
2012-06-18	BND	ETF	84.44	84.46	84.32	84.43	845900.0
2012-06-18	BNO	ETF	33.935	34.265	33.865	34.0	96800.0
2012-06-18	BOIL	ETF	772200.0	843600.0	762000.0	840400.0	15.6

> showing 50 of 930 rows — these rows as CSV

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