PREVIEW / etf_daily / 2012-01-25

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-25.parquet
  size:    37 KB
  rows:    899

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-25	SPY	ETF	131.26	132.87	130.75	132.56	198613200.0
2012-01-25	QQQ	ETF	60.28	60.58	59.8335	60.43	61591782.0
2012-01-25	IWM	ETF	78.6	79.57	78.19	79.27	68272900.0
2012-01-25	DIA	ETF	126.06	127.52	125.47	127.25	9642500.0
2012-01-25	GLD	ETF	161.07	166.55	160.29	166.42	28957700.0
2012-01-25	TLT	ETF	116.06	118.53	115.89	116.17	12867600.0
2012-01-25	AAXJ	ETF	54.84	55.65	54.58	55.5	243400.0
2012-01-25	ACTV	ETF	14.44	14.61	14.4	14.52	79110.0
2012-01-25	ACWI	ETF	44.25	44.88	44.05	44.75	626100.0
2012-01-25	ACWV	ETF	52.08	52.34	51.96	52.34	4900.0
2012-01-25	ACWX	ETF	38.5	39.25	38.356	39.11	424037.0
2012-01-25	ADRE	ETF	41.96	42.854	41.85	42.84	73986.0
2012-01-25	AFK	ETF	27.25	27.717	26.8	27.7	5760.0
2012-01-25	AGEM	ETF	22.94	23.19	22.785	23.155	4898.0
2012-01-25	AGG	ETF	109.98	110.48	109.85	110.14	1559600.0
2012-01-25	AGQ	ETF	217.76	239.2	213.72	237.56	935800.0
2012-01-25	AGZ	ETF	112.712	113.2	112.56	112.9055	98163.0
2012-01-25	AIA	ETF	42.81	43.57	42.78	43.5	31345.0
2012-01-25	AIQ	ETF	5.7	5.95	5.6	5.9	11555.0
2012-01-25	AIS	ETF	2.36	2.45	2.25	2.37	1499606.0
2012-01-25	AIVI	ETF	39.95	40.74	39.8	40.7	103600.0
2012-01-25	AMJ	ETF	39.72	40.17	39.7	40.15	620535.0
2012-01-25	AMLP	ETF	84.2	84.55	84.0	84.55	455120.0
2012-01-25	AOA	ETF	34.56	34.97	34.44	34.93	7500.0
2012-01-25	AOK	ETF	29.62	29.78	29.555	29.75	92886.0
2012-01-25	AOM	ETF	30.3312	30.58	30.32	30.559	106504.0
2012-01-25	AOR	ETF	31.9599	32.25	31.94	32.25	21807.0
2012-01-25	ARB	ETF	36.17	37.0	36.07	36.84	144234.0
2012-01-25	ARGT	ETF	23.4	24.0	23.4	24.0	350.0
2012-01-25	ASEA	ETF	15.38	15.61	15.38	15.61	10900.0
2012-01-25	AWAY	ETF	25.99	26.96	25.22	26.59	182659.0
2012-01-25	BAB	ETF	28.65	28.88	28.55	28.58	257487.0
2012-01-25	BAL	ETF	60.22	60.35	58.61	59.63	41606.0
2012-01-25	BALT	ETF	4.33	4.34	4.2	4.24	109555.0
2012-01-25	BBH	ETF	41.0	42.04	41.0	42.0233	56100.0
2012-01-25	BIB	ETF	10.2513	10.6363	10.25	10.6224	96304.0
2012-01-25	BICK	ETF	26.2	26.6174	26.2	26.6174	4567.0
2012-01-25	BIL	ETF	91.64	91.66	91.64	91.64	269800.0
2012-01-25	BIS	ETF	4451.2	4451.2	4241.6	4264.0	243.0
2012-01-25	BITS	ETF	22.72	22.8	22.28	22.72	3147.0
2012-01-25	BIV	ETF	86.83	87.31	86.8	87.12	654000.0
2012-01-25	BJK	ETF	32.07	32.79	32.07	32.72	12100.0
2012-01-25	BKF	ETF	40.92	41.68	40.73	41.61	121967.0
2012-01-25	BKLN	ETF	24.2	24.3	24.16	24.23	145100.0
2012-01-25	BLV	ETF	89.81	91.27	89.81	90.33	36400.0
2012-01-25	BMVP	ETF	14.41	14.55	14.31	14.54	8298.0
2012-01-25	BND	ETF	83.35	83.77	83.31	83.53	1101200.0
2012-01-25	BNO	ETF	38.125	38.575	37.955	38.44	106000.0
2012-01-25	BOIL	ETF	1531000.0	1720000.0	1529000.0	1694000.0	5.6
2012-01-25	BRF	ETF	40.97	42.11	40.79	42.06	363137.0

> showing 50 of 899 rows — these rows as CSV

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