PREVIEW / etf_daily / 2012-08-06

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-06.parquet
  size:    39 KB
  rows:    942

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-08-06	SPY	ETF	139.72	140.17	139.56	139.62	86326200.0
2012-08-06	QQQ	ETF	65.94	66.39	65.8	66.1	23529615.0
2012-08-06	IWM	ETF	78.7	79.63	78.59	79.22	34662800.0
2012-08-06	DIA	ETF	130.94	131.61	130.88	130.9	4572700.0
2012-08-06	GLD	ETF	155.92	156.73	155.74	156.3	4610800.0
2012-08-06	TLT	ETF	127.67	128.14	127.37	127.47	3673600.0
2012-08-06	AAXJ	ETF	53.75	54.06	53.7	53.84	77000.0
2012-08-06	ACTV	ETF	11.82	11.92	11.15	11.29	463128.0
2012-08-06	ACWI	ETF	45.0	45.26	44.96	45.07	922900.0
2012-08-06	ACWV	ETF	56.67	56.67	55.74	55.75	24500.0
2012-08-06	ACWX	ETF	38.04	38.27	37.98	38.12	55335.0
2012-08-06	ADRE	ETF	38.24	38.89	38.24	38.63	49048.0
2012-08-06	AFK	ETF	28.9	28.96	28.81	28.91	26465.0
2012-08-06	AGEM	ETF	21.93	22.1399	21.93	22.1399	2301.0
2012-08-06	AGG	ETF	112.12	112.23	112.04	112.16	1832500.0
2012-08-06	AGQ	ETF	153.44	156.6	152.96	155.68	182850.0
2012-08-06	AGZ	ETF	113.66	113.7	113.58	113.69	5642.0
2012-08-06	AIA	ETF	43.05	43.28	43.03	43.03	19404.0
2012-08-06	AIQ	ETF	4.9	4.95	4.7575	4.85	11987.0
2012-08-06	AIVI	ETF	38.76	39.1	38.76	38.97	33500.0
2012-08-06	AMJ	ETF	39.35	39.818	39.35	39.69	1007401.0
2012-08-06	AMLP	ETF	82.5	82.75	82.15	82.7	317840.0
2012-08-06	ANGL	ETF	26.11	26.11	26.03	26.1	1500.0
2012-08-06	AOA	ETF	35.62	35.8	35.62	35.7	17200.0
2012-08-06	AOK	ETF	30.18	30.25	30.16	30.22	11182.0
2012-08-06	AOM	ETF	31.1	31.229	31.1	31.22	12013.0
2012-08-06	AOR	ETF	33.03	33.12	33.03	33.05	7099.0
2012-08-06	ARB	ETF	36.05	36.19	35.53	35.74	113761.0
2012-08-06	ARGT	ETF	16.68	16.94	16.68	16.84	5150.0
2012-08-06	ASEA	ETF	16.43	16.49	16.4	16.42	3900.0
2012-08-06	AWAY	ETF	23.8	24.37	23.403	24.32	362564.0
2012-08-06	BAB	ETF	30.33	30.45	30.33	30.4	158442.0
2012-08-06	BAL	ETF	49.34	50.0999	49.29	49.99	23330.0
2012-08-06	BALT	ETF	3.36	3.4	3.346	3.4	26899.0
2012-08-06	BBH	ETF	49.63	49.91	49.4	49.77	19500.0
2012-08-06	BCM	ETF	43.8099	44.12	43.8099	44.12	1980.0
2012-08-06	BIB	ETF	13.75	13.9135	13.234	13.7725	81328.0
2012-08-06	BICK	ETF	22.94	23.28	22.94	23.2019	5493.0
2012-08-06	BIL	ETF	91.64	91.66	91.64	91.66	208550.0
2012-08-06	BIS	ETF	2976.0	2977.6	2976.0	2977.6	6.25
2012-08-06	BIV	ETF	89.67	89.83	89.63	89.71	162400.0
2012-08-06	BJK	ETF	30.66	30.9	30.66	30.88	2100.0
2012-08-06	BKF	ETF	36.5	37.02	36.47	36.74	78666.0
2012-08-06	BKLN	ETF	24.66	24.68	24.65	24.65	245900.0
2012-08-06	BLV	ETF	97.52	98.0	97.48	97.7	36400.0
2012-08-06	BMVP	ETF	15.6467	15.7366	15.6467	15.7366	8757.0
2012-08-06	BND	ETF	84.93	84.94	84.82	84.87	1236000.0
2012-08-06	BNO	ETF	38.48	39.0	38.425	38.975	81600.0
2012-08-06	BOIL	ETF	908200.0	944800.0	880400.0	939000.0	10.6
2012-08-06	BOND	ETF	107.25	107.26	107.08	107.14	335677.0

> showing 50 of 942 rows — these rows as CSV

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