PREVIEW / etf_daily / 2012-06-12

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-12.parquet
  size:    38 KB
  rows:    934

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-12	SPY	ETF	131.79	133.01	131.16	132.92	181931800.0
2012-06-12	QQQ	ETF	62.09	62.59	61.68	62.56	48802598.0
2012-06-12	IWM	ETF	75.44	76.26	74.78	76.22	56599400.0
2012-06-12	DIA	ETF	124.4	125.66	124.04	125.59	4923700.0
2012-06-12	GLD	ETF	155.49	157.04	155.45	156.46	13241100.0
2012-06-12	TLT	ETF	124.97	125.63	124.5	124.63	10921700.0
2012-06-12	AAXJ	ETF	51.26	51.66	51.11	51.65	223400.0
2012-06-12	ACTV	ETF	14.7	14.95	14.58	14.95	401699.0
2012-06-12	ACWI	ETF	42.64	43.0	42.37	42.98	425200.0
2012-06-12	ACWV	ETF	52.98	53.35	52.98	53.35	12700.0
2012-06-12	ACWX	ETF	36.06	36.35	35.8	36.35	121986.0
2012-06-12	ADRE	ETF	36.54	36.88	36.5	36.88	29235.0
2012-06-12	AFK	ETF	27.07	27.37	27.04	27.3144	94970.0
2012-06-12	AGEM	ETF	20.18	20.45	20.18	20.45	780.0
2012-06-12	AGG	ETF	110.98	111.04	110.83	110.91	482000.0
2012-06-12	AGQ	ETF	169.76	171.84	167.28	170.8	344225.0
2012-06-12	AGZ	ETF	113.3001	113.399	113.2101	113.348	8340.0
2012-06-12	AIA	ETF	40.53	40.73	40.5	40.71	20883.0
2012-06-12	AIQ	ETF	4.8	4.95	4.65	4.9	9142.0
2012-06-12	AIS	ETF	3.29	3.31	3.25	3.27	954084.0
2012-06-12	AIVI	ETF	37.12	37.36	36.77	37.29	52800.0
2012-06-12	AMJ	ETF	36.34	36.78	36.01	36.38	1369262.0
2012-06-12	AMLP	ETF	77.85	78.75	77.85	78.35	298500.0
2012-06-12	ANGL	ETF	25.05	25.05	25.02	25.05	900.0
2012-06-12	AOA	ETF	34.09	34.26	33.96	34.26	16800.0
2012-06-12	AOK	ETF	29.6	29.65	29.52	29.65	24604.0
2012-06-12	AOM	ETF	30.3275	30.44	30.26	30.39	12748.0
2012-06-12	AOR	ETF	31.91	32.05	31.78	32.0	61006.0
2012-06-12	ARB	ETF	33.55	33.91	33.25	33.88	105364.0
2012-06-12	ARGT	ETF	15.56	15.56	15.28	15.28	1700.0
2012-06-12	ASEA	ETF	14.93	15.15	14.87	15.05	39900.0
2012-06-12	AWAY	ETF	21.62	21.62	19.76	20.38	1821447.0
2012-06-12	BAB	ETF	29.87	29.9	29.77	29.82	141735.0
2012-06-12	BAL	ETF	45.47	46.02	45.29	45.779	31697.0
2012-06-12	BALT	ETF	3.15	3.27	3.12	3.26	116356.0
2012-06-12	BBH	ETF	44.86	44.91	44.38	44.91	5100.0
2012-06-12	BCM	ETF	40.49	40.56	40.43	40.54	42964.0
2012-06-12	BIB	ETF	11.6725	11.765	11.4488	11.765	22456.0
2012-06-12	BICK	ETF	22.15	22.33	22.08	22.33	8232.0
2012-06-12	BIL	ETF	91.66	91.66	91.64	91.66	245950.0
2012-06-12	BIS	ETF	3625.6	3657.6	3548.8	3548.8	6.8
2012-06-12	BIV	ETF	88.52	88.61	88.22	88.22	228400.0
2012-06-12	BJK	ETF	31.41	31.6	31.41	31.6	3300.0
2012-06-12	BKF	ETF	35.26	35.52	35.016	35.49	211448.0
2012-06-12	BKLN	ETF	24.07	24.27	24.0	24.27	188900.0
2012-06-12	BLV	ETF	94.21	94.46	93.86	93.92	44500.0
2012-06-12	BMVP	ETF	14.49	14.64	14.49	14.64	6014.0
2012-06-12	BND	ETF	84.19	84.21	84.07	84.1	1194400.0
2012-06-12	BNO	ETF	34.58	34.67	34.31	34.445	31600.0
2012-06-12	BOIL	ETF	638200.0	653600.0	623000.0	624000.0	5.2

> showing 50 of 934 rows — these rows as CSV

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