PREVIEW / etf_daily / 2011-10-04

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-04.parquet
  size:    37 KB
  rows:    878

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
2011-10-04	SPY	ETF	108.35	112.58	107.43	112.34	459177500.0
2011-10-04	QQQ	ETF	50.595	52.29	50.095	52.19	137011447.0
2011-10-04	IWM	ETF	60.32	64.88	60.09	64.79	165100000.0
2011-10-04	DIA	ETF	105.08	108.09	103.84	107.72	18100000.0
2011-10-04	GLD	ETF	160.95	161.03	155.27	157.64	24000000.0
2011-10-04	TLT	ETF	124.37	125.03	122.18	122.24	17301400.0
2011-10-04	AADR	ETF	24.69	24.7	24.62	24.7	3100.0
2011-10-04	AAXJ	ETF	44.84	46.27	44.27	46.2	517200.0
2011-10-04	ACTV	ETF	14.04	15.94	14.04	15.92	138383.0
2011-10-04	ACWI	ETF	37.48	38.74	37.09	38.73	925600.0
2011-10-04	ACWX	ETF	33.71	34.56	33.23	34.56	316299.0
2011-10-04	ADRE	ETF	34.64	35.51	34.09	35.48	73171.0
2011-10-04	AFK	ETF	25.43	25.94	25.24	25.901	14733.0
2011-10-04	AGEM	ETF	18.95	19.02	18.72	18.776	5776.0
2011-10-04	AGG	ETF	110.43	110.53	109.99	110.0	1351400.0
2011-10-04	AGQ	ETF	217.76	218.86	192.88	211.32	950000.0
2011-10-04	AGZ	ETF	112.98	112.98	112.7	112.7	24523.0
2011-10-04	AIA	ETF	35.2	36.28	34.746	36.18	85968.0
2011-10-04	AIQ	ETF	5.65	5.95	5.05	5.85	40260.0
2011-10-04	AIS	ETF	2.15	2.32	2.1	2.28	970609.0
2011-10-04	AIVI	ETF	37.13	38.07	36.67	38.06	109400.0
2011-10-04	AMJ	ETF	32.97	33.14	31.54	33.14	3515701.0
2011-10-04	AMLP	ETF	74.95	75.0	71.5	74.95	184440.0
2011-10-04	AOA	ETF	29.09	30.09	28.76	30.09	29000.0
2011-10-04	AOK	ETF	28.33	28.43	28.18	28.35	18292.0
2011-10-04	AOM	ETF	28.46	28.6	28.35	28.5156	94278.0
2011-10-04	AOR	ETF	28.58	29.27	27.84	29.23	68488.0
2011-10-04	ARB	ETF	32.42	36.43	32.42	36.21	243450.0
2011-10-04	ARGT	ETF	18.24	18.62	18.22	18.62	1350.0
2011-10-04	ASEA	ETF	13.1	13.41	12.95	13.41	11300.0
2011-10-04	AWAY	ETF	32.5	33.57	32.02	33.39	208818.0
2011-10-04	BAB	ETF	29.13	29.35	28.91	29.06	215265.0
2011-10-04	BAL	ETF	61.84	64.287	61.6902	63.41	105049.0
2011-10-04	BALT	ETF	4.17	5.01	4.17	4.93	220531.0
2011-10-04	BBH	ETF	31.0633	31.8033	30.9633	31.8033	66300.0
2011-10-04	BIB	ETF	6.25	6.6475	6.2337	6.6475	91288.0
2011-10-04	BICK	ETF	20.74	21.43	20.57	21.43	89197.0
2011-10-04	BIL	ETF	91.7	91.7	91.68	91.7	691050.0
2011-10-04	BIS	ETF	7766.4	7843.2	7283.2	7283.2	24.55
2011-10-04	BITS	ETF	21.2	22.8	21.2	22.0	1900.0
2011-10-04	BIV	ETF	87.79	87.86	87.22	87.33	206800.0
2011-10-04	BJK	ETF	25.96	26.82	25.63	26.81	17200.0
2011-10-04	BKF	ETF	32.48	33.08	31.7829	33.01	220065.0
2011-10-04	BKLN	ETF	22.71	22.8	22.5	22.7	334400.0
2011-10-04	BLNG	ETF	49.4	49.4	49.4	49.4	200.0
2011-10-04	BLV	ETF	93.53	93.68	92.0	92.1	91300.0
2011-10-04	BMVP	ETF	11.47	11.97	11.34	11.97	55104.0
2011-10-04	BND	ETF	84.0	84.05	83.65	83.67	1500000.0
2011-10-04	BNO	ETF	33.6	34.235	33.4	34.03	145000.0
2011-10-04	BRF	ETF	37.78	38.2	36.85	38.14	416135.0

> showing 50 of 878 rows — these rows as CSV

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