PREVIEW / etf_daily / 2011-10-13

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-13.parquet
  size:    36 KB
  rows:    875

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-13	SPY	ETF	120.04	120.87	119.12	120.51	212538800.0
2011-10-13	QQQ	ETF	56.49	57.19	56.43	57.12	63443629.0
2011-10-13	IWM	ETF	69.42	70.12	68.58	69.76	54163300.0
2011-10-13	DIA	ETF	114.53	115.01	113.64	114.66	5493900.0
2011-10-13	GLD	ETF	162.3	162.48	160.82	162.3	8327900.0
2011-10-13	TLT	ETF	115.03	116.55	114.96	115.63	11263300.0
2011-10-13	AADR	ETF	27.65	27.65	27.65	27.65	400.0
2011-10-13	AAXJ	ETF	51.11	51.44	50.6	51.23	302600.0
2011-10-13	ACTV	ETF	14.18	15.0	14.1	14.42	87121.0
2011-10-13	ACWI	ETF	42.04	42.29	41.67	42.14	481100.0
2011-10-13	ACWX	ETF	37.75	37.95	37.404	37.89	208832.0
2011-10-13	ADRE	ETF	38.55	38.81	38.08	38.721	55486.0
2011-10-13	AFK	ETF	26.9	27.25	26.86	27.25	7195.0
2011-10-13	AGEM	ETF	21.48	21.4902	21.06	21.4902	5444.0
2011-10-13	AGG	ETF	109.17	109.32	108.93	109.12	939600.0
2011-10-13	AGQ	ETF	238.32	238.4	228.68	233.6	443725.0
2011-10-13	AGZ	ETF	112.01	112.22	111.9	111.98	18309.0
2011-10-13	AIA	ETF	39.49	39.49	38.94	39.37	83208.0
2011-10-13	AIQ	ETF	6.65	6.6505	6.15	6.45	14609.0
2011-10-13	AIS	ETF	2.33	2.33	2.28	2.32	459273.0
2011-10-13	AIVI	ETF	41.35	41.79	40.99	41.62	110200.0
2011-10-13	AMJ	ETF	35.02	35.34	34.71	35.34	1033406.0
2011-10-13	AMLP	ETF	77.65	77.8	77.05	77.8	104640.0
2011-10-13	AOA	ETF	31.91	32.13	31.81	32.13	3300.0
2011-10-13	AOK	ETF	28.81	28.889	28.81	28.86	9362.0
2011-10-13	AOM	ETF	29.4	29.52	29.37	29.52	14071.0
2011-10-13	AOR	ETF	30.3	30.4901	30.3	30.4	16816.0
2011-10-13	ARB	ETF	38.32	38.57	37.21	37.56	229252.0
2011-10-13	ASEA	ETF	14.54	14.75	14.54	14.75	6300.0
2011-10-13	AWAY	ETF	35.04	35.42	34.09	35.18	155532.0
2011-10-13	BAB	ETF	28.13	28.27	27.94	28.19	138386.0
2011-10-13	BAL	ETF	62.74	63.39	62.26	62.26	58324.0
2011-10-13	BALT	ETF	5.5	5.71	5.29	5.66	115823.0
2011-10-13	BBH	ETF	33.5	34.0633	33.5	33.9867	18300.0
2011-10-13	BCM	ETF	42.91	43.4099	39.13	43.4099	1350.0
2011-10-13	BIB	ETF	7.4162	7.5637	7.4162	7.5637	15992.0
2011-10-13	BICK	ETF	24.61	24.61	24.315	24.56	13028.0
2011-10-13	BIL	ETF	91.68	91.7	91.68	91.7	494050.0
2011-10-13	BIS	ETF	6585.6	6585.6	6388.8	6388.8	8.1
2011-10-13	BITS	ETF	22.88	23.8	22.6	23.16	400.0
2011-10-13	BIV	ETF	86.4	86.8	86.4	86.53	268800.0
2011-10-13	BJK	ETF	30.96	31.08	30.5	31.03	428400.0
2011-10-13	BKF	ETF	37.4	37.576	36.81	37.51	172475.0
2011-10-13	BKLN	ETF	23.28	23.44	23.25	23.39	98500.0
2011-10-13	BLV	ETF	89.16	89.82	89.1	89.45	65500.0
2011-10-13	BMVP	ETF	13.11	13.28	13.06	13.23	12270.0
2011-10-13	BND	ETF	83.02	83.12	82.9	83.0	1690600.0
2011-10-13	BNO	ETF	37.005	37.51	36.76	37.425	220800.0
2011-10-13	BOIL	ETF	3700000.0	3746000.0	3626000.0	3731000.0	0.2
2011-10-13	BRF	ETF	43.45	43.46	42.501	43.32	138286.0

> showing 50 of 875 rows — these rows as CSV

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