PREVIEW / etf_daily / 2012-07-24

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-24.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-07-24	SPY	ETF	135.19	135.25	133.03	133.93	173301200.0
2012-07-24	QQQ	ETF	63.58	63.66	62.55	62.96	57269688.0
2012-07-24	IWM	ETF	77.95	77.98	76.22	76.65	55609200.0
2012-07-24	DIA	ETF	126.93	127.01	124.94	125.86	7077400.0
2012-07-24	GLD	ETF	153.63	153.8	152.2	153.52	6538900.0
2012-07-24	TLT	ETF	130.35	132.04	130.28	131.82	6748800.0
2012-07-24	AAXJ	ETF	50.97	51.17	50.48	50.77	153500.0
2012-07-24	ACTV	ETF	14.58	14.62	14.4	14.42	130900.0
2012-07-24	ACWI	ETF	43.02	43.04	42.36	42.63	120000.0
2012-07-24	ACWV	ETF	55.5	55.5	53.94	54.18	12600.0
2012-07-24	ACWX	ETF	35.85	35.89	35.31	35.53	90736.0
2012-07-24	ADRE	ETF	36.66	36.66	36.09	36.29	53577.0
2012-07-24	AFK	ETF	27.47	27.5999	27.1884	27.45	15552.0
2012-07-24	AGG	ETF	112.47	112.68	112.43	112.66	521200.0
2012-07-24	AGQ	ETF	147.92	148.08	142.04	146.24	272150.0
2012-07-24	AGZ	ETF	114.03	114.16	114.01	114.06	14226.0
2012-07-24	AIA	ETF	39.9701	40.14	39.849	40.13	37039.0
2012-07-24	AIQ	ETF	4.05	4.35	3.65	4.0	19651.0
2012-07-24	AIVI	ETF	36.28	36.28	35.01	35.66	176800.0
2012-07-24	AMJ	ETF	39.53	39.84	39.17	39.28	968877.0
2012-07-24	AMLP	ETF	82.55	82.6	81.75	82.0	369600.0
2012-07-24	ANGL	ETF	25.5	25.5	25.5	25.5	300.0
2012-07-24	AOA	ETF	34.64	34.64	34.15	34.23	15400.0
2012-07-24	AOK	ETF	29.78	29.841	29.76	29.81	5227.0
2012-07-24	AOM	ETF	30.59	30.59	30.49	30.51	3236.0
2012-07-24	AOR	ETF	32.16	32.19	32.01	32.0151	19769.0
2012-07-24	ARB	ETF	35.5	35.78	34.57	34.82	108669.0
2012-07-24	ARGT	ETF	15.58	15.58	15.58	15.58	100.0
2012-07-24	ASEA	ETF	15.8	15.8	15.58	15.62	17500.0
2012-07-24	AWAY	ETF	22.09	22.93	21.73	22.0	638672.0
2012-07-24	BAB	ETF	30.53	30.77	30.52	30.76	257608.0
2012-07-24	BAL	ETF	47.78	47.89	46.49	46.69	18322.0
2012-07-24	BALT	ETF	3.36	3.38	3.25	3.25	42378.0
2012-07-24	BBH	ETF	48.24	48.24	47.33	47.43	28000.0
2012-07-24	BCM	ETF	42.95	43.06	42.9499	43.06	5550.0
2012-07-24	BIB	ETF	13.5013	13.5013	12.9625	12.9625	45960.0
2012-07-24	BICK	ETF	21.42	21.42	21.123	21.2336	5974.0
2012-07-24	BIL	ETF	91.62	91.64	91.62	91.64	225300.0
2012-07-24	BIS	ETF	3169.6	3169.6	3169.6	3169.6	3.125
2012-07-24	BIV	ETF	90.03	90.29	90.01	90.22	259600.0
2012-07-24	BJK	ETF	30.5	30.51	29.9	29.97	23900.0
2012-07-24	BKF	ETF	34.64	34.66	34.05	34.33	72715.0
2012-07-24	BKLN	ETF	24.52	24.54	24.46	24.54	177700.0
2012-07-24	BLV	ETF	98.5	99.48	98.34	99.37	85500.0
2012-07-24	BMVP	ETF	14.9667	14.9863	14.8189	14.86	7137.0
2012-07-24	BND	ETF	85.17	85.35	85.13	85.3	743200.0
2012-07-24	BNO	ETF	36.905	36.905	36.665	36.87	18800.0
2012-07-24	BOIL	ETF	1101200.0	1136000.0	1079000.0	1114400.0	11.0
2012-07-24	BOND	ETF	107.49	107.6	107.462	107.57	456133.0
2012-07-24	BRF	ETF	34.51	34.51	34.0025	34.29	62119.0

> showing 50 of 931 rows — these rows as CSV

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