PREVIEW / etf_daily / 2012-05-02

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-02.parquet
  size:    38 KB
  rows:    933

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-05-02	SPY	ETF	139.92	140.46	139.46	140.32	121081000.0
2012-05-02	QQQ	ETF	66.5	67.11	66.38	67.06	38299220.0
2012-05-02	IWM	ETF	80.91	81.82	80.57	81.77	52095800.0
2012-05-02	DIA	ETF	132.04	132.51	131.65	132.4	3746000.0
2012-05-02	GLD	ETF	160.74	160.78	159.76	160.59	5632300.0
2012-05-02	TLT	ETF	117.22	117.32	116.8	117.25	3565700.0
2012-05-02	AADR	ETF	30.49	30.49	30.49	30.49	400.0
2012-05-02	AAXJ	ETF	56.41	56.76	56.32	56.72	442100.0
2012-05-02	ACTV	ETF	16.71	16.91	16.65	16.72	199854.0
2012-05-02	ACWI	ETF	46.46	46.71	46.36	46.68	524700.0
2012-05-02	ACWV	ETF	54.78	55.11	54.6	54.87	65000.0
2012-05-02	ACWX	ETF	39.89	40.08	39.75	40.05	71149.0
2012-05-02	ADRE	ETF	41.21	41.52	41.21	41.45	37153.0
2012-05-02	AFK	ETF	29.77	29.98	29.77	29.91	1151.0
2012-05-02	AGEM	ETF	22.81	22.8699	22.796	22.8699	1251.0
2012-05-02	AGG	ETF	110.46	110.51	110.36	110.44	1298500.0
2012-05-02	AGQ	ETF	193.52	194.6	191.28	194.56	266600.0
2012-05-02	AGZ	ETF	113.02	113.02	112.83	112.83	8286.0
2012-05-02	AIA	ETF	45.46	45.5539	45.26	45.5	11068.0
2012-05-02	AIQ	ETF	7.3	7.3	7.05	7.1	9387.0
2012-05-02	AIS	ETF	3.11	3.2	3.1	3.15	620086.0
2012-05-02	AIVI	ETF	40.28	40.44	40.04	40.44	21000.0
2012-05-02	AMJ	ETF	39.99	40.2599	39.99	40.17	664816.0
2012-05-02	AMLP	ETF	83.5	84.35	83.5	84.35	530180.0
2012-05-02	ANGL	ETF	25.57	25.57	25.4	25.46	98700.0
2012-05-02	AOA	ETF	36.11	36.31	36.06	36.29	12000.0
2012-05-02	AOK	ETF	30.15	30.2	30.15	30.18	14816.0
2012-05-02	AOM	ETF	31.22	31.29	31.2	31.28	18711.0
2012-05-02	AOR	ETF	33.25	33.34	33.167	33.31	20498.0
2012-05-02	ARB	ETF	37.53	38.05	37.37	37.38	645138.0
2012-05-02	ARGT	ETF	18.6	18.64	18.6	18.64	350.0
2012-05-02	ASEA	ETF	16.3	16.42	16.27	16.42	4900.0
2012-05-02	AWAY	ETF	25.94	26.075	25.78	25.85	207668.0
2012-05-02	BAB	ETF	29.4	29.44	29.3564	29.44	72516.0
2012-05-02	BAL	ETF	55.75	55.8399	55.33	55.42	29690.0
2012-05-02	BALT	ETF	4.29	4.3596	4.18	4.26	172959.0
2012-05-02	BBH	ETF	45.64	46.3	45.64	46.26	8500.0
2012-05-02	BCM	ETF	44.72	44.72	44.51	44.51	6041.0
2012-05-02	BIB	ETF	12.1088	12.4588	12.1088	12.4262	22240.0
2012-05-02	BICK	ETF	25.3	25.423	25.279	25.416	2216.0
2012-05-02	BIL	ETF	91.64	91.66	91.64	91.66	123300.0
2012-05-02	BIS	ETF	3545.6	3560.0	3483.84	3483.84	9.8
2012-05-02	BIV	ETF	87.82	87.9	87.75	87.85	236000.0
2012-05-02	BJK	ETF	36.8	37.03	36.48	36.94	48500.0
2012-05-02	BKF	ETF	40.09	40.09	39.81	40.03	82622.0
2012-05-02	BKLN	ETF	24.67	24.67	24.61	24.64	135000.0
2012-05-02	BLV	ETF	91.31	91.41	91.11	91.29	24000.0
2012-05-02	BMVP	ETF	15.57	15.64	15.54	15.63	6445.0
2012-05-02	BND	ETF	83.69	83.78	83.68	83.74	768300.0
2012-05-02	BNO	ETF	41.975	42.07	41.49	41.655	24000.0

> showing 50 of 933 rows — these rows as CSV

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