PREVIEW / etf_daily / 2012-02-16

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-16.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-02-16	SPY	ETF	134.57	136.17	134.33	136.05	186567800.0
2012-02-16	QQQ	ETF	62.79	63.7	62.63	63.63	83642235.0
2012-02-16	IWM	ETF	81.32	82.9	81.28	82.8	61456800.0
2012-02-16	DIA	ETF	127.98	129.18	127.95	129.07	8699000.0
2012-02-16	GLD	ETF	166.33	168.14	166.17	168.0	10734000.0
2012-02-16	TLT	ETF	117.27	117.6	116.13	116.61	9036200.0
2012-02-16	AADR	ETF	30.45	30.45	30.45	30.45	200.0
2012-02-16	AAXJ	ETF	57.11	57.68	57.0	57.63	251900.0
2012-02-16	ACTV	ETF	15.74	15.92	15.63	15.76	169461.0
2012-02-16	ACWI	ETF	45.64	46.23	45.55	46.17	835500.0
2012-02-16	ACWV	ETF	52.7	52.7	52.7	52.7	500.0
2012-02-16	ACWX	ETF	40.07	40.6	39.93	40.58	176974.0
2012-02-16	ADRE	ETF	43.0	43.73	42.88	43.73	97321.0
2012-02-16	AFK	ETF	28.87	29.17	28.75	29.1	9525.0
2012-02-16	AGEM	ETF	23.75	24.07	23.75	24.038	6945.0
2012-02-16	AGG	ETF	110.5	110.58	110.38	110.48	918800.0
2012-02-16	AGQ	ETF	230.32	240.16	228.6	239.32	463900.0
2012-02-16	AGZ	ETF	113.09	113.09	112.8205	112.97	13093.0
2012-02-16	AIA	ETF	44.35	44.8271	44.34	44.775	16787.0
2012-02-16	AIQ	ETF	6.9	7.25	6.9	7.2	8058.0
2012-02-16	AIS	ETF	2.5	2.51	2.43	2.47	1101280.0
2012-02-16	AIVI	ETF	41.04	41.7	40.92	41.67	162500.0
2012-02-16	AMJ	ETF	40.75	41.27	40.7	41.18	2874008.0
2012-02-16	AMLP	ETF	84.7	85.25	84.5	85.1	413980.0
2012-02-16	AOA	ETF	35.46	35.82	35.46	35.82	63200.0
2012-02-16	AOK	ETF	29.97	30.07	29.95	30.06	30182.0
2012-02-16	AOM	ETF	30.88	31.0396	30.88	31.0	47850.0
2012-02-16	AOR	ETF	32.65	32.94	32.65	32.94	31276.0
2012-02-16	ARB	ETF	34.47	35.23	34.41	35.2	216024.0
2012-02-16	ASEA	ETF	15.76	15.86	15.72	15.86	13300.0
2012-02-16	AWAY	ETF	26.27	27.13	26.27	26.98	240865.0
2012-02-16	BAB	ETF	29.3	29.3155	29.12	29.22	123640.0
2012-02-16	BAL	ETF	56.87	57.29	56.61	57.28	8066.0
2012-02-16	BALT	ETF	4.37	4.64	4.3	4.51	308210.0
2012-02-16	BBH	ETF	43.71	44.14	43.64	44.01	15500.0
2012-02-16	BCM	ETF	45.43	45.43	45.43	45.43	600.0
2012-02-16	BIB	ETF	11.375	11.7688	11.375	11.6738	87776.0
2012-02-16	BICK	ETF	27.82	28.11	27.7	28.09	10419.0
2012-02-16	BIL	ETF	91.66	91.66	91.64	91.66	442200.0
2012-02-16	BIS	ETF	3851.2	3851.2	3795.2	3795.2	27.8
2012-02-16	BITS	ETF	22.12	22.12	21.56	22.12	125.0
2012-02-16	BIV	ETF	87.78	87.83	87.48	87.59	515100.0
2012-02-16	BJK	ETF	33.56	33.99	33.54	33.99	5500.0
2012-02-16	BKF	ETF	42.74	43.43	42.54	43.4	149498.0
2012-02-16	BKLN	ETF	24.43	24.48	24.38	24.44	121800.0
2012-02-16	BLV	ETF	91.01	91.2	90.36	90.74	39100.0
2012-02-16	BMVP	ETF	14.9433	15.23	14.9433	15.2265	3807.0
2012-02-16	BND	ETF	83.71	83.78	83.61	83.7	976100.0
2012-02-16	BNO	ETF	41.75	42.005	41.6	41.905	95400.0
2012-02-16	BOIL	ETF	1291000.0	1368000.0	1280000.0	1350000.0	7.6

> showing 50 of 921 rows — these rows as CSV

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