PREVIEW / etf_daily / 2012-02-03

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-03.parquet
  size:    38 KB
  rows:    916

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-03	SPY	ETF	134.0	134.62	133.77	134.54	160598500.0
2012-02-03	QQQ	ETF	61.78	62.12	61.6799	62.05	36453755.0
2012-02-03	IWM	ETF	82.47	83.22	82.24	82.95	72738000.0
2012-02-03	DIA	ETF	128.04	128.49	127.83	128.37	8654000.0
2012-02-03	GLD	ETF	169.88	170.14	167.51	167.64	23355300.0
2012-02-03	TLT	ETF	116.46	116.8	115.97	116.57	12467400.0
2012-02-03	AAXJ	ETF	56.99	57.31	56.81	57.29	263000.0
2012-02-03	ACTV	ETF	15.0	15.36	14.93	15.36	488650.0
2012-02-03	ACWI	ETF	45.65	45.9	45.52	45.9	775100.0
2012-02-03	ACWV	ETF	52.97	52.97	52.97	52.97	200.0
2012-02-03	ACWX	ETF	40.26	40.46	40.11	40.45	305370.0
2012-02-03	ADRE	ETF	43.83	43.99	43.63	43.88	34445.0
2012-02-03	AFK	ETF	29.26	29.3	29.0208	29.24	10400.0
2012-02-03	AGEM	ETF	24.24	24.24	23.982	24.15	5141.0
2012-02-03	AGG	ETF	110.3	110.6	110.22	110.56	1142400.0
2012-02-03	AGQ	ETF	246.0	247.52	237.4	241.8	719150.0
2012-02-03	AGZ	ETF	113.1023	113.12	112.89	113.1	16862.0
2012-02-03	AIA	ETF	43.92	44.25	43.91	44.21	15941.0
2012-02-03	AIQ	ETF	6.4	6.7	6.105	6.7	43009.0
2012-02-03	AIS	ETF	2.66	2.69	2.6	2.68	1425828.0
2012-02-03	AIVI	ETF	41.26	41.65	41.21	41.65	80800.0
2012-02-03	AMJ	ETF	40.37	40.42	40.0212	40.17	1069589.0
2012-02-03	AMLP	ETF	85.05	85.1	84.6	84.7	351500.0
2012-02-03	AOA	ETF	35.36	35.57	35.35	35.56	20700.0
2012-02-03	AOK	ETF	29.9499	29.99	29.91	29.99	33978.0
2012-02-03	AOM	ETF	30.86	30.91	30.79	30.9	40125.0
2012-02-03	AOR	ETF	32.7	32.77	32.64	32.77	67177.0
2012-02-03	ARB	ETF	34.75	35.04	34.63	34.94	203975.0
2012-02-03	ASEA	ETF	16.07	16.17	16.02	16.16	7000.0
2012-02-03	AWAY	ETF	27.25	27.25	26.58	27.02	488869.0
2012-02-03	BAB	ETF	28.95	29.11	28.9	29.03	287005.0
2012-02-03	BAL	ETF	59.49	60.49	59.339	59.9	21339.0
2012-02-03	BALT	ETF	4.26	4.26	4.02	4.1	201142.0
2012-02-03	BBH	ETF	43.8967	43.94	43.3333	43.5967	30300.0
2012-02-03	BCM	ETF	45.49	45.5	45.2519	45.5	4033.0
2012-02-03	BIB	ETF	11.5738	11.6625	11.375	11.5038	88656.0
2012-02-03	BICK	ETF	27.87	27.879	27.71	27.81	16368.0
2012-02-03	BIL	ETF	91.64	91.66	91.64	91.64	365200.0
2012-02-03	BIS	ETF	3897.6	3931.52	3865.6	3904.0	58.5
2012-02-03	BITS	ETF	22.24	22.6	22.0	22.56	2453.0
2012-02-03	BIV	ETF	87.92	87.92	87.65	87.83	349800.0
2012-02-03	BJK	ETF	33.94	34.13	33.9	34.1	28800.0
2012-02-03	BKF	ETF	43.0	43.18	42.89	43.01	172814.0
2012-02-03	BKLN	ETF	24.48	24.57	24.48	24.54	148000.0
2012-02-03	BLV	ETF	90.47	90.69	90.29	90.67	32000.0
2012-02-03	BMVP	ETF	14.79	14.89	14.78	14.87	10094.0
2012-02-03	BND	ETF	83.77	83.81	83.69	83.8	1326000.0
2012-02-03	BNO	ETF	39.575	39.925	39.275	39.85	206400.0
2012-02-03	BOIL	ETF	1320000.0	1393000.0	1283000.0	1338000.0	6.8
2012-02-03	BRF	ETF	44.5	44.82	44.12	44.49	293936.0

> showing 50 of 916 rows — these rows as CSV

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