PREVIEW / etf_daily / 2011-07-13

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-13.parquet
  size:    36 KB
  rows:    868

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
2011-07-13	SPY	ETF	132.09	133.22	131.52	131.84	204062600.0
2011-07-13	QQQ	ETF	57.94	58.34	57.55	57.76	82374518.0
2011-07-13	IWM	ETF	83.38	84.47	83.22	83.59	79327200.0
2011-07-13	DIA	ETF	124.96	125.94	124.49	124.8	7366800.0
2011-07-13	GLD	ETF	153.76	154.71	153.58	154.14	26351000.0
2011-07-13	TLT	ETF	96.71	97.43	96.11	97.4	13112200.0
2011-07-13	AADR	ETF	31.2	31.2	31.2	31.2	300.0
2011-07-13	AAXJ	ETF	61.3	61.91	61.16	61.21	555800.0
2011-07-13	ACTV	ETF	18.73	18.99	18.4801	18.69	49766.0
2011-07-13	ACWI	ETF	47.51	48.11	47.44	47.68	412100.0
2011-07-13	ACWX	ETF	43.85	44.256	43.62	43.91	514876.0
2011-07-13	ADRE	ETF	45.37	45.8908	45.27	45.58	78443.0
2011-07-13	AFK	ETF	31.24	31.78	31.24	31.41	60781.0
2011-07-13	AGEM	ETF	25.62	26.03	25.62	25.8927	2407.0
2011-07-13	AGG	ETF	107.43	107.72	107.4	107.71	508400.0
2011-07-13	AGQ	ETF	377.54	398.18	376.58	395.56	1511150.0
2011-07-13	AGZ	ETF	110.94	111.054	110.94	110.974	4773.0
2011-07-13	AIA	ETF	45.9	46.42	45.9	46.01	32143.0
2011-07-13	AIQ	ETF	18.3	18.6	18.1	18.25	26865.0
2011-07-13	AIS	ETF	2.4	2.5	2.4	2.44	1177606.0
2011-07-13	AIVI	ETF	44.95	45.7	44.89	45.23	81900.0
2011-07-13	AMJ	ETF	37.2	37.36	37.1	37.15	430712.0
2011-07-13	AMLP	ETF	80.65	80.65	80.0	80.1	76040.0
2011-07-13	AOA	ETF	36.05	36.09	35.75	35.75	7900.0
2011-07-13	AOK	ETF	29.39	29.5	29.39	29.47	10193.0
2011-07-13	AOM	ETF	30.684	30.76	30.684	30.69	4147.0
2011-07-13	AOR	ETF	32.7485	32.7485	32.6	32.63	1689.0
2011-07-13	ARB	ETF	40.98	41.28	40.32	40.57	101168.0
2011-07-13	ARGT	ETF	29.94	29.94	29.94	29.94	1000.0
2011-07-13	ASEA	ETF	16.77	16.86	16.77	16.77	5700.0
2011-07-13	AWAY	ETF	41.81	42.48	41.15	41.95	256716.0
2011-07-13	BAB	ETF	26.7	26.7	26.49	26.67	118596.0
2011-07-13	BAL	ETF	65.59	67.61	64.8108	67.11	148514.0
2011-07-13	BALT	ETF	5.25	5.317	4.99	5.08	239461.0
2011-07-13	BBH	ETF	35.3767	35.53	35.2067	35.3067	56400.0
2011-07-13	BCM	ETF	48.33	48.33	48.28	48.28	824.0
2011-07-13	BIB	ETF	9.9325	10.0638	9.8362	9.8688	130600.0
2011-07-13	BICK	ETF	31.28	31.8434	31.28	31.572	4557.0
2011-07-13	BIL	ETF	91.7	91.72	91.7	91.72	1115500.0
2011-07-13	BIS	ETF	5870.4	5870.4	5692.8	5731.2	17.65
2011-07-13	BITS	ETF	21.72	22.84	21.68	22.84	2093.0
2011-07-13	BIV	ETF	85.03	85.39	84.99	85.37	82500.0
2011-07-13	BJK	ETF	35.39	35.72	35.18	35.26	45100.0
2011-07-13	BKF	ETF	46.51	47.22	46.45	46.94	110718.0
2011-07-13	BKLN	ETF	24.79	24.87	24.79	24.87	56600.0
2011-07-13	BLNG	ETF	50.15	50.15	50.15	50.15	100.0
2011-07-13	BLV	ETF	81.74	82.38	81.5	82.36	67200.0
2011-07-13	BMVP	ETF	15.79	15.9133	15.6937	15.7066	14888.0
2011-07-13	BND	ETF	81.79	81.98	81.75	81.98	1043600.0
2011-07-13	BNO	ETF	38.91	39.715	38.91	39.34	194000.0

> showing 50 of 868 rows — these rows as CSV

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