PREVIEW / etf_daily / 2012-01-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-13.parquet
  size:    37 KB
  rows:    897

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-13	SPY	ETF	128.64	129.05	127.72	128.84	179836200.0
2012-01-13	QQQ	ETF	58.1	58.2	57.68	58.18	35985091.0
2012-01-13	IWM	ETF	76.18	76.48	75.6	76.39	42600400.0
2012-01-13	DIA	ETF	123.71	124.16	122.92	124.16	6392100.0
2012-01-13	GLD	ETF	159.32	159.59	158.01	159.26	8910300.0
2012-01-13	TLT	ETF	121.1	121.64	120.81	120.88	9819000.0
2012-01-13	AADR	ETF	27.88	28.08	27.88	28.08	1500.0
2012-01-13	AAXJ	ETF	51.75	51.84	51.35	51.77	633000.0
2012-01-13	ACTV	ETF	14.89	15.02	14.75	14.99	325695.0
2012-01-13	ACWI	ETF	42.79	42.87	42.44	42.82	382100.0
2012-01-13	ACWX	ETF	37.06	37.06	36.6	36.96	199584.0
2012-01-13	ADRE	ETF	39.96	40.05	39.67	40.05	33775.0
2012-01-13	AFK	ETF	26.36	26.36	26.06	26.31	6415.0
2012-01-13	AGEM	ETF	21.68	21.74	21.52	21.6301	5629.0
2012-01-13	AGG	ETF	110.41	110.65	110.41	110.55	765000.0
2012-01-13	AGQ	ETF	191.52	194.44	187.52	189.88	402250.0
2012-01-13	AGZ	ETF	113.22	113.67	112.9	113.26	29236.0
2012-01-13	AIA	ETF	40.44	40.5	40.21	40.44	10215.0
2012-01-13	AIQ	ETF	5.7	5.75	5.4	5.5	30413.0
2012-01-13	AIS	ETF	2.19	2.22	2.17	2.19	508914.0
2012-01-13	AIVI	ETF	39.11	39.11	38.6	39.06	65500.0
2012-01-13	AMJ	ETF	38.59	38.73	38.37	38.73	700314.0
2012-01-13	AMLP	ETF	82.6	82.75	82.15	82.75	518580.0
2012-01-13	AOA	ETF	33.73	33.74	33.45	33.74	9000.0
2012-01-13	AOK	ETF	29.51	29.51	29.45	29.48	43678.0
2012-01-13	AOM	ETF	30.13	30.1326	30.064	30.1326	25344.0
2012-01-13	AOR	ETF	31.48	31.58	31.48	31.58	9973.0
2012-01-13	ARB	ETF	35.97	36.59	35.91	36.14	148695.0
2012-01-13	ARGT	ETF	22.72	22.72	22.52	22.52	100.0
2012-01-13	ASEA	ETF	14.83	14.85	14.67	14.85	4200.0
2012-01-13	AWAY	ETF	25.0	25.5	24.39	24.93	674378.0
2012-01-13	BAB	ETF	28.9	29.0	28.852	28.8799	334306.0
2012-01-13	BAL	ETF	58.88	59.3	58.5069	59.14	17398.0
2012-01-13	BALT	ETF	4.41	4.46	4.4	4.4	67096.0
2012-01-13	BBH	ETF	39.8533	40.0333	39.5167	39.92	28200.0
2012-01-13	BCM	ETF	43.6164	43.78	43.61	43.77	29875.0
2012-01-13	BIB	ETF	9.9	10.0175	9.7363	9.9923	90896.0
2012-01-13	BICK	ETF	24.44	24.494	24.25	24.37	23134.0
2012-01-13	BIL	ETF	91.64	91.66	91.64	91.64	581600.0
2012-01-13	BIS	ETF	4598.4	4620.8	4519.04	4519.04	11.25
2012-01-13	BITS	ETF	22.76	22.8	22.44	22.76	500.0
2012-01-13	BIV	ETF	87.38	87.5	87.19	87.34	166800.0
2012-01-13	BJK	ETF	30.83	31.03	30.64	30.98	20700.0
2012-01-13	BKF	ETF	38.26	38.4	37.934	38.35	145946.0
2012-01-13	BKLN	ETF	24.01	24.14	24.01	24.1	115600.0
2012-01-13	BLV	ETF	92.24	92.54	92.1	92.23	24500.0
2012-01-13	BMVP	ETF	14.0033	14.029	13.93	14.029	5425.0
2012-01-13	BND	ETF	83.7	83.78	83.59	83.7	889100.0
2012-01-13	BNO	ETF	38.42	38.65	38.22	38.63	124800.0
2012-01-13	BOIL	ETF	1662000.0	1675000.0	1580000.0	1583000.0	1.8

> showing 50 of 897 rows — these rows as CSV

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