PREVIEW / etf_daily / 2012-01-24

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-24.parquet
  size:    38 KB
  rows:    900

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-24	SPY	ETF	130.8	131.5	130.6	131.46	103083300.0
2012-01-24	QQQ	ETF	59.54	59.84	59.41	59.68	38440197.0
2012-01-24	IWM	ETF	77.68	78.75	77.27	78.6	49856900.0
2012-01-24	DIA	ETF	126.1	126.55	125.87	126.43	4798200.0
2012-01-24	GLD	ETF	161.81	162.37	161.53	162.01	7502100.0
2012-01-24	TLT	ETF	116.71	116.71	115.78	116.45	5776500.0
2012-01-24	AADR	ETF	28.88	28.88	28.88	28.88	400.0
2012-01-24	AAXJ	ETF	54.59	55.0	54.35	54.98	170000.0
2012-01-24	ACTV	ETF	14.22	14.59	14.16	14.48	73594.0
2012-01-24	ACWI	ETF	44.0	44.38	43.99	44.34	985700.0
2012-01-24	ACWV	ETF	52.17	52.51	52.17	52.32	8700.0
2012-01-24	ACWX	ETF	38.39	38.7	38.35	38.66	594688.0
2012-01-24	ADRE	ETF	41.76	42.22	41.7403	42.18	21432.0
2012-01-24	AFK	ETF	26.92	27.67	26.92	27.346	15690.0
2012-01-24	AGG	ETF	109.97	109.99	109.84	109.98	791600.0
2012-01-24	AGQ	ETF	222.84	224.8	218.8	219.48	337825.0
2012-01-24	AGZ	ETF	112.6	112.88	112.52	112.56	173280.0
2012-01-24	AIA	ETF	42.53	42.97	42.53	42.896	55826.0
2012-01-24	AIQ	ETF	5.8	5.8	5.6	5.75	7977.0
2012-01-24	AIS	ETF	2.18	2.27	2.17	2.27	937221.0
2012-01-24	AIVI	ETF	39.94	40.23	39.85	40.2	94900.0
2012-01-24	AMJ	ETF	39.6	39.89	39.6	39.69	1005188.0
2012-01-24	AMLP	ETF	84.2	84.5	83.9	84.2	335500.0
2012-01-24	AOA	ETF	34.31	34.61	34.31	34.61	4400.0
2012-01-24	AOK	ETF	29.59	29.62	29.56	29.62	90379.0
2012-01-24	AOM	ETF	30.35	30.4	30.3	30.39	59751.0
2012-01-24	AOR	ETF	31.88	32.06	31.88	32.04	28635.0
2012-01-24	ARB	ETF	36.02	36.47	35.7	36.27	150514.0
2012-01-24	ARGT	ETF	23.7	23.72	23.66	23.68	1400.0
2012-01-24	ASEA	ETF	15.38	15.55	15.38	15.48	4400.0
2012-01-24	AWAY	ETF	25.68	26.13	25.2	26.02	452249.0
2012-01-24	BAB	ETF	28.69	28.69	28.524	28.59	196243.0
2012-01-24	BAL	ETF	61.3	61.5049	60.19	60.63	58739.0
2012-01-24	BALT	ETF	4.41	4.4885	4.31	4.34	79059.0
2012-01-24	BBH	ETF	39.9633	40.5167	39.8933	40.4433	39000.0
2012-01-24	BCM	ETF	44.47	44.749	44.47	44.749	700.0
2012-01-24	BIB	ETF	9.9062	10.131	9.9062	10.125	28640.0
2012-01-24	BICK	ETF	26.07	26.44	26.07	26.362	13542.0
2012-01-24	BIL	ETF	91.64	91.66	91.64	91.64	216150.0
2012-01-24	BIS	ETF	4587.2	4587.2	4472.0	4481.6	34.05
2012-01-24	BITS	ETF	22.6	22.8	22.6	22.8	100.0
2012-01-24	BIV	ETF	86.74	86.86	86.55	86.77	185300.0
2012-01-24	BJK	ETF	32.04	32.37	31.98	32.23	8400.0
2012-01-24	BKF	ETF	40.5	40.946	40.39	40.92	75778.0
2012-01-24	BKLN	ETF	24.22	24.24	24.14	24.22	95900.0
2012-01-24	BLV	ETF	90.28	90.28	89.51	90.07	123300.0
2012-01-24	BMVP	ETF	14.35	14.45	14.34	14.44	11584.0
2012-01-24	BND	ETF	83.38	83.38	83.25	83.29	1057600.0
2012-01-24	BNO	ETF	38.225	38.395	38.21	38.365	77600.0
2012-01-24	BOIL	ETF	1529000.0	1583000.0	1428000.0	1487000.0	5.4

> showing 50 of 900 rows — these rows as CSV

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