PREVIEW / etf_daily / 2012-01-31

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-31.parquet
  size:    38 KB
  rows:    909

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-01-31	SPY	ETF	132.02	132.18	130.68	131.32	157212000.0
2012-01-31	QQQ	ETF	60.75	60.86	60.14	60.53	51449601.0
2012-01-31	IWM	ETF	79.66	79.82	78.58	79.02	52024000.0
2012-01-31	DIA	ETF	126.88	126.92	125.38	126.07	5951700.0
2012-01-31	GLD	ETF	169.77	169.86	167.72	169.31	11192500.0
2012-01-31	TLT	ETF	119.26	120.91	119.19	120.85	7998300.0
2012-01-31	AADR	ETF	29.04	29.04	29.04	29.04	400.0
2012-01-31	AAXJ	ETF	55.3	55.48	54.87	55.08	392100.0
2012-01-31	ACTV	ETF	14.65	14.94	14.5	14.88	86498.0
2012-01-31	ACWI	ETF	44.85	44.86	44.31	44.48	1128600.0
2012-01-31	ACWV	ETF	52.21	52.21	51.89	52.19	3600.0
2012-01-31	ACWX	ETF	39.29	39.32	38.86	39.11	3118237.0
2012-01-31	ADRE	ETF	42.72	42.93	42.2318	42.41	61843.0
2012-01-31	AFK	ETF	28.4	28.41	28.0	28.1516	9386.0
2012-01-31	AGEM	ETF	23.18	23.18	22.94	22.98	1100.0
2012-01-31	AGG	ETF	110.84	111.07	110.72	111.05	3255900.0
2012-01-31	AGQ	ETF	248.0	248.36	232.56	236.32	835075.0
2012-01-31	AGZ	ETF	113.24	113.5399	113.03	113.47	26314.0
2012-01-31	AIA	ETF	43.37	43.37	42.92	43.1	26893.0
2012-01-31	AIQ	ETF	5.7	5.8	5.6	5.7	9823.0
2012-01-31	AIS	ETF	2.61	2.63	2.51	2.56	1442307.0
2012-01-31	AIVI	ETF	40.85	40.85	40.29	40.52	168600.0
2012-01-31	AMJ	ETF	39.69	39.75	39.44	39.72	1245590.0
2012-01-31	AMLP	ETF	84.2	84.2	83.7	84.15	481680.0
2012-01-31	AOA	ETF	34.9	34.9	34.56	34.67	12100.0
2012-01-31	AOK	ETF	29.79	29.84	29.75	29.84	28440.0
2012-01-31	AOM	ETF	30.57	30.601	30.491	30.59	63428.0
2012-01-31	AOR	ETF	32.31	32.32	32.1064	32.24	70172.0
2012-01-31	ARB	ETF	36.82	36.82	35.55	35.71	130444.0
2012-01-31	ARGT	ETF	23.4	23.4	23.4	23.4	250.0
2012-01-31	ASEA	ETF	15.64	15.66	15.52	15.57	1600.0
2012-01-31	AWAY	ETF	26.59	27.25	26.13	27.04	275045.0
2012-01-31	BAB	ETF	29.3	29.39	29.14	29.39	266049.0
2012-01-31	BAL	ETF	58.77	58.77	57.63	57.9	12455.0
2012-01-31	BALT	ETF	4.27	4.28	4.21	4.23	76277.0
2012-01-31	BBH	ETF	42.08	42.7633	41.94	42.0067	35100.0
2012-01-31	BCM	ETF	45.27	45.27	44.9799	45.05	1862.0
2012-01-31	BIB	ETF	10.6263	10.695	10.5625	10.695	39920.0
2012-01-31	BICK	ETF	26.71	26.74	26.27	26.5	16339.0
2012-01-31	BIL	ETF	91.66	91.66	91.64	91.64	416800.0
2012-01-31	BIS	ETF	4254.4	4254.4	4188.8	4211.2	116.5
2012-01-31	BITS	ETF	22.76	22.76	22.52	22.68	1125.0
2012-01-31	BIV	ETF	88.09	88.36	88.07	88.3	283500.0
2012-01-31	BJK	ETF	33.01	33.01	32.69	32.84	5600.0
2012-01-31	BKF	ETF	41.5	41.62	40.94	41.16	128799.0
2012-01-31	BKLN	ETF	24.39	24.51	24.3	24.42	95600.0
2012-01-31	BLV	ETF	92.21	92.9	92.18	92.85	45000.0
2012-01-31	BMVP	ETF	14.4467	14.4551	14.3233	14.3953	5869.0
2012-01-31	BND	ETF	84.03	84.07	83.9	84.07	3801200.0
2012-01-31	BNO	ETF	39.23	39.23	38.5	38.645	74800.0

> showing 50 of 909 rows — these rows as CSV

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