PREVIEW / etf_daily / 2012-04-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-13.parquet
  size:    38 KB
  rows:    921

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-04-13	SPY	ETF	138.47	138.82	137.01	137.14	169246700.0
2012-04-13	QQQ	ETF	66.96	67.2022	66.16	66.19	55227428.0
2012-04-13	IWM	ETF	80.38	80.41	79.43	79.54	53965200.0
2012-04-13	DIA	ETF	129.32	129.36	128.27	128.4	8826800.0
2012-04-13	GLD	ETF	162.45	162.46	160.17	160.85	10041000.0
2012-04-13	TLT	ETF	116.15	116.9	116.12	116.84	8607700.0
2012-04-13	AAXJ	ETF	56.5	56.5	55.72	55.8	7286000.0
2012-04-13	ACTV	ETF	16.74	17.24	16.28	16.5	228003.0
2012-04-13	ACWI	ETF	46.16	46.17	45.67	45.67	527100.0
2012-04-13	ACWV	ETF	53.49	53.49	53.49	53.49	100.0
2012-04-13	ACWX	ETF	39.78	39.78	39.29	39.3	149931.0
2012-04-13	ADRE	ETF	41.48	41.51	41.07	41.23	16402.0
2012-04-13	AFK	ETF	28.67	28.67	28.45	28.488	2480.0
2012-04-13	AGEM	ETF	22.83	22.83	22.8215	22.8215	301.0
2012-04-13	AGG	ETF	110.3	110.38	110.21	110.36	1103900.0
2012-04-13	AGQ	ETF	215.56	215.72	203.6	205.56	581525.0
2012-04-13	AGZ	ETF	112.72	112.8	112.6	112.769	20046.0
2012-04-13	AIA	ETF	44.71	44.71	44.21	44.29	7517.0
2012-04-13	AIQ	ETF	7.45	7.45	7.1	7.1	10776.0
2012-04-13	AIS	ETF	3.11	3.12	2.99	2.99	749213.0
2012-04-13	AIVI	ETF	39.91	39.91	39.46	39.48	75000.0
2012-04-13	AMJ	ETF	38.47	38.85	38.47	38.66	748882.0
2012-04-13	AMLP	ETF	81.85	82.8	81.85	82.55	294140.0
2012-04-13	ANGL	ETF	25.25	25.33	25.25	25.32	5300.0
2012-04-13	AOA	ETF	35.82	35.82	35.53	35.57	25100.0
2012-04-13	AOK	ETF	30.02	30.02	29.941	29.9509	22169.0
2012-04-13	AOM	ETF	31.04	31.04	30.9	30.9136	55473.0
2012-04-13	AOR	ETF	32.99	32.99	32.78	32.78	18316.0
2012-04-13	ARB	ETF	37.15	38.03	37.04	37.92	354967.0
2012-04-13	ARGT	ETF	19.98	20.04	19.98	20.04	5150.0
2012-04-13	ASEA	ETF	16.24	16.24	16.03	16.11	3900.0
2012-04-13	AWAY	ETF	24.4	24.67	23.92	24.08	226247.0
2012-04-13	BAB	ETF	29.45	29.4527	29.35	29.43	131733.0
2012-04-13	BAL	ETF	55.81	56.002	55.21	55.76	9000.0
2012-04-13	BALT	ETF	4.18	4.19	4.03	4.08	54271.0
2012-04-13	BBH	ETF	42.95	42.95	42.42	42.45	9300.0
2012-04-13	BCM	ETF	45.1	45.1	44.69	44.69	4931.0
2012-04-13	BIB	ETF	11.2762	11.2762	10.9625	10.9625	14816.0
2012-04-13	BICK	ETF	25.87	25.9291	25.8012	25.8086	3570.0
2012-04-13	BIL	ETF	91.62	91.64	91.62	91.62	148550.0
2012-04-13	BIS	ETF	3936.0	3972.16	3936.0	3942.56	47.5
2012-04-13	BIV	ETF	87.6	87.71	87.49	87.65	369800.0
2012-04-13	BJK	ETF	36.13	36.15	35.85	36.02	65000.0
2012-04-13	BKF	ETF	40.76	40.87	40.26	40.46	109688.0
2012-04-13	BKLN	ETF	24.39	24.43	24.35	24.36	759400.0
2012-04-13	BLNG	ETF	50.67	50.67	50.67	50.67	415.0
2012-04-13	BLV	ETF	90.38	90.95	90.38	90.85	58400.0
2012-04-13	BMVP	ETF	15.3	15.3	15.25	15.26	3890.0
2012-04-13	BND	ETF	83.62	83.74	83.58	83.71	2484000.0
2012-04-13	BNO	ETF	42.745	42.82	42.49	42.82	41800.0

> showing 50 of 921 rows — these rows as CSV

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