PREVIEW / etf_daily / 2012-01-30

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-30.parquet
  size:    38 KB
  rows:    909

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-30	SPY	ETF	130.51	131.44	130.06	131.37	147311800.0
2012-01-30	QQQ	ETF	59.88	60.54	59.66	60.45	42797536.0
2012-01-30	IWM	ETF	79.08	79.43	78.52	79.1	46332400.0
2012-01-30	DIA	ETF	125.39	126.31	125.0	126.23	5910600.0
2012-01-30	GLD	ETF	168.19	168.54	167.74	168.03	8438000.0
2012-01-30	TLT	ETF	119.84	120.39	119.34	119.47	8388400.0
2012-01-30	AADR	ETF	28.7	28.89	28.7	28.89	500.0
2012-01-30	AAXJ	ETF	54.32	54.88	54.24	54.77	542200.0
2012-01-30	ACTV	ETF	14.39	14.65	14.37	14.58	51152.0
2012-01-30	ACWI	ETF	44.2	44.5	44.01	44.39	996300.0
2012-01-30	ACWV	ETF	52.11	52.21	52.11	52.17	3000.0
2012-01-30	ACWX	ETF	38.67	38.91	38.54	38.88	386231.0
2012-01-30	ADRE	ETF	42.02	42.33	41.79	42.25	116962.0
2012-01-30	AFK	ETF	27.91	28.05	27.72	27.77	21717.0
2012-01-30	AGEM	ETF	22.88	22.968	22.75	22.968	21565.0
2012-01-30	AGG	ETF	110.75	110.94	110.69	110.86	1490300.0
2012-01-30	AGQ	ETF	239.32	243.2	237.28	240.16	429675.0
2012-01-30	AGZ	ETF	113.206	113.35	113.02	113.11	20903.0
2012-01-30	AIA	ETF	42.68	42.925	42.58	42.89	17208.0
2012-01-30	AIQ	ETF	5.7	5.7	5.5	5.65	6242.0
2012-01-30	AIS	ETF	2.51	2.68	2.45	2.49	2589195.0
2012-01-30	AIVI	ETF	40.17	40.39	40.08	40.34	69900.0
2012-01-30	AMJ	ETF	39.54	39.58	39.314	39.55	680475.0
2012-01-30	AMLP	ETF	84.1	84.15	83.55	83.9	294500.0
2012-01-30	AOA	ETF	34.54	34.71	34.46	34.65	19500.0
2012-01-30	AOK	ETF	29.77	29.81	29.7261	29.79	286231.0
2012-01-30	AOM	ETF	30.52	30.559	30.4626	30.54	27545.0
2012-01-30	AOR	ETF	32.04	32.192	32.01	32.17	56844.0
2012-01-30	ARB	ETF	36.55	36.72	36.22	36.48	239396.0
2012-01-30	ARGT	ETF	23.5	23.58	23.18	23.3	4050.0
2012-01-30	ASEA	ETF	15.48	15.59	15.39	15.5	13400.0
2012-01-30	AWAY	ETF	27.0	27.06	26.19	26.56	279606.0
2012-01-30	BAB	ETF	29.1	29.27	29.09	29.14	145264.0
2012-01-30	BAL	ETF	59.2	59.2	58.27	58.34	9828.0
2012-01-30	BALT	ETF	4.09	4.32	4.09	4.25	73578.0
2012-01-30	BBH	ETF	41.86	41.9233	41.5	41.8333	30000.0
2012-01-30	BCM	ETF	45.15	45.17	45.09	45.09	1600.0
2012-01-30	BIB	ETF	10.4238	10.5875	10.3413	10.5712	71040.0
2012-01-30	BICK	ETF	26.27	26.36	26.1	26.27	19342.0
2012-01-30	BIL	ETF	91.64	91.66	91.64	91.66	256050.0
2012-01-30	BIS	ETF	4355.2	4355.2	4264.0	4264.0	46.55
2012-01-30	BITS	ETF	22.52	22.76	22.32	22.72	750.0
2012-01-30	BIV	ETF	88.0	88.2	87.91	88.07	510500.0
2012-01-30	BJK	ETF	32.46	32.81	32.43	32.66	11600.0
2012-01-30	BKF	ETF	40.68	40.96	40.36	40.89	98818.0
2012-01-30	BKLN	ETF	24.38	24.44	24.34	24.39	116600.0
2012-01-30	BLV	ETF	92.49	92.68	92.07	92.27	70300.0
2012-01-30	BMVP	ETF	14.24	14.3391	14.2033	14.3391	2482.0
2012-01-30	BND	ETF	84.06	84.14	83.91	84.0	1646400.0
2012-01-30	BNO	ETF	38.735	38.9	38.41	38.6	36000.0

> showing 50 of 909 rows — these rows as CSV

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