PREVIEW / etf_daily / 2012-12-04

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-04.parquet
  size:    39 KB
  rows:    951

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-12-04	SPY	ETF	141.44	141.87	140.87	141.25	127512200.0
2012-12-04	QQQ	ETF	65.69	65.77	65.2	65.63	49671701.0
2012-12-04	IWM	ETF	82.07	82.32	81.46	82.09	37225000.0
2012-12-04	DIA	ETF	129.61	130.14	129.3	129.39	5760400.0
2012-12-04	GLD	ETF	164.06	164.83	163.87	164.42	10208900.0
2012-12-04	TLT	ETF	125.02	125.41	124.84	125.38	2586300.0
2012-12-04	AADR	ETF	30.68	30.68	30.43	30.43	1100.0
2012-12-04	AAXJ	ETF	58.12	58.29	57.99	58.02	452300.0
2012-12-04	ACTV	ETF	5.04	5.15	4.955	5.0	492942.0
2012-12-04	ACWI	ETF	47.19	47.34	47.07	47.13	1414800.0
2012-12-04	ACWV	ETF	56.46	56.52	56.2	56.29	10300.0
2012-12-04	ACWX	ETF	40.65	40.8	40.65	40.69	100812.0
2012-12-04	ADRE	ETF	38.36	38.4	38.03	38.03	27628.0
2012-12-04	AFK	ETF	30.19	30.42	30.08	30.33	41147.0
2012-12-04	AGEM	ETF	22.2	22.2	22.16	22.16	1300.0
2012-12-04	AGG	ETF	111.6	111.69	111.51	111.67	871900.0
2012-12-04	AGQ	ETF	208.64	212.0	206.0	209.4	426175.0
2012-12-04	AGZ	ETF	113.73	113.9308	113.65	113.67	18276.0
2012-12-04	AIA	ETF	46.2015	46.3047	46.06	46.06	22278.0
2012-12-04	AIQ	ETF	6.2	6.25	6.05	6.05	5000.0
2012-12-04	AIVI	ETF	40.77	40.88	40.71	40.81	44800.0
2012-12-04	ALTL	ETF	25.34	25.34	25.34	25.34	130.0
2012-12-04	AMJ	ETF	39.46	39.55	38.79	38.8286	1454890.0
2012-12-04	AMLP	ETF	80.75	81.0	80.2	80.35	394980.0
2012-12-04	ANGL	ETF	27.23	27.23	26.91	27.03	8600.0
2012-12-04	AOA	ETF	36.68	36.77	36.6	36.73	7700.0
2012-12-04	AOK	ETF	30.49	30.54	30.4751	30.5299	16467.0
2012-12-04	AOM	ETF	31.66	31.7	31.6304	31.64	12980.0
2012-12-04	AOR	ETF	33.71	33.75	33.68	33.74	41079.0
2012-12-04	ARB	ETF	36.87	37.38	36.64	37.36	94088.0
2012-12-04	ARGT	ETF	16.2	16.36	16.14	16.36	5200.0
2012-12-04	ASEA	ETF	16.73	16.73	16.61	16.65	14700.0
2012-12-04	AWAY	ETF	19.83	21.9	19.775	21.36	786166.0
2012-12-04	BAB	ETF	30.64	30.68	30.6	30.66	81939.0
2012-12-04	BAL	ETF	48.05	48.05	47.37	47.48	11428.0
2012-12-04	BALT	ETF	2.86	2.97	2.82	2.88	40745.0
2012-12-04	BBH	ETF	54.35	54.44	54.08	54.44	14500.0
2012-12-04	BCM	ETF	44.67	44.67	44.56	44.6699	1240.0
2012-12-04	BIB	ETF	14.775	14.8408	14.6635	14.825	30800.0
2012-12-04	BICK	ETF	23.8	23.87	23.76	23.77	10332.0
2012-12-04	BIL	ETF	91.64	91.64	91.62	91.62	217150.0
2012-12-04	BIV	ETF	90.44	90.49	90.39	90.48	160400.0
2012-12-04	BJK	ETF	35.21	35.22	35.0	35.05	3700.0
2012-12-04	BKF	ETF	38.22	38.47	38.21	38.23	41657.0
2012-12-04	BKLN	ETF	24.77	24.83	24.75	24.82	718900.0
2012-12-04	BLV	ETF	96.82	97.2	96.79	97.09	118700.0
2012-12-04	BMVP	ETF	15.9433	15.9733	15.9166	15.9588	4247.0
2012-12-04	BND	ETF	84.89	84.92	84.85	84.91	918000.0
2012-12-04	BNO	ETF	40.07	40.205	40.01	40.14	56800.0
2012-12-04	BOIL	ETF	901000.0	918600.0	892000.0	896400.0	10.0

> showing 50 of 951 rows — these rows as CSV

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